estoy haciendo un formulario y quisiera que el campo subject cogiera los datos de una base de datos mysql, llevo un tiempo con esto y no encuentro salida.
os pongo el codigo a ver si me podeis ayudar
Gracias
$error = '';
$name = '';
$email = '';
//$phone = ''; Remove the // tags and this text to active phone number.
$subject = '';
$comments = '';
//$verify = '';
if(isset($_POST['contactus'])) {
$name = $_POST['name'];
$email = $_POST['email'];
//$phone = $_POST['phone']; Remove the // tags and this text to active phone number.
$subject = $_POST['subject'];
$comments = $_POST['comments'];
//$verify = $_POST['verify'];
if(trim($name) == '') {
$error = '<div class="error_message">Por favor, escribe tu nombre.</div>';
} else if(trim($email) == '') {
$error = '<div class="error_message">Por favor, escribe un e-mail válido.</div>';
} else if(!isEmail($email)) {
$error = '<div class="error_message">Por favor, debes escribir un e-mail válido. Inténtalo de nuevo.</div>';
}
if(trim($subject) == '') {
$error = '<div class="error_message">Por favor, escribe el asunto.</div>';
} else if(trim($comments) == '') {
$error = '<div class="error_message">Por favor, escribe tu mensaje.</div>';
//} else if(trim($verify) == '') {
//$error = '<div class="error_message">Attention! Please enter the verification number.</div>';
//} else if(trim($verify) != '4') {
//$error = '<div class="error_message">Attention! The verification number you entered is incorrect.</div>';
}
if($error == '') {
if(get_magic_quotes_gpc()) {
$comments = stripslashes($comments);
}
<form method="post" action="">
<label for=name accesskey=U><span class="required">*</span> Tu nombre</label>
<input name="name" type="text" id="name" size="30" value="<?=$name;?>" />
<br />
<label for=email accesskey=E><span class="required">*</span> E-mail</label>
<input name="email" type="text" id="email" size="30" value="<?=$email;?>" />
<br />
<!-- Remove these comment tags to activate phone number field.
<label for=phone accesskey=P><span class="required">*</span> Phone</label>
<input name="phone" type="text" id="phone" size="30" value="<?=$phone;?>" />
<br />
-->
<label for=subject accesskey=S><span class="required">*</span> Asunto</label>
<input name="subject" type="text" id="subject" size="30" value="<?=$subject;?>" />
<br />
<label for=comments accesskey=C><span class="required">*</span> Tu comentario</label>
<textarea name="comments" cols="40" rows="3" id="comments"><?=$comments;?></textarea>
<!--
<hr />
<p><span class="required">*</span> Are you human?</p>
<label for=verify accesskey=V> 3 + 1 =</label>
<input name="verify" type="text" id="verify" size="4" value="<?=$verify;?>" /><br /><br />
-->
<input name="contactus" type="submit" class="submit" id="contactus" value="Enviar" />
</form>
</fieldset>
