what's wrong with my code (below) ?

[jd2007]

<?php
$id=$_GET["varj"];
$gname=$_GET["varg"];
$grom_no=$_GET["varh"];
$glink=$_GET["vark"];

$db=mysql_connect("localhost", "root") or die(mysql_error());
mysql_select_db("ndsrom");
$query="update games set name=$gname where id=$id";
$result=mysql_query($query);
$query2="update games set romno=$grom_no where id=$id";
$result2=mysql_query($query2);
$query3="update games set link=$glink where id=$id";
$result3=mysql_query($query3);
if ($result && $result2 && $result3)
{
  $edit="<br><br>Game succesfully edited!";
  header("location:index.php?var10=$edit"); 
}
else
{
  $edit2="<br><br>ERROR!";
  header("location:index.php?var11=$edit2"); 
}



?>

 

it always results in error !

[pocobueno1388]

Try putting a die statement at the end of each query to make sure there aren't any problems with the queries.

 

$result=mysql_query($query)or die(mysql_error());

[Crew-Portal]

Fist Off Your MySQL Connection is unsecure! if you do have a password set up it should look more like this

 

mysql_connect(localhost, root, password, database);

[pedrobcabral]

What do you mean by unsecure? If it is without password, if you can't put files into the server of 'someone' is it still not safe?

[Crew-Portal]

If your mysql database has no password than anyone could log on to it using name root on the cmd prompty and add records read confedental information get other users passwords flood, drop, and erase your databases!

 

Do you think google has a password set up! Of course they do because without it the mysql is UNSECURE!

[jd2007]

thanks, buddy