Combined query not working

[imperium2335]

Hi,

 

Is there a more efficient way of doing this?

 

$result = mysql_query("SELECT users.id
						   FROM users, active_users_dyn
						   WHERE users.id = active_users_dyn.userRef
						   AND users.username = '$user' LIMIT 1")or die(mysql_error()) ;
	$result2 = mysql_query("SELECT users.id
						   FROM users
						   WHERE users.isRegistered = 1
						   AND users.username = '$user' LIMIT 1")or die(mysql_error()) ;

	$errz = mysql_num_rows($result) + mysql_num_rows($result2) ;

 

I have tried combining them into one query using another set of ANDS with an OR but it brings back 0 rows even though I know there is one.

 

Also, since I'm only interested in the number of rows, do I have to SELECT something even though I don't need it?

[Zane]

SELECT users.id
   FROM users
   JOIN active_users_dyn as dyn ON users.id = dyn.userRef
   WHERE users.username = '$user' AND users.isRegistered = 1

[imperium2335]

Thanks, but it didn't work

 

Same result as:

 

$result = mysql_query("SELECT users.id
						   FROM users, active_users_dyn
						   WHERE users.id = active_users_dyn.userRef
						   AND users.username = '$user'
						   OR users.isRegistered = 1
						   AND users.username = '$user' LIMIT 1")or die(mysql_error()) ;

 

Saying there are no rows.

[Zane]

What does this pull up?

SELECT users.id
   FROM users
   JOIN active_users_dyn as dyn ON users.id = dyn.userRef
   WHERE users.username = '$user'

 

[imperium2335]

0 rows

[Zane]

Well then $user must not have the value you think it does

 

To find out you can either run this query

SELECT users.id
   FROM users
   WHERE users.username = '$user'

Or echo out the $user variable and see for yourself.