Create Proc

[otuatail]

Can anyone help here. I have been told by my web host that on MySQL 5.0.4 that I have been given privaleges for creating stored procedurers and view. The only codeing I have on this subject is sklserver 2000, but up to now

all the commands are the same. Can someone tell me if there is an error in this

 

CREATE PROC surname

@id NVARCHAR(10),

@name VARCHAR (60) OUTPUT

AS

SELECT @name = lastname FROM PhoneNumbers WHERE id = @id

 

This is waht i get back

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROC surname

@id NVARCHAR(10),

@name VARCHAR (60) OUTPUT

AS

SELECT @name = l' at line 1

 

 

[Glyde]

http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html

[Glyde]

CREATE PROCEDURE surname(pid VARCHAR(10), name VARCHAR (60)) SELECT lastname FROM PhoneNumbers WHERE `id` = pid AND `lastname` = name

Ah, sorry about the double post, I thought I clicked the edit button.  Ugh.

[otuatail]

Thanks your code worked and I modified it to output AS

CREATE PROCEDURE surname(pid VARCHAR(10), OUT name VARCHAR (60))

SELECT lastname AS name FROM PhoneNumbers WHERE `id` = pid

 

I just need to get to call this from .PHP webpage. Will try somethings out.

 

Des