Help with simple query

Posted on 16th Feb 2014 07:03 pm by admin

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:

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

Your Answer:

Login to answer

Other forums

SCRIPT ERROR
Here is the CONTACT FORM I made for our website:

<form id="form1" name="

PHP loop
Okay so I have several "articles" stored in a mysql database and am attempting to echo tho

Can't find a decent web analytics!!!
I've downloaded and installed Piwik. It's location detection based on IP addresses is fairly inaccur

Cron Job and Output
I have php codes running under a cron job.
But everytime i output (echo) , it comes out as comple

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

Add 5 to a variable when a button is clicked, and re-run a for loop
So I'm making a feedback sort of section on a website with MySQL and PHP, I've gotten the script to

Matchcode in ALV change header column
Hello everyone,

I am working in an SAP system that is currently in upgrade and conversion

Fatal error: Call to a member function fetchrow() on a non-object in C:xamppht
okay i have this query and everytime i add `item_id`=? to it... it gives me the error in the title..

How could I combine these arrays??
Hello.. I'm trying to figure out a way to combine these first two arrays to get the last array..

do while...woes
I'm sure this is childsplay but it is stumping me, everytime i try what I think would make this work