Try using mysql_error() to display the mysql error message before issuing
your die(). this will give more information to troubleshoot. You may not
have the right privileges set up in your database where you can update or
insert into the database or table.
/dkm
----- Original Message -----
From: "Hawk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 1:18 PM
Subject: [PHP] PHP & MySQL problems, updating database..
> 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
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
