Hi,

I am new enough to web development, I am trying to develop a site for Horse Racing, the way I would like the site to work is as follows.

I want to display a table/list of all the days races and then select the race off the list, once the race is selected a new page loads with all the horses in the race and again I would like to be able to select a horse from this table /list and get all details on the selected horse.

I have all the necessary data in a database.

My question is what technology/features would be best used to achieve this type of design, tables populated from db with selectable fields.

Hope I have explained this sufficiently.

Thanks in advance :)

slahy

just bind a grid view to ur db table with details u want along with a column 'View' having id of race.
run a loop which will create a new imagebutton with id as that of race id and add a click event handler to these buttons with same method to be called.
ex:
for(int i=0;i<gvRace.rows.count;i++)
{
imagebutton imb=new imagebutton();
imb.id=gvRace.rows[i].cell[0].text;//or value
imb.imageUrl="";//any image u like
imb.click+=new eventhandler(imb_click);
gvRace.Rows[i].cell[0].controls.add(imb);
}

and in the click event just find the imagebutton id which is actually ur race id and pass it to next page via query string or session

protected void imb_click(object sender,ImageButtonEventAgrs e)
{
control imb=(control)sender;
server.transfer("raceDetail.aspx?rid="+imb.id);
}

slahy,
To respond to your homework thread, I need to know more about the database, that includes the tables and their relationship. Meaning information in the horses table, how many races per day and the date or calendar table.

Also, another question, are you familiar with APEX and what is the name of your class? This will assist me in how much or detail of information to give.

Hope this helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Hi peace95,

sorry for the delay in getting back to you and thanks for replying, details are as follows
I have 3 tables races, horses, snapshots. The database is a MYSQL database

Races – all details about each race columns as follows

rceid, racedate, track, racetime, url1,url2,description,type,distance,furlong,class

raceid is an int it is the key for this table, racedate,track,time should all be obvious enough as to their content,
url1 and url2 are the url’s that I get all the information from these do not need to be displayed anywhere on the site.
Description (name of race), type (type of race), distance (distance in miles), furlong (distance in furlong), class(class of the race)

Horse – details about each horse columns as follows

horseid, raceid, res, cardno, draw, horsename, jockey, trainer, owner

horseid is an int it is the key for this table with raceid being the relationship between race and horse tables
res – finishing position of horse (not to be displayed anywhere) , cardno – cardno of horse, draw – stall the horse is in, horsename, jockey, trainer, owner all abvious enough.

Snapshots – contains multiple sets of bookie prices at taken at various time during the day for each horse. Columns are as follows

snapid, snaptime, snapnumber,raceid,horseid,bookieprice1,bookieprice 2,bookieprice3 ….. bookie price11.

snapid is an int it is the key for this table with raceid and horse id being the relationship to the horse and race table.
Snaptime (time snapshot was taken ), snapnumber (int between 1 – 14) bookieprice1 is the price that bookie had for the horse in question at the time of the snapshot.

There can be anything from 12 – 50 races a day, I am not familiar with APEX but if it would be the most suitable technology/language to achieve this I will start to familiarize myself with it. I have no idea what class you are referring to. Programming class ? Or something else ? I am a fast learner so don’t hold back on the details !

I would like the site to work something like this
Todays Races
racedate track racetime description type distance furlong class
Race 1 details ……………………………………
Race 2 details ……………………………………
Race 3 details ……………………………………
Race 4 details ……………………………………

Select the race you want
New page loads with the following

Race 2 ….details
cardno, draw, horsename, jockey, trainer, owner
Horse 1 details …………………………………….
Horse 2 details …………………………………….
Horse 3 details …………………………………….
Horse x details …………………………………….

Select the horse you would like and either a drop down / pop up / new page with the following

Horse name and card no
snapnumber snaptime bookieprice1 bookieprice2 bookieprice3 bookiepricex ….. ….. bookieprice11
snapshot 1 details……………………………………………
snapshot 2 details……………………………………………
snapshot 3 details……………………………………………
snapshot 4 details……………………………………………
snapshot x details……………………………………………

if you need more details please let me know.

Thanks,

slahy