I do something like this, where $result is the result of a mysql_query():
<?php
while ($row = mysql_fetch_array($result))
{
if ($row[col] == 1)
{
print_entry($row);
}
}
?>
This is to fill one column on screen. Now I would like to do the same for
the second column: if ($row[col] == 2). But the $result pointer has moved
to the end. How to move it back to the start again? reset() won't work,
because it's not an array, just an integer pointing to a MySQL result set.
How to move through this result set using PHP? Or should I just run a
seperate query for each column with a 'where col =' clause? That looks like
pretty intensive use of computer resources... I could also turn the result
set into a 2D array of rows and work with that. Sounds a bit voluminous as
well...
Thanks, marco
|
| Marco Bleeker, Amsterdam
| [EMAIL PROTECTED]
| http://www.euronet.nl/users/mbleeker/
|
| Attachments only after prior notice please.
| Don't put me on any kind of mailing list.
|
| I am now receiving the Snowhite virus 4x a day
| - some of you must be infected, please check !
| (No, you did not get it from me, I use Eudora)
| __@
| _`\<,_
|__(*)/ (*)________________Ah, op DIE fiets !
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php