RE: Still having problems....
| From: | Uttam | Date: | Fri, 28 Feb 2003 14:11:15 +0000 |
| Subject: | RE: Still having problems.... | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-18767@lists.php.net to get a copy of this message | ||
is it the missing braces for while in get_list() function definition?
function get_list($q)
{
$result = mssql_query($q) or die("ERROR in - get_sw_ids function");
while ($rr[] = mssql_fetch_array($result)) $i++;
return $rr;
}
-----Original Message-----
From: A. Mikkelsen [mailto:a__mikkelsen@hotmail.com]
Sent: Friday, February 28, 2003 18:38
To: php-windows@lists.php.net
Subject: Still having problems....
I'm still having problems :
My query :
$q = "SELECT id, computer_id, date, domain, ip, license_key, software,
wm_id
FROM data WHERE id IN (SELECT MAX(ID) FROM data GROUP BY Computer_ID) "
.
$Where_Text . " ORDER BY Domain, Date DESC";
The show part:
<?
$sw_list = get_list($q);
For ($i=0; $i < sizeof($sw_list); $i++)
{
ECHO
"<TR><TD>".$sw_list[$i]['Computer_ID']."</a></TD>";
ECHO "<TD>".$sw_list[$i]['Domain']."</TD>";
ECHO
"<TD>".$sw_list[$i]['License_Key']."</FONT></TD>";
ECHO "<TD> "
.$sw_list[$i]['WM_ID']."</TD>";
ECHO "<TD>" .$sw_list[$i]['Date']. "</TD></TR>";
}
?>
My function :
function get_list($q)
{
$result = mssql_query($q) or die("ERROR in - get_sw_ids function");
while ($rr[] = mssql_fetch_array($result)) $i++;
return $rr;
}
When i remove the show part, the code works.
I'm getting more and more fustrated....
//Anders