I like Mike's WHILE-loop better than my solution.

thanks, Mike

-----Original Message-----
From: Mike Gohlke [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 3:56 PM
To: Raymond Lilleodegard; [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
>To: "'Raymond Lilleodegard'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>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:[EMAIL PROTECTED]]
>>Sent: Thursday, February 07, 2002 1:22 PM
>>To: [EMAIL PROTECTED]
>>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" <[EMAIL PROTECTED]> wrote in message
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>>Yes, but the question is why?
>>
>>-----Original Message-----
>>From: Raymond Lilleodegard [mailto:[EMAIL PROTECTED]]
>>Sent: Thursday, February 07, 2002 1:22 PM
>>To: [EMAIL PROTECTED]
>>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
>>
>
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to