Linking tables

[david4u]

When I submit an order, I want to send the customers
details to the customer database and the item number and customer
number only to the orders database. When the customers
details are entered into the DB an auto incrementing customer
number is generated. How do I extract this and assign it to
a variable so that I can enter it into the orders DB along
with the item number?

I have tried variations of this:

$customer_number = mysql_query("SELECT customer_number FROM
customers WHERE customer_number = [maximum value]);

Does anybody know how to extract the maximum value from a
column?

[ednark]

you may want to look at this function

mysql_insert_id()

the general form to get the max value, which i don't think you want to do here is

select MAX(col_name) from table_name

[david4u]

Thanks, I have solved the problem.

Thanks alot