PHP - Php Mysql Update Failure?

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 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.

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?

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]
<?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

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";
}

?>

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.

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.

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'm having problems updating my database, I have 4 fields i want to change. I checked all the { on the page, that's not the problem, I tried to echo information from the database and it displayed my information so that's not the problem, i tried yelling at my computer, that didn't work, i tried to input data into the database with the insert function it worked but is not practical in my situation. I'm probably going to face palm when i find out whats wrong, help please 

btw, the $_SESSION['usr'] was set in another page and works.


Code: [Select]

<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Edit Info</title>
   
    <link rel="stylesheet" type="text/css" href="demo.css" media="screen" />
   
</head>

<body>

<div id="main">


<div class="container">
<font size="5" face="sans-serif">Change Settings <?php echo "{$_SESSION['usr']}"; ?></font>
<form action="" method="POST">
<table cellpadding="3" cellspacinf="4" border="0">

<tr>
<td>Name</td>
<td><input type="text" name="name" /></td>
</tr>
<tr>
<td>Age</td>
<td><input type="text" name="age" /></td>
</tr>
<tr>
<td>Gender</td>
<td><input type="text" name="mf" /></td>
</tr>
<tr>
<td>Location</td>
<td><input type="text" name="loc" /></td>
</tr>
<tr>
<td><input type="submit" name="submit" value="submit" /></td>
</tr>
</table>
</form>



<?php
if ($_POST['submit']){
define('INCLUDE_CHECK',true);
require 'connect.php';

$usr = $_SESSION['usr'];

$sql = 
mysql_query("UPDATE members 
SET name='{$_POST['name']}', age='{$_POST['age']}, mf='{$_POST['mf']}', loc='{$_POST['loc']}' 
WHERE usr='{$_SESSION['usr']}'");

if($sql){
echo 'Changes Saved!';

}else{
echo 'Error';
} 
}

?>
</div>
</div>
</body>
</html>

Hi
I currently have this form to update the names of each session in the database.
However how do I go about updating more than one value. I also want to update the 'order' swell as the name so the order in which they're displayed is updated

I want to have another text field next to it for the order which will just be a number but i can't figure out how to update both in the foreach() function

Code: [Select]
<?php
 
if($_POST['update_sessions']){
foreach($_POST as $sessionid => $sessionname){
mysql_query("UPDATE `sessions` SET `name`='".mysql_real_escape_string($sessionname)."' WHERE `id`='".mysql_real_escape_string($sessionid)."'");
}
echo("Done!");
}

?>
<form method="post">
<?php


$getsessions = mysql_query("SELECT * FROM `sessions` ORDER BY `order`");
while($sessions = mysql_fetch_array($getsessions)){
echo("<input type='text' name='".$sessions['id']."' value='".$sessions['name']."'><br />\n");
}
?>
<input type="submit" value="Update" name="update_sessions" />
</form>

Hi,   Im having a problem and I can't seem to figure it out or find anything on the net.   If I use the following code the script successfully updates every row in the table:

mysqli_query($con,"UPDATE Ads SET Ads_LocalArea='Stroud'");

However if I try updating the table using the WHERE clause in any of the combinations below nothing happens.

mysqli_query($con,"UPDATE Ads SET Ads_LocalArea='Stroud' WHERE Ads_ID=$DBROWID");

----------------------------------------------------------------------   My Script:

mysqli_query($con,"INSERT INTO Ads (Ads_ID, Ads_AID, Ads_Title)
VALUES ('', '$Polished_AdRef', '$Polished_AdTitle')");

$DBROWID = mysqli_insert_id($con);

mysqli_query($con,"UPDATE Ads SET Ads_AID='Stroud' WHERE Ads_ID=$DBROWID");

// TRIED THESE TOO
// mysqli_query($con,"UPDATE Ads SET Ads_AID='Stroud' WHERE Ads_ID='$DBROWID'");
// mysqli_query($con,"UPDATE Ads SET Ads_AID='Stroud' WHERE Ads_ID='5'");

Does any one know where I am going wrong?

Thanks for reading my post. How can I update the ten rows from MYSQL


Thanks in advance

Hi I have the file "pback.php" which displays a mysql table.
One row allows me to update the data.
If I press "update it leads me to update.php, but there I just get white fields instead of the data from the id requested.
If I type anything in the field and press confirm it opens update_ac but just says error.
What do I do wrong?
Thanks!
Quote

pback.php

Code: [Select]
<?php
$host="xxx"; // Host name
$username="xxx"; // Mysql username
$password="xxx"; // Mysql password
$db_name="xxx"; // Database name
$tbl_name="sp_users"; // 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");

//$sql="SELECT * FROM $tbl_name ORDER BY user_id";
$sql="SELECT * from sp_users,sp_schools where sp_users.user_id=sp_schools.school_id ORDER BY school_name";
$result=mysql_query($sql);
$num_rows=mysql_num_rows($result);
?>
<style type="text/css">
<!--
.style2 {font-weight: bold}
.style3 {
font-family: Arial, Helvetica, sans-serif;
color: #000000;
}
.style10 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #000000; }
#Layer1 {
position:absolute;
left:803px;
top:36px;
width:65px;
height:28px;
z-index:1;
}
#Layer2 {
position:absolute;
left:707px;
top:19px;
width:143px;
height:39px;
z-index:1;
}
-->
</style>

