PHP/MySQL - "Query was empty"

[leckie]

I'm trying gather visitor usage statistics, insert them into my database, then display all usage statistics.

$hostname = "localhost";
$db ="alexisfx_db";

$conn = mysql_connect($hostname) or die("Invalid server or user.");

$user_ip = $_SERVER['REMOTE_ADDR'];
$url = $_SERVER['PHP_SELF'];
$referring_url = $_SERVER['HTTP_REFERER'];
$today = date("F j, Y, H:i:s");

//printed query
print("insert into pagestats(user_ip, page_url, referring_url, date_time) values('$user_ip', '$url', '$referring_url', '$today')");

$query = mysql($db, "insert into pagestats(user_ip, page_url, referring_url, date_time) values('$user_ip', '$url', '$referring_url', '$today')");

$result = mysql_query($query) or exit(mysql_error());

$query = mysql($db, "select * from pagestats");

$numrows = mysql_numrows($query);

print("<b>Stats</b>");
for($i=0; $i < $numrows; $i++)
{
	$user_ip = mysql_result($query, $i, 'user_ip');
	$page_url = mysql_result($query, $i, 'page_url');
	$referring_url = mysql_result($query, $i, 'referring_url');
	$date_time = mysql_result($query, $i, 'date_time');

print($user_ip . ", " . $page_url . ", " . $referring_url . ", " . $date_time. "<br>");
}

The error returned is "Query was empty". When i print the query out to the page and then insert it manually into phpMyAdmin, it works no problems. I also get the same error returned for the select query.

Help would be appreciated!

[laserlight]

What does your mysql() function do?

[leckie]

The first one inserts into the database, the second selects from the same database. Is that what you're asking about because i thought that seemed pretty self explanatory?

[mtmosier]

$query = mysql($db, "insert into pagestats(user_ip, page_url, referring_url, date_time) values('$user_ip', '$url', '$referring_url', '$today')");

You have a function called "mysql". Since this function doesn't appear in the manual I assume it's a user defined function. Clearly you expect it to return a query (while being passed a query?), but it seems it's not actually returning one. So what's this function do? Can we see the code?

[leckie]

Previously i have been able to use that function to execute a mysql query. Strange that it no longer works. Thanks for the help, i have it worked out now!