[database design help]

ok, I wanted to do a little project and wondered how the database should be designed.

I am a good php coder so the actuall coding of the project would only take a day. However I always struggle with the database design.

 

Ok, basically I want to create a "world cup 2010" project. basically my friends put down their predictions of each game. and depending on the outcome would depend on the points earned.

 

what would the best way to design the database be?

 

any assitance would be appreciated

 

thanks in advance

 

jmcall10

[looping records to update, checkboxes, dropdowns, radio buttons]

Thanks for your response mgallforever it is much appreciated

 

so far I have managed to get it working and its not far off of what you suggested.

 

I shall work on it more tonight.

 

Regards,

 

jmcall10

 

[looping records to update, checkboxes, dropdowns, radio buttons]

 

*sigh*

 

You have this issue with constantly having to convince yourself about being mature. I have managed to get it working now (no thanks to you). You have no idea how old I am and for that matter the level of intelligence. You are simply making assumptions based on what you have read.

 

I could guarantee you that whatever your assumptions may be that you are way off.

 

Regardless of that, these forums are for learning and I have truly learnt something today...

 

Further note, this is the first time I have been disappointed with phpfreaks.com and another member.

 

Maybe you are highly thought of, perhaps not. I don’t know. Self gratification only gets you so far.

 

[looping records to update, checkboxes, dropdowns, radio buttons]

 

well I think you have shown us all how excellent you truely are.

 

You are a amazing!

 

Please do go on.....

[looping records to update, checkboxes, dropdowns, radio buttons]

Yea but only one has came on blasting about it.

 

Seems you need to let off some steam, and over a keyboard is the best way for you not to get hurt.

 

Now these forums, if I am not mistaken, are for constructive assistance. You constantly are replying with posts that are of no use to anyone and frankly are as welcome as a fart in a space suit. ( go on tell me how welcome a fart is in a space suit)

 

Damn kids.

[looping records to update, checkboxes, dropdowns, radio buttons]

Thank you Pikachu2000 for a constructive response.

 

and you are correct, it does seem like I wanted someone to write/supply the code. However I did say I hope this isnt too much to ask and that a sample script (if someone had it) would be appreciated.

 

Thanks again for your response Pikachu2000.

[looping records to update, checkboxes, dropdowns, radio buttons]

 

I rest my case

[looping records to update, checkboxes, dropdowns, radio buttons]

hmm no caps was ever used. Caps is for someone that cannot put into words anything constructive.

 

I used bold to highlight my point. However I can see that this conversation has come to a close.

 

Well if the mods signature is anything to go by then my question surely must be the worst ever because your response was as useful as a chocolate tea pot.

 

If your programming skills are any direct relation to your communication skills then I doubt I would want your assistance.

 

Have a good day and I shall ask someone with a little brains.

 

 

[looping records to update, checkboxes, dropdowns, radio buttons]

No, I dont want someone to write a universal front end.

 

I want to know learn how to update multiple records that hold different input types!

 

I know how to update multiple records, but only if they are text inputs!

 

Now please only comment if you have something constructive to write.

 

Feedback is good, but only from those that know how to deliver it!

 

 

[looping records to update, checkboxes, dropdowns, radio buttons]

Hi,

 

I was wondering if someone would be so kind as to post some code for me?

 

Basically I want to display all of my records in a table like format and be able to update them by clicking one update button at the bottom of the table.

 

My records inlcude textfields, dropdowns, checkboxes, and radio buttons.

 

So basically a sample script that updates multiple records that uses different input types.

 

I hope this isnt too much to ask but it would be much appreciated.

 

Regards,

 

jmcall10

[contact form script on one page]

This seems to be the answer!

 

Thank you!

[contact form script on one page]

scampbell,

 

Using sessions is the solution that keeps coming up so i guess that will be my work around.

 

Could you do me a favour. Could you post some sample code on how that might look?

 

That would be much appreciated.

 

jmcall10

[contact form script on one page]

Is this not possible then?

[contact form script on one page]

Hi guys,

 

I was wondering if someone with good experience could help me out.

 

Basically all I would like is a contact form script (easy I know) however there is a few requirements that I cannot find a good solution for.

 

