Dreamweaver - Simple Recordset Question

Author

Simple Recordset Question

David Wilson

2004-04-30, 5:31 pm

Complete brain cramp. Have two sets of data in databases orderdetails and
orders. They have a shared OrderID. If I look at the records in each table
individually I can see all the information..However if I try and combine
them together I do not see the orders (older orders appear, but not the new
ones). Recordset is set to display all and recordset code is below..What am
I missing??

$query_Recordset1 = "SELECT * FROM orderdetails, orders WHERE
orderdetails.OrderID = orders.OrderID";
$Recordset1 = mysql_query($query_Recordset1, $connBentwood) or
die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

Aloosenation

2004-04-30, 5:33 pm

> orderdetails.OrderID = orders.OrderID";

orderdetails.OrderID == orders.OrderID";

Maybe that's it.

David Wilson wrote:

> Complete brain cramp. Have two sets of data in databases orderdetails and
> orders. They have a shared OrderID. If I look at the records in each table
> individually I can see all the information..However if I try and combine
> them together I do not see the orders (older orders appear, but not the new
> ones). Recordset is set to display all and recordset code is below..What am
> I missing??
>
> $query_Recordset1 = "SELECT * FROM orderdetails, orders WHERE
> orderdetails.OrderID = orders.OrderID";
> $Recordset1 = mysql_query($query_Recordset1, $connBentwood) or
> die(mysql_error());
> $row_Recordset1 = mysql_fetch_assoc($Recordset1);
> $totalRows_Recordset1 = mysql_num_rows($Recordset1);
>
>