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

Seperate team from score
I am writing a site that does a NFL Pick 'em type application and I have a feed that gives me the sc

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Preg_match question
I want to use preg_match to make sure a string is always 6 characters long and only contains 0-9 and

What's wrong with my code
sobbing for many days, still don't know why please Help. Why my page isn't posted correctly. In a

UDP Multicast question
Hey,

Im not really in the know when it comes to network related programming and activitie

how to get different value in second view of webdynpro?
hello guys,

In ABAP webdynpro I am trying to create one application having two views.

how do i make a string??
hey guys,
can someone please tell me how to put data from the glob function into a string

paginate search result
Hi, I have a paginations script to display data from my database but i would like to paginate someon

Form help: Syntax & Logic
Hello again all,

I'm working on a form and ran into a wall (again) and can't seem to think th

Hyperlink is adding an extra gap to variable
Hi, here's my problem..

I have a php generated page with a hyperlink which opens in a new win