get just one result

[DaDeViL]

is there any way to get one specific name from a database

...for example, I have a table named user_message
and a row called the_user which keeps track of which user posted the message,
but what I want to do is compare the username of the CURRENT_userto the user that posted the message
(ie. a user already in the row the_user )
so that another user cant change the same message.

$check_user_query = "select * from user_message where

the_user = \"CURRENT_user\"";

$check_user = mysql_query($check_user_query) or

die(mysql_error());

if(mysql_num_rows($check_user) != 0){

return "TRUE";

} else {

return "FALSE";

} 

When i use this, it always returns true...no matter what value i put in for CURRENT_user

Thanks

[r937]

it will return FALSE if you put in a value for a user that has not posted a message

in effect, you are saying "get all the messages for user X, and if there are any, return TRUE"

[DaDeViL]

so what query should i use to check if the current user is the same as the one specific user that posted the message?

[r937]

select the_user
from user_messages
where message_id = N

you need to specify which message you're talking about

the query will return exactly one result

then compare this in your code to the current user