PHP - No Error, But Mysql Won't Update

Please help me with this: been doing this for 2 days and still cannot solve it. it won't update...

I have attached my file:

<?php
include('connect-database.php');
if (isset($_POST['submit']) AND $_POST['submit'] == 'update') {
   $error = false;
   extract($_POST);
   if (empty($full_name)) $error = true;
   if (!$error) {
      $update = "UPDATE users SET
               full_name = '$full_name',
               WHERE id=$id
               ";
      mysql_query($update) or die(mysql_error() . "<br><br>" . $update);
      $full_name = '';
      $message = "Record successfully updated.";
   } else {
      $message = "There is an error in your entry";
   }
} else {
   $id = intval(isset($_GET['id']) ? $_GET['id'] : 0);
}
if ($id == 0) {
   echo "<div style='margin-bottom:10px'>Invalid ID.</div>";
   exit;
}
$query = "SELECT * FROM users WHERE id=$id";
$result = mysql_query($query) or die(mysql_error() . "<br><br>" . $query);
if (mysql_num_rows($result) == 0) {
   echo "<div style='margin-bottom:10px'>Record Not Found in Database!</div>";
   exit;
}
$row = mysql_fetch_array($result);
extract($row);

?>
  <div id="mainContent" class="tab_container">
    <div id="tab1" class="tab_content">
    <h1>Edit Personal Data</h1>
   <div style="color:red;font-weight:bold"><? echo $message; ?></div>
          <form name="submit" action="" method="post">
        <ul>
           <li><b>ID # :</b> <?php echo $id?></li>
           <li><b>Name :</b> <input type="text" name="full_name" id="" size="30" value="<?php echo $full_name ?>" /></li>
            <li><b>Address :</b> <input type="text" name="address" id="" size="55" maxlength="100" value="<?php echo $address ?>" /></li>
            <li><b>Contact Number :</b> <input type="text" name="contact_number" id="" size="11" value="<?php echo $contact_number ?>" /></li>
            <li><b>Email Address :</b> <input type="text" name="user_email" id="" size="30" value="<?php echo $user_email ?>" /></li>
            <li><b>Status :</b> <input type="text" name="status" id="" size="10" value="<?php echo $status ?>" /></li>
            <li><b>Nationality :</b> <input type="text" name="nationality" id="" size="20" value="<?php echo $nationality ?>" /></li>
            <li><b>Religion :</b> <input type="text" name="religion" id="" size="20" value="<?php echo $religion ?>" /></li>
        </ul>
    <h2>Self Description</h2>
    <p><textarea rows="9" cols="40" name="self_description" ><?php echo $self_description ?></textarea></p>
   <input type="hidden" name="id" value="<?php echo $id; ?>" />
   <input type="submit" name="submit" value="update" />
   
   </form>
    </div>

Hey, I have this code, and it's ment to change the name / content of a page that is being put onto a page.
Both of the include files are fine as it works for other actions, but this one just returns the error.


<?php
include "../includes/mysql_connect.php";
include "../includes/info_files.php";

if(isset($_POST['submitted'])) {
mysql_query("UPDATE `pages` SET name='$_POST[name]' AND SET content='$_POST[content]' AND SET catt='$_POST[catt]' AND SET page='$_POST[page]' WHERE id='$_POST[id]'") or die('Edit failed');
echo "Page made.<br /><br />";
}else{

$result = mysql_query("SELECT * FROM pages WHERE id='$_GET[page]'");
while($row = mysql_fetch_array($result))
  {
echo '<form action="" method="post">';
echo '<input type="hidden" name="id" value="' . $row['id'] . '" /><br />';
echo '<strong>Edit: ' . $row['name'] . '</strong><br />';
echo 'Name: <input type="text" name="name" value="' . $row['name'] . '" /><br />';
echo 'Category: <input type="text" name="catt" value="' . $row['catt'] . '" /><br />';
echo 'Page: <input type="text" name="page" value="' . $row['page'] . '" /><br />';
echo '<textarea rows="25" cols="60" name="content">' . $row['content'] . '</textarea><br />';
echo '<input type="submit" name="submitted" value="Edit" />';
echo '</form>';
  }
}
?>

