so i have a table called image. in side image table it has
image_id
user_id
image_short_name.
i am trying to create upload page where user can sumbit image. but i want to make sure a user dont pick same image_short_name.
for ex if a user called "dave" pick a image_short_name "tree" than he can not pick the same image_short_name again.
but another user "chris" can pick the name "tree" but only ones.
$query = mysql_query("Select * FROM image WHERE image_short_name = '$image_short_name_p'");
if(mysql_num_rows($query) >= 1)
{
$upload_error .= "That image name is already taken";
}
this check the whole database. can some one help me with this query.