MYSQL Query problem...

From: Date: Sun, 21 Sep 2003 10:02:08 +0000
Subject: MYSQL Query problem...
Groups: php.db 
Request: Send a blank email to php-db+get-30597@lists.php.net to get a copy of this message
is there something wrong with my SQL Query? I didnt get any results neither errors.. <?php $link = mysql_connect('localhost', '<username>') or die('Cannot connect to the database.'); mysql_select_db("profiles",$link); $SQLQuery = "INSERT INTO profyles (username, fname, mname, lname, address, country, gender, sexuality, status, bday, race, yahoo, msn, icq, email, webpage, hair, bodytype, eye, height, weight, facialhair, hobbies, interests, aboutme, profession, food, music, tvshows, authors, movies, rolemodel, place, visit, online, picture) VALUES ('$user', '$firstname', '$middlename', '$lastname ', '$address, '$country', '$gender', '$sexuality', '$status', '$birthday', '$race', '$yahoo', '$msn', '$icq', '$email'. '$webpage', 'haircolour', '$bodytype', '$eyecolour', '$height', '$weight', '$facialhair', '$hobbies', '$interest', '$aboutme', '$profession', '$food', '$music', '$tvshows', '$authors', '$movies', '$rolemodel', '$place', 0, 'y' , 'y')"; mysql_query($SQLQuery,$link); ?> ian

« previous php.db (#30597) next »