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

help with database debug pls
Parse error: syntax error, unexpected T_ELSE in /home/content/m/e/s/mesick/html/students/05/php/chec

cURL proxy
Okay here is the thing... i know how to add proxys

Code: curl_setopt($ch, CURLOPT_PROXYTYPE,

reading partial code from external site
Hi,

I am trying to write a script for my website to get an article from an external website.

Getting PHP to ammended the selected in option field
Hey Guys

thanks for everyones help so far. This site and its users are oozing awesomness.

What am I missing here? Help!
Hello all!. I can't seem to get this working right. Well - it renders right, but something is goin

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p

date("now") prints out wrong date ?
Hi Guys
Anyone know why and how I can fix it ?

Time script, set to my time zone?
I am using this line to get the date and time

Code: $time = date(F." ".d.", &q

Help with PHP Calendar code...
Hello, I'm new to this forum and I'm glad I found it.
I wrote this code for a PHP calendar as an

Include with Parameters
In a particular page I would like to include a file that requires $_GET parameters.

when I go