php question

[julia]

Hey there.

Is it possible to make more than one query from 2 different tables on the same page

For instance

 

$account_query = tep_db_query("select customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_telephone, customers_nightphone from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");

$account = tep_db_fetch_array($account_query);

 

then repeat to get values from the Address Book Table

 

When I put the two strings on the page, I get a SQL syntax error.

 

Thanks

[Jack_mcs]

Give this a try:

$account_query = tep_db_query("select c.customers_id, c.customers_gender, ab.customers_id, ab.entry_gender_  from " . TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " ab where c.customers_id = ab.customers_id and c.customers_id = '" . (int)$customer_id . "'");

I'm doing it from memory so it may need some tweaking and you will need to fill in all of the fields you want to call. but it should work.

 

Jack

[julia]

Give this a try:

$account_query = tep_db_query("select c.customers_id, c.customers_gender, ab.customers_id, ab.entry_gender_ ?from " . TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " ab where c.customers_id = ab.customers_id and c.customers_id = '" . (int)$customer_id . "'");

I'm doing it from memory so it may need some tweaking and you will need to fill in all of the fields you want to call. but it should work.

 

Jack

<{POST_SNAPBACK}>

 

Thanks Jack!

I will try that.

Julie