[phpfreek]

Hey guys ... How r ya all doing ?

Hope you are fine ...

i was trying to write a script , but got stuck on a code ... thought some of you guys mught help me

Here is my problem ;

I want the code to see if a table named "money" in the database has a value bigger than 500, if it has a value bigger than 500, the folowing query's will be executed :

PHP Code:

$query="UPDATE $usernamee SET weapon = 'klashen'";

$query2="update $usernamee set money=money-500";

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

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

And if it doesn't have a value bigger than 500, the folowing line will be displayed :
You do not have enought money to buy that weapon !

After hard work of cosing, i have come up with the folowing code :

PHP Code:

<?php

session_start();

$username="root"; 

$password=""; 

$database="login";

$usernamee=$_SESSION['username'];

mysql_connect(localhost,$username,$password); 

@mysql_select_db($database) or die( "Unable to select database");

$query="UPDATE $usernamee SET weapon = 'klashen'";

$query2="update $usernamee set money=money-500";

if (money>100) {

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

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

} else {

echo "You do not have enought money to buy that weapon !";

}

mysql_close();

?>

Unfortunately, it didin't work

Can any of you guys help me with my script ?

Thank you in advance,
Best Regards;
PHPFREEK

[UnrealEd]

this will not work as you didn't define money, and as money is not a variable.

first select the money from your db, assign it to the variable $money, and the match against 100

Greetz,
UnrealEd

[phpfreek]

Hmmm ... i think i understand ... well do u know the code for selecting the table from the database ??? ... if you do, can u please tell me ...

Thank you in advance.
PHPFREEK

[UnrealEd]

i don't know exactly what your database looks like, but try this:

PHP Code:

$res = mysql_query("SELECT money FROM $usernamee");

$temp = mysql_fetch_array($res) or dei(mysql_error());

$money = $temp['money']; 

btw: those 2 queries you're updating can be merged into 1:

PHP Code:

$query = "UPDATE $usernamee SET money=money-500, weapon='klashen'"; 

it seems that you don't know much about mysql querires, here are some good tutorials:
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
http://www.php-mysql-tutorial.com/my...rial/index.php
http://www.tizag.com/mysqlTutorial/

these are all rather basic tutorials, but this is how i learned the basis of mysql. Or you could just by a book about mysql

Greetz,
UnrealEd