big-dog1965 Posted February 11, 2009 Share Posted February 11, 2009 I have a form that has a short cut to <?php // Global registers by pass include("global.inc.php"); pt_register('POST','id'); // Start regular stuff if($id=="") header("Refresh: 0;url=index.php"); else { include("config.inc.php"); $db = mysql_connect($hostname,$username,$password); mysql_select_db($dbname); $query = "delete from ".$table." where id='".$id.""; $result = mysql_query($query); header("Refresh: 0;url=index.php"); } ?> The form gets records from the database and displays information at the end of each record theres a delete record shortcut. It is suppost to delete that record by the id which is auto incroment, but it doesnt the screen refreshes and record is still in the DB Any help would be great Link to comment https://forums.phpfreaks.com/topic/144719-mysql-php-and-form/ Share on other sites More sharing options...
xtopolis Posted February 11, 2009 Share Posted February 11, 2009 $query = "delete from ".$table." where id='".$id.""; This line is probably invalid im guessing. but if you echo out $query, what does it produce? If you put that in your mysql console/phpmyadmin, does it produce the expected result? Link to comment https://forums.phpfreaks.com/topic/144719-mysql-php-and-form/#findComment-759437 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.