what is wrong with this script?:(((

[alarik149]

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

[Gaia]

Well, with the code you have right there, it's not outputting anything, you've just saved the mySQL result to a variable...

You need to remove the $result = part..

[code]
mysql_query($sql) or die(mysql_error());
[/code]

Since you just want to update there's no need to save the result in a variable.

[alarik149]

and how do i save it?please tell me the exact line(s) i need:(.in the book from luke welling it says just like that...no 'saving':(

[Gaia]

I did......

change

[code]
$result = mysql_query($sql) or die(mysql_error());
[/code]

To...

[code]
mysql_query($sql) or die(mysql_error());
[/code]

[alarik149]

yey,it works;) thanks a lot man...big thanks :)

[AV1611]

First, you are missing a ' be fore the word host in the first line
[code]
$db = mysql_connect(host', 'championships', 'passwd')
[/code]
Second,

Do you actually have a username a? (username = 'a') or do you mean unsername like 'a%'?

Third, here is how I do PHP connect...
[code]
    $user="myname";
    $host="localhost";
    $password="mypassword";
    $database = "bible";
    mysql_connect($host,$user,$password);
    mysql_select_db($database);
[/code]
You can even take these lines:
[code]
<?php
    $user="myname";
    $host="localhost";
    $password="mypassword";
?>
[/code]

and put them in a file called mysqllogin.inc.php
then just use:
[code]
include 'mysqllogin.inc.php';
[/code]
on all your web pages... it will save you a lot of typing