Hmmmmm... Well the only things I ever use in MySQL are following
VARCHAR - I use this for storing say a username or a password, can be up to 255 charecters supposedly although I could only get it to work at 254 charecters on older versions.
INT - For storing numbers, say if I made a lottery game for example I'd use INT to store the numbers a user submits, again up to 255 charecters.
DATETIME / DATE / TIME - these do what they suggest. Don't write anything to them in your PHP script and it'll automatically put the DATE & TIME, DATE, or TIME in itself.
BLOB - I use this for storing binary. God knows how many charecters it allows!
Also you should be aware of
PRIMARY KEY - Hmmmm I don't understand this either but mah you have to set a primary key (I always make a field called 'id' int 255 for this) if you want to write to your table, straaaaaaaaaaange.
Auto-Increasement - If you use this, you don't need to tell your PHP script what to do, just don't write to it, MySQL will automatically give it one number higher than the previous one that was written, I use it in my tables (all of them!!!) to give 'id' 'int' '255' 'primayr key' 'auto-increasement' works great.
Ok this is how you connect to a mysql database
mysql_connect("host", "username", "password");
Now you need to select your db
mysql_select_db("dbname");
Now run your queries...
I'm not so good with this I have to look it all up whenever I want to run a query so pherpas I'm not the right person to show you how to do queries! 😉
When you're finnished with your database connection, you want to close it using
mysql_close();
Hmmmmm that's about all I know with MySQL, it isn't my brightest side, sorry.
