pls help

From: Juro Polak (polak@axon.sk)
Date: 20. 02. 2001, 10:22 CET 

toto je kusok kodu, problem mam asi s predavanim premennych, lebo select
count(*) from user where active=1 mi v mysql funguje... Vie niekto pomoct?
Diky

$result = '';
 $connection = mysql_pconnect(SQL_SERVER, SQL_UID, SQL_PWD);
 mysql_select_db(SQL_DB, $connection);
 $sql = 'select count(*) total from user where active=1';
 $query = mysql_query($sql);
 $record = mysql_fetch_array($query);
 $result = 'There are a total of ' . $record['total'] . ' pictures and ';
 $sql = "select sum(votecount) total from user";
 $query = mysql_query($sql);
 $record = mysql_fetch_array($query);
 $result .= $record['total'] . " votes in the system";
 return $result;

This archive was generated by hypermail 2.1.2 : 04. 09. 2001, 05:36 CEST