checking if a value in a database is = or >

[Anon]

hi,
i just wanted to ask you guys, how would i go about checking if a value is higher or equal to that stored in a mysql databases.

Say a person requests email addresses from me, everytime they request an email address a value in a mysql database is updated by 1 ( + 1 ) however, each time, when submit is entered, it will check the database first whether $number_allowed is higher than or equal to say a field in the mysql database called $number_used (this is the field that is updated by 1.)

if it is equal to the number, it will bring up an error saying something like
"you have used up all your email credits" or something like that. But if the $number_allowed is higher than the value $number_used, it will process the rest of the form and just + 1 to $number used.

i know this sounds a little confusing :o) but i hope, if its not too much trouble someone can help me please??

Thanks alot,
Khilan Gudka

[Anon]

Hi! At this time in my country (1.20am, Argentina) I could only think in 2 solutions:
1)
$result = mysql_query("SELECT field FROM table WHERE field >= $number_to_check AND ANY_OTHER_CONDITION_YOU_WANT");
if(mysql_affected_rows()==0) $error = true;

2)
$result = mysql_query("SELECT field FROM table WHERE ANY_CONDITION_YOU_WANT");
$data = mysql_fetch_array($result);
if($data['field'] >= $number_to_chechk) $error = false;

This could give you an idea of what to do.. HTH

inK

[Anon]

hi,

thanks for the input, unfortunately it doesnt seem to work. is there possibly a simpler way of doing it or a more understandable way?

thanks!

Khilan Gudka