[RESOLVED] check the insert query

[vang]

hi,

is there a way to check for success insert query?
i try this and it is not working for me.
the count return no value when i echo.

$query = "INSERT INTO table .......";
$result = mysql_query($query);
$count = mysql_num_rows($result);
if($count >0)
{ // insert successful
}
else
{ //insert failed
}

[taskagent]

Your trying to read an empty table. Your asking for the query basically before the info has even made into the db.

//Make your insert
$query = "INSERT INTO table .......";
// Now query the table
$page_key = 'MEMBERS'; // a key to search by
$cq = mysql_query("select * from page_listing where PAGE_KEY = '".$page_key."'");
$cqr = (mysql_fetch_array($cq));
$PAGE_NAME = stripslashes($cqr['page_name']);

// ask to see the page name
if ($PAGE_NAME !=""){
echo $PAGE_NAME
} else {
echo 'empty';
}

[bradgrafelman]

If a query fails, [man]mysql_query/man will return false and [man]mysql_errno/man will return the error number (e.g. 1062 for a "duplicate data for key" type of error).