David,
I have a MySQL table called images, each with a rating from 1-10. The column
is a decimal(10,2). For simplicity's sake, let's say i have the following:
CREATE TABLE images (
image_id int not null auto_increment,
image_path varchar(255) not null,
rating decimal(10,2) not null,
I have a MySQL table called images, each with a rating from 1-10. The column is a
decimal(10,2). For simplicity's sake, let's say i have the following:
CREATE TABLE images (
image_id int not null auto_increment,
image_path varchar(255) not null,
rating decimal(10,2) not null,
primary
David,
Your question is a little bit unclear.
First, if it is rank, you do not need decimal, but integer (tinyint will
do it). Then you need a little bit of statistics to rank the picture
against the others, so, anytime each picture is ranked, you have to run
the statistics and update the table