View Single Post
Old 11-12-2012, 07:15 PM   PM User | #14
stevenryals
New Coder

 
Join Date: Jul 2012
Posts: 63
Thanks: 4
Thanked 0 Times in 0 Posts
stevenryals is an unknown quantity at this point
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
stevenryals is offline   Reply With Quote