MYSQL Query problem...
| From: | Ian Bert Tusil | 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