Re: Query with numbers like 1, 3, 5..........
| From: | Mike Gohlke | Date: | Thu, 07 Feb 2002 21:55:36 +0000 |
| Subject: | Re: Query with numbers like 1, 3, 5.......... | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16635@lists.php.net to get a copy of this message | ||
<? 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 </td><td>$ref2->id </td></tr><?
}
?>
</table>
btw, the 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