show data from 2 tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am attempting to pull data from 2 tables.  My SELECT statement seems ok.  But the next line: while ... etc. is giving me an error of "Supplied argument is not a valid MySQL result resource.".  But this is the way I usually show my data and it works fine when only 1 table is involved.  Is there a different way of showing your data when pulling data from more than one table?

$result = @mysql_query('SELECT orders.orderid, orders.amount, orders.date
	from customers, orders WHERE customers.name = "Don Hansen" and
	customers.customerid = orders.customerid');

while ( $row = mysql_fetch_array($result) )
{
	$zorderid = $row['orders.orderid'];
	$zamt = $row['orders.amount'];
	echo (str_pad($zorderid,4,' ') .  str_pad($zamt,6, '  ') . '<br>');
}

Thanks,
Doug

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



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux