SitePoint Sponsor

User Tag List

Results 1 to 9 of 9

Thread: mySQL & PHP

  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2000
    Location
    USA
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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...
    Living the OO way.
    Hardware Help | Desperados!

  2. #2
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You should use MySQL documentation instead. Here it is:

    http://www.mysql.com/documentation/m...n=CREATE_TABLE
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy

  3. #3
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    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.
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference

  4. #4
    SitePoint Enthusiast
    Join Date
    Dec 2000
    Location
    USA
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks
    now i just gotta install phpmyadmin (no biggie)
    Living the OO way.
    Hardware Help | Desperados!

  5. #5
    AdSpeed.com Son Nguyen's Avatar
    Join Date
    Aug 2000
    Location
    Silicon Valley
    Posts
    2,241
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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!
    - Son Nguyen
    AdSpeed.com - Ad Serving and Ad Management Made Easy

  6. #6
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  7. #7
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    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.
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference

  8. #8
    SitePoint Addict sstaubin01's Avatar
    Join Date
    Nov 2000
    Location
    Ont, Canada
    Posts
    234
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  9. #9
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    Please don't PM me with questions.
    Use the forums, that is what they are here for.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •