0

Hi there..

Once running through your post. Well I believe the problem more or less would be in reltaion to the sql query.
The parameters of a form will be available be available in a string format when you use the POST option. I've noticed that your sql statement , encloses the the values in single quotes.
When you echo the sql statement you would probably be getting a statement which would be like values(xyz,1,ten), where as it should be values('xyz',1,'ten') . Notice the quotes.

Kindly try it and let me know

0

Hi there..

Once running through your post. Well I believe the problem more or less would be in reltaion to the sql query.
The parameters of a form will be available be available in a string format when you use the POST option. I've noticed that your sql statement , encloses the the values in single quotes.
When you echo the sql statement you would probably be getting a statement which would be like values(xyz,1,ten), where as it should be values('xyz',1,'ten') . Notice the quotes.

Kindly try it and let me know

where in the script? and what section needs changing?

0

Easiest way would be assign the value of the posted form elements to a variable and then use single quote. Eg.

$name=$_POST['name'];
$city=$_POST['city'];

$query="insert into tablename (name,city) values ('$name','$city')";

Cheers,
Naveen

0

Easiest way would be assign the value of the posted form elements to a variable and then use single quote. Eg.

$name=$_POST['name'];
$city=$_POST['city'];

$query="insert into tablename (name,city) values ('$name','$city')";

Cheers,
Naveen

Ive givin up on my login form, its a waste of time. and its never going to work (my scripting is crap, so their fourth im going to start on Visual Basics.

0

Oh woops, Sorry. All I did was give my e-mail address. I wanted to keep it private so other people don't add me.

0

If you want to help to solve a problem, please do it here in the forums.
When other people experience similar problems, they can just search the forum and find the answer.
That's the reason why the rule 'keep it on the site' exists

Niek

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.