Niet inserten?
Gamezhoek
HTML interesse
Kan iemand mij vertellenw arom dit niet werkt?
$verzenden = mysql_query("INSERT INTO pm(subject, message, user_to, user_from, read, time) VALUES($subject, $bericht, $user_to, $user_from, '0', NOW())");
$verzenden = mysql_query ( "INSERT INTO pm(subject, message, user_to, user_from, read, time) VALUES($subject , $bericht , $user_to , $user_from , '0', NOW())" ) ;
8 antwoorden
ikkedikke
PHP expert variabelen buiten quotes halen, krijg je een error?
Gamezhoek
HTML interesse Geen error, en, variabelen staan ook buiten quotes... behalve die 0, wnt dat is een string.
timo
PHP ver gevorderde je moet altijd de waardes wel tussen '' zetten... en zet er nog eens 8er: or die(mysql_error());
Gamezhoek
HTML interesse 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 'read, time) VALUES(Onderwerp, Bericht, Gamezhoek, Gamezhoek, '0', NOW())' at line 1
marten (laatste wijziging 04/04/2006 19:40)
Beheerder
<?php
'" . $verzenden = mysql_query("
INSERT INTO pm
(subject,
message,
user_to,
user_from,
read,
time)
VALUES('" . $subject . "'.
'" . $bericht . "',
'" . $user_to . "',
'" . $user_from . "',
'0',
'NOW()'
)")
OR die(mysql_error());
?>
<?php
'" . $verzenden = mysql_query("
INSERT INTO pm
(subject,
message,
user_to,
user_from,
read,
time)
VALUES(' " . $subject . " '.
' " . $bericht . " ',
' " . $user_to . " ',
' " . $user_from . " ',
' 0 ',
' NOW( ) '
)")
OR die(mysql_error());
?>
Gamezhoek
HTML interesse Dan krijg ik, als ik er or die(mysql_error()); achter zet, deze error:
marten
Beheerder
<?php
$verzenden = mysql_query("
INSERT INTO pm
(subject,
message,
user_to,
user_from,
read,
time)
VALUES('" . $subject . "'.
'" . $bericht . "',
'" . $user_to . "',
'" . $user_from . "',
'0',
'NOW()'
)")
OR die(mysql_error());
?>
<?php
INSERT INTO pm
(subject,
message,
user_to,
user_from,
read,
time)
VALUES('" . $subject . "'.
'" . $bericht . "',
'" . $user_to . "',
'" . $user_from . "',
'0',
'NOW()'
)" )
?>
Dit onderwerp is gesloten .
Wat is jouw favoriete javascript framework? (S: 18, R: 2)
Gesponsorde links
Actiefste leden van de maand
