Cannot Update Database

[Mysterio]

Hi, can anyone help me where is the problem?

index.php

else if($action=="uset2"){
$dob = explode("-",$bdy[0]);
boxstart("Update");
echo "<p><form action=\"genproc.php?action=uprof2&amp;sid=$sid\" method=\"post\">
School: <input id=\"inputText\" type=\"text\" name=\"school\" maxlength=\"30\"/><br/>
Bad HAbits: <input id=\"inputText\" type=\"text\" name=\"habitsb\" maxlength=\"150\"/><br/>
Good Habits: <input id=\"inputText\" type=\"text\" name=\"habitsg\" maxlength=\"150\"/><br/>
Sport: <input id=\"inputText\" type=\"text\" name=\"favsport\" maxlength=\"20\"/><br/>
Music: <input id=\"inputText\" type=\"text\" name=\"favmusic\" maxlength=\"20\"/><br/>
Orient Sex: <select id=\"inputText\" name=\"sexpre\">
<option value=\"Hetero\">Hetero</option>
<option value=\"Homo\">Homo</option></select><br/>
Height (cm): <input id=\"inputText\" type=\"text\" name=\"height\" maxlength=\"3\"/><br/>
Weight (kg): <input id=\"inputText\" type=\"text\" name=\"weight\" maxlength=\"3\"/><br/>";
/// echo "Race: <input id=\"inputText\" type=\"text\" name=\"racerel\" maxlength=\"50\"/><br/>";
echo "
Hair: <input id=\"inputText\" type=\"text\" name=\"hairtype\" maxlength=\"10\"/><br/>
Eyes: <input id=\"inputText\" type=\"text\" name=\"eyescolor\" maxlength=\"10\"/><br/>
- - - - -<br/>
Want more?: <input id=\"inputText\" type=\"text\" name=\"moretext\" maxlength=\"500\"/><br/>
<input id=\"inputButton\" type=\"submit\" value=\"Update\"/>
</form>
</p>";
}

genproc.php

else if($action=="uprof2")
{
$sexpre = $_POST["sexpre"];
$height = $_POST["height"];
$weight = $_POST["weight"];
$racerel = $_POST["racerel"];
$hairtype = $_POST["hairtype"];
$eyescolor = $_POST["eyescolor"];
$habitsb = $_POST["habitsb"];
$habitsg = $_POST["habitsg"];
$favsport = $_POST["favsport"];
$favmusic = $_POST["favmusic"];
$school = $_POST["school"];
$moretext = $_POST["moretext"];

$res = mysql_query("UPDATE ibwf_xinfo SET sexpre='".$sexpre."', height='".$height."', weight='".$weight."', racerel='".$racerel."', hairtype='".$hairtype."', eyescolor='".$eyescolor."', habitsb='".$habitsb."', habitsg='".$habitsg."', favsport='".$favsport."', favmusic='".$favmusic."', school='".$school."', moretext='".$moretext."' WHERE id='".$uid."'");

if($res)
{
echo "Done<br/>";
}else{
echo "Error<br/>";
}
}

Why do I always get error? Or am I blink?

[crazybrumi]

what error are you actually getting.

[Mysterio]

Just error (echo "Error<br/>";)
See the script above!

[riderz]

what are ur site link

and ur problem are in ur config.php

[WhiteWarrior]

Here, a quick mind tricking fix...

Remove
else{
echo "Error<br/>";
}

Upload the ibwf_xinfo table here

[Mysterio]

Upload the ibwf_xinfo table here

i can remove it, but anyway, the values are not going to be updated in the database.

[Mysterio]

Ok, here is the database:

CREATE TABLE IF NOT EXIST 'ibwf_xinfo' (
'uid' int(100) NOT NULL DEFAULT '0',
'sexpre' varchar(100) DEFAULT 'Not Given',
'height' varchar(100) DEFAULT 'Not Given',
'weight' varchar(100) DEFAULT 'Not Given',
'racerel' varchar(100) DEFAULT 'Not Given',
'hairtype' varchar(100) DEFAULT 'Not Given',
'eyescolor' varchar(100) DEFAULT 'Not Given',
'habitsb' varchar(100) DEFAULT 'Not Given',
'habitsg' varchar(100) DEFAULT 'Not Given',
'favsport' varchar(100) DEFAULT 'Not Given',
'favmusic' varchar(100) DEFAULT 'Not Given',
'school' varchar(100) DEFAULT 'Not Given',
'moretext' varchar(100) DEFAULT 'Not Given'
) ENGINE = MyISAM DEFAULT CHARSET=latin1;

[Anshul]

Add
if(!$res) echo mysql_error();
after $res update query
and post here wat error u get

[Mysterio]

thanks mates, i corected it, and it was my mistake. Because i tried to perform the action with a new user. So, there is not going to be and "UPDATE", but a "SET". I will post full code if you want... Thanks you!