Re: [PHP] Problem with INSERT Query

2003-12-30 Thread Marek Kilimajer
Do you understand the request - response process? User requests a page, php buids the page and sends it to the user, user's browser displays the page, users views it and takes some action (follows a link, submits a form) and the whole process repeats. [EMAIL PROTECTED] wrote: Hi all: Well, whe

[PHP] Problem with INSERT Query

2003-12-30 Thread irinchiang
Hi all: Well, when i bring out the page with the drop down list it was able to display all tutors' names from "tutor_name" column. Anyway here's a review of my code (snip) again before i continue: --- $sql = "INSERT I

Re: [PHP] problem with INSERT query

2003-12-09 Thread irinchiang
[EMAIL PROTECTED] schrieb: > > Thanks alot for your help!!! > It was only a spacing mistake... > There should have no spacing in between each variables: > > VALUES ($tutor_name,$tutor_contact,$tutor_email,$tutor_profile)"; hi, a space after a comma shouldn't be a problem. your problem

Re: [PHP] problem with INSERT query

2003-12-09 Thread Tom Rogers
Hi, Tuesday, December 9, 2003, 4:58:30 PM, you wrote: ijc> Hi all, ijc> I am trying to do a simple INSERT data into the database using the following ijc> php script but the problem here is that whenever I click "submit", the script ijc> only insert a "NULL" value into the columns into the data

Re: [PHP] problem with INSERT query

2003-12-09 Thread Sven
[EMAIL PROTECTED] schrieb: Thanks alot for your help!!! It was only a spacing mistake... There should have no spacing in between each variables: VALUES ($tutor_name,$tutor_contact,$tutor_email,$tutor_profile)"; hi, a space after a comma shouldn't be a problem. your problem were probably your sin

Re: [PHP] problem with INSERT query

2003-12-09 Thread irinchiang
Thanks alot for your help!!! It was only a spacing mistake... There should have no spacing in between each variables: VALUES ($tutor_name,$tutor_contact,$tutor_email,$tutor_profile)"; Thanks a million. Irin. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www

Re: [PHP] problem with INSERT query

2003-12-09 Thread Viraj Kalinga Abayarathna
VALUES (''irin'', ''788798878'', ''[EMAIL PROTECTED]'', ''no profile'') in above line, note the two quotes, in both side of each value.. this is the cause to your DB syntax error.. correct the above line as follows... ($tutor_name,$tutor_contact,$tutor_email,$tutor_profile)"; and try, but investi

Re: [PHP] problem with INSERT query

2003-12-09 Thread Jason Wong
On Tuesday 09 December 2003 15:34, [EMAIL PROTECTED] wrote: > 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

Re: [PHP] problem with INSERT query

2003-12-09 Thread irinchiang
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

Re: [PHP] problem with INSERT query

2003-12-09 Thread irinchiang
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 ti

Re: [PHP] problem with INSERT query

2003-12-09 Thread Jason Wong
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 alr

Re: [PHP] problem with INSERT query

2003-12-09 Thread irinchiang
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.

Re: [PHP] problem with INSERT query

2003-12-09 Thread Viraj Kalinga Abayarathna
insert following... echo $sql; immediatly after the folowing code block.. $sql = "INSERT INTO tutor (tutor_name, tutor_contact,tutor_email,tutor_profile) VALUES ('$tutor_name', '$tutor_contact', '$tutor_email', '$tutor_profile')"; then execute the script, and check whether it sho

[PHP] problem with INSERT query

2003-12-08 Thread irinchiang
Hi all, I am trying to do a simple INSERT data into the database using the following php script but the problem here is that whenever I click "submit", the script only insert a "NULL" value into the columns into the datadase instead the value I enter in the forms fieldSELECT query was su