Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Generate Keys on from a list when refreshed

  1. #11
    Join Date
    Sep 2008
    Posts
    44
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by Nile View Post
    Aww man! What kind of host are you using?
    Dreamhost, they have their own custom control panel so it makes it hard to do things.

  2. #12
    Join Date
    Jan 2008
    Posts
    4,168
    Thanks
    28
    Thanked 628 Times in 624 Posts
    Blog Entries
    1

    Default

    Dreamhost has mysql databases...
    Jeremy | jfein.net

  3. #13
    Join Date
    Sep 2008
    Posts
    44
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by Nile View Post
    Dreamhost has mysql databases...
    Yes but you can't physically edit them. At least from what I found out.

  4. #14
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,164
    Thanks
    265
    Thanked 690 Times in 678 Posts

    Default

    Permissions can be limited. For example, my host does not allow adding new databases outside of their own control panel.
    However, no host limits mysql usage to the point where you cannot modify tables-- it would be pointless.
    There may be no default editor setup, but you could try to install one (like phpmyadmin), or just use text commands.
    In your PHP, you can use commands like mysql_query("CREATE TABLE ...") and go from there.
    Daniel - Freelance Web Design | <?php?> | <html>| español | Deutsch | italiano | português | català | un peu de français | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

  5. #15
    Join Date
    Jan 2008
    Posts
    4,168
    Thanks
    28
    Thanked 628 Times in 624 Posts
    Blog Entries
    1

    Default

    PHP Code:
    mysql_connect("host""user""pass") or die(mysql_error());
    mysql_select_db("database") or die(mysql_error());
    mysql_query("CREATE TABLE IF NOT EXISTS `code` (
      `codes` text NOT NULL,
      `used` tinyint(1) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1"
    ) or die(mysql_error()); 
    Jeremy | jfein.net

  6. #16
    Join Date
    Sep 2008
    Posts
    44
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Default

    Quote Originally Posted by Nile View Post
    PHP Code:
    mysql_connect("host""user""pass") or die(mysql_error());
    mysql_select_db("database") or die(mysql_error());
    mysql_query("CREATE TABLE IF NOT EXISTS `code` (
      `codes` text NOT NULL,
      `used` tinyint(1) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1"
    ) or die(mysql_error()); 
    Wow...I really need some sleep ^_^" thanks for your help , will try this tomorrow.

  7. #17
    Join Date
    Jan 2008
    Posts
    4,168
    Thanks
    28
    Thanked 628 Times in 624 Posts
    Blog Entries
    1

    Default

    Did it happen to work out for you?
    Jeremy | jfein.net

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
  •