PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
<?php
@session_start();
$con = mysql_connect("*","*","*");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("*", $con);
$id4 = $_SESSION['id2'];
$fquote1 = $_POST['fquote'];
$fbasis1 = $_POST['fbasis'];
mysql_query("UPDATE main2.id SET fquote='$fquote1', fbasis='$fbasis1'] WHERE main2.id = $id4");
mysql_close($con);
?>
Looks right but I cant just seem to get it to work..
Any help would be awesome. Thanks.
Last edited by aredden on Wed Jun 06, 2007 1:20 pm, edited 2 times in total.
<?php
/*
FOR SOME REASON YOU ARE NOT INCLUDING THIS FILE
IF YOU DONT WANT IT HERE DELETE THE LINE
*/
//include("mailout.php");
session_start();
$con = mysql_connect("*","*","*");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("*", $con);
/*
YOU DO ABSOLUTELY NO EXISTENCE CHECKS HERE
WHAT HAPPENS IF THIS SESSION VAR HAS NOT YET BEEN SET?
*/
$id4 = $_SESSION['id2'];
$fquote = "111.3";
/*
WHERE DOE THE VAR $basis GET SET?
WRAPPING THIS STRING IN DOUBLE QUOTES TELLS
PHP TO PARSE THE STRING FOR VARS
*/
$fbasis = "$basis";
/*
AGAIN THERE ARE NO EXISTENCE CHECKS FOR THESE
VARS. WHAT HAPPENS IF THERE IS NOT POST ARRAY?
*/
$fquote1 = $_POST['fquote'];
$fbasis1 = $_POST['fbasis'];
/*
IF THE ABOVE VARS ARENT'T SET THEN THIS
QUERY WILL USE NULL VALUES FOR UPDATES
*/
mysql_query("UPDATE main2 SET fquote='$fquote1', fbasis='$fbasis1' WHERE main2.id= $id4");
mysql_close($con);
?>
The general syntax you want to follow for updates is: