truncate table works, but i still get numrows error.

[nelsonm]

Hi all,

I checked database table, and the table is being truncated. But i'm still getting the following error:

Warning: mysql_numrows() expects parameter 1 to be resource

when i execute mysql_numrows($Result) in the php script below:

$sql = "TRUNCATE TABLE distance";
$Result = mysql_query($sql, $conn) or die("<br>** Unable to query distance database table <b>".mysql_error()."</b><br>$sql");
$Rows = mysql_num_rows($Result);

if (!$Result){
echo "<br>** distance table base truncation failed, [$Result] [$Rows].";
exit;
}

[nelsonm]

btw...

The database contains three tables. I select from the first two tables and get the number of rows selected by using the mysql_num_rows() function without errors. The distance table is the only table i am inserting into.

1. I'm guessing i'm using the wrong function to get the number of rows inserted.
2. I'm guessing that TRUNCATE or INSERT, $Result does not return a resource - just TRUE or FALSE?

[enigma1]

The function mysql_num_rows is valid for select or show. Try using the mysql_affected_rows instead.

[nelsonm]

it did not work either. However by issuing a "select * from" then i was able to get msql_num_rows to work.

[enigma1]

how about this code?

$sql = "delete from distance";
$Result = mysql_query($sql, $conn) or die("<br>** Unable to query distance database table <b>".mysql_error()."</b><br>$sql");
$Rows = mysql_affected_rows($conn);

if (!$Result){
echo "<br>** distance table base truncation failed, [$Result] [$Rows].";
exit;
}

[nelsonm]

that works, thanks.

The problem was that i was testing $Results in mysql_affected_rows() instead of $conn.