slionheart
New Members-
Posts
4 -
Joined
-
Last visited
Never
Profile Information
-
Gender
Not Telling
slionheart's Achievements
Newbie (1/5)
0
Reputation
-
Printf Where would that code go exactly, also are thos notations in there, like I said I'm a noob, thanks again for your time.
-
Thanks you all, let me try it out.
-
Hey everyone how's it going? First I want to start out and mention that I'm a total noob and I'm using Dreamweaver 8. Now here is my situation. I built a form and it's submitting to information to the database, but I want to make sure that someone doesn't use the same email address, how do I validate that and send back that the email address has already been used so there are no duplicates. Thank you for your time, my code is posted below. <form action="<?php echo $editFormAction; ?>" method="POST" name="form1" id="form1" > <table width="453" border="0" cellpadding="5" cellspacing="1" bgcolor="#59AD00" class="plaintext"> <tr> <td height="23" bgcolor="#99CC00" class="SectionTab"><b> Contact Information:</b></td> <td valign="top" class="sectiontab"> </td> </tr> <tr> <td width="160" nowrap="nowrap" bgcolor="#99CC00" class="AppLeft">Name:</td> <td width="270" nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight"><font color="#333333">First <input name="FirstName" style="WIDTH: 100px;" maxlength="50" /> Last <input name="LastName" style="WIDTH: 100px;" maxlength="50" /> </font></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00" class="AppLeft">Street Address:</td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight"><input name="Street" id="Street" style="WIDTH: 250px;" maxlength="50" /></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00" class="AppLeft">City, State & Zip</td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight"><input name="City" id="City" style="WIDTH: 100px;" maxlength="50" /> <select name="State" id="State"> <option value="AL">AL</option> <option value="AK">AK</option> <option value="AZ">AZ</option> <option value="AR">AR</option> <option value="CA">CA</option> <option value="CO">CO</option> <option value="CT">CT</option> <option value="DE">DE</option> <option value="DC">DC</option> <option value="FL">FL</option> <option value="GA">GA</option> <option value="HI">HI</option> <option value="ID">ID</option> <option value="IL">IL</option> <option value="IN">IN</option> <option value="IA">IA</option> <option value="KS">KS</option> <option value="KY">KY</option> <option value="LA">LA</option> <option value="ME">ME</option> <option value="MD">MD</option> <option value="MA">MA</option> <option value="MI">MI</option> <option value="MN">MN</option> <option value="MS">MS</option> <option value="MO">MO</option> <option value="MT">MT</option> <option value="NE">NE</option> <option value="NV">NV</option> <option value="NJ">NJ</option> <option value="NM">NM</option> <option value="NY">NY</option> <option value="NC">NC</option> <option value="ND">ND</option> <option value="OH">OH</option> <option value="OK">OK</option> <option value="OR">OR</option> <option value="PA">PA</option> <option value="RI">RI</option> <option value="SC">SC</option> <option value="SD">SD</option> <option value="TN">TN</option> <option value="TX">TX</option> <option value="UT">UT</option> <option value="VA">VA</option> <option value="VT">VT</option> <option value="WA">WA</option> <option value="WV">WV</option> <option value="WI">WI</option> <option value="WY">WY</option> </select> <input name="Zip" id="Zip" style="WIDTH: 50px;" maxlength="5" /> </td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00" class="AppLeft">E-Mail:</td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight"><input name="EMail" id="EMail" size="35" maxlength="20" /></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00" class="AppLeft"> Phone:</td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight"><input name="Phone" id="Phone" style="WIDTH: 100px;" maxlength="20" /></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00" class="AppLeft">Cell Phone:</td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight"><input name="CellPhone" id="CellPhone" style="WIDTH: 100px;" maxlength="20" /></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00" class="AppLeft">Best Time to Call:</td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight" style="width: 150px;"><select name="BestTimeToCall"> <option value="8am - 10am">8am - 10am</option> <option value="10am - 12 noon">10am - 12 noon</option> <option value="12noon - 2pm">12noon - 2pm</option> <option value="2pm - 4pm">2pm - 4pm</option> <option value="4pm - 6pm">4pm - 6pm</option> <option value="6pm - 8pm">6pm - 8pm</option> </select> </td> </tr> <tr> <td colspan="2" nowrap="nowrap" bgcolor="#FFFFFF" class="AppLeft"><div align="center"><font color="#333333">Time Zone: </font> <select name="TimeZone" id="TimeZone"> <option>(GMT -10:00) Hawaii</option> <option>(GMT -9:00) Alaska</option> <option>(GMT -8:00) Pacific Time (US & Canada)</option> <option>(GMT -7:00) Mountain Time (US & Canada)</option> <option selected="selected">(GMT -6:00) Central Time (US & Canada), Mexico City</option> <option>(GMT -5:00) Eastern Time (US & Canada), Bogota, Lima</option> </select> </div></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00" class="AppLeft"><p>Position interested in </p> <p><i>ex. customer service, </i></p> <p><i>tech support, </i></p> <p><i>Admin assistant</i></p></td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight" style="width: 150px;"><input name="Posistion_Interested" id="Posistion_Interested" maxlength="40" /></td> </tr> <tr> <td valign="top" nowrap="nowrap" bgcolor="#99CC00" class="AppLeft">Notes</td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight" style="width: 150px;"><textarea name="Notes" cols="35" rows="5" id="Notes"></textarea></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00" class="AppLeft"><p>Salary preference</p> <p><i>ex. 8,9,10/Hr or Annual</i></p></td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight" style="width: 150px;"><span class="AppRight" style="width: 150px;"> <input name="Salary" id="Salary" style="WIDTH: 100px;" maxlength="20" /> </span></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00" class="AppLeft">Highest level of education </td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight" style="width: 150px;"><select name="LevelEducation" id="LevelEducation"> <option value="GED">GED</option> <option value="High School">High School</option> <option value="Some College">Some College</option> <option value="Bachelors">Bachelors</option> </select></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00" class="AppLeft">Currently in school </td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight" style="width: 150px;"><span class="AppRight" style="width: 150px;"> <select name="CurrentlyInSchool" id="CurrentlyInSchool"> <option value="Yes">Yes</option> <option value="No">No</option> </select> </span></td> </tr> <tr> <td nowrap="nowrap" bgcolor="#99CC00"><p>Willing to go back to school </p> <p><i><font size="1">(Most employers are willing to hire </font></i></p> <p><i><font size="1">applicants that are in school or </font></i></p> <p><i><font size="1">willing to further their education </font></i></p> <p><i><font size="1">at some point.)</font></i></p></td> <td nowrap="nowrap" bgcolor="#FFFFFF" class="AppRight" style="width: 150px;"><span class="AppRight" style="width: 150px;"> <select name="GoBackToSchool" id="GoBackToSchool"> <option value="Yes">Yes</option> <option value="No">No</option> </select> </span></td> </tr> <tr> <td colspan="2" align="center" valign="center" bgcolor="#99CC00"><span class="AppLeft"> <input name="Date" type="hidden" id="Date" value="<?php echo date("Y/m/d"); ?>" /> </span> <div align="center"> <input name="submit" type="submit" value="Submit Information" /> <br /> <FONT color="navy" size="1"> <u></td> </tr> </table> <input type="hidden" name="MM_insert" value="form1"> </form>
-
Search with empty options.
slionheart replied to stevebob's topic in Editor Help (PhpStorm, VS Code, etc)
Don't know if you found out how to yet, but I would use dropdown menus instead of options and set this as the top option <option value="">Please Choose</option> Set the value to "" to make it empty and it will give you the search results you need