Re: Query with numbers like 1, 3, 5..........

From: Date: Thu, 07 Feb 2002 22:06:58 +0000
Subject: Re: Query with numbers like 1, 3, 5..........
References: 1 2 3  Groups: php.db 
Request: Send a blank email to php-db+get-16638@lists.php.net to get a copy of this message
Thank's a lot guys for helping me out here! Now I can sleep well to night ; ) "Mike Gohlke" <mike@rcs-net.net> wrote in message news:3C62F7D8.5060807@rcs-net.net... > <? 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 > >> > > > > > > > > >

« previous php.db (#16638) next »