mysql_fetch_array
| From: | its me | Date: | Thu, 27 Sep 2001 23:45:12 +0000 |
| Subject: | mysql_fetch_array | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12808@lists.php.net to get a copy of this message | ||
i tried to solve my problem:
$result=mysql_query("select p.price,
d.price as dprice, d.price as pprice
from printers p,desktops d
where d.companyname='$valcompanyname'
and d.companyname=p.companyname");
while($row = mysql_fetch_array($result)) {
echo $row["pprice"]."<BR>";
echo $row["dprice"]."<BR>";
}
and i got:
1.00
1.00
1.00
1.00
787.00
787.00
787.00
787.00
10000000000.00
10000000000.00
10000000000.00
10000000000.00
and these 3 numbers are in the desktops table and it ignore completely the
printers table!!!!
------------------------------------------------------------
------------------------------------------------------------