Rating System Timers

[supanoob]

Basically im working on a system that allows people to rate other people out of 10. Now what i want to do is limit how many times you can rate any one person per day to 1. for example:

 

Person A Rates Person B

 

They can then no longer rate person B for 24 hours, However they can rate other people if they wish. How could this be done?

[redarrow]

voted_member

id

user_id

votes

date

<?php

// database connection

$sql="select * from members_votes where id='".$ESSION['id']."' ";

$result=mysql_fetch($sql) or die(mysql_error());

while($rec=mysql_fetch_assoc($result)){

if ($rec['date'] < date("dmy,his") ){

//insert vote

}else{};

}
?>

[supanoob]

Ill give that a go thanks

[redarrow]

example only........

<?php session_start();

// database connection

$sql="select * from members_votes where id='".$ESSION['id']."' ";

$result=mysql_fetch($sql) or die(mysql_error());

while($rec=mysql_fetch_assoc($result)){

if ($rec['date'] < date("dmy his") ){

//insert vote

}else{}; // means do nothink.........

}
?>

 

[redarrow]

mysql_query >>>> sorry