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
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

Posted: Tue Mar 28, 2006 12:34 pm
by ms_tilly

there was a spelling mistake in my database
thank for ur help