The way I was thinkig is:
Code: Select all
$insert = "INSERT INTO `request` (`quote_no`, `username` , `title` , `description` , `post_date` , `required_by_date` )
VALUES (
'',
'".mysql_real_escape_string($_POST['title_txt'])."',
'".mysql_real_escape_string($username)."',
'".mysql_real_escape_string($title)."',
'".mysql_real_escape_string($description)."',
'".mysql_real_escape_string($post_date)."',
'".mysql_real_escape_string($require_by_date)."'
)";
if($insert_result = $connector->query($insert)) {
//get the id of the row that is just inserted
$id = $connector->insert_id();
//create quote no
$quote = "Q2000".$id; // wht happens when id= 2000? the quote no looks like Q20002000 . Not what I want.
Is there any function I can use?
//now update the quote no
$update = "UPDATE request SET quote_no = $quote WHERE id= $id"