<title>User overview</title>
</html>
<div id="Layer2">
  <form action="<?= $_SERVER['PHP_SELF'] ?>" method="post">
<input type="hidden" name="foo" value="<?= $foo ?>" />
<input type="submit" name="submit" value="Refresh" />
</form></div>
<table width="779" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#996600">
<tr>
<td width="777">
 
    <div align="left">
      <table width="779" border="1" cellspacing="0" cellpadding="3">
        <tr>
          <td colspan="6" align="center"><div align="center" class="style1 style3"><strong>SchoolPorta.com Users / Total: <?php echo $num_rows ?></strong></div></td>
          </tr>
        <tr>
          <td width="342" align="center"><span class="style2">school</span></td>
          <td width="62" align="center"><span class="style2">Name</span></td>
          <td width="104" align="center"><span class="style2">Lastname</span></td>
          <td width="130" align="center"><span class="style2">Email</span></td>
      <td width="64" align="center"><span class="style2">Update</span></td>
        </tr>
        <?php
while($rows=mysql_fetch_array($result)){
?>
        <tr>
          <td><span class="style10"><? echo $rows['school_name']; ?></span></td>
  <td><span class="style10"><? echo $rows['user_first_name']; ?></span></td>
          <td><span class="style10"><? echo $rows['user_surname']; ?></span></td>
          <td><span class="style10"><a href="mailto:<?php echo $rows['user_login']; ?>"><?php echo $rows['user_login']; ?></a></span></td>
          <td align="center"><a href="update.php?id=<? echo $rows['user_id']; ?>" class="style10">update</a></td>
        </tr>
        <?php
}
?>
      </table>
    </div></td>
</tr>
</table>

<div align="left">
  <p>&nbsp;   </p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>
    <?php
mysql_close();
?>
  </p>
</div>
Quote

update.php

Code: [Select]
<?php

$host="xxx"; // Host name
$username="xxx"; // Mysql username
$password="xxx"; // Mysql password
$db_name="xxx"; // Database name
//$tbl_name="sp_users"; // 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['user_id'];

?>
<?php
$sql="SELECT * from sp_users,sp_schools where sp_users.user_id=sp_schools.school_id";
$result=mysql_query($sql) or die("Problem with the query: $sql<br>" . mysql_query());
?>
<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"><div align="center" class="style1">Update data in mysql </div></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"><span class="style7">Name</span></td>
<td align="center"><span class="style7">Lastname</span></td>
<td align="center"><span class="style7">Email</span></td>
</tr>
<tr>
<td>&nbsp;</td>
<td align="center"><input name="name" type="text" id="name" value="<? echo $rows['user_first_name']; ?>"></td>
<td align="center"><input name="lastname" type="text" id="lastname" value="<? echo $rows['user_surname']; ?>" size="15"></td>
<td><input name="email" type="text" id="email" value="<? echo $rows['user_login']; ?>" size="15"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input name="id" type="hidden" id="id" value="<? echo $rows['user_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();

?>
</body>
</html>
Quote

update_ac.php

Code: [Select]
<?php
$host="xxx"; // Host name
$username="xxx"; // Mysql username
$password="xxx"; // Mysql password
$db_name="xxx"; // Database name
$tbl_name="sp_users"; // 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 name='$user_name', lastname='$user_lastname', email='$email' WHERE id='$user_id'";
$result=mysql_query($sql);

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

else {
echo "ERROR";
}

?>

I am attempting something similar to the following:

Code: [Select]
mysql_query("UPDATE table SET name='$name' WHERE id=$id");
if (mysql_affected_rows()==0) {
mysql_query("INSERT INTO table (id, name) VALUES ('$name',$id);
}

If the $id row does not exists in the table, mysql_affected_rows() returns 0 and a new $id row gets inserted
but if the $id row already exists and UPDATE changes nothing, mysql_affected_rows() still returns 0
and gives an 'duplicate id' error as expected.

I know I could use a SELECT to test for the existance of the $id row.
In Perl there is an '0E0', 'zero but true', condition to handle this. Is there an equivilant in PHP?