| Lil' Stef |
27-11-2003 19:04 |
profiel probleem 2
PHP-code:
<?
$database_server = mysql_connect();
mysql_select_db("test", $database_server);
$sql = "SELECT * FROM `profiles` WHERE `id` = '".$id."'";
$resultaat = mysql_query($sql);
$record = mysql_fetch_object($resultaat);
echo "<form method=post action=profiles2.php>";
echo "realname: <input type=text value='$record->realname' name=realname><br>";
echo "email: <input type=text value='$record->email' name=email><br>";
echo "age: <input type=text value='$record->age' name=age><br>";
echo "gender: <input type=text value='$record->gender' name=gender><br>";
echo "status: <select name=status><option>Relationship</option><option>Single</option><option>Searching for someone</option><option>Married</option></select><br>";
echo "length: <input type=text value='$record->length' name=length><br>";
echo "eyes: <input type=text value='$record->eyes' name=eyes><br>";
echo "school: <input type=text value='$record->school' name=school><br>";
echo "hobbys: <input type=text value='$record->hobbys' name=hobbys><br>";
echo "brothers: <input type=text value='$record->brothers' name=brothers><br>";
echo "smoke: <input type=text value='$record->smoke' name=smoke><br>";
echo "country: <input type=text value='$record->country' name=country><br>";
echo "car: <input type=text value='$record->car' name=car><br>";
echo "movie: <input type=text value='$record->movie' name=movie><br>";
echo "city: <input type=text value='$record->city' name=city><br>";
echo "mousepad: <input type=text value='$record->mousepad' name=mousepad><br>";
echo "bed: <input type=text value='$record->bed' name=bed><br>";
echo "color: <input type=text value='$record->color' name=color><br>";
echo "fast: <input type=text value='$record->fast' name=fast><br>";
echo "sex: <input type=text value='$record->sex' name=sex><br>";
echo "<input type=submit value='Make my profile!' name=send>";
if($send !="") {
$sql = "UPDATE profiles SET realname='$realname', email='$email',
age='$age', gender='$gender', status='$status', length='$length',
eyes='$eyes', school='$school', hobbys='$hobbys', brothers='$brothers',
smoke='$smoke', country='$country', car='$car', movie='$movie',
city='$city', mousepad='$mousepad, bed='$bed', color='$color', fast='$fast',
sex='$sex' WHERE id='$id'";
mysql_query($sql);
echo "$sql";
}
?>
ik ben aanbeland bij het updaten van het systeem alleen werkt het niet zoals behoren. Hij hoort gewoon nu wel de schrijven maar ik krijg nix te zien en als ik echo dan krijg ik dit
UPDATE profiles SET realname='Stefan Pouw', email='stefan@lincoln.nl', age='17', gender='man', status='Searching for someone', length='1.65', eyes='blue', school='school', hobbys='lolo', brothers='1', smoke='no', country='ned', car='ford', movie='60', city='la', mousepad='no, bed='no', color='blauw', fast='no', sex='no' WHERE id=''
ut heeft nix met de globals of me mysql connect gebeure
iemand die ut weet?? |
