Input is fine, output is difficult!!!!

shakazulu

Hi there, I was wondering if anybody could help me with this problem..?

Whilst inputting a match report for my football/soccer team via a form, the user chooses the starting line-up from lists, and the match report as a textfield...

The input form i have works fine. My problem is generating a page to display the reports already there...

The data is held in MySQL as numbers (i.e 1=Lee, 2=Rod etc etc)[/B].

I realise that I can get the report to display names by writing explicit code such as If(id=1, "Lee"If(id=2,"Rod", "other")), but I was wondering how I would go about doing it dynamically, so that If a squad number is changed I dont have to change all instances in the 'If' statement??

Hope that makes sense, let me know if I'm not explaining it properly. Cheers, LeeBoy! 😃 😕

Norman_Graham

Originally posted by shakazulu
Hope that makes sense, let me know if I'm not explaining it properly.

This is to let you know that you're not explaining it properly. 😃
What exactly are you entering into the DB? The names of the squad members at a particular match and then the report for that match? What is it you want to display? If you want to display the names of the squad members and the report, then presumably you just do: SELECT names, report FROM match_reports ...

Explain your input data, your table structure and your select statement and we'll maybe get to the root of this problem.

Norm

shakazulu

lol, i knew I wasn't telling it straight!!! 😃 I'm in work so dont have the tables in front of me...

OK, here we go.

Data entered: match_id, keeper, right-back, left-back, centre-back1, centre-back2, right-wing, left-wing, centre-mid1, centre-mid2, forward1, forward2, sub1, sub2, sub3, match_report

Apart from 'match_report', all are entered as 'INT'.
'match_id' is obtained automatically from a link.

The lists show the player names, but when the form is posted it sends their corresponding numbers to the DB.

The lists get their data from the table tblplayerinfo which holds playerID, name

Using the SELECT * FROM tblmatch_reports returns the correct result, but not in the right format. Basically where the numbers are, I would like the player names...

Does that make more sense at all?😃 😕

tsinka

Hi,

post the code (at least the part that deals with the POST variables and the mysql queries).

Thomas

Norman_Graham

Hi Shakazulu

Posting the code is a good idea. You may also like to take a look at the syntax for JOIN.

There's quite a useful user comment at the bottom of the page from a teacher who needs to collate student names and scores (Scott Atkins, posted on 23rd January 2003). He uses a complicated JOIN query and I believe this may be applicable to your situation.

(Ho hum ... I wonder if he'll notice that I don't actually know the exact solution to his problem ...)

HTH

Norm :o

shakazulu

ok guys. will post that code as soon as I get back from work!

I only have until sunday to get this done!!!!!

In the meantime cheers for your help, I'll have a look at that other post you mentioned too...

🆒