PHP Forum

**ckdoublenecks** · 09-18-2010, 12:31 PM

this is what I get when I execute the below code?

Quote:

Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' in C:\xampp\htdocs\hofiles\receipts2.php on line 23

PHP Code:


			
<?php
$apt=$_POST['apt'];
$name=$_POST['name'];
$amtpaid=$_POST['amtpaid'];
$datepaid=$_POST['datepaid'];
$stat = mysql_connect(localhost,root,"") or die('Unable to connect to database: ' . mysql_error()); 
$stat = mysql_select_db(prerentdb) or die('Unable to select database: ' . mysql_error()); 
if(!empty($_POST["submit"]))
{
 $apt = $_POST['apt'];
 $query="SELECT * FROM payments Where apt='$apt'";
 $result=mysql_query($query);
 if(mysql_num_rows($result))
?>
<html><body>
<font size=2><b>Hammock Oaks Apartments</font>
&nbsp;&nbsp;&nbsp;Rent Receipt<p>
<?php
 {
  echo "<form action='#' method='post'>
        while($row = mysql_fetch_assoc($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.";
 }
?>
<form method="post" action="#">
 <br />
 <input type="text" name="apt"/> <p>
<input type="submit" name="submit" value="receipt apartment"/>
</form>
</b></body></html>

**chrishirst** · 09-18-2010, 01:08 PM

and line 23 would be??

because you have a missing , or ; before it.

**NullPointer** · 09-18-2010, 01:51 PM

As I suggested to you in this thread, if you use an editor with syntax highlighting these problems become much easier to spot.

If you take a look at line 23 and the line before it with syntax highlighting on you'll see the issue.

**ckdoublenecks** · 09-18-2010, 04:05 PM

I've been staring at it and trying different things pertaining to those two lines but I'm just trying to learn PHP and so... what editor with syntax highlighting do you suggest?

**NullPointer** · 09-18-2010, 04:32 PM

Notepad++. You forgot your ending quote and semicolon on this line:

PHP Code:


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

**chrishirst** · 09-18-2010, 04:48 PM

I'll second the vote for Notepad++.

**lynxus** · 09-18-2010, 05:32 PM

+1 for Notepad++ ( or any syntax highlighter. )

People wont look down on you for using syntax highlighting. Its there for a reason.