Page 1 of 1

beginner JOIN question

Posted: Tue Mar 28, 2006 12:05 pm
by ms_tilly
im getting an error with a join. When declaring the ON part is the following ok

Code: Select all

ON profiles.refid = user.userid
does refid have to be the same as userid? thanks

Posted: Tue Mar 28, 2006 12:12 pm
by hawleyjr
What is the error? What does the rest of your query look like?

Posted: Tue Mar 28, 2006 12:19 pm
by ms_tilly
the error im getting is

Code: Select all

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource.....
i'm just playing around with the code so i cant post it right now

is it ok to compare a field name with a variable of a different name even though the data types are the same?

thanks

Posted: Tue Mar 28, 2006 12:21 pm
by hawleyjr
Your query isn't what's throwing the error. You are having an issue connecting to the database.

Edit: My bad (Thx Feyd) It is an error with your query :oops: :oops:

Posted: Tue Mar 28, 2006 12:34 pm
by ms_tilly
:oops: there was a spelling mistake in my database

thank for ur help