limit results by user

[canabatz]

what is the code for limiting results sent from users?

i want to give limit to users that they cannot have 5 results in a row ,they can only have 4 rows in a row ,and if they post again and it's one of the 5 in the row it will be deleted?

1 user1 345
2 user1 275
3 user1 954 <=== this one was the last that was posted and will be deleted
4 user1 352
5 user1 356

and never mind which post was last ,it can be 3,1,2,5,4

thanx

[bilibytes]

the question is not very clear,

if you want to limit the number of insertions, you should count the number of rows for a user and then from PHP or whichever language you use, tell:

if($mysql_num_rows($result) < 4){
-> sql code to insert the row into table.
}
else{
-> prompt the user that he cannot add a row.
}
 

if you want to erase from your tables the rows above 4 for each user, you shoud make a query which would count the number of rows for each user and get the date added.
Once you get that date delete from table all values where date > date

if you don't use dates to order your posts, then you could use what ever you want, but the idea is to get the max allowed value, and delete the values that are above that one.

[canabatz]

is it possible in php to count in a row?

like:

this is going in ORDER DESC

username | price

user 1 | 200
user 1 | 199
user 1 | 198
user 1 | 197
user 1 | 196
user 2 | 195
user 2 | 194
user 2 | 193

user 1 have 5 results in a row ,user 2 got 3 in a row , what im looking for is to limit the user to have 4 results maximum !

this is good !!

user 1 | 200
user 1 | 199
user 1 | 198
user 1 | 197 4 in row
user 2 | 196 1 in the row
user 1 | 195
user 2 | 194
user 2 | 193

if a user enter a price that is going to be between the 4 ,then it will be as 5 in a row!

hope you got me better now :)

thanx