Hei jeg har laget en registering skjema men får ikke den til å funke.
Får bare denne feil mld.
Could not execute query : INSERT into smsreg (id,fame,lname,username,password,epost,epost1,mobil,sex,ar,p ost) VALUES ('her ','står','det','bare','hva','jeg skriver','i','skjema','på','regside,','').Unknown column 'password' in 'field list'
signup.php
sign.php
Tror jeg har sikkert gjort noe feil her.
Får bare denne feil mld.
Could not execute query : INSERT into smsreg (id,fame,lname,username,password,epost,epost1,mobil,sex,ar,p ost) VALUES ('her ','står','det','bare','hva','jeg skriver','i','skjema','på','regside,','').Unknown column 'password' in 'field list'
signup.php
Kode
<form action="sign.php" method="post"> Fornavn <input maxLength="20" size="12" name="fame"> Etternavn <input maxLength="30" size="12" name="lname"> Brukernavn? <input maxLength="14" size="12" name="username"> Passord <input maxLength="14" size="12" name="password" type="password"> E-Post <input type="email" size="12" name="epost"> E-posts igjen <input type="email" size="12" name="epos1"> Mobilnr. <input maxLength="8" size="8" name="mobil"> 8 siffer Kjønn <input type="radio" value="mann" name="sex" checked> <font size="1">Mann <br> n <input type="radio" value="kvinne" name="sex" checked> <font size="1">Kvinne Fødselsår <input maxLength="4" size="4" value="19" name="ar"> <font size="1">eks. 1981 Postnummer <input maxLength="4" size="4" name="post"> <input type="submit" value="Submit" name="Post"> </form>
sign.php
Kode
<?php
$hostname="";
$user="";
$pass="";
$dbase="";
$connection = mysql_connect("$hostname" , "$user" , "$pass");
$db = mysql_select_db($dbase , $connection);
$q="INSERT into smsreg (id,fame,lname,username,password,epost,epost1,mobil,sex,ar,post)
VALUES ('','$fame','$lname','$username','$password','$epost','$epost1','$mobil','$sex','$ar,'$post,'')";
$result= mysql_db_query($dbase, $q, $connection) or die
("Could not execute query : $q." . mysql_error());
if ($result)
{
echo "Takk, $fame du er blitt registert i vår database";
}
?>
Tror jeg har sikkert gjort noe feil her.
Kode
CREATE TABLE `smsreg` ( `id` int(11) NOT NULL auto_increment, `fame` varchar(20) default NULL, `lname` varchar(20) default '', `username` varchar(30) default '', `passord` varchar(30) default '', `epost` varchar(40) default '', `epost1` varchar(40) default '', `mobil` varchar(40) default '', `sex` varchar(40) default '', `ar` varchar(40) default '', `post` varchar(40) default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2;