combining 2 queries
Posted: Wed Jun 27, 2007 3:03 pm
patrikG | Please use
any ideas how to progress
all opinions will be appeciated!!
patrikG | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Hi
I am trying to create a query that takes a members ID looks up past images they have submitted and the locations they are from. It then uses these locations to find further images of the particluar locations submitted by other members.
Am having a little trouble writing this query
so far I have
[syntax="php"]$result = mysql_query("Select * from plogger_pictures INNER JOIN pubs on plogger_pictures.location_id = location.location_id where plogger_pictures.member_id = '$member_id'")all opinions will be appeciated!!
patrikG | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]