[RESOLVED] Selecting data after one result

darylr

Hi all,

Having a bit of a problem but I know its probably an easy answer..

I have a database with two tables. Basically, I am taking direct data from one table on a webpage, and want to select data depending on the results of the first query.

eg. Ive retrieved data from one table that displays city codes, such as:

In a seperate database table, I have the names and co-ordinates of each city with the city Code too. I want to be able to get that information and post it beside "LON" etc by selecting it from the database. Only thing is the cities codes that appear are random so are never the same. (which is why I dont have all the data in one table)

Thats probably not a very clear post, but any help would be greatly appreciated!

Thanks,

_uk_stuff

Can you not join the two tables together within the select?

i.e. SELECT tb1.This, tb1.That, tb2.Bits, tb2.Bobs FROM TableOne tb1 LEFT JOIN TableTwo tb2 on tb1.CityCode = tb2.CityCode WHERE tb1.CityCode='LON';

This should allow you to get all info back in one query?

Any good?

darylr

[uk]stuff,

I've never used that before.. can you help me further? Ive selected the database in the header and then echoed the city codes in a table. Im sure this is wrong:

$query_city = "SELECT * FROM citycodes WHERE rating = '5' LEFT JOIN cities on citycodes.code";

Later in the page in the table where the cities appear, I just echo it as

$row_city['code'];

and want to get it to display the city name and details beside that.

Thanks for your help, as you can probably tell Im no expert!

_uk_stuff

(Had to edit it... Should check before posting in future)

I am just guessing on you table structure here but the SQL should be something like:

$query_city = "SELECT * FROM citycodes LEFT JOIN cities on citycodes.code = cities.code WHERE citycodes.rating = '5' ";

You will then, like you mentioned, be able to access all columns via the row_city array... a nice easy way to see what would be available would be to print_r ($city_row).

This will list all of the values and associated array keys.

Good Luck!!

darylr

Spot on [uk]stuff!

Thanks for your help! 🙂