[SOLVED] Help with simple query

[Mr Chris]

Hi,

 

I'm trying to do a Query with a Union where I want to print the number of rows $tc contains.  Can anyone see what's wrong with this:

 

$tc = @mysql_num_rows(mysql_query("(SELECT * FROM tbl1 WHERE id = $id) UNION (SELECT * FROM tbl2 WHERE id = $id)"));
print $tc;

[sasa]

remove @from begining and look the error

[janusmccarthy]

Is this a trick question?  Are you getting an error?

 

I can't see anything wrong with it off the top of my head, but you could have written it and tested in the time it takes to post here so I'm not sure why it's here.

 

If you are getting an error, separate out the statements:

print "QUERY STRING: "."(SELECT * FROM tbl1 WHERE id = $id) UNION (SELECT * FROM tbl2 WHERE id = $id)";

print "QUERY RESULT: ".mysql_query("(SELECT * FROM tbl1 WHERE id = $id) UNION (SELECT * FROM tbl2 WHERE id = $id)");

print "COUNT RESULT: ".mysql_num_rows(mysql_query("(SELECT * FROM tbl1 WHERE id = $id) UNION (SELECT * FROM tbl2 WHERE id = $id)"));

 

[Baronen]

Without an error it's hard

 

But make sure tbl1 and tbl2 has the same number of columns, this is required because you select *

[Mr Chris]

Cheers Guys,

 

I'll investigate further

[Mr Chris]

My Bad - column count did not match!