Jump to content

Archived

This topic is now archived and is closed to further replies.

alarik149

what is wrong with this script pls tell me

Recommended Posts

<?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

Share this post


Link to post
Share on other sites
... connect(host', ...

that should be connect('host', ...

*EDIT*
also add a semicolon at the end of the first line...

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.