Help needed with SQL query on 2 tables

[vbthanks]

Hi,
I have 2 tables in my db and need to get the emails from the first table (list_mike) dependant on the location value in another table (options).

Table 1 - list_mike:
id|email|etc

Table 2 - options:
fieldid|value|etc

So, what i'm trying to do is....
select email from list_mike
WHERE
value="south" from options

Not sure how to do this mutli-table query, and any help much appreciated!
Mike

[Vpekulas]

Do you reference the first table in the other one ?
In other words are you trying to get the value based on a foreign key ?

[samsm]

So is Table 1's "id" related to Table 2's "fieldid"? If so, you would use something like this:

select email from table1, table2 where table1.id=table2.feildid

Does that answer it?

[vbthanks]

Thanks for the replies so far

In Table 1 (list_mike) 'id' is the same as 'userid' in Table 2(options)

Regards,
Mike

[vbthanks]

Thanks for the replies so far

In Table 1 (list_mike) 'id' is the same as 'userid' in Table 2(options)

Regards,
Mike

[samsm]

Alright, you did not give us enough info the first time you asked. Where did this userid business come from?

don't read this bonehead business, I made a silly error that is corrected belowselect email from list_mike, options where list_mike.id=options.userid where options.value='south'

[someonewhois]

Originally posted by samsm

select email from list_mike, options where list_mike.id=options.userid where options.value='south'

2 Where's?

Don't you mean...

SELECT email FROM list_mike, options WHERE list_mike.id=options.userid && options.value='south'

BTW: I always like to use the mysql things (SELECT, UPDATE, SET, WHERE, FROM, INSERT, DELETE etc.) in capitals, so you can see the true difference a lot easier.

[samsm]

Yeah, that's what I meant, thanks!

[vbthanks]

Thankyou guys,
Much appreciated. Big thanks to phpJohn who helped me for nearly an hour on this labrynth of a db. This was the solution.....

$query = "SELECT userid FROM options WHERE fieldid = 111 AND value = 'south'"; 
  
$result = mysql_query($query);
  
$resultOptions = $result;  
while($fetch = mysql_fetch_array($resultOptions)) 

 { 

$query = "SELECT email FROM list_mike WHERE id = ".$fetch["userid"]; 
  
$result = mysql_query($query);
    
$fetchEmail = mysql_fetch_array($result); 
$emailAddress = $fetchEmail["email"]; 
echo $emailAddress."<br />";

 } 

There should be some sort of reward system for getting help like this! I should be able to order a pizza online for phpJohn and have it delivered to his/her door as a means of appreciation. "PayPizza" or somethin'