Query comparison

[thefollower]

How do i construct a query which would do something like this:

 

search in tablename and find all the records with houseID which is the same as HouseID of housetablename ?

 

Im only used to using the UserID session in queries so ive not done something like that before ^ ?

[samoht]

It seems like you just need to:

 

<?php
SELECT *
FROM tablename, housetablename
WHERE houseID = HouseID

 

What else?

[pocobueno1388]

It seems like you just need to:

 

<?php
SELECT *
FROM tablename, housetablename
WHERE houseID = HouseID

 

What else?

 

Wouldn't it be:

 

SELECT *
FROM tablename t, housetablename h
WHERE t.houseID = h.HouseID

 

I'm no expert in MySQL, so they may do the same thing.

[phpSensei]

its the same thing, just different ways of writing it...

[thefollower]

which one is best to use though :S

[phpSensei]

<?php


$result=mysql_query("SELECT * FROM housetablename WHERE houseID = HouseID");

?>

[AV1611]

aliasing the table name takes a little longer but when you start doing joins you will be glad you learned to use them

 

i.e.

 

SELECT DISTINCT a.name,a.ip,b.name

FROM onlineip AS a Inner Join onlineip AS b ON a.ip = b.ip

WHERE a.name NOT LIKE  b.name AND a.ip NOT LIKE  '' AND a.name NOT LIKE  'Recruit' AND b.name NOT LIKE  'Recruit'

order by a.name