I am retrieving an array from a query:
$cmid=mysql_fetch_array($queryid);
$cmid contains 2 values: 211 and 237.
I can iterate through this with a while loop:
while($cmid=mysql_fetch_array($queryid))
echo "The line numbers are: $cmid[0]<br>";
This outputs 211 and 237 as two values of $cmid[0].
How can I set each of these two to different variables as I want to use these values to do two separate queries with two different sets of output? (I can't just run them through the same query because the results must be "collated" to two separate tables and forms.)
I have tried using every form of array iteration that I know ( current(), prev(), next(), end(), etc. )and I can't seem to retrieve both values individually to set them to a variable by themselves. I would greatly appreciate any help.