Well, I tried that and this is what i got:
INSERT INTO tutor (tutor_name, tutor_contact, tutor_email, tutor_profile)
VALUES (''irin'', ''788798878'', ''[EMAIL PROTECTED]'', ''no profile'')
DB Error: syntax error
well, when I echo again, i can successfully see the values I entered. But this
time there's a "DB syntax error"????
and when I went into the database to view, it stil reflect a "NULL" value...
-------------------------------------------------------------------------------
On Tuesday 09 December 2003 15:20, [EMAIL PROTECTED] wrote:
> This is what I get after I "echo" my query statement:
>
> INSERT INTO tutor (tutor_name, tutor_contact, tutor_email, tutor_profile)
> VALUES ('NULL', 'NULL', 'NULL', 'NULL')
>
> How come the value is null???
>
> In my INSERT query, I already state my value variable to be the name of the
> fields in my html. Why is it still inserting "NULL" into the database when
> I have entered values in the HTML fields?????
>
> $sql = "INSERT INTO tutor (tutor_name,
> tutor_contact,tutor_email,tutor_profile)
> VALUES
> ('$tutor_name', '$tutor_contact', '$tutor_email',
> '$tutor_profile')";
>
>
> What could be the problem??
> >$tutor_name = $db->quote($POST["tutor_name"]);
> >$tutor_contact = $db->quote($POST["tutor_contact"]);
> >$tutor_email = $db->quote($POST["tutor_email"]);
> >$tutor_profile = $db->quote($POST["tutor_profile"]);
You most probably be wanting to use $_POST instead of $POST.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
