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
