PHP - Mysql Update With Maximum Value

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?

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 ?

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

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

?>

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 i have this following code that doesn't work

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.

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.

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

I am trying to update a mysql field.

I am using this php code all the login info is right and it does not work
Table Name: camera
Field I Want To Change: public1

Code: [Select]
//Connect To Database
$db_host = "localhost";
$db_name = "mydbname";
$username = "myusername";
$password = "mypassword";

mysql_connect($db_host,$username,$password);
mysql_select_db($db_name);
$result = mysql_query("UPDATE camera SET public1='2' WHERE cwuser='$user'");
?>

Hello all, first post here so i hope i'm doing this right and am putting this into the right place.
Im in the process of integrating a blog into my website, mostly it's set up however i'm currently working on the code to update the posts (theres only 2 parts a title and a comments[which is in actual fact the post content itself]). The code succsefully completes without any errors but for some reason it does not actually update the mysql database.. the code i'm using is as follows:

Code: [Select]
<?php
require_once('header.php');
include "../blog/blogconfig.php";

if(isset($_POST['submit'])){
$update="UPDATE eq_blogarticle SET title='".$_POST['title']."',comments='".$_POST['comment']."' WHERE artid='$aid'";
if(!mysql_query($update)){
echo mysql_error();
}else{
header("location:blog.php?action=listmsgs");
exit;
}
}
?>
<?php
// get value of aid that sent from address bar by blog.php?action=listmsgs
$aid=$_GET['aid'];

// Retrieve data from database
$sql="SELECT * FROM eq_blogarticle WHERE artid='$aid'";
$result=mysql_query($sql);

$row=mysql_fetch_array($result);
?>

<form name="form2" method="post" action="update.php">
<script type="text/javascript">var SITE_URL="<?php echo SITE_URL;?>";</script>
<script type="text/javascript" src="<?php echo SITE_URL;?>/includes/js/nicEdit.js"></script>
<script type="text/javascript">
//<![CDATA[
bkLib.onDomLoaded(function() { nicEditors.allTextAreas() });
//]]>
</script>
<body>
<table width="100%" border="0" cellspacing="1">
  <tr>
    <td colspan="2" class="temptitle">Equidisc Blog</td>
  </tr>
  <tr>
    <td width="74%" valign="top">
<table>
Edit Blog Post
<br>
<br>
Title:
<br>
<input name="title" type="text" class="input" id="title" value="<? echo $row['title']; ?>">
<br>
<br>
<span class="style1 style2 style3">Blog Post:</span>
<br>
<br>
<textarea name="comments" cols="55" rows="12" class="input" id="comments"><? echo stripslashes($row['comments']); ?></textarea>
<br>
<br>
<input name="aid" type="hidden" id="aid" value="<? echo $row['artid']; ?>">
<input type="submit" name="submit" value="Submit">
</form>
</table>
</td>
    <td width="26%" valign="top"><table width="100%" border="0" cellspacing="1">
      <tr>
        <td colspan="2"><img src="../blog/images/fb.gif" width="16" height="16" /> <strong>Blog Menu</strong></td>
        </tr>
       <tr>
        <td><a href="blog.php">Home</a></td>
       </tr>
      <tr>
        <td><a href="blog.php?action=newblogpost">New Post </a></td>
        </tr>
      <tr>
        <td><a href="blog.php?action=listmsgs">Manage Posts </a></td>
        </tr>
    </table></td>
  </tr>
</table>
</body>
<?php
require_once('footer.php');
?>
Explanation: header/footer.php obvious
../blog/blogconfig.php holds my mysql connection settings and connects to the sql, this is the same config as is used for creating the new posts which i have no issues with so i dont think the issue lays there. If i run the query on phpmyadmin with dummy data it works fine and updates the entry..
Any help would be very much appreciated as i'm at the end of my tether with this!.
Thanks in advance.
Jo

Good Day    Please could someone be so gracious as to help me with the following problem.   I am wanting to update a MYSQL database from a Firebird database.    I have tested connecting to both databases individually which works fine, it is just when I put the code together it does not work.   Below is the code

//Firstly I connect to the MYSQL database to see what needs to updated
      
 mysql_connect("localhost", "database", "password") or die(mysql_error());
 mysql_select_db("database") or die(mysql_error());

$check = "SELECT * FROM table WHERE blah != ''";

$result = mysql_query($check)
or die ("Error in query: $check. " . mysql_error());
if (mysql_num_rows($result) > 0)
{
while($row = mysql_fetch_object($result))

 
{
$blah = $row->blah;

// Then I connect to the Firebird database to get the info

$dsndb = 'host';
$userdb = 'user';
$passdb = 'password'; 
try {  
    $dbh = new PDO($dsndb, $userdb, $passdb);
               
   $sth = ("SELECT * from table WHERE blah = '$blah'");


  foreach ($dbh->query($sth) as $row)
   
   {

//Then I update the MYSQL database from the Firebird database info

$sql = "UPDATE table SET field1 = 'field1', field2 = 'field2', field3 = 'field3' WHERE blah = '$blah'";

$update=mysql_query($sql) or die(mysql_error());

     }

}

  } 
}

Your assistance will be greatly appreciated.          

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?