Help with a call to MySQL and echo'ing results

misteraven

Hello, I'm trying to modify some code thats part of an open source script. I'm still pretty new to all of this and was hoping I could get some help. I'm trying to pull in matching entries from two seperate tables, to then echo out on a page, but cant get entry_city to show up. It's probably something stupid, but any help or explaination will be appreciated.

Thanks.

$customer = tep_db_query("select c.customers_firstname,
 c.customers_lastname, a.entry_city from " . TABLE_CUSTOMERS . 
" c, " . TABLE_ADDRESS_BOOK . " a where c.customers_id = '" . $customer_id . "' and
 a.customers_id = c.customers_id and a.address_book_id = '" . $customer_default_address_id . "'");

$customer_values = tep_db_fetch_array($customer);

<?php echo $customer_values['customers_firstname'] . ' from
 ' . $customer_values['entry_city']; ?>

_SuperString

Try aliasing your SQL elements like this:

SELECT a.table as a_table, b.table as b_table

echo $result['b_table'];

misteraven

I'm not familiar with aliasing in PHP, can you explain this a little please?

misteraven

actually, I just solved it. It was a problem with a different segment of code, so the above should be correct.

Thnaks for the help regardless.

_SuperString

Its not a PHP thing, its standard SQL.... anyway, when your compose a SQL Select query that uses multiple tables you need to set a new name to the fields/tables (aliasing).

For example if you have a table called 'employees' and another one called 'department' and you want to select 2 fields from 'employees' and just one from 'department' you may write this:

SELECT e.firstname as firstname,
             e.lastname as lastname,  

             d.department_name as dept_name
FROM    employees e,
             department d
WHERE -- whatever in here

as you can see I have aliased the table name employee as 'e' and department as 'd', I have also aliased all the fields (the name after the as keyword).
So with that said, you can now refer to the aliased name in PHP, like this:

$result_array['aliased_name'];

misteraven

cool.

thanks a lot.