PHP

amansingh630

Daer
I am working on a project using mySQL and PHP. I have two tables on mySQL.
Table 1 has 2 fields, the City Code and City Name (which are added just once as they do not change or increase).
Table 2 is the Product table, with 2 fields, where all the Item Description is given and the City Code.
Everything is ok, however, on the PHP search form, I want the Table 2 City Code field and Table 1 City Name field to match and show results by showing the City Name and not the city code.

I would appreciate if someone can help me by sending an easy link that would help me understand what to do or even if you can tell me how to do this is full detail.
Thank you

Kind regards

Aman

Nile

I didn't quite get that, but -
to do a search with mysql, use the LIKE function,
and to find the name of the city, when the code is given, try looking up join.

johanafm

The first part of the query specifies the fields you want to retrieve
The FROM clause specifies one or more tables (cartesian product).
A join can be either inner or outer, usually written as INNER JOIN and LEFT JOIN respectively, and they take an ON clause with one or more constraints for the join. You can join as many tables as you like. Reading up on the difference between the join types is a good idea.

The reference for your DBMS will have information on all of the above. Just read its section for SELECT statement syntax.

SELECT name, description
FROM table2 AS t2
INNER JOIN table1 AS t1 ON t2.code = t1.code

amansingh630

Thank you for your reply, and help the code you given is bit hard to understand, i would be very great to you if could give me link or any tutorial to sort this matter, because i am a new php user,

aman

johanafm

This has nothing to do with PHP, only SQL. How you go about executing the SQL statement with PHP depends on what you use: mysql, mysqli, PDO or other database abstraction layer/wrapper.

SELECT syntax for MySQL: http://dev.mysql.com/doc/refman/5.1/en/select.html. That page also contains a link to the page with JOIN syntax.

Googling for "php mysql tutorial" yields almost 5 million hits, so I'm certain one of those will be useful.

Similarily, a search for PDO tutorial might be helpful.