The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mySQL Help?

Discussion in 'cPanel Developers' started by seelke, Oct 7, 2003.

  1. seelke

    seelke Member

    Joined:
    Aug 13, 2001
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    I am trying to make an addon script. I want to execute a mySQL command after the database is setup.
    Can someone please help me out with this?

    Here is the command I need to work. I know it works in phpMyAdmin.

    UPDATE envo_users SET pn_uname = '$username', pn_pass = MD5('$password') WHERE pn_uid = '2';

    Here is how I have it in the install file. It isn't working.

    system("mysql UPDATE envo_users SET pn_uname = '$username', pn_pass = MD5('$password') WHERE pn_uid = '2';");

    Does anyone know how to correct this?
    Thanks, Eddie

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page