searching array for value 1

[Microbe]

Hey folks,

I am trying to create a pair of previous/next links.

I find a value from a database and then want my links to be the previous and next records.

I have determined that all my values are in the array but I am having trouble accessing them.

Testing, I can loop through the array OK using

do{
	echo $row_categories["categoryID"] . " ";
}while($row_categories = mysql_fetch_assoc($categories));

However I would have thought that I would have hte same result from

foreach ($row_categories as $a ){
	echo $a . "<br>";
}

but it only returns the first record.

I am a bit brain dead and am likely not seeing the obvious here...but I just can't see how to achieve what I know is relatively straight forward.

The way I would really like to do this is use array_search to find the key for the value of the record I have and then find prev and next (allowing for beginning and end of array etc)

Maybe I just need a break...but any pointers appreciated.

Steve

http://www.ColdCallComedy.com

- I have fun with telemarketers

 

[jpadie]

$row_categories will only have ONE row in it at any one time, the way that you have set things up.

and note with the do ... while loop that the first call to it will not have ANY row data. Hence it is FAR more usual to use a while {} loop for database recordset iteration.

to get all your data into an array do the following

while ($row_categories = mysql_fetch_assoc($categories)){
 $r_c[] = $row_categories['categoryID'];
}

the data will be in the $r_c array

 

[Microbe]

As always jpadie, a helpful answer.

Thanks.

Steve

http://www.ColdCallComedy.com

- I have fun with telemarketers