Hello bob,
Friday, February 13, 2004, 12:10:06 PM, you wrote:
bp> $array=array("Flyer","Email","Phone");
bp> $array_len=count($array);
bp> for($i=0;$i<$array_len;$i++){
bp> $query="select count(score) from test_table
bp> where source = '$array[$i]'";
bp> $result=mssql_query($query,$numero);
bp> $row=mssql_fetch_row($result);
bp> $array[$i].total=$row[0];<-- problem here
bp> }
$array[$i]['total'] = $row[0];
Alternatively, you can probably do this too:
$query = "SELECT COUNT(score) AS hits FROM ...";
$result = mssql_query($query, $numero);
$array[$i]['total'] = mssql_result($result, 0, "hits");
Same end result, but saves on processing a bit. This assumes MSSql has
the same functions available as MySQL does (the mssql_result part)
--
Best regards,
Richard mailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
