I need to make 2 submit buttons one that if clicked sends data to a mysql server the other if clicked takes data from the mysql server.

This is what my submit buttons are currently.

<input type="submit" name="submit" id="submit" value="Create an Account" />
<input type="submit" name="submit" id="submit" value="Tell Me My Password" />

I am using an if statement in perl to try and get it to do one of the other action for it like this.

if ($submit == "Create an Account")
{
Send everything to the database
}

if ($submit == "Tell Me My Password")
{
Send password back
}

Right now it will run through both of them sending the data to the mysql database as well as sending it back and printing it, and I don't know how to make it so that it will only run through the one clicked on. Can anyone help me?

You can't have two elements with the same ID.

Just give the buttons different names

"create" & "send_pwd" or submit1 & submit2

What do you tell the form to do once submitted? E.G. <form action = something>.

First change the name of one of the submit buttons so you have two different names. Something like this:

<input type="submit" name="submit1" id="submit" value="Create an Account" />
<input type="submit" name="submit2" id="submit" value="Tell Me My Password" />

Then do something like this inside the file that gets executed:
PHP:

if(isset($_POST["submit1"]))
{
create account code
}
else if(isset($_POST["submit2"]))
{
retrieve password
}

I changed them so that the first input is submit and the second one is submit2.

                            <form name="info" id="info" action="cgi-bin/booksonline.cgi" method="post">
                            Account Number: <input type="text" name="username" id="username" size="5" maxlength="5" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                            Password: <input type="password" name="password" id="password" size="10" maxlength="10" />
                            <br /><br />
                            <input type="submit" name="submit" id="submit" value="Create and Account" onclick="" />
                            <input type="submit" name="submit2" id="submit2" value="Tell Me My Password" onclick=""  />
                            </form>

Thats my form code, it is linked to a perl file that says this

if ($submit == "Create an Account")
{
Send everything to the database
}

elsif ($submit2 == "Tell Me My Password")
{
retrieve the password
}

It still comes up as completing the first if, but it does not get to the second one anymore. That means it is returning the first if true every time I assume?