[SOLVED] can i get hand please

[Jiraiya]

im trying to create a variable update script that changes a when they click on a link here is the code i have so far..

 

<?php

$username = $_COOKIE['ID_my_site']; 
mysql_connect("hostname", "username", "password") or die(mysql_error());
mysql_select_db("databasename") or die(mysql_error());
$sql = mysql_query("SELECT * FROM users WHERE username = '$username'");
$row = mysql_fetch_array($sql);
{
mysql_query("UPDATE `users` SET `location` = 'Home' WHERE username = '$username'") or die(mysql_error());
echo '<center>You are home'.$username.'</center>';
}else{
echo '<center>You aren't allowed there</center>';
}
?>

[Jiraiya]

is the above script done write?

[MasterACE14]

change it to:

<?php
$username = $_COOKIE['ID_my_site']; 
mysql_connect("hostname", "username", "password") or die(mysql_error());
mysql_select_db("databasename") or die(mysql_error());
mysql_query("UPDATE `users` SET `location` = 'Home' WHERE username = '$username'") or die(mysql_error());
echo "<center>You are home " . $username . "</center>";
?>

 

You don't need the SELECT query.

 

And as for the if(btw you forgot the if) and else There going to be set to 'home' as soon as they reach that page, so you don't even need them.

 

Regards ACE