On Mon, Sep 15, 2003 at 02:15:56AM +0200, Ryan A wrote:
:
: Its a version problem, UNION was not implempted till V4, and my host has
: V3.23
: Anybody know of a work around with my code? I have found some work arounds
: on google but its too advanced for me...i dont really understand left joins,
:
s it give you the errors less often?
>
> Wouter
>
> -Original Message-
> From: Ryan A [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 15, 2003 12:49 AM
> To: esctoday.com | Wouter van Vliet
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP] Program works only when there
Hey,
Thanks for replying.
> This looks like a pretty decent query to me...
Thanks.
I took your advise and put a couple of "print mysql_error();" and got 8 of
the same error...
*
You have an error in your SQL syntax near 'UNION SELECT COUNT(*), 'Count2'
FROM dedicated where user='test
ROTECTED]
Sent: Monday, September 15, 2003 12:49 AM
To: esctoday.com | Wouter van Vliet
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Program works only when there are records :-(
Hey,
Thanks for replying.
sorry, i thought i explained what $tt was, but here it is in program code if
you want to be cl
Hey,
Thanks for replying.
sorry, i thought i explained what $tt was, but here it is in program code if
you want to be clear on it.
$tt = "SELECT COUNT(*), 'Count1' FROM shared WHERE user ='".$mmmy_user."'
and ccno=".$mmmy_ccno." UNION SELECT COUNT(*), 'Count2' FROM dedicated
WHERE user='".$mmmy
Start by giving us the value of $tt, ... That'll probably tell more about
the problem. Or you can do something like this:
if ($res = mysql_query($tt)) {
$num_rows = mysql_num_rows($res); //This is line 25
$x=1;
for($i=0; $i<5; $i++) {
$a = mysql_result($res
6 matches
Mail list logo
