Hello
Iam new to this forum and hope i can get this awnsered. I have a form that lets users submit data online. Now i check my sql database to see if they arent submitting a duplicate username.

How can i get the error message to appear on the form? You have this done when you register for this forum. I need to connect to the database and if there is a error display it on the form??? Below is a simple form can i have an example with thsi form where an dhow would i add the php to A check the database field(userid) and B) Submit the form into the database. I think i have to use php echo self

thanks
pete

Form:

<meta http-equiv="Content-Language" content="en-us">
<form method="POST" action="--WEBBOT-SELF--">
<p>Name: <input type="text" name="T1" size="20"></p>
<p>Username: <input type="text" name="T3" size="20"></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

One way is to redisplay your form passing it an error code. Then in the PHP if error code exists you add a line above the form itself indicating what's wrong.

In essence:

__________________

Cow: You're a lawyer too?
Mooseblood (mosquito): Ma'am, I was already a bloodsucking parasite. All I needed was a briefcase!

Ok so now i have the code you gave me but how do i tie it in with my mysql. below you will find the sql im checking for in my database




You guys gave me this example, how do i tie in mysql with you code. Im checking for a duplicate username, if duplicate want the message to show on the form.

$errline = "";
if ($err == 1) { $errline = "Name Error"; }
else
if ($err == 2) { $errline = "Address Error"; }

print $errline
print "<FORM ..."




heres my COde:

$query1 = "SELECT * from test WHERE name = '$user'";
$result1 = mysql_query($query1) or exit(mysql_error());
if (mysql_num_rows($result1))


PS Great Forum

How do you know if there's an error? I assume you know how to test for this. So when you get one, set the error code, and reload the form with the error as part of the query string.

__________________

Cow: You're a lawyer too?
Mooseblood (mosquito): Ma'am, I was already a bloodsucking parasite. All I needed was a briefcase!