php - upload but only 3 times ! how to ?

[nster]

Hello fellas,
say that we have a (mysql) table which includes the field NAME .
Also i have a php script to upload photos .
The NAME is stored every time that one photo is uploaded .

This i want to do is, to set a limit on uploading. I want everyone to be able to upload photos only for 3 times , No More than 3 !
So, i was thinking to make it according the NAME . Par example, if Jason is in my database 3 times Jason, Jason, Jason with some..count(NAME) to find that is 3 times and block him from uploading again ( cause already 3 times he did) .

My question is how can i implement,write this with PHP ..??

Please give me some example and expalin plz

thanks iN advance..

[Thanol]

I'm sure there's a more efficent way than what I'm giving you but this should work:

//first we're accessing the mysql database and having it count how many times NAME is equal to the variable $name, which you can set as whatever. 
$count_name = mysql_query("SELECT COUNT(*) FROM $dbtable WHERE NAME='$name'") or die(mysql_error("Failed to Count"));
//The results of the query is put into an array, and since we're only getting one thing, we don't need to put it in a loop.  $total_counts is an array that contains a number that says how many times that name has been counted
$total_counts = mysql_fetch_array($count_name); 
//since it's in an array you should probably throw it into a different variable to keep everything tidy
$counted_name = $total_counts[0];

$counted_name == some integer.

[nster]

thanks i ll try to make something with it ..and propably i;ll inform ya later here

[StupidScript]

"Jason" should only be in the database one time ... he's one user. Why not add a column for "uploads", and increment it each time the logged in user uploads a file? When they get to the upload page, check the field that counts how many times they have (successfully) uploaded, and if it's 3 times, don't display the upload form. Something like:

if ($counter<3) {
 print "<form id='uploadForm' ... ";
 ...
 print "</form>";
}
else {
 print "You have uploaded the maximum number of files.";
}

[Arenlor]

That's a cool way to count, didn't know about that I just select * and mysql_num_rows but yeah if NAME is a username then just attach the num to them, that way if they delete an upload you just decrement the number.

[nster]

thanks everybody is okay now