alarik149 Posted March 8, 2006 Share Posted March 8, 2006 <?php$db = mysql_connect(host', 'championships', 'passwd') mysql_select_db('championships', $db);$sql = "UPDATE register SET status = 'inactive' WHERE username = 'a'";$result = mysql_query($sql) or die(mysql_error());?>why dosen`t this script work?I have 1 database named championships and 1 table named register.with 2 fields 'username' and 'status'.i don`t get it.it connects to the database good but it dosen`t change anything,no errors,no nothing.why?:( pls help me Quote Link to comment Share on other sites More sharing options...
Randy Posted March 8, 2006 Share Posted March 8, 2006 ... connect(host', ...that should be connect('host', ...*EDIT*also add a semicolon at the end of the first line... Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted March 10, 2006 Share Posted March 10, 2006 Change:[code]$db = mysql_connect(host', 'championships', 'passwd')mysql_select_db('championships', $db);[/code]to[code]$db = mysql_connect('host', 'championships', 'passwd') or die("MySQL Connection Error: " . mysql_error());mysql_select_db('championships', $db) or die("Selecting database error: " . mysql_error());[/code]If theres a problem with your connection or if your database has a problem then you should recieve an message.Also why post this in HTML Help Forum? Why not PHP Help? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.