or
die ("Error Message"); --------------------- John Asendorf - [EMAIL PROTECTED] Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 Nullum magnum ingenium sine mixtura dementiae fuit > -----Original Message----- > From: Nicole Amashta [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 17, 2002 2:00 PM > To: [EMAIL PROTECTED] > Subject: [PHP-WIN] 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" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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" <[EMAIL PROTECTED]> wrote in message > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > 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 Windows 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 Windows 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]