Selecting data from mysql table and related data from another to join them

Posted by knittledan on Stack Overflow See other posts from Stack Overflow or by knittledan
Published on 2012-04-11T20:10:30Z Indexed on 2012/04/12 23:28 UTC
Read the original article Hit count: 168

Filed under:
|

Ive looked at other questions and answers but still dont understand which brings me here.

I have one data base two tables. lets say table1 and table2 from database.

I'm looking to grab all the information from table1 and only one column from table2 that coincides with the correct row in table1.

Example which I know is wrong:

SELECT table1.*, table2.time_stamp FROM table1, table2 
    WHERE table1.ticket_id=$var AND table1.user_id = table2.user_id

Basically select data from table1 then use a value from the selected table to grab the related data from table2 and join them to output them as one mysql_query. Im sure its simple and has been asked before.

edit:

I dont receive an error. SQL just returns noting. log form of this would be:

$sqlResults = mysql_query("SELECT table1.* FROM table1 WHERE table1.ticket_id=$var")

while($rowResult = mysql_fetch_array( $sqlResults )) {

$userID = $rowResult['user_id'];

$sqlResults2 = mysql_query("SELECT table2.time_stamp FROM table2 
    WHERE table2.user_id=$userID")

}

I want to combine that into one sql statement so i dont have to hit table2 for every row table1 has

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql