create a mailing list

[drunk_dude]

i apologize if this is a dumb/inappropriate question. i'm a newbie to sql, and i need to create a mailing list from a sql db. the db has all of the subscribers information, but for the state field the record is just a number (state id). in another db is all the states names and id #'s. how can i replace the state id #'s w/ the state names? any push in the right direction is much appreciated.

[PurpleMonkey]

Hmm, well its never a stupid question if you don't know the answer! Instead of getting the ids from both db's, why not just select the name and email adress from the db and do something like this..

$conn = mysql_connect();
$db = mysql_db_select();
$sql = "select name,email from table";
$qr = mysql_query($sql, $conn);
$message = "the mailing message";
#use a for loop!

for($i=0; $i < mysql_num_rows($qr); $i++) {

mail($i["email"],$message,$re);

}
something like that.