[SOLVED] need a little help

[Jiraiya]

Im trying to set up a script that changes one variable if another variable is equal to or greater then a set number. my question to you is how would i go about doing this?

 

[ngreenwood6]

I think this is what you mean:

 

$constant = 5;
$variable = 10;

if($constant >= 5)
{
$variable = 5;
}

If not please elaborate on what you are trying to do.

[Maq]

Why did you post this in MySQL Help?  Are you extracting data from a database?

[Jiraiya]

i want to the php to check my database to verify that a variable is equal to or greater then the required number  before changing the other variable

[Maq]

Okay, post your code a relevant code snippet, relevant table structure, and exactly what you want to do with each field.

[xtopolis]

Perhaps page 9 of CV's tutorial might be helpful:

http://www.phpfreaks.com/tutorial/php-custom-list-order/page9

 

Otherwise you may need to show some code/an example so we can specifically see what needs to be changed?  I'm assuming you mean changing a database variable?

[Jiraiya]

yes i do mean changing a database variable but im not sure how to write the scritp here is what i have so far

 

 

$username = $_COOKIE['ID_my_site']; 
$sql = mysql_query("SELECT * FROM users WHERE username = '$username'") or die(mysql_error());




if($skill >= 5000000)
{
$rank = Akatsuki;
}


?>

[corbin]

Based on that script, you don't know the basic handling of MySQL stuff in PHP....

 

You should really look into it, but I'll just go ahead and tell you:

 

 

 

<?php
$username = $_COOKIE['ID_my_site'];  //You shouldn't trust cookies!  You need to atleast escape this data, and if it's used as authentication data, that's a big no-no.
$sql = mysql_query("SELECT * FROM users WHERE username = '$username'") or die(mysql_error());
if($r = mysql_fetch_assoc($sql)) {
    $skill = $r['skill'];
    if($skill >= 5000000) {
        //$rank = Akatsuki;
        //Unless Akatsuki is a constant, it should be in quotes.
        $rank = 'Akatsuki';
    }
}


?>

[Jiraiya]

is this rite for updating the rank variable?

 

 

 

$username = $_COOKIE['ID_my_site']; 
$sql = mysql_query("SELECT * FROM users WHERE username = '$username'") or die(mysql_error());
if($r = mysql_fetch_assoc($sql)) {
    $skill = $r['skill'];
    if($skill >= 5000000) {
        //$rank = Akatsuki;
        //Unless Akatsuki is a constant, it should be in quotes.
        $rank = 'Akatsuki';

$query = "UPDATE users rank = '$rank=Akatsuki";