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: