PHP problem - VIP update script

[Johno]

Hey

Im new to php coding but trying to code a update script for my users

here is what i have so far but its not working

<?php
$username = $_SESSION['username'];
$userq = mysql_query("SELECT * FROM users WHERE username = '".$username."' LIMIT 1");
$user = mysql_fetch_array($userq);
mysql_query("UPDATE users SET rank = '3' WHERE username = '".$username."'" "SET credits = '+1000000"');

?>

 

[RastaLulz]

Is that your entire page? What error are you getting?

 

[Johno]

when i visit it, as a logged in user on rank 1, it dont update the rank or coins but takes me back to the me page :s

 

[Jo$h]

In your mysql_query, you need to include the variable where your MySQL connection is stored.

 

[Johno]

im using the REV cms, were would i include that (sorry to sound noob) but im still learning all about this

 

[ImagicianX]

Replace your code with:

<?php
$username = $_SESSION['username'];
$userq = mysql_query("SELECT username FROM users WHERE username = '".$username."' LIMIT 1");
$user = mysql_fetch_assoc($userq);
mysql_query("UPDATE users SET rank = '3', credits = credits '+1000000' WHERE username = '".$user['username']."'");
?>

Yours, Imagician.

 

[Johno]

Hey

I tried that and it did not add the credits or update the rank

 

[ImagicianX]

I can help you on Team Viewer.

 

[Johno]

i am uploading to a remote server, just need help with the coding side of it, nothing on the server, Thanks