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:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 18:38
To: [EMAIL PROTECTED]
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
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php