Re: PHP & MySQL problems, updating database..

You may want to add exit; where the failures occur to stop code "execution." > if ( $link = mysql_connect($host,$user,$pswd) ) > { > if( !mysql_select_db($db, $link) ) > { > echo "error selecting db"; exit; > } > } > else { > echo "error connecting to db"; exi; > } "Nicole Amashta" <430ntr3k@bellsouth.net> wrote in message news:20020117184948.70528.qmail@pb1.pair.com... > 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 > > > > > >