Andy wrote:
Hi, Sorry, still not really enough info to be able to give a decent answer =)
1) What "field" is the prize held in?
2) Is the prize field actually "money"? (i.e so it can be totalled up)
3) Can you show a bit more of the code you just sent, with the SQL query you are using to grab the data.
That may help a bit more :)
Cheers
1) What "field" is the prize held in?
Its not held in a field as its a comparision.
2) Is the prize field actually "money"? (i.e so it can be totalled up)
Yes it is money
3) Can you show a bit more of the code you just sent, with the SQL query you are using to grab the data.
Code:
$result = mysql_db_query ($DBName, $query, $Link); while ($row = mysql_fetch_array($result)){
if ($row[ticket] == "$ticketnumber"){
// Find how many match
if ($row[1] == $row[you1]){
$winner = $winner + 1;
}
if ($row[2] == $row[you2]){
$winner = $winner + 1;
}
if ($row[3] == $row[you3]){
$winner = $winner + 1;
}
if ($row[4] == $row[you4]){
$winner = $winner + 1;
}