PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
<?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>
so that means that i would neeed to assign a var to my sql connection right? BEcaus i have it set up in there as mysql_affected_rows($sql) wont work right?
$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);
I don't see any error checking code between the mysql_query() line and the mysql_affected_rows() line. Add some code to check mysql_error() and see what the problem is. Every query should be followed by an error check.
a94060 wrote:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
$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);