Whats wrong with my insert script :((

[alexander_s]

im getting an error on the details query line 🙁

<?php
function texter()
{
global $conn;
$conn = mysql_connect("localhost", "root", "diewin") or die(mysql_error());
mysql_select_db("texter",$conn) or die(mysql_error());
}
?>

<?php

$title=$POST['title'];
$date=$POST['date'];
$text=$_POST['text'];

$query_details = "INSERT INTO details (textid, title, date) VALUES('', $POST['title'], $POST['date'])";
$query_text = "INSERT INTO text (textid, text) VALUES((SELECT LAST_INSERT_ID()), $_POST['text']")";
mysql_query($query_details);
mysql_query($query_text);
mysql_close();
?>

[thorpe]

i see your only fairly new to the board, so welcome. just some advice... if your getting an error, its best to let us know what it is. also, its always a good idea (when posting code) to wrap your code in the forums php tags. this makes for MUCH easier reading.

now... some help.

depending on the type of field, most values need to be surrounded by single quotes, (int) is an exception.

also... why try to insert an empty value into textid? i'll assume this is an autoincriment type field.

try this;

$query_details = "INSERT INTO details (title, date) VALUES ('$_POST['title']','$_POST['date']')";

[AcousticJames]

I see you've stuck your $_POST variables into local variables. Why aren't you using those in your insert line? Would look much cleaner and avoid any confusion with quotes (whenever I see any kind of quote in a quoted string, I always wonder if I should be escaping them). So try this:

$query_details = "INSERT INTO details (title, date) VALUES ('$title', '$date');

Should work like a charm.

James

[alexander_s]

Now im getting an error on line 24 instead :/

wich is the insert into text query:

<?php
function texter()
{
  global $conn;
    $conn = mysql_connect("localhost", "root", "diewin") or die(mysql_error());
      mysql_select_db("texter",$conn) or die(mysql_error());
      }
      ?>




<?php



$title=$_POST['title'];
$date=$_POST['date'];
$text=$_POST['text'];


$query_details = "INSERT INTO details (title, date) VALUES ('$title', '$date');
$last_id=mysql_insert_id();
$query_texts = "INSERT INTO texts (text) VALUES ('$text');
mysql_query($query_details);
mysql_query($query_texts);
mysql_close();
?>

[alexander_s]

i fixed some quotes and solved that problem.
now it cant connect instead :S

Warning: mysql_insert_id(): A link to the server could not be established in /var/www/localhost/htdocs/insert.php on line 23

[thorpe]

you have an unterminated string on the line before your error. change it to;

$query_details = "INSERT INTO details (title, date) VALUES ('$title', '$date')";

[alexander_s]

Yeah i did that to thanks 🙂

But now i cant get it to give me an textid on both the details query and the texts query.

cuse my search script needs text.textid=details.textid
and since i get textid 1,2,3(with other words it works) on the details query but only 0,0,0 on the texts query i cant search on my database.