value pair) for all of the data returned
if (sizeof($result) > 0)
{
$num_fields = mysql_num_fields($result);
$row_cnt = 0;
while ($row_data = mysql_fetch_array($result)) {
for ($cnt = 0; $cnt < $num_fields; $cnt++) {
$field_name = mysql_field_name($result, $cnt);
$data[$row_cnt][$field_name] = $row_data[$cnt];
}
$row_cnt++;
}
}
return $data;
}
$hostname = "itp.nyu.edu";
$dbname = "sve204";
$username = "sve204";
$password = "xxxx";
// Connect to the database
$mySql = mysql_connect($hostname, $username, $password) or die (mysql_error());
mysql_select_db($dbname, $mySql) or die(mysql_error());
// Query the database to see if this caller has called before
$query = "select id, caller_id, last_call_time, name_audio from callers order by last_call_time";
$result = sqlQuery($query, $mySql);
?>
Callers To Shawn's System