I have the following query:
$query = SELECT d.utilization, d.capacity_date, d.day, i.id, i.interface, cd.date,
cd.id ;
$query .= FROM (capacity_data as d LEFT JOIN interfaces as i ON d.interface =
i.id) ;
$query .= LEFT JOIN capacity_date as cd ON d.capacity_date=cd.id ;
$query .=
Shouldn't that be:
while($data=mysql_fetch_array($result))
{
//SSLT
}
NOTE: Added ) and changes $query to $result
-Original Message-
From: Van Andel, Robbert [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 3:21 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL Query Result
To: Van Andel, Robbert; [EMAIL PROTECTED]
Subject: RE: [PHP] MySQL Query Result Question
Shouldn't that be:
while($data=mysql_fetch_array($result))
{
//SSLT
}
NOTE: Added ) and changes $query to $result
-Original Message-
From: Van Andel, Robbert [mailto:[EMAIL PROTECTED]
Sent
At 00:20 01.03.2003, Van Andel, Robbert said:
[snip]
I have the following query:
$query = SELECT d.utilization, d.capacity_date, d.day, i.id, i.interface,
cd.date, cd.id ;
$query .= FROM (capacity_data as d LEFT JOIN interfaces as i ON
d.interface =
and verified that I got nothing back. I don't
know at this point. I'm at a loss.
Robbert van Andel
-Original Message-
From: Ernest E Vogelsinger [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 3:51 PM
To: Van Andel, Robbert
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL Query
Vogelsinger
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] MySQL Query Result Question
I had the same thought and it didn't work. I have verified that $cmts[$i] is a
different value then the previous iteration, but the second time through the same data
as the first time through is processed. I've even run
6 matches
Mail list logo
