Mailaddy abfragen

[extrabreit]

ich nochmal..

Ich habe eine jobdatenbank wo die mailaddy bei stellenangeboten angegeben werden muss.
das problem ist, wenn ich unter der gleichen mailaddy eine zweite stellenanzeige schalten will, dann meckert das programm.....die mailaddy ist schon vorhanden und nimmt das 2. stelleangebot nicht an.

1. wie lautet diese Mailaddyabfrage in der programmiersprache php

2.
wie kann ich das so umschreiben, dass unter einer mailaddy mehrere Angebote geschaltet werden können

Wie sieht denn die Jobdatenbank aus?

[extrabreit]

Das ist die Datei die das regeln soll




<?php
if($_POST['senden_x'] && !empty($_POST['mail']) && ereg("^([a-zA-Z0-9\.\_\-]+)@([a-zA-Z0-9\.\-]+\.[A-Za-z][A-Za-z]+)$", $_POST['mail']) && !empty($_POST['name']) && !empty($_POST['vorname']) && !empty($_POST['strasse']) && !empty($_POST['ort']) && !empty($_POST['plz']) && !empty($_POST['tel']) && ($_POST['pw']==$_POST['pw1']) && !ereg("[^a-zA-ZäüöÄÜÖ]", $_POST['vorname']) && !ereg("[^a-zA-ZäüöÄÜÖ]", $_POST['name']) && !ereg("[^0-9]", $_POST['plz']))

