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
t; $a = mysql_result($res, $i); //This is line 30
> $bb[$x]=$a;
> $x++;
> }
> } else {
> print "sorry, no results found";
> };
>
> Also, for:
> =
> for($i=0; $i<5; $i++) {
> $a = mysql_result($res, $i); //This is line 30
> =
>
> I'd sugg
a = mysql_fetch_array($res)) {
Wouter
-Original Message-
From: Ryan A [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 14, 2003 11:45 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Program works only when there are records :-(
Hi,
I have a select statment with a UNION so that i am getting 5 COUNT(*)&#
Hi,
I have a select statment with a UNION so that i am getting 5 COUNT(*)'s from
a table.
After that I have this code:
*
$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, $i); //This is li
7 matches
Mail list logo
