MySql Error

Duskwalker

It keeps saying there is something wrong with this piece of code.....




if ($view == equipment) {
	print "<form method=post action=test.php?view=equipment&step=add>book title <input type=text name=name><br>
Book, html and all<input type=text name=text><br>
short description<input type=text name=desc><br>

<br> with 



<input type=submit value=Add></form>";
	if ($step == add) {



$nump = @mysql_num_rows(mysql_query("select * from wbooks"));

$numa = ($nump + 1);

		$sql = "INSERT INTO wbooks ( id , name , text , author , cat , desc , tread ) ";
		$sql .= "VALUES ( '".$numa."', '".$name."', ".$text.", 's', 's', '".$desc."', '0' )";
		$sql .= ""; 
		mysql_query("$sql");
print "$name, $numa, $text, $desc";




} 

}

Its probably something really simple, that i just keep overlooking. I really appreciate any help, thanks.

-Dusk

planetsim

At a quick glance i couldnt exactly find anything wrong however without the error im not sure of what i should be looking for. Please post the error.

planetsim

After posting im just a little curious on this

$nump = @mysql_num_rows(mysql_query("select * from wbooks"));

$numa = ($nump + 1);

Why dont you have the ID set at auto_increment, instead of creating one on the fly. It may also be the source of the error.