Hi,
In my php script i am running a sql statement,
I am using a union statement via a count to get the number of records from 5
differient tables with the cno=3, its working fine except for one thing, if
the any one of the tables dont have cno=3 it does not give me back a zero.
Heres what i am doing:
$theResult="SELECT COUNT(*) FROM table1 WHERE cno = 3
UNION
SELECT COUNT(*) FROM table2 WHERE cno = 3
UNION
SELECT COUNT(*) FROM table3 WHERE cno = 3
UNION
SELECT COUNT(*) FROM table4 WHERE cno = 3
UNION
SELECT COUNT(*) FROM table5 WHERE cno = 3";

this will return 5 rows in result, f.e.:

COUNT(*)
--------
12
10
9
23
7

but if table1 didnt have cno=3 it gives me:
COUNT(*)
--------
10
9
23
7

I am sure this must have been a problem with you guys to so how did you
solve it? how can i know (in my script) if its contains a positive number or
is 0?
I can run 5 counts but that would be a waste of connections if the site gets
a lot of members (which by the looks of it, it will).

Any help appreciated, thanks in advance.

Cheers,
-Ryan


We will slaughter you all! - The Iraqi (Dis)information ministers site
[url]http://MrSahaf.com[/url]