Any help would be great.

So there is this code I have here :  http://pastebin.com/rwcN7FeJ and I need to find a way to incorporate this code that user Barand gave me Code: [Select]
$referName = mysql_real_escape_string($gateway_data['refer']);
$query = "UPDATE users a
        INNER JOIN users b ON a.refer = b.nick
        SET a.refer = '', b.balance = b.balance + 5
        WHERE b.refer = '$referName'";
mysql_query($query);
But I havent the damnedest how to do that.  If anyone could help me at all, it would be appreciated.

Is there something seriously wrong with this code that im missing ?

I have written it at least 10-12 different ways and it will NOT update my db..

Code: [Select]
<?php 
mysql_connect('localhost','root','');
mysql_select_db('myDB');

$dates = $_POST['date']; 
$store = $_POST['store'];  // these actually display the correct information

mysql_query = ("UPDATE Agency Stores - Table 1 SET date = '".$date."' WHERE F3 = '".$store."' ");

?>


there are several other columns in the table.  I have tried to put them in as the value they already have and it still didnt work...

any ideas ?

Code: [Select]
<?php
$querySelect = mysql_query("SELECT * FROM `G4V_Videos` WHERE `counter`");
$row = mysql_fetch_assoc($querySelect);
$counter = $row['counter'];

if (empty($counter)) {

$counter = 1;
$insert = mysql_query ("INSERT INTO counter VALUES ('counter')");
$printid = (print $data['id']);
$printlink = (print $data['link']);
}

$add = $counter+1;
$insertNew = mysql_query("UPDATE G4V_Videos SET counter=('$add') WHERE id = ('$printid') AND link = ('$printlink')") or die (mysql_error());
echo "Video Views";
echo ":";
echo" ";
echo"<br />";
echo "$counter";
?>
It shows the same amount of hits on everyvideo instead of just the one video with the id
www.game4vids.com

I have lost my record when I run the code below, all fields are empty...

Code: [Select]
<a href='edit.php?id={$info['person_id']}'><font color='#00AE0A'>Edit User</font> </a>
Code: [Select]
$sql = "SELECT * FROM person WHERE person_id='{$_REQUEST['id']}' ";

$result = mysql_query($sql);
if (!$result) {
  echo("<p>Error performing query: " . mysql_error() . "</p>");
  exit();
}

if ($row = @mysql_fetch_array($result, MYSQL_ASSOC)) {

print "

<form action='<?php echo $PHP_SELF;?>' method=\"post\">

<table>


<tr>
<td><strong>Name</strong></td>
<td><input type=\"text\" name=\"fname\" size=\"60\" value=\"$row[fname]\"></td>
</tr>
<tr>
<td><strong>Surname</strong></td>
<td><input type=\"text\" name=\"lname\" size=\"60\" value=\"$row[lname]\"></td>
</tr>

<tr>
<td><strong>Email</strong></td>
<td><input type=\"text\" name=\"email\" size=\"60\" value=\"$row[email]\"></td>
</tr>

<tr>
<td><strong>Committee</strong></td>
<td><input type=\"text\" name=\"committee_no\" size=\"60\" value=\"$row[committee_no]\"></td>
</tr>

        <tr>
<td><INPUT type=\"submit\" value=\"Send\"> </td>

</tr>





</table></form>
";

} else {
    echo("There has been an error" . mysql_error());
}

/* closes connection */




?>

