jmcall10

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

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

*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.

well I think you have shown us all how excellent you truely are. You are a amazing! Please do go on.....

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.

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.

I rest my case

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.

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!

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

This seems to be the answer! Thank you!

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

Is this not possible then?

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

Thanks guys I went with the echo

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?

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

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.

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

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

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?

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

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?

Yes that is the output I would like I dont want to change my tables tho Can you suggest anything?

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