Hi,
I just got started on php and mysql and I'm learning but one little thingie I don't get yet: JOINS.
There are inner and outer joins but what's the difference?
What syntax is the most commonly used?
I tried following codes:
$qry = "SELECT userdate.name,userdate.birth,userdate.postcode,userdate.city,userdate.state,userdate.country,userdate.sexpref,userdate.lovestate FROM (userdate INNER JOIN users ON id) WHERE users.username='{$pagenick}' ";
$qry = "SELECT userdate.name,userdate.birth,userdate.postcode,userdate.city,userdate.state,userdate.country,userdate.sexpref,userdate.lovestate FROM userdate,users WHERE users.username='{$pagenick}' ";
and they don't seem to work.Yet I don't see the error right away.
the purpose of the query is to get data out of table userdate when username(from table users) = provided nick.
Maybe I link them bad, please help...
