RE: [PHP-DB] Query with numbers like 1, 3, 5..........

I like Mike's WHILE-loop better than my solution. thanks, Mike -----Original Message----- From: Mike Gohlke [mailto:mike@rcs-net.net] Sent: Thursday, February 07, 2002 3:56 PM To: Raymond Lilleodegard; php-db@lists.php.net Subject: Re: [PHP-DB] Query with numbers like 1, 3, 5.......... <? whatever... ?> <table border=1> <? $qry = mysql_query("select * from tablename order by id"); while ( $ref1 = mysql_fetch_object($qry) ) { $ref2 = mysql_fetch_object($qry) ?><tr><td>$ref1->id &nbsp;</td><td>$ref2->id &nbsp;</td></tr><? } ?> </table> btw, the &nbsp; is to keep the internal cell borders from not appearing using netscape. (keeps it from being empty). Hope this helps.... Mike... Raymond Lilleodegard wrote: >Hi again Rick! : ) > >It is because I am trying to list all products that I have in a database >into a "menu page". And I would like to have two products beside eachothers. >So... is it possible to get two datarows in one: > >do { > >} while (mysql_fetch_array() ); > >?? or is this a stupid way to do it? > >Reagrds Raymond >----- Original Message ----- >From: "Rick Emery" <remery@excel.com> >To: "'Raymond Lilleodegard'" <raymol@online.no>; ><php-db@lists.php.net> >Sent: Thursday, February 07, 2002 8:55 PM >Subject: RE: [PHP-DB] Query with numbers like 1, 3, 5.......... > > >>Yes, but the question is why? >> >>-----Original Message----- >>From: Raymond Lilleodegard [mailto:raymol@online.no] >>Sent: Thursday, February 07, 2002 1:22 PM >>To: php-db@lists.php.net >>Subject: [PHP-DB] Query with numbers like 1, 3, 5.......... >> >> >>Hi! >> >>Is there a way to get the rows with id's like 1, 3, 5, and so on or 2, 4, >> >6, > >>...........? >> >> >>Best regards Raymond >> >> >> >>-- >>PHP Database Mailing List (http://www.php.net/) >>To unsubscribe, visit: http://www.php.net/unsub.php >> >> >"Rick Emery" <remery@excel.com> wrote in message >news:EAA093B474ABD311A71E00508B5FE08305C2D0D3@adntex03.us.excel.com... > >>Yes, but the question is why? >> >>-----Original Message----- >>From: Raymond Lilleodegard [mailto:raymol@online.no] >>Sent: Thursday, February 07, 2002 1:22 PM >>To: php-db@lists.php.net >>Subject: [PHP-DB] Query with numbers like 1, 3, 5.......... >> >> >>Hi! >> >>Is there a way to get the rows with id's like 1, 3, 5, and so on or 2, 4, >> >6, > >>...........? >> >> >>Best regards Raymond >> >> >> >>-- >>PHP Database Mailing List (http://www.php.net/) >>To unsubscribe, visit: http://www.php.net/unsub.php >> > > >