Menu
Community /Pin to ProfileBookmark
@NogDogJul 23.2006 — #Do you really even need the previous_column/next_column elements? Your array will already have a sequential index which you can use to get the previous/next values.
For instance:
array problem
I’m trying to populate an array with:
Column Name
Column Data Type
Next Column
Previous Column
From a mysql database.
I have:
[code=php]
<?php
mysql_connect(“host”,”username”,”pass”) ;
mysql_select_db(“db”) ;
$result = mysql_query(“SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = ‘test'”) ;
$result_set = array() ;
while ($array = mysql_fetch_assoc($result))
{
$result_set[] = array(‘COLUMN_NAME’=>$array[‘COLUMN_NAME’],’DATA_TYPE’=>$array[‘DATA_TYPE’], ‘PREV_COLUMN’=>$temp, ‘NEXT_COLUMN’=>’?????’) ;
$temp = $array[‘COLUMN_NAME’] ;
}
print_r($result_set) ;
?>
the column name and data type were no problem, i got the previous column by storing the column name in a temp variable and adding it in the next loop.
problem is i can’t get the next column.
I don’t use arrays very much, and i’m sure there is a much better method than this. can anyone help me out.
Sign in
to post a comment3 Comments(s) ↴
0
@NogDogJul 23.2006 — #Do you really even need the previous_column/next_column elements? Your array will already have a sequential index which you can use to get the previous/next values.For instance:
[code=php]
for($ix = 0; $ix < count($result_set); $ix++)
{
echo "<p>Current column: {$result_set[$ix]['COLUMN_NAME']}n";
if($ix > 0)
{
echo "<br>Previous column: {$result_set[$ix - 1]['COLUMN_NAME']}n";
}
if($ix < count($result_set) - 1)
{
echo "<br>Next column: {$result_set[$ix + 1]['COLUMN_NAME']}n";
}
echo "</p>n";
}
[/code]