[Resolved] how do I select one record from multiple tables in php

adrianuk29

This is another thing that has bugged me. how do I select one record from multiple tables in php

I know how I can do this for a whole database but I have never been able to do this for just one record only.

// Example one search for phpbuilder across two tables ///
$result = mysql_query("SELECT * FROM table1, table2 WHERE table1.id=table2.id AND name='phpbuilder'");

Now say I wanted to search for say a record number example 1234, In the past when I have entered the following code I always get an error

// Example two, find id number ////////////////////////////////////
$result = mysql_query("SELECT * FROM table1, table2 WHERE table1.id=table2.id AND id=$id");

Your help would be greatly appreciated.

acidbox

Originally posted by adrianuk29
This is another thing that has bugged me. how do I select one record from multiple tables in php

I know how I can do this for a whole database but I have never been able to do this for just one record only.

// Example one search for phpbuilder across two tables ///
$result = mysql_query("SELECT * FROM table1, table2 WHERE table1.id=table2.id AND name='phpbuilder'");

Now say I wanted to search for say a record number example 1234, In the past when I have entered the following code I always get an error

// Example two, find id number ////////////////////////////////////
$result = mysql_query("SELECT * FROM table1, table2 WHERE table1.id=table2.id AND id=$id");

Your help would be greatly appreciated.

I don't really understand your question, but the problem with your second example is that you don't specify what table the id is from (ie: table2.id=$id)

try something like this:

$sql = "SELECT t1.*, t2.* FROM table1 t1, table2 t2 WHERE t1.id = t2.id AND t1.id = " . $id . " ORDER BY t1.id ASC";
$query = mysql_query($sql);

I didn't actually test the code 🙂

adrianuk29

Sorry my original question was slightly confusing.

What I want to be able to do is search from two tables at once but only output one result depending on the number $id number

$id being the number of the record in the database.

Has this made it even more confusing lol.

acidbox

Your question doesn't really make sense. What I pasted to you was a select from 2 tables.

Maybe what you are saying is you want to SELECT DISTINCT?

That means that if there are multiple results that are the same, it only fetches one of them.

If not, you will need to post more specific (less confusing) data 🙂

adrianuk29

Its ok I finally did it. I used a LIKE statment inside my query, its not really the correct way to do it but it works. Thank you for your help.