Re: PHP & MySQL problems, updating database..

Please try this: if ( $link = mysql_connect($host,$user,$pswd) ) { if( !mysql_select_db($db, $link) ) { echo "error selecting db"; } } else { echo "error connecting to db"; } Nicole Amashta www.aeontrek.com "Hawk" <hwk@barrysworld.com> wrote in message news:20020117181851.39529.qmail@pb1.pair.com... > 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 > >