Warning: mysql_affected_rows(): supplied argument is not a v
Posted: Wed Jun 14, 2006 2:49 pm
i could swear that it probably looks like im smapping the forum but,i get this error:
Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in C:\xampplite\htdocs\admin\do.php on line 29
Code: Select all
<?PHP
session_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<?PHP
if($_SESSION['in'] != '1' ) {
echo '<font color=red>You are not logged in,please go <a href="../admin">Here</a> to login.</font>';
}
else {
/*the action page.all actions of the admin will be redirected here.
That is all*/
include("../includes/sql.php");
$act = $_GET['act'];
$entry = $_GET['entry'];//the id of the entry
if($act == 'approve') {
$query = "SELECT * FROM poffers WHERE id=$entry";
$result = mysql_query($query);
$data = mysql_fetch_array($result,MYSQL_ASSOC);
$sql2 = "INSERT INTO coffers (username,offer_name,offer_type) VALUES ('{$data['username']}', '{$data['offer_name']}', '{$data['offer_type']})'";
$sql2run = mysql_query($sql2);//inserts the offer to completed table.
//remove it from the old table
$put = mysql_affected_rows($sql2run);
if($put == 1) {
$delete = "DELETE FROM poffers WHERE id=$entry LIMIT 1";
$delrun = mysql_query($delete);
$hits = mysql_num_rows($delrun);
if($hits == '1') {
echo 'The offer' .$entry.'has been removed from pending offers and has been moved to completed offers.';
}
else{
echo 'The entry was not added.';
}
}
}
}
if($act == 'offer_add') {
$offer = $_GET['offer'];
$type = $_GET['select'];//tells what type of offer it is
$sql = "INSERT INTO offers ('offer_name' , 'offer_type') VALUES (" .$offer. " , " .$type.")";
$query = mysql_query($sql);
if(mysql_num_rows($query) != 1) {
echo "Your add was not successful,please go back and try again.";
}
else {
echo "Your Offer was sucessfully added to the database.";
}
}
?>
</body>
</html>