{
mysql_connect($DB_HOST, $DB_USER, $DB_PASS);
mysql_select_db($DATABASE);
$sql = "SELECT
*
FROM
db_job_kontakt WHERE mail='".$_POST['mail']."'";
$mail_match = mysql_query($sql);
if (mysql_num_rows($mail_match) > 0) {
?>
<table cellspacing="0" width="100%"border="0" bgcolor="#ee985e"><tr><td>
<table width="100%" cellpadding="7" bgcolor="#e6f0fb"><tr><td align="center">

<table cellpadding="0" cellspacing="0" width="100%" border="0" bgcolor="#e6f0fb">
<tr>
<td width="30%" align="center"><img src="./images/icon_no.jpg" alt="Yes" border="0"></td>
<td ><font color="brown"><b>Hinweis!</b></font>&nbsp;-&nbsp;Ihre E-Mail Adresse existiert schon in der Datenbank.<p></p><b>&raquo;&raquo;&nbsp;<a href="javascript:history.back()">Zur&uuml;ck zum Formular</a></b></td>
</tr>
</table>

</td></tr></table>
</td></tr></table>
<?
} else {
?>
<form method="post" action="newadd2.php?get=<? echo $_GET['get'] ?>">
<table width="<? echo $BODY_WIDTH ?>" cellpadding="<? echo $BODY_CELL_PAD ?>" cellspacing="<? echo $BODY_CELL_SPC ?>" align="center" cellpadding="5">
<tr><td class="border3" colspan="2"><b>Angaben kontrollieren</b></td></tr>
<tr><td width="30%">Firma:</td><td class="border3"><? echo $_POST['firma'] ?></td></tr>
<tr><td width="30%">Vorname:</td><td class="border3"><? echo $_POST['vorname'] ?></td></tr>
<tr><td width="30%">Nachname:</td><td class="border3"><? echo $_POST['name'] ?></td></tr>
<tr><td width="30%">Strasse:</td><td class="border3"><? echo $_POST['strasse'] ?></td></tr>
<tr><td width="30%">PLZ:</td><td class="border3"><? echo $_POST['plz'] ?></td></tr>
<tr><td width="30%">Wohnort:</td><td class="border3"><? echo $_POST['ort'] ?></td></tr>
<tr><td width="30%">Telefon:</td><td class="border3"><? echo $_POST['tel'] ?></td></tr>
<tr><td width="30%">Telefax:</td><td class="border3"><? echo $_POST['fax'] ?></td></tr>
<tr><td width="30%">E-Mail:</td><td class="border3"><? echo $_POST['mail'] ?></td></tr>
<tr><td width="30%">Passwort:</td><td class="border3"><? echo $_POST['pw'] ?></td></tr>
<tr><td class="border3" colspan="2"><b>Angaben zum Jobangebot</b></td></tr>
<tr><td width="30%">Berufsbezeichnung:</td><td class="border3"><? echo $_POST['jobname'] ?></td></tr>
<tr><td width="30%">Position:</td><td class="border3"><? echo $_POST['jobpos'] ?></td></tr>
<tr><td width="30%">Beschäftigungsart:</td><td class="border3"><? echo $_POST['jobart'] ?></td></tr>
<tr><td width="30%">Arbeitszeit:</td><td class="border3"><? echo $_POST['jobzeit'] ?></td></tr>
<tr><td width="30%">Berufsbranche:</td><td class="border3"><? echo $_POST['branche'] ?></td></tr>
<tr><td width="30%">Sprachkenntniss:</td><td class="border3"><? echo $_POST['sprache'] ?></td></tr>
<tr><td width="30%">Alter:</td><td class="border3"><? echo $_POST['alter'] ?></td></tr>
<tr><td width="30%">zu besetzen ab:</td><td class="border3"><? echo $_POST['jobab'] ?></td></tr>
<tr><td width="30%">Stellenanzahl:</td><td class="border3"><? echo $_POST['anzahl'] ?></td></tr>
<tr><td width="30%">Einsatzort:</td><td class="border3"><? echo $_POST['einsatz'] ?></td></tr>
<tr><td width="30%">Lohn/Gehalt:</td><td class="border3"><? echo $_POST['joblohn'] ?></td></tr>
<tr><td width="30%">Führerschein:</td><td class="border3"><? echo $_POST['jobab'] ?></td></tr>
<tr><td width="30%">Beschreibung AG:</td><td class="border3"><? echo $_POST['text_ag'] ?></td></tr>
<tr><td width="30%">Beschreibung AN:</td><td class="border3"><? echo $_POST['text_an'] ?></td></tr>
<?
$_SESSION['firma'] = $_POST['firma'];
$_SESSION['name'] = $_POST['name'];
$_SESSION['vorname'] = $_POST['vorname'];
$_SESSION['strasse'] = $_POST['strasse'];
$_SESSION['ort'] = $_POST['ort'];
$_SESSION['plz'] = $_POST['plz'];
$_SESSION['tel'] = $_POST['tel'];
$_SESSION['fax'] = $_POST['fax'];
$_SESSION['mail'] = $_POST['mail'];
$_SESSION['pw'] = $_POST['pw'];
$_SESSION['jobname'] = $_POST['jobname'];
$_SESSION['jobpos'] = $_POST['jobpos'];
$_SESSION['jobart'] = $_POST['jobart'];
$_SESSION['jobart_1'] = $_POST['jobart_1'];
$_SESSION['jobzeit'] = $_POST['jobzeit'];
$_SESSION['jobzeit_1'] = $_POST['jobzeit_1'];
$_SESSION['branche'] = $_POST['branche'];
$_SESSION['sprache'] = $_POST['sprache'];
$_SESSION['alter'] = $_POST['alter'];
$_SESSION['jobab'] = $_POST['jobab'];
$_SESSION['anzahl'] = $_POST['anzahl'];
$_SESSION['einsatz'] = $_POST['einsatz'];
$_SESSION['joblohn'] = $_POST['joblohn'];
$_SESSION['jobauto'] = $_POST['jobauto'];
$_SESSION['text_an'] = $_POST['text_an'];
$_SESSION['text_ag'] = $_POST['text_ag'];

?>
<tr><td><input class="submit" type="button" onClick="history.back();" value="<< Zurück"></td><td align="right"><input class="submit" type="submit" name="senden3" value="Weiter >>"></td></tr></table>
</form>
<?
}
}else{
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']."?get=".$_GET['get'] ?>">
<table width="<? echo $BODY_WIDTH ?>" cellpadding="<? echo $BODY_CELL_PAD ?>" cellspacing="<? echo $BODY_CELL_SPC ?>">
<tr><td colspan="2"><font size="2" color="#859fb9"><b>&raquo;&nbsp;Neue <? if ($_GET['get']==1){echo "Classic";}else{echo "Business";} ?> Anzeige erstellen&nbsp;&laquo;</b></font></td></tr>
<tr><td class="border3" colspan="2"><b>Arbeitgeber Information</b></td></tr>
<?php
if($_POST['senden_x'] && empty($_POST['firma']))
{
?>
<tr><td width="30%"><font color="red">*Firma:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="firma" class="form1"></td></tr>
<?
}else{
if (!empty($_POST['firma']) && ereg("[^a-zA-ZäüöÄÜÖ]", $_POST['firma'])){
?>
<tr><td><font color="red">*Firma:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="firma" value="<? echo $_POST['firma']; ?>" class="form1"><br>
<?
echo "<font color=\"red\"><b>Bitte geben Sie einen gültigen Namen ein!</b></font>";
?>
</td></tr>
<?
}else{
?>
<tr><td>*Firma:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="40" name="firma" value="<? echo $_POST['firma']; ?>" class="form1"></td></tr>
<?
}
}
if($_POST['senden_x'] && empty($_POST['vorname']))
{
?>
<tr><td width="30%"><font color="red">*Vorname:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="vorname" class="form1"></td></tr>
<?
}else{
if (!empty($_POST['vorname']) && ereg("[^a-zA-ZäüöÄÜÖ]", $_POST['vorname'])){
?>
<tr><td><font color="red">*Vorname:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="vorname" value="<? echo $_POST['vorname']; ?>" class="form1"><br>
<?
echo "<font color=\"red\"><b>Bitte geben Sie einen gültigen Namen ein!</b></font>";
?>
</td></tr>
<?
}else{
?>
<tr><td>*Vorname:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="40" name="vorname" value="<? echo $_POST['vorname']; ?>" class="form1"></td></tr>
<?
}
}
if($_POST['senden_x'] && empty($_POST['name']))
{
?>
<tr><td width="30%"><font color="red">*Nachname:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="name" class="form1"></td></tr>
<?
}else{
if (!empty($_POST['name']) && ereg("[^a-zA-ZäüöÄÜÖ]", $_POST['name'])){
?>
<tr><td><font color="red">*Nachname:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="name" value="<? echo $_POST['name']; ?>" class="form1"><br>
<?
echo "<font color=\"red\"><b>Bitte geben Sie einen gültigen Namen ein!</b></font>";
?>
</td></tr>
<?
}else{
?>
<tr><td>*Nachname:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="40" name="name" value="<? echo $_POST['name']; ?>" class="form1"></td></tr>
<?
}
}
if($_POST['senden_x'] && empty($_POST['strasse']))
{
?>
<tr><td width="30%"><font color="red">*Strasse:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="strasse" class="form1">&nbsp;Bsp.: Berliner Str. 10</td></tr>
<?
}else{
?>
<tr><td width="30%">*Strasse:</td><td class="border3">&nbsp;&nbsp;<input value="<? echo $_POST['strasse']; ?>" type="text" size="40" name="strasse" class="form1">&nbsp;Bsp.: Berliner Str. 10</td></tr>
<?
}
if($_POST['senden_x'] && empty($_POST['ort']))
{
?>
<tr><td width="30%"><font color="red">*Wohnort:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="ort" class="form1"></td></tr>
<?
}else{
?>
<tr><td width="30%">*Wohnort:</td><td class="border3">&nbsp;&nbsp;<input value="<? echo $_POST['ort']; ?>" type="text" size="40" name="ort" class="form1"></td></tr>
<?
}
if($_POST['senden_x'] && empty($_POST['plz']))
{
?>
<tr><td width="30%"><font color="red">*PLZ:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="plz" class="form1">&nbsp;5-stellige PLZ</td></tr>
<?
}else{
if (!empty($_POST['plz']) && ereg("[^0-9]", $_POST['plz'])){
?>
<tr><td><font color="red">*PLZ:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="plz" value="<? echo $_POST['plz']; ?>" class="form1">&nbsp;5-stellige PLZ<br>
<?
echo "<font color=\"red\"><b>Bitte geben Sie eine gültige 5-stellige Postleitzahl ein!</b></font>";
?>
</td></tr>
<?
}else{
?>
<tr><td>*PLZ:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="40" name="plz" value="<? echo $_POST['plz']; ?>" class="form1">&nbsp;5-stellige PLZ</td></tr>
<?
}
}
if($_POST['senden_x'] && empty($_POST['tel']))
{
?>
<tr><td><font color="red">*Telefon:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="tel" class="form1">&nbsp;Bsp.: 01234 / 56789</td></tr>
<?
}else{
?>
<tr><td>*Telefon:</td><td class="border3">&nbsp;&nbsp;<input value="<? echo $_POST['tel']; ?>" type="text" size="40" name="tel" class="form1">&nbsp;Bsp.: 01234 / 56789</td></tr>
<?
}
?>
<tr><td>Telefax:</td><td class="border3">&nbsp;&nbsp;<input value="<? echo $_POST['fax']; ?>" type="text" size="40" name="fax" class="form1">&nbsp;Bsp.: 01234 / 56789</td></tr>
<?
if($_POST['senden_x'] && empty($_POST['mail']))
{
?>
<tr><td><font color="red">*E-Mail Adresse:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="mail" class="form1"></td></tr>
<?
}else{
if (!empty($_POST['mail']) && !ereg("^([a-zA-Z0-9\.\_\-]+)@([a-zA-Z0-9\.\-]+\.[A-Za-z][A-Za-z]+)$", $_POST['mail'])){
?>
<tr><td><font color="red">*E-Mail Adresse:</font></td><td class="border_error">&nbsp;&nbsp;<input type="text" size="40" name="mail" value="<? echo $_POST['mail']; ?>" class="form1"><br>
<?
echo "<font color=\"red\"><b>Bitte geben Sie eine gültige E-Mail Adresse ein!</b></font>";
?>
</td></tr>
<?
}else{
?>
<tr><td>*E-Mail Adresse:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="40" name="mail" value="<? echo $_POST['mail']; ?>" class="form1"></td></tr>
<?
}
}
if($_POST['senden_x'] && empty($_POST['pw']))
{
?>
<tr><td><font color="red">*Passwort:</font></td><td class="border_error">&nbsp;&nbsp;<input type="password" size="40" name="pw" class="form1"></td></tr>
<?
}else{
if (($_POST['pw'])!=$_POST['pw1']){
?>
<tr><td><font color="red">*Passwort:</font></td><td class="border_error">&nbsp;&nbsp;<input type="password" size="40" name="pw" value="<? echo $_POST['pw']; ?>" class="form1"><br>
<?
echo "<font color=\"red\"><b>Passwörter stimmen nicht überein!</b></font>";
?>
</td></tr>
<?
}else{
?>
<tr><td>*Passwort:</td><td class="border3">&nbsp;&nbsp;<input type="password" size="40" name="pw" value="<? echo $_POST['pw']; ?>" class="form1"></td></tr>
<?
}
}
if($_POST['senden_x'] && empty($_POST['pw1']))
{
?>
<tr><td><font color="red">*Passwort widerholen:</font></td><td class="border_error">&nbsp;&nbsp;<input type="password" size="40" name="pw1" class="form1"></td></tr>
<?
}else{
if (($_POST['pw1'])!=$_POST['pw']){
?>
<tr><td><font color="red">*Passwort widerholen:</font></td><td class="border_error">&nbsp;&nbsp;<input type="password" size="40" name="pw1" value="<? echo $_POST['pw1']; ?>" class="form1"><br>
<?
echo "<font color=\"red\"><b>Passwörter stimmen nicht überein!</b></font>";
?>
</td></tr>
<?
}else{
?>
<tr><td>*Passwort widerholen:</td><td class="border3">&nbsp;&nbsp;<input type="password" size="40" name="pw1" value="<? echo $_POST['pw1']; ?>" class="form1"></td></tr>
<?
}
}
?>
<tr><td class="border3" colspan="2"><b>Angaben zum Jobangebot</b></td></tr>
<tr><td width="30%">Berufsbezeichnung:</td><td class="border3">
&nbsp;&nbsp;<input type="text" size="40" class="form1" name="jobname">
</td></td></tr>
<tr><td>Position:</td><td class="border3">
&nbsp;&nbsp;<input type="text" size="40" class="form1" name="jobpos">
</td></td></tr>
<tr><td>Beschäftigungsart:</td><td class="border3">&nbsp;
<select class="form1" name="jobart">
<option>unbefristet</option>
<option>befristet</option>
<option>Nebenjob</option>
<option>Praktikum</option>
<option>Studentenjob</option>
<option>400 Euro</option>
</select>&nbsp;<input type="text" size="24" class="form1" name="jobart_1">&nbsp;Bsp.: 6 Monate Probezeit</td></td></tr>
<tr><td>Arbeitszeit:</td><td class="border3">&nbsp;
<select class="form1" name="jobzeit">
<option>Vollzeit</option>
<option>Teilzeit</option>
<option>Zeitarbeit</option>
</select>&nbsp;<input type="text" size="24" class="form1" name="jobzeit_1">&nbsp;Bsp.: 40h / Woche</td></td></tr>
<tr><td>Berufsbranche:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="40" class="form1" name="branche"></td></tr>
<tr><td>Sprachkenntnis:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="40" class="form1" name="sprache"></td></tr>
<tr><td>Alter:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="40" class="form1" name="alter"></td></tr>
<tr><td>zu besetzen ab:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="40" class="form1" name="jobab"></td></tr>
<tr><td>Stellenanzahl:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="3" class="form1" name="anzahl" value="0"></td></tr>
<tr><td>Einsatzort:</td><td class="border3">&nbsp;&nbsp;<input type="text" size="40" class="form1" name="einsatz"></td></tr>
<tr><td width="30%">Lohn/Gehalt:</td><td class="border3">
&nbsp;&nbsp;<input type="text" size="40" class="form1" name="joblohn">
</td></td></tr>
<tr><td>Führerschein:</td><td class="border3">&nbsp;
<select class="form1" name="jobauto">
<option>nicht erforderlich</option>
<optgroup label="Motorräder">
<option>Klasse A</option>
</optgroup>
<optgroup label="PKW">
<option>Klasse B</option>
<option>Klasse BE</option>
</optgroup>
<optgroup label="LKW">
<option>Klasse C</option>
<option>Klasse C1</option>
<option>Klasse C1E</option>
<option>Klasse CE</option>
</optgroup>
<optgroup label="BUS">
<option>Klasse D</option>
<option>Klasse D1</option>
<option>Klasse D1E</option>
<option>Klasse DE</option>
</optgroup>
</select></td></td></tr>
<tr><td>Stellenprofil:</td><td class="border3">
&nbsp;&nbsp;<textarea class="form1" name="text_ag" cols="50" rows="8" ></textarea>
<p></p>Beschreiben Sie Ihr Stellenangebot</td></tr>
<tr><td>Bewerberprofil:</td><td class="border3">
&nbsp;&nbsp;<textarea class="form1" name="text_an" cols="50" rows="8" ></textarea>
<p></p>Beschreiben Sie die Eigenschaften Ihres Bewerbers</td></tr>
<tr><td colspan="2">Mit dem Absenden akzeptiere ich die <a href="javascript:void(window.open('agb.php', 'AGB', 'height=480, width=640, resizable=no, scrollbars=yes'));">Allgemeine Geschäftsbedingungen von <? echo $COMPANY ?></a></td></tr>
<tr><td><input type="submit" class="submit" name="senden_x" value="Weiter >>"></input></td><td><small>Alle Felder mit einem Sternchen (*) sind Pflichtfelder!</small></td></tr></table>
</form>
<?
}
?>

[Bassboy]

Bitte mach PHP-Tags drumherum.

[iF_]

Nur mit den Augen drübergeflogen - wie verhält es sich wenn Du aus

PHP-Code:

if (mysql_num_rows($mail_match) > 0)  { 


z.B.

PHP-Code:

if (mysql_num_rows($mail_match) > 10)  { 


machst?