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 Link to comment https://forums.phpfreaks.com/topic/4416-what-is-wrong-with-this-script-pls-tell-me/ 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... Link to comment https://forums.phpfreaks.com/topic/4416-what-is-wrong-with-this-script-pls-tell-me/#findComment-15449 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? Link to comment https://forums.phpfreaks.com/topic/4416-what-is-wrong-with-this-script-pls-tell-me/#findComment-16143 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.