mysql table help!!

[DirtyD_]

im trying to make a new pet mod and want to make a new table for it.

How do i create and a new table with userid

and whats the script to display the information on the site.

such as the pets name????????

[Guest]

Tizag has some good resources for SQL see here http://www.tizag.com/mysqlTutorial/mysqltables.php

[Razor42]

I recently had to create a mod with this and had no real idea of doing it so I just looked up a mod that does it for example crimes, houses etc and then used that as an example to build my mod upon and now after another few times doing it it has become natural :)

[Dominion]

The way you asked this basically comes across as... " Can someone create a pets mod? ". If you want help with just the SQL have a look into it yourself (sites mentioned above) or ask a specific question. If you want it all done or a full example search the site as people have posted free "pets mods" in the past.

[Newbie]

if this is what ya mean then ill start you off. Tizag is a good site to learn from used it quite alot

 

CREATE TABLE `pets` (
`userid` int(11) NOT NULL auto_increment,
PRIMARY KEY  (`userid`)
) ENGINE=MyISAM ;