More than one array in PHP

[Heather]

Could anyone tell me whether or not you can have more than one array in the same if statement in PHP. I need to get information from two separate tables to send to a function. Here is the code I'm using:

if($add)
{
if($ShoppingCart)
$session = $ShoppingCart;

 $result = mysql_query(  "SELECT * FROM inventory WHERE product='$add'");
 $row = mysql_fetch_array($result);

 $result2 = mysql_query("select cust_id from customer where name='$cust_name'");
 $row2 = mysql_fetch_array($result2);

 $cart->add_item($table,$session,$row[product],1,$row[price],$row2[cust_id]);

}

Please help!!

[ir4z0r]

what do you mean by using 2 arrays in an if-st.?

sth like that?

if ($array1 && $array2)
{ ...

with mysql? $row and $row2? like you already have, yes

[Heather]

This looks ok to u? I now need to send these array values to a function so as they will be added, but the customer id isn't added. Here is the code I'm using:

function add_item($table,$session,$product,$quantity,$cost_price,$cust_id)
{
// Checks to see if they already have that product in their list
$in_list = "SELECT * FROM $table WHERE session='$session' ";
$in_list .= "AND product='$product'";
$result = mysql_query( "$in_list");
$num_rows = mysql_num_rows($result);
if($num_rows == 0)
{
$sql = "INSERT INTO $table (session,product,quantity,cost_price,cust_id) VALUES ";
$sql .= "('$session','$product','$quantity','$cost_price','$cust_id')";
mysql_query( "$sql");
}

Any ideas as to why the customer id is not added ( in MySQL it remains as 'o')??

[ir4z0r]

well, no :rolleyes:

have you done a little debugging?

echo the vars after getting 'em from the tables, before sending to
the function and after receiving them in the function to ensure they
are filled with the correct values

and maybe check the column type for the cust_id again