DrAwesomePhD

Ah thanks so much. So INSERT must be for new rows only.... thanks ^_^ good to know.

Hi, i'm sure this is a really stupid question, but could anyone please tell me the command to insert data into a certain part of the table? It seems my command that i've used before is being tempermental :-/ I'm trying to change the value of my account (charname=Jeht member_id = 1) in the access field to 15 from null. I've tried this: INSERT INTO members (access) VALUES ('15') WHERE charname = 'Jeht'; and its not happy with the "WHERE" part of it .... anyone plz help? and sorry for my noobness :-/

Hi, i was totally intrigued by the way this website checked your password automatically when you filled in the fields, if your two passwords matched it changed the border on the <div> to green from white, if they didnt it changed them to red... I'm not too familiar with javascript, but could anyone help me please... and tell me how to do something like that? The main problem seems to be - when you deselect a password box, you have to make a check to see if they are the same... but how do you know when someone deselects the password box?

sorry for my noobness but it doesnt make sense >.< What does the "AS m" and "AS cr" mean? and how does that relate to cr.member_id...

The query where i grab everyone who is in a specific raid (which would be in the combined_raids table) AND the information about each specific character (class, guild, etc etc --- which would be in the members table) so i can print out in an organized fashion who attended the raid and quickly see how many warriors, mages, etc.

Sorry, i was just playing around with this, i'm still confused as to how this combined raid works... So ive got raid and members tables with info in them fine... but how do i say "OK, who is signed up to raid_id=1? " how do i get a list of their member_ids? Will it ultimately look like this: [code]Raid id:       Member ID:         1                     11 1                     14 1                     9 1                     27 1                     31 1                     18 2                     11 2                     21 2                     17 2                     24 2                     22[/code] Just as some rnadom numbers, but the thats the basic pattern? The problem i run into seems to be in the actual coding... so i want to print this out in some sort of reliable fashion... I'm really quite stumped on how you are supposed to do this using these multiple tables and have a clean set of code. The only thing i could think of doing is querrying the combined_raid table, making multiple arrays (one for each class) and storing all the member_id's inside of them for people who have signed up for the same raid_id, and then doing another query with lots of for loops to print the arrays out with even more querries inside of it for the specific member info.... but tahts really really really messy code :-/ surely theres a better way to use MySQL to simply get ALL the info you need and just sorting through it? Please someone help :(

Aw :-/ so basically i should make a login script and use the login names as unique ID's for signing up for the raids. That makes sense.... so much for being lazy :P thanks for the help!!

Hi, i'm sure theres a better way to word it... but i'm basically trying to create a table within a table and have run into a little snag. Heres what i'm trying to create: a way of organizing my guild (in world of warcraft) raids via a website. So, i have created a database called "raids" to hold all this information... now i wanted to create a new table for each Raid, and WITHIN each of those tables store the info about people's names, classes, etc. etc. because they are dependent of the raid... AKA different people will sign up for different raids. Could anyone tell me how to get around this dillemma ? The help would be greatly apprecaited! ^_^