submitting order

[Anon]

hi
im trying to get the customer_if from one table and put it into my orders table but havent had much success. Im using php and its thelast part of the project-any help woould be appreciatted??

[herve]

What's precisely is the problem ?

You do a SELECT to get the customer_id from
your first table, get the data in PHP variables, then you do an INSERT
into the orders table, no ?

[Anon]

This is what Im doing:

$conn = db_connect();
$result = mysql_query("select customer_id from customers where username='$username'");( if (!$result)
return false;
$result = @mysql_fetch_array($result);
return $result;

(the username is the person who is logged in-and wants to make a purchase)
then i do this....

$result = mysql_query("insert into orders values
('', '$customer_id', '$total_price', '$date', 'PARTIAL')");
if (!$result)
return "Could not register you in database - please try again later.";

return true;

All of it goes in accept the customer_id which is always a zero. Im presuming it has somehting to do with username which its not recognising?? any ideas will be greatly appreciated. Thanks

[herve]

$result = @mysql_fetch_array($result);
return $result;

You should use :

$row = mysql_fetch_array($result);
return $row[0];

or

$row = mysql_fetch_array($result);
return $row["customer_id"];

[Anon]

Nope Ive tried and the none of the data goes into the table. Im sure its to do with the username. Any ideas regarding how to make sure the screen knows which user is logged on @ that time(ive tried $valid-user and im using sessions as opposed to cookies. Thanks for the help uve given. Much appreciated

[herve]

Ok,

choose one or the other (otherwise, it's sure
it won't work at all)

• check (by printing on screen) the value
  of your $username variable

• check the returned value (before returning)

because if there's nothing returned, then of course, nothing will be inserted in the next function.