SQL not inserting

[thecase]

Hi,

 

Cant seem to figure out why this SQL line wont insert to the db

 

$query = sprintf("INSERT INTO raceadmin (username, matchid, text) VALUES ('%s', '%s', '%s')",	
            mysql_real_escape_string($username),
            mysql_real_escape_string($id),
            mysql_real_escape_string($text2));

 

Any ideas will be greatful

 

Thanks

[celsoendo]

PHP error? MySQL error? what?!?!

 

Anyway, before call mysql_query(), just print $query variable and check if the query is ok.

[flyhoney]

<?php

$query = "
INSERT INTO raceadmin
SET
	username = '%s', 
	matchid = '%s', 
	text = '%s'
";

$query = sprintf(
$query,	
mysql_real_escape_string($username),
mysql_real_escape_string($id),
mysql_real_escape_string($text2)
);

$result = mysql_query($query);

if (!$result)
{
die('Invalid query: ' . mysql_error());
}