Re: another PHP Sql question...
| From: | jsWalter | Date: | Fri, 29 Aug 2003 07:46:09 +0000 |
| Subject: | Re: another PHP Sql question... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30214@lists.php.net to get a copy of this message | ||
> "Boaz Yahav" <berber@netvision.net.il> 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