update query question

[bhavin_85]

hi guys

 

im trying to write an update query that updates a few fields in a row on my sql database

 

im gettin a parse error and i cant figure out why

 

<?php
session_start();
if ( empty($_SESSION['username'])){
header("location:default.php");
exit;
}
$id=$_SESSION['cust_id'];

include('config.php')

$sql="UPDATE customer SET first_name = ".$_POST['first_name']" WHERE cust_id = '$id'";
mysql_query($sql) or die ("Couldnt execute $sql: " . mysql_error()); 
?>

ive used post because there is a form on the previous page which the user enters their updated values into

[iceman400]

try adding (') around the post['first_name'] like this:

$sql="UPDATE customer SET first_name = [color=yellow][b]'[/b][/color]".$_POST['first_name']"[color=yellow][b]'[/b][/color] WHERE cust_id = '$id'";

[trq]

Your missing the closing ; on this line...

 

include('config.php')

 

Also note that include is NOT a function and does not require the braces.

 

include 'config.php';

[bhavin_85]

$sql="UPDATE customer SET first_name = '".$_POST['first_name']"' WHERE cust_id = '$id'";

 

gave that a try but im still getting a parse error

 

says unexpected "

 

 

[trq]

$sql = "UPDATE customer SET first_name = '".$_POST['first_name']."' WHERE cust_id = '$id'";

[bhavin_85]

cheers

 

i realised i was missing the . after the post

 

if i have a date field set in one of the fields and the user has to update it how would i do it?

 

the date is currently set at yyyy/mm/dd if i want it to be entered as dd/mm/yyyy but converted before its stored in the database?

 

would a drop down list work?