Form post -&gt; no insert

Form post -> no insert

tidalwave

HI I'm new to PHP/mysql So im learning fast and trying all kinds of ideas I get in my mind. But for some reason I cant get this form active with is funtion.

I want a form, with inout fields. and after inputting the data you press submit and its adds or updates it too the database. I havent even gotten pass the Insert so update isnt in yet. Maybe its a very small error but I looked at it for 2 days now so plz help

here is the file I have, its called voorbeeld20.php on my computer and runs on localhost so that clears that up. Again plz help

thnx TidalWave

//
//<HEAD>
//<TITLE>Data Entry</TITLE>
//</HEAD>
//<BODY BGCOLOR="#FFFFFF" LINK="#0000FF" VLINK="#800080" TEXT="#000000" TOPMARGIN=0 LEFTMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
//<?php
//$server = mysql_connect("localhost") or die//("Couldn't Connect.");
//mysql_select_db("Login",$server) or die("Couldn't Select.");
//if ($submit) {
//$sql = "INSERT INTO Users (Title, Name, Class, Level, HpMp, Er, Ac, Weapon) VALUES ($Title, $Name, $Class, $Level, $HpMp, $Er, $Ac, $Weapon);";

//Mysql_query($sql) or die("Oops");
//echo "Record updated/edited!<p>";}
//mysql_close();
//?>
//<form method="Get" action="voorbeeld20.php">
//Title: <input type=text name="Title"><br>
//Name: <input type=text name="Name"><br>
//Class: <input type=text name="Class"><br>
//Level: <input type=text name="Level"><br>
//Hp/Mp: <input type=text name="HpMp"><br>
//Er: <input type=text name="Er"><br>
//Ac: <input type=text name="Ac"><br>
//Weapon: <input type=text name="Weapon"><br>
//<input type=submit name="submit" value="Submit">
//</Form>
//</Body>
//

amcgrath

what error are you getting?

tidalwave

Oops, like I programmed

Anon

I think you have too many semi-colons.

You typed:
$sql = "INSERT INTO Users (Title, Name, Class, Level, HpMp, Er, Ac, Weapon) VALUES ($Title, $Name, $Class, $Level, $HpMp, $Er, $Ac, $Weapon);";

Try this:
$sql = "INSERT INTO Users (Title, Name, Class, Level, HpMp, Er, Ac, Weapon) VALUES ('$Title', '$Name', '$Class', '$Level', '$HpMp', '$Er', '$Ac', '$Weapon')";

Notice I did two things. I put single quotes around each item in the VALUES () and I removed a semi-colon.

tidalwave

O man, U saved me!!! it worked right away, Now I can finally go on.... Thnx a lot... Saving email to look at when in trouble again and if im out of ideas

TidalWave