MySQL Forums
Forum List  »  Stored Procedures

PROCEDURE ALMOST WORK
Posted by: DarkEden Genesis Extreme Genesis
Date: September 11, 2011 10:22AM

Hello guys,

I have made the following procedure:

CREATE PROCEDURE create ($id varchar(20),$pass varchar(20),$email varchar(100)) BEGIN INSERT INTO User (user,pass,ip,e-mail) values ('$id','$pass','{$_SERVER['REMOTE_ADDR']}',$email);

It works...but has two problems:

1st: field e-mail gets the value 0 instead of the registrant email;

2nd: ip field gets the function name instead of the registrant ip value.

www.darkedengenesis.com
DarkEden Genesis Online



Edited 1 time(s). Last edit at 09/11/2011 08:35PM by DarkEden Genesis Extreme Genesis.

Options: ReplyQuote


Subject
Views
Written By
Posted
PROCEDURE ALMOST WORK
3428
September 11, 2011 10:22AM
900
September 11, 2011 06:04PM
877
September 12, 2011 11:34PM
900
September 13, 2011 01:44PM
816
September 14, 2011 09:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.