One last question about mysql.

[whelpton]

Ok, I need to check my mysql database to check if referused=1 and if it does the user cannot continue.

[revraz]

Read the field and do a check on it...

[whelpton]

im not sure how to do that

[dezkit]

phpmyadmin

[whelpton]

I take it would be something along the lines of mysql_query("SELECT referused FROM Users WHERE id = '$refer'") or die(mysql_error());

 

but how do i stop the code from continueing if referused is 1?

[dezkit]

<?php
// conection
mysql_query("SELECT referused FROM Users WHERE id = '$refer'") or die(mysql_error());
if($refer == "1"){
// watever
} else {
echo "you cannot continue";
}
?>

[revraz]

This is what I would suggest.  Look up some tutorials on MySQL and PHP, read how to connect to the DB and how to do SELECT statements.  Read how to get values from fields and then use PHP to compare them.

 

Look up the mysql_fetch command to get the results you need.

 

And Dez, that wont work because you are comparing the ID to 0, not the referused value.

[whelpton]

Thanks dez, I can alter that to what I need

[dezkit]

This is what I would suggest. Look up some tutorials on MySQL and PHP, read how to connect to the DB and how to do SELECT statements. Read how to get values from fields and then use PHP to compare them.

 

Look up the mysql_fetch command to get the results you need.

 

And Dez, that wont work because you are comparing the ID to 0, not the referused value.

 

fixed

 

edit: ya whel.

[revraz]

No, I mean you are comparing the wrong variable.  $refer is the user's id, not the referused value.

[whelpton]

well then could you help me out and say what the right code is, I have no clue how to make a variable from a mysql database, Ive only started working with them this week .

[whelpton]

anyone?