TalkPHP - View Single Post

Village Idiot · 12-05-2007, 08:14 PM

Lol indeed.

For the forum I made, I should also add that I didnt use auto_increment in my databases. Inserting a row was like this.

PHP Code:


			
$sql = mysql_query("SELECT * FROM board_reports");
$num = mysql_num_rows($sql);

mysql_query("INSERT INTO board_reports (report_id , report_topic_id , report_post_id , report_reason , report_by , report_status ) 
             VALUES ('$num','$topic_id','$post_id','','$user_id','0')");

I simply didnt delete rows, the 0 at the end was the rows status, I treated 1 as deleted.

12-05-2007, 08:14 PM	#25 (permalink)
Village Idiot Wizard Join Date: Sep 2007 Posts: 1,299 Thanks: 17	Lol indeed. For the forum I made, I should also add that I didnt use auto_increment in my databases. Inserting a row was like this. PHP Code: `$sql = mysql_query("SELECT * FROM board_reports"); $num = mysql_num_rows($sql); mysql_query("INSERT INTO board_reports (report_id , report_topic_id , report_post_id , report_reason , report_by , report_status ) VALUES ('$num','$topic_id','$post_id','','$user_id','0')");` I simply didnt delete rows, the 0 at the end was the rows status, I treated 1 as deleted.