mySQL & PHP

[MethoD]

Can someone tell me the syntax for (in mysql) creating a table, a row, and a column?

I couldn't find the information in the php manual under mySQL functions for some reason...

[Son Nguyen]

You should use MySQL documentation instead. Here it is:

http://www.mysql.com/documentation/m...n=CREATE_TABLE

[Kevin Yank]

All PHP lets you do is send SQL (Structured Query Language) commands to the MySQL server and retrieve the results. Neccessarily, this requires that you know SQL as well as PHP. The PHP manual tells you all the PHP commands you need, while the MySQL manual covers the SQL commands.

Alternatively, check out Part 2 of my MySQL/PHP tutorial here for a quick introduction to SQL, including the commands you're asking for.

[MethoD]

Thanks
now i just gotta install phpmyadmin (no biggie)

[Son Nguyen]

Yeah, phpMyAdmin will erase your potential knowledge of SQL! Just kidding, the documentation is always there for anyone to look up, phpMyAdmin makes life easier and more productive!

[freddydoesphp]

Unfortunately I compare it to using Dreamweaver instead of learning html. Not to say that I don't use it from time to time, but I would never dream of relying solely on a gui alternative.

[Kevin Yank]

Unlike most of the other SitePoint staff members, I work faster at a MySQL command line than I do in phpMyAdmin. Admittedly, I am an elitist snob.

[sstaubin01]

Once you learn the basics of PHP or SQL, it's all copy/paste from there. Learning the basics gives you the understanding which leads to less confusion for debugging.

I hope Freddy isn't reading this as he gave me the same lecture last week when I asked about date manipulation in PHP.

We all take the short cuts but make sure you understand what's generated.

[freddydoesphp]

You got it at least you listened to me which is more than I can say for most of the people I associate with, isn't the virtual swell.