Submit twice different variables to get a select

[spighita]

Hello:
I have an INPUT type where the user inputs dates. Once he the variable is read then he gets the "select from the database" But my problem is that the user must put two different dates before he gets the select from the database.

Does anyone know what is happening or what I`m doing wrong.

Thanks in advance for anyone who helps.

[sijis]

i find the description of your problem quite vague.

you can create another input field.
you can also concatinate the values of both input fields.

if you post some code I might be able to help you better and know exactly what you are trying to accomplish.

[jimson]

perhaps you got to explain your problem a byte further so that we can understand and then assist you... 🙂 cheers.

[thessoro]

Jimson, that's the way you $NumPosts++; ??? LoL

[jimson]

the phpbuilder stuck when i was posting the first.. then i press Ctrl R... then untill it can runs... ok, i deleted them...

[spighita]

I have this input type where if i enter a date as 06-06 i dont get it at first, after that if i enter 06-06 again I wont won`t get a "select from the databse" but if I enter 06-06 and then enter 07-06 i will get a select. And after that happens everything goes OK. I can enter any date I want and it´ll work OK. But it's just the beginning where I get the problems. I have to enter two different dates before I get a list. If I enter the same date twice, and insist I won't the select.

The only way I do get it is when I enter two different dates.

I hope i was clear with my problem. I have included the code so you can see.

<?php
if (isset($ed_buscar_fecha)) {
	$buscar_fecha = $ed_buscar_fecha;

}


?>
<FORM name="invitados"  method="POST" action="verlista.php">
<TABLE>
<TR>
<TD>FECHA <INPUT TYPE="TEXT" name="ed_buscar_fecha"  value="
<?PHP if (isset($ed_buscar_fecha)) {
	echo $buscar_fecha; 
	}
		?> " > </TD>
<TD> <INPUT TYPE="SUBMIT" VALUE="Buscar" NAME="Buscar"> </TD>
<TR>
</TABLE>
</FORM>
<TABLE BORDER="1">
	<TR> <TD CENTER COLSPAN="5"> <div align='center'><H2>
	<?PHP echo 'LA LISTA DE LOS INVITADOS '  ;
	?>
	</TD>
	</TR>
	<TR>
	<TD><DIV ALIGN="CENTER"><H4>Identificaci&oacute;n Socio</TD>
	<TD><DIV ALIGN="CENTER"><H4>Nombre Invitado</TD>
	<TD><DIV ALIGN="CENTER"><H4>Apellido Invitado</TD>
	<TD><DIV ALIGN="CENTER"><H4>Rut Invitado</TD>
	<TD><DIV ALIGN="CENTER"><H4>Email Invitado</TD>
	</TR>

<?PHP
 $error = "";
	  $con = mysql_connect("localhost", "", "");
	  if (!isset($con)) {
		 $error = "Error Interno: No se puede conectar a base de datos";
		 } else {
			if (!mysql_select_db("socios", $con)) {
						mysql_close($con);
						$error = "Error Interno: No se puede cambiar a B.D.";
		}
	 }

if(isset($buscar_fecha)){
	$sql="SELECT * FROM invitado where fecha='$buscar_fecha' order by rut_invitado";
	if ($resultado = mysql_query($sql, $con)){
		while ($row = mysql_fetch_array($resultado)){
			$fecha=$row["fecha"];
			echo '<TR>';
			echo '<TD> <DIV ALIGN="CENTER">' . $row["idsocioinvitado"]. '</TD>';
			echo '<TD><DIV ALIGN="CENTER">' . $row["nombre_invitado"]. '</TD>';
			echo '<TD><DIV ALIGN="CENTER">' . $row["apellido_invitado"]. '</TD>';
			echo '<TD><DIV ALIGN="CENTER">' . $row["rut_invitado"] .'</TD>';
			echo '<TD><DIV ALIGN="CENTER">' . $row["email_invitado"]. '</TD>';
			echo '</TR>';

	}
}
}

?>

[thessoro]

uhmm you could try echoing your variable:
<?php
if (isset($ed_buscar_fecha)) {

$buscar_fecha = $ed_buscar_fecha;
echo $buscar_fecha;

}

in order to see what you are really sending. Also, to avoid confussion, you shoul keep the value of $ed_buscar_fecha just in this variable, as you are not modifying its content, it's useless and confusing having two variables with the same value.

[spighita]

I made the changes and you are right about the extra lines of coding I have. Thank you for the tip. But the problem is still here. I have to submit it twice with different values before getting a list.

[thessoro]

test your script again echoing:
1) the value of the variable sent.
2) the $query done to the db.

the list you obtain the second time, is for the first value you type in the input or for the second ?
i mean, if you type 06-06 and get nothing, and then you type 07-06 and get a list... echo the $query cause i think that the results you are seeing are the ones of the previous value (06-06)
echo echo echo... that could give you a clue!

hope it helps