One question:
Do you mean that a & b are from the same column but are row 1 & 2 from
your query result.?
If so, you can possibly write a loop like so
Dump all your records in an array;
Start loop for as long you find records in array
{
Take the first record from your array and dump it into a
variable (var1);
Move the value from the variable var1 to another variable
(var2);
If both variables are set
{
Print the two variables with the html tags you want;
Unset both variables;
}
}
Add a handler to make sure you get the last records if it happens to be
an od number off records;
You'll have to do your own coding around this logic.
Good luck
Jack
-----Original Message-----
From: jsWalter [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 9:46 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] another PHP Sql question...
> "Boaz Yahav" <[EMAIL PROTECTED]> wrote in message
> I'm not sure i understand the problem.
> a,c,e come from one query result and b,d,f from another?
No, they all come from the same table, but the same field name but from
different rows of the database.
> If it's all from the same query why not do :
>
> reult=mysql_query(".....
> <TABLE>
> While($row = mysql_fetch_object($result)) {
> Echo"<TR><TD>$row->feild_A</TD><TD>$row->feild_B</TD></TR>";
> }
> </TABLE>
This method does not grap data from 2 rows at atime.
I examined my example and noticed I goofed, it should have read...
...
<tr>
<td>row_1/field_A</td>
<td>row_2/field_A</td>
</tr>
<tr>
<td>row_3/field_A</td>
<td>row_4/field_A</td>
</tr>
Same field, but diffeent rows.
Sorry for the confusion.
Walter
--
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
