0

I cannot get this mysql update query to work. Please help. I am new at this.:)

<?PHP
session_start();
?>

<?php

//it's getting the data from the post fine. I know this part is working. 

$ud_id=$_POST['ud_id'];
$ud_fname=$_POST['ud_fname'];
$ud_lname=$_POST['ud_lname'];
$ud_type=$_POST['ud_type'];
$ud_used=$_POST['ud_used'];
$ud_sdate=$_POST['ud_sdate'];
$ud_edate=$_POST['ud_edate'];

if ($ud_id == "") echo " No record ID supplied! <br>";
else
echo "Amending record $ud_id";

if ($ud_id == "") echo " ";
else
echo "<br> Employee Name: $ud_fname $ud_lname";

//clean up any carriage returns etc

$ud_fname = preg_replace("/[\n\r]*/","",$ud_fname);
$ud_lname = preg_replace("/[\n\r]*/","",$ud_lname);



//Select the database we want to use
$db = mysql_connect("localhost", "root", "");
mysql_select_db("test1",$db) or die ('Unable to connect to database');

//NOT WORKING
mysql_query("UPDATE persons SET FirstName ='$ud_fname', LastName ='$ud_lname', Type ='$ud_type', DaysUsed ='$ud_used', StartDate ='$ud_sdate', EndDate ='$ud_edate', WHERE ID = '$ud_id'");

if ($ud_id == "") echo " ";
else
echo "<BR>Record Updated<BR><BR>";
?>

<?php

I then display the new data, but data is not updated.

Edited by mike_2000_17: Fixed formatting

3
Contributors
3
Replies
9
Views
7 Years
Discussion Span
Last Post by orcaraheel
0

replace this with your line

mysql_query("UPDATE persons SET FirstName ='$ud_fname', LastName ='$ud_lname', Type ='$ud_type', DaysUsed ='$ud_used', StartDate ='$ud_sdate', EndDate ='$ud_edate' WHERE ID = '$ud_id'");

you had a "," between the EndDate ='$ud_edate' and WHERE ID = '$ud_id'"

0
$con=mysql_connect("$hostname_boss", "$username_boss", "$password_boss")or die("cannot connect");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
                                 mysql_select_db("$database_boss")or die("cannot select DB");    
$update = $_POST['update'];
$quantity = $_POST['quantity'];
$id = $_POST['id'];
if($update){
$insert2="UPDATE productorder SET Product_quantity = '$quantity' WHERE product_id = '$id'";  
$resu= mysql_query($insert2);
echo "your quantity: $quantity";
echo "your id: $id";
echo "<meta http-equiv=\"refresh\" content=\"0;URL=shoping_cart.php\">";
mysql_close();
}

they update the lasr row(record) in database table how i update the other row(records)

Edited by Reverend Jim: Fixed formatting

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.