Need help converting from MSSQL to MySQL

[w1nn3r]

I have a page that is written for MSSQL and need it to be for MySQL.

$uwebregrq = "exec adduser '$uwebreg_un',$uwebreg_pwd,'$uwebreg_squestion',$uwebreg_sanswer,
'$uwebreg_truename',$uwebreg_idnumber,'$uwebreg_email',
'$uwebreg_mobilenumber','$uwebreg_province','$uwebreg_city',
'$uwebreg_phonenumber','$uwebreg_address',$uwebreg_postal,$uwebreg_gender,
'$uwebreg_dob',1,$uwebreg_pwd";

adduser is the procedure I want to call.

 

[feherke]

Hi

Does not really sounds like a PHP question.

See [tt]call[/tt] in the MySQL documentation.

Feherke.

http://rootshell.be/~feherke/

 

[vacunita]

Looks to me like you want to call a MSSQL only function.

If you want to add a user to MYSQL it would be something like:
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password'];

And then you would issue another query to GRANT that USER different permissions.


Perhaps the MYSQL manual can be of help to you.

http://dev.mysql.com/doc/refman/5.0/en/grant.html

http://dev.mysql.com/doc/refman/5.0/en/create-user.html

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[jpadie]

I don't think that's what the MS SQL is after, vacunita. It looks like a stored function to me.

the OP would need to create the function/procedure in mysql, and name it 'adduser'. instead of exec he would, as feherke points out, use 'call'