First off, I'd like to point out that I'm totally new to Mysql - a couple weeks. It just stopped making my head hurt Monday when I started understanding the simple strings and the dynamic site I'm building was going fairly smooth for a total amateur data base person. Well, today my head started to hurt again, lol.

I'm trying to show a Consultant's information on the same page as their sponsor. I initially had all of the data in 1 table, since all sponsors are Consultants. I played with numerous variations, but either got nothing for the sponsor or all the same person as sponsor. After doing a bunch of reading and studying today, I decided to split the table down with the Cons_id and Sponsor_id in a seperate data base, but still in the first so that I could try to relate them. It's not working and I'm pleading for help. I'm using GoDaddy's Mysql data base and Dreamweaver MX (and they don't seem to like each other :p ). Here is what I have:

mysql_select_db($database_ConsAcct, $ConsAcct);
$query_Sponsor = "SELECT * FROM Consultant WHERE Consultant.cons_id =
(SELECT Sponsor.Cons_id FROM Sponsor WHERE Consultant.SponsorID = 'Sponsor.Spons_id')", $colname_Acct, $colname_Sponsor);
$Sponsor = mysql_query($query_Sponsor, $ConsAcct) or die(mysql_error());
$row_Sponsor = mysql_fetch_assoc($Sponsor);
$totalRows_Sponsor = mysql_num_rows($Sponsor);

And this is the error I'm getting:

Parse error: parse error, unexpected ',' in [the URL] on line 15

Line 15 is the (SELECT Sponso.Cons_id

I have beat my head over this all day and hope somebody can please help.