[dangmnx]

My 'members' table values are not updating!

<?php
include('connect.php');

$hacker = $_POST['hacker'];

if ($hacker != 0 ){
mysql_query("UPDATE `members` SET `wins`='0' AND loses='0'  WHERE username='$user'");
}
?>

This post has been edited by Dormilich: 29 May 2011 - 06:04 AM
Reason for edit:: please use [code] /* your code source here */ [/code] tags when posting code

[CTphpnwb]

$user is null.
You shouldn't use query strings directly in a query since it makes it hard to output/error_log the query. If you can't output it you can't see how it got built.

[Dormilich]

additionally, you have an SQL syntax error.

[dangmnx]

I still can't get it right, What would be the correct format to set this code up?

[Dormilich]

the MySQL UPDATE syntax.

[calebjonasson]

I'm going to give you a hint so you can move along with the project much more quickly.

AND is not used to separate update values.
Compare it to the simple update query here.
http://www.w3schools...ysql_update.asp