The variable are coming through:
array(2) { ["tval"]=> string(8) "testing3" ["cval"]=> string(2) "12" }
here is my form: (since we made a couple of small changes there)
Code:
<form method=post action="purgestrikesearch.php">
<label>Delete Records: Tag Name:</label>
<input size="15" type="text" id="tval" name="tval">
<label> Where CPM is greater than:</label>
<input size="2" type="text" id="cval" name="cval">
<input type=submit value="Delete"></b>
Here is action:
Code:
<?php
$db_host = <defined>
$db_user = <defined>
$db_pwd = <defined>
$database = <defined>
$table =<defined>
$tval = mysql_real_escape_string($val);
$cval = mysql_real_escape_string($cval);
if (!mysql_connect($db_host, $db_user, $db_pwd))
die("Can't connect to database");
if (!mysql_select_db($database))
die("Can't select database");
$sql = mysql_query("DELETE FROM expedia WHERE `tag`='$tval' AND `cpm`=$cval" );
if (!$sql) {
die(mysql_error());
}
mysql_free_result($result);
?>
sorry to cause such trouble on what is probably a simple mistake