Re: [PHP-DB] show data from 2 tables

[Rolf Brusletto]

[EMAIL PROTECTED] wrote:

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, '  ') . '');
}
Thanks,
Doug
 

Doug -

the data would actually be accessed as the actual fieldnames without the 
"tablename."

while($row=mysql_fetch_assoc($result))
{
   foreach($row as $key => $value) {
  echo '$row['.$key.'] => '.$value.'';
   }
   echo '';
}
the above snippet will allow you to see the values being passed to $row 
by mysql_fetch_assoc();

hope this helps,

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

[PHP-DB] show data from 2 tables

[ddhull]

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, '  ') . '');
}

Thanks,
Doug

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