<?php


   $control =  mysql_query(" UPDATE person SET fname='{$_REQUEST['fname']}' , lname='{$_REQUEST['lname']}' , email='{$_REQUEST['email']}', 
               committee_no='{$_REQUEST['committee_no']}'
               WHERE person_id='{$_REQUEST['id']}'");

if($control)
{
header("Location:".$_SERVER["HTTP_REFERER"]."");
}


?>

I have this query:

Code: [Select]
$sql3 = "UPDATE users SET hours = '$newHours', pay = '$newPay', virtualLocation = '$arrival', expDate = '$expDate' WHERE pilotID = '$pilotid'";

I've echoed it out and all the variables put out the correct values. The query works except for the pay section of it. It will update the hours, virtual location, and expiration date but it will  not update the pay. It inputs 1.00 when the value echoed in the query is not 1.00. I'm not sure if, because it is a decimal, it changes how the query works. Any help? Thanks.

I have the following code that when used seperately work. How would I write an if..else statement that will make them work together? The following code give me an Parse Error, syntax error  unexpected T_string. The following if my code I have tried,

Code: [Select]

if (SELECT tournament FROM weekly_picks WHERE tournament = '$tournament')
mysql_query("UPDATE weekly_picks SET player = '$golfer' WHERE tournament = '$tournament' AND user = '$usr'");
else
mysql_query("INSERT INTO weekly_picks (t_id, tournament, user, player, backup, timestamp) VALUES ('$t_id', '$tournament', '$usr', '$golfer', '$backup', '$time')",$link) or die('Error, insert query failed');


I also know that values are being stored in the variables.

Code: [Select]
if(isset($_POST['npassword']) and ($_POST['cpassword'])){
$npassword = $_POST['npassword'];
$cpassword = $_POST['cpassword'];
$username = $_SESSION['SESS_login'];
if($npassword==$cpassword){
$password = md5($npassword);
$lol = mysql_query("UPDATE `members` SET  `passwd` = '$password' WHERE  `login`= '$username';");
echo"Password Changed!";
}
}

It echos password changed, but its not updating the password. If I run it in phpmyadmin it works fine... So i'm really stuck.

I am trying to update the content of my website which is all stored in a MySQL database.

Currently on the page I am displaying all the data stored in the database using MySQL SELECT and a while loop. Using JavaScript when the text is clicked the element changes into a text box allowing the text to be edited.

What I want to do is be able to change the data in the text box and then store it into the database updating the current data.

Code: [Select]
<form method="post" action="editindex.php">
<?php
$sql = "SELECT * FROM home ORDER BY id ASC";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)){
echo "<span id=\"itm1\" onclick=\"exchange(this);\">" . $row['title'] . "</span><input ondblclick=\"exchange(this);\" id=\"itm1b\" class=\"replace\" type=\"text\ name=\"title\">";?>
<input type="submit" value="Save" name="submit">
<input type="hidden" name="id" value="<?php  $row['id'] ?>"
</form>
<?php 
if (isset ($_POST['submit'])) {
$update = "UPDATE home SET title=".$_POST['title']." WHERE id=".$_POST['id']."";
mysql_query($update);
}
?>

I have more text being output from the while loop below but I just want to get it working on the title first.

Any ideas of why the update is not working?
 

So i have this following code that doesn't work

I have made this, although i can not seem to the status...

changeapp.php
Code: [Select]
<form method="post" name="memberadd" action="change_app_complete.php">

<label>Name:</label>
<select name="member">
<?php
$con = mysql_connect("host","user","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("database",$con);
$sqlquery="SELECT * FROM `application` Order By Name";
$result=mysql_query($sqlquery,$con);
while($row=mysql_fetch_array($result))
{
echo "<option value='".$row['ID']."'>".$row['Name']." (".$row['Status'].")</option>";
}
?>
</select>
<br>

<label>Status:</label>
<select name="Status">
<option value="PENDING">PENDING</option>
<option value="ACCEPTED">ACCEPTED</option>
<option value="DENIED">DENIED</option>
<br>
<input type="submit" value="submit" />
</form>
change_app_complete.php
Code: [Select]
<?php
$status=$_POST['Status'];

$con = mysql_connect("host","user","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("database",$con);

$sql="UPDATE application SET Status = '$status' WHERE Name= '$member'";
if(mysql_query($sql,$con))
{
echo 'Status Changed.<br /><a href="../applications.php">Return To Members List</a>';
}
else
{
die('Could not submit: ' . mysql_error());
}
mysql_close($con);

?>
What is wrong?

this is what i have so far but i cant get it to update the data

update page

<?php
$host="localhost"; // Host name
$username="**"; // Mysql username
$password="*****"; // Mysql password
$db_name="manews"; // Database name
$tbl_name="Shows"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// get value of id that sent from address bar
$id=$_GET['id'];


// Retrieve data from database
$sql="SELECT * FROM $tbl_name WHERE id='$id'";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<form name="form1" method="post" action="update_ac.php">
<td>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>&nbsp;</td>
<td colspan="3"><strong>Update data in mysql</strong> </td>
</tr>
<tr>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
</tr>
<tr>
<td align="center">&nbsp;</td>
<td align="center"><strong>Day</strong></td>
<td align="center"><strong>Month</strong></td>
<td align="center"><strong>Year</strong></td>
<td align="center"><strong>Song</strong></td>
<td align="center"><strong>Data</strong></td>
</tr>
<tr>
<td>&nbsp;</td>
<td align="center"><input name="Day" type="text" id="Day" value="<? echo $rows['Day']; ?>"></td>
<td align="center"><input name="Month" type="text" id="Month" value="<? echo $rows['Month']; ?>"></td>
<td align="center"><input name="Year" type="text" id="Year" value="<? echo $rows['Year']; ?>" size="15"></td>
<td align="center"><input name="Song" type="text" id="Song" value="<? echo $rows['Song']; ?>"></td>
<td align="center"><input name="Data" type="text" id="Data" value="<? echo $rows['Data']; ?>" size="15"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input name="id" type="hidden" id="id" value="<? echo $rows['id']; ?>"></td>
<td align="center"><input type="submit" name="Submit" value="Submit"></td>
<td>&nbsp;</td>
</tr>
</table>
</td>
</form>
</tr>
</table>

<?

// close connection
mysql_close();

?>

update script

<?php
$host="localhost"; // Host name
$username="**"; // Mysql username
$password="**"; // Mysql password
$db_name="manews"; // Database name
$tbl_name="Shows"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// update data in mysql database
$sql="UPDATE $tbl_name SET Day='$Day', Month='$Month', Year='$Year', Year='$Song', Year='$Data' WHERE id='$id'";
$result=mysql_query($sql);

// if successfully updated.
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='list_records.php'>View result</a>";
}

else {
echo "ERROR";
}

?>

Hi all me again thank god for sites like this

here is my prob

i have a page that edits then sends the info to a processing page to update the db but after i added a new bit i get a error

Error: 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 'order = '6', bi = '1', print = '1', online = '1', short_details = 'asdasda', ful' at line 1

im using get in my forms till its all working so i can see what is being passed to the processing page here is my code


the update page


<?
//Set no caching
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<? include("protect/password_protect.php"); ?>
<?php
error_reporting(E_ALL);
include ("../includes/db_config.php");

mysql_connect($db_hostname,$db_username,$db_password);
@mysql_select_db($db_database) or die( "Unable to select database");
$query="SELECT * FROM `$db_table` WHERE `id` ='".$_GET['id']."'";

$result=mysql_query($query);

$num=mysql_num_rows($result);

mysql_close();


$i=0;
while ($i < $num) {

$id=mysql_result($result,$i,"id");
$order=mysql_result($result,$i,"order");
$pro_name=mysql_result($result,$i,"pro_name");
$short_details=mysql_result($result,$i,"short_details");
$full_details=mysql_result($result,$i,"full_details");
$bi=mysql_result($result,$i,"bi");
$print=mysql_result($result,$i,"print");
$online=mysql_result($result,$i,"online");


?>
<table width="515" height="315" >
<form name="form1" method="get" action="runupdate.php?id=<? echo"$id"?>">
  <tr>
    <th width="22%" scope="row"><p>Id</p></th>
    <td width="78%"><input class="udp" name="id" type="text" id="id" value="<? echo "$id"  ?>" size="3" maxlength="3" readonly="readonly"> Ordering:
 <select name="order">
 <option value="<? echo"$order"?>" selected>Is Now<? echo"$order"?></option>
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    <option value="5">5</option>
    <option value="6">6</option>
    <option value="7">7</option>
    <option value="8">8</option>
    <option value="9">9</option>
    <option value="10">10</option>
  </select>
</td>
  </tr>
  <tr>
    <th scope="row"><p>Project Name</p></th>
    <td><input class="udp" name="pro_name" type="text" id="pro_name" value="<? echo "$pro_name"  ?>" size="40" MAXLENGTH="40"></td>
  </tr>
  <tr>
    <th scope="row"><p>Category</p></th>
    <td> Brand Identity:<input <?php if (!(strcmp("$bi",1))) {echo "checked=\"checked\"";} ?> name="bi" type="checkbox"  value="1" />
    Print:<input <?php if (!(strcmp("$print",1))) {echo "checked=\"checked\"";} ?> name="print" type="checkbox"  value="1" />
    Online:<input <?php if (!(strcmp("$online",1))) {echo "checked=\"checked\"";} ?> name="online" type="checkbox"  value="1" /></td>
  </tr>
  <tr>
    <th scope="row"><p>Short Details</p></th>
    <td><input class="udp" name="short_details" type="text" value="<? echo "$short_details"  ?>" size="50" MAXLENGTH="60"/></td>
  </tr>
  <tr>
    <th height="163" valign="top" scope="row"><p>Full Details</p></th>
    <td><textarea class="udp" name="full_details" cols="50" rows="10" id="full_details"><? echo "$full_details"?>
    </textarea>
      <input class="udp" type="submit" name="Update" id="Update" value="Update" /></td>
  </tr>
  <tr>
    <th scope="row">
    </form></th>
    </tr>
</table>
<? 
$i++;
}
?>


and this is the processing page
can any one help with the sql injection protection here please just an example will do thanks.



<?php
error_reporting(E_ALL);

include ("../includes/db_config.php");

$con = mysql_connect($db_hostname,$db_username,$db_password);
@mysql_select_db($db_database) or die( "Unable to select database");

$bi=mysql_result($result,$i,"bi");
$print=mysql_result($result,$i,"print");
$online=mysql_result($result,$i,"online");
$ud_pn=$_GET['pro_name'];
$ud_sd=$_GET['short_details'];
$ud_fd=$_GET['full_details'];
$ud_bi=$_GET['bi'];
$ud_print=$_GET['print'];
$ud_online=$_GET['online'];
$ud_order=$_GET['order'];


//// when i add order = '$ud_order' to the query it errors and i dont no why as it is layed out the same as pro_name and bi and print ect.

$query = "UPDATE $db_table SET pro_name = '$ud_pn', order = '$ud_order', bi = '$ud_bi', print = '$ud_print', online = '$ud_online', short_details = '$ud_sd', full_details = '$ud_fd' WHERE id = '".$_GET['id']."'";

if (!mysql_query($query,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "$ud_pn record updated<p>With:<p>Short Details:<p>$ud_sd<p>Full Details:<p>$ud_fd<p>Category:<p>Brand Identity:$ud_bi</br>
Print:$ud_print</br>
Online:$ud_online</br><p>
Ordering:$ud_order</br> ";





mysql_close($con)

?>

Hello guys,
I have these lines of code
echo $_POST['uteamid'];
$iddquery1 = mysql_query("Select Driver_ID from Driver where Driver_Name='".$temp."'");
$result = mysql_fetch_assoc($iddquery1);
$idquery2 =mysql_query("Select Driver_ID from Driver where Driver_Name='".$_POST['DriverSubst']."'");
$resultidquery2 = mysql_fetch_assoc($idquery2);
$replaceid = $result['Driver_ID'];
echo $replaceid;
$updatequery2 = "Update Team_Driver SET Driver_ID = '".$resultidquery2['Driver_ID']."' where UTeam_ID='".$_POST['uteamid']."' and Driver_ID='".$replaceid."'";
echo $updatequery2;

Output of the query is:

5
1
Update Team_Driver SET Driver_ID = '2' where UTeam_ID='5' and Driver_ID=''
Why is that last Driver_ID = null?
wen it should be 1..and its echoing 1 right before that line.
Any help will be appreciated