Insert and Update

[D_tunisia]

I've got this code:

<?php

session_start();

if (!$_SESSION["valid_user"])
    {
    // User not logged in, redirect to login page
    Header("Location: login.php");
    }

include ("dbConfig.php");

?>

<?php

if ($submit) {

  $sql = "INSERT INTO threads (userid,postid,title,text,date) VALUES ('$userid','$postid','$title','$text','$date')";

  $result = mysql_query($sql);

  echo "Thank you! Your message has been posted.\n";

} else{

?>

<form method="post" name="inputform" action="<?php echo $PHP_SELF?>">

<input type="hidden" name="postid" value="<?php print $id; ?>">

<input type="hidden" name="date" value="<?php echo date("y.m.d, H:i:s",time()); ?>">

<input type="hidden" name="userid" value="<?php print $_SESSION["valid_id"]; ?>">

Title: <input type="text" size="37" name="title">

<br><textarea rows="10" name="text" cols="40"></textarea><br><br>

  <input type="Submit" name="submit" value="Post Message">

  </form>

<?php

} // end if

?>

But as well as entering the data into a new record, I want to update another record with the same date information.

Can anyone point me in the right direction please?

Thanks in advance.

[devinemke]

do the UPDATE query right after the INSERT query. use the WHERE clause to specifiy which record you want to update.

[D_tunisia]

I've tried to do it like this:

  $sql = "INSERT INTO threads (userid,postid,text,date) VALUES ('$userid','$postid','$text','$date')";


  $result = mysql_query($sql);

  $sql = "UPDATE threads SET date = '$date_update' WHERE id = $id";


  $result = mysql_query($sql);

But it doesn't do the update, what am I doing wrong?

[devinemke]

what does [man]mysql_error[/man] have to say?
are $date_update and $id actually set?

$sql = "UPDATE threads SET date = '$date_update' WHERE id = '$id'";
$result = mysql_query($sql) or exit(mysql_error());

[D_tunisia]

It says:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[devinemke]

again i ask, are $date_update and $id actually set?
what do you see...

$sql = "UPDATE threads SET date = '$date_update' WHERE id = '$id'";
echo $sql;

[D_tunisia]

I see what you mean now sorry.

I get

UPDATE threads SET date = '05.02.26, 07:55:08' WHERE id = Thank you! Your message has been posted.

Looks like the ID isn't being passed.

[devinemke]

you are never setting $date_update so your UPDATE query is failing.

[D_tunisia]

Originally posted by devinemke
you are never setting $date_update so your UPDATE query is failing.

How do I set it? <-- Newbie here.

[D_tunisia]

This is the code I have:

<?php

session_start();

if (!$_SESSION["valid_user"])
    {
    // User not logged in, redirect to login page
    Header("Location: login.php");
    }

include ("dbConfig.php");

?>

<?php 


$page_id = $id;
$date_update = date("y.m.d, H:i:s",time());


if ($submit) {



  $sql = "INSERT INTO threads (userid,postid,text,date) VALUES ('$userid','$postid','$text','$date')";


  $result = mysql_query($sql);


  $sql = "UPDATE threads SET date = '$date_update' WHERE id = $page_id";
  $result = mysql_query($sql);



  echo "Thank you! Your message has been posted.\n";



} else{

?>

<form method="post" name="inputform" action="<?php echo $PHP_SELF?>">


<input type="hidden" name="postid" value="<?php print $id; ?>">


<input type="hidden" name="date" value="<?php echo date("y.m.d, H:i:s",time()); ?>">

<input type="hidden" name="date_update" value="<?php echo date("y.m.d, H:i:s",time()); ?>">



<input type="hidden" name="userid" value="<?php print $_SESSION["valid_id"]; ?>">

<br><textarea rows="10" name="text" cols="40"></textarea><br><br>



  <input type="Submit" name="submit" value="Post Message">



  </form>

<?php







} // end if







?>