question about M. Lemos form script

[dr zoidberg]

Hello,

I'm creating registration service with this great form script for
creating forms within Smarty.

Question is how can I validate 'username' against allready registered
users in MySQL?

TNX!

[Robert Beier]

On Tue, 16 Mar 2004 16:58:16 +0100, dr zoidberg wrote:

Hello,

I'm creating registration service with this great form script for
creating forms within Smarty.

Question is how can I validate 'username' against allready registered
users in MySQL?

TNX!

why dont you compare username with the entries in the database?
something like this...

$res = mysql_query("SELECT * FROM table WHERE u_name LIKE $username");
if($mysql_num_rows()) $username_exists = 1;

if one row is returned, username already is registered.
hope i didnt misunderstood your problem.
(and sorry for the bad english, not my mother-language)

Robert