[ckdoublenecks]

PHP Code:

<?php

mysql_connect(localhost,root,"");

mysql_select_db(prerentdb) or die( "Unable to select database");

if(!empty($_POST["submit"]))

{

 $apt = $_POST['apt'];

 $query="SELECT * FROM payments Where apt='$apt'";

 $result=mysql_query($query);

 if(mysql_num_rows($result))

 {

  echo "<form action='#' method='post'><b>

<font size=2><b>Hammock Oaks Apartments</font>&nbsp;&nbsp;&nbsp;Rent Receipt<p>;

        while($row = mysql_fetch_assoc($result))

  {

      echo "$name in apartment $apt has paid $amtpaid on this day $datepaid<br />";

}

        else{echo "No listing for apartment $apt.<br />Please select another.<br />";}

}

?>

<form method="post" action="#">

 <br />

 <input type="text" name="apt"/> <p>

<input type="submit" name="submit" value="receipt apartment"/>

</form>

[Yeroon]

Hey,
It is hard for us to "guess" what the problem is or what doesnt work. So please be more specific. You get any errors?

/Yero

[Yeroon]

Decided to guess anyway. This might work better:

PHP Code:

<?php 

mysql_connect(localhost,root,""); 

mysql_select_db(prerentdb) or die( "Unable to select database"); 

if(!empty($_POST["submit"])) 

{ 

 $apt = $_POST['apt']; 

 $query="SELECT * FROM payments Where apt='$apt'"; 

 $result=mysql_query($query); 

 if(mysql_num_rows($result)) 

 { 

  echo "<form action='#' method='post'><b> 

<font size=2><b>Hammock Oaks Apartments</font>&nbsp;&nbsp;&nbsp;Rent Receipt<p>"; 

        while($row = mysql_fetch_assoc($result)) 

  { 

      echo $name ."in apartment." $apt ."has paid".  $amtpaid ."on this day". $datepaid."<br />"; 

} 

        else{echo "No listing for apartment ".$apt."<br />Please select another.<br />";} 

} 

?> 

<form method="post" action="#"> 

 <br /> 

 <input type="text" name="apt"/> <p> 

<input type="submit" name="submit" value="receipt apartment"/> 

</form>

My php isnt very good. But you missed some closing quotes

[ckdoublenecks]

thanks guys - I solved it with this code

<?php
mysql_connect(localhost,root,"");
mysql_select_db(prerentdb) or die( "Unable to select database");
if(!empty($_POST["submit"]))
{
$apt = $_POST['apt'];
$query="SELECT name, apt, amtpaid, datepaid FROM payments Where apt='$apt'";
$result=mysql_query($query);
if(mysql_num_rows($result))
{
echo "<form action='#' method='post'><font size=4><b>Hammock Oaks Apartments</font>&nbsp;&nbsp;&nbsp;Rent Receipt<br /><br /><i>amount paid is the total paid this month<br /><br /></i>
<table border='0'>
<tr>
<th>.</th>
</tr>";
echo "</table>";
echo "</form>";
while(list($name,$apt,$amtpaid,$datepaid)= mysql_fetch_row($result))
{
echo "$name in apartment $apt has paid $amtpaid on this day $datepaid<br />";
}

}
else{echo "No listing for appartment $apt.<br />Please select another.<br />";}
}
?>
<form method="post" action="#">
<br />
<input type="text" name="apt"/> <p>
<input type="submit" name="submit" value="receipt apartment"/>
</form>