Displaying MySQL rows in an ECHO

darylr

Hello all,

Ive a big problem that I just cannot solve!

I am trying to create a code that will display all records in a database table if there are any. If there are none, I want it to display "No Events"... This is the code I have;

<? if ("$row_events['id'];" != "") {
		  echo ("<td width=\"20%\"><?php echo $row_events['date']; ?></td>
          <td width=\"80%\"><a href=\"viewevent.php?id=<?php echo $row_events['id']; ?>\"><?php echo $row_events['title']; ?></a></td>"); } 
		  else echo("<th colspan=\"2\" scope=\"col\">No Events</th>");?>

The error I get is;

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

Please help :bemused:

Thanks in advance,

Daryl R

subwayman

I think there is quite a lot wrong with this.

if ("$row_events['id'];" != "") {

This will always equate to true. try

if ($row_events['id'] != "") {

echo ("<td width=\"20%\"><?php echo $row_events['date']; ?></td>

You are already in script so the <php .. ?> are not needed, try:

echo "<td width=\"20%\">".$row_events['date']."</td>

You have a similar problem later with your link.

Some people prefer to echo all html like you. I prefer the other way, which is to come out of script and only echo for dynamic bits. It helps with all the quotes and escaping.

try

<? if ($row_events['id'] != "") { ?>

      <td width="20%">
         <?php echo $row_events['date']; ?>
      </td> 
      <td width="80%">
           <a href="viewevent.php?id=<?php echo $row_events['id']; ?>">
                <?php echo $row_events['title']; ?>
           </a>
      </td>

<?php } else { ?>

    <th colspan="2" scope="col">No Events</th>

<?php } ?>

Note the use of {} in a if statement even if there is only one statement. This helps make sure you balance up all your brackets.

darylr

Hi subwayman,

That seemed to do the trick! Its working now.

Thanks ever so much! Really appreciate it!

Daryl