PHP & MySQL problems, updating database..
| From: | Hawk | Date: | Thu, 17 Jan 2002 18:18:52 +0000 |
| Subject: | PHP & MySQL problems, updating database.. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-80947@lists.php.net to get a copy of this message | ||
Having a problem with this, I have a working login that supports multiple
users, and I'm trying to make it possible for the users to change their own
settings etc, but I get killed when trying to send the data to the MySQL
database.
To connect I use mysql_connect($host,$user,$pswd) and mysql_select_db($db)
the retrieving data from the form works since I belive, since it showed up
when I added a print "$the vars " but I don't know how to save it to the
database..
I might be missing some line or maybe it's just because I'm a newbie or
something.. ;D
anyway.. I use something similiar to this
$query = "UPDATE users SET email='$email'"; // and so on..
$result = mysql_query($query) or die ("blabla");
I don't get any error lines or anything, the only thing that shows is the
"blabla" thing.
I also tried INSERT INTO in the query but that didn't make any difference :p
if anyone could tell me what I'm doing wrong I would be happy.. :p
"the best way to learn is to ask people that know" :p
Hawk