RE: [PHP-WIN] Re: PHP & MySQL problems, updating database..

2002-01-17 Thread Asendorf, John
e- > 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 "

[PHP-WIN] Re: PHP & MySQL problems, updating database..

2002-01-17 Thread Nicole Amashta
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 Am

[PHP-WIN] Re: PHP & MySQL problems, updating database..

2002-01-17 Thread Nicole Amashta
... and if you verify that your connection to mysql is working, then check your query. Your update will update EVERY row in the user table. You may want to add the where clause and specify what rows to update ... like someone else mentioned .. otherwise, you will funkify your user data ... caref

[PHP-WIN] Re: PHP & MySQL problems, updating database..

2002-01-17 Thread Nicole Amashta
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 PROTEC