the requirements are as follows:

• script must be in one page (i.e. call itself)
  
• After the form has been submitted I would like the users variables echo'd to the user (just to show what contact info they have submitted)
  
• If after form submission the user hits refresh then I would like them to be presented with form again or something saying you have submitted a form etc
  

 

I can do the first two bullet points but the third is were I am stuck and cannot see a way round it.

 

Basically the way my script is just now, the user is initially presented with the form and after submission the form is sent via the mail function and the user is shown the info in each of the variables they submitted with a thank you. At this point if the user hits the refresh button the user is shown their info again and another submission is sent.

 

There must be a way round this. I have tried unsetting the $_POST variables etc.

 

If someone could either show me an example of thiers working or even guide me that would be much appreciated.

However I have had many people saying "this will work" then it doesnt, because they actually didnt know if it would or not lol.

 

That wasnt meant nasty incase it was taken that way, im just looking for a real solution or even a reason as to why this cant be done.

 

Thanks in advance

 

jmcall10

[<? and <?php problem]

Thanks guys

 

I went with the echo

[<? and <?php problem]

Hi,

 

I have a script that is not written by myself and uses "<?" and my server seems to only work when its changed to "<?php"

 

This is fine for most of the script, however there are some sections of code that does not allow for this.

 

For example:

 

<? version

<input name="username" type="text" value="<?=$row2["username"]?>" >

 

<?php

<input name="username" type="text" value="<?php=$row2["username"]?>" >

 

when I change it to <?php in this case it does not work.

 

I have put in that works but not sure if this is good practice :

<input name="username" type="text" value="<?php echo $row2["username"]?>" >

 

Does anyone know why and how I can change it?

 

 

[PHP football script]

Thanks i am at work and this appears to be blocked, so will have a look when I get home.

[PHP football script]

Hi,

I can read and understand php and mysql scripting however I am not good at writing it from scratch.

 

I was wondering how hard it would be to write a script that stores names and stats of players of a five aside game.

 

Now what i mean by stats is very limited. We dont keep track of who scored etc. We just keep track of game date, who played and who won.

 

The teams are never the same so there might be a pool of 18 people and any five would play against another 5.

 

Really all I want it to do is allow for player creation, game creation, and update the game details with the outcome.

 

Is this too hard and if not I would be willing to pay a small fee for this script.

 

Thanks in advance

jmcall10

 

ps if there is something out there then that would be great but I couldnt find anything.

 

[Is this the best efficient way?]

Neil, Thanks for your response.

 

I agree that my tables are set up optimally however do you have any code that would get me my desired result?

 

Thanks

 

jmcall10

[Is this the best efficient way?]

Thank you so much for your time and effort

 

This is a small project I am working on and will only be viewed by a small number of people.

 

If I had the experience then Id love to re-code it more efficiently.

 

It seems too large for me to do as it messes with my head haha

 

Thanks anyway for all the help

[Is this the best efficient way?]

ok I will have to ponder this as I can see what is happening however it means drastically re-writing my code

 

I am not the best coder as it is lol

 

I have one question however. With my original design. What is wrong with nesting a query within a loop?

 

Im assuming it has something to do with performance?

[Is this the best efficient way?]

Ok I understand that first part

 

onto the second part.

 

I understand arrays but could you explain what is happening in the code you posted as I am unfamiliar with nested arrays sorry

 

I appreciate all this help by the way   Thank you

[Is this the best efficient way?]

Ok I have ran the first query in phpmyadmin and I get back a table almost like what you have mentioned.

 

It has pid, name, events

 

However under the events heading it says [bLOB - 3 B] or [bLOB - 1 B] etc

 

is this correct?

[Is this the best efficient way?]

Yes that is the output I would like

 

I dont want to change my tables tho

 

Can you suggest anything?

[Is this the best efficient way?]

Ok, say I stick with my table design.

 

Is the way I have nested 3 loops the most efficient way?

 

Or am I using to much php resources or something?

 

at the moment I am looping through all the people

then for ech person looping through the events

  then for each event checking to see if that person attended or not.

 

It is my looping code I want to know if it is efficient or not