Still having problems....
| From: | A. Mikkelsen | Date: | Fri, 28 Feb 2003 13:08:24 +0000 |
| Subject: | Still having problems.... | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-18762@lists.php.net to get a copy of this message | ||
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