[RESOLVED] Printing array into a html table

lilRachie

I'm trying to build a virtual "tv" guide of sorts

Channel Tune In Description Category
ch# url show descrip type of show

The information is in a db table named objects, but I'm getting this error
Parse error: syntax error, unexpected T_STRING in /home/christin/public_html/xxxbiztv/channels/guinc.php on line 28
Channel Tune In Description Category

<?
//connect db
include ('connect.php');

//set variables
function show_data(){
$ch= array();
$url= array();
$name= array();
$desc= array();
$cat= array();
   $id = mysql_real_escape_string($_GET['id']);
   $i=0;
   if(isset($id)) {

//get table info
$query = "SELECT * FROM objects";
      if($result = mysql_query($query)) {
        $i = 0;
         while ($row = mysql_fetch_array ($result)) {
            $ch[$i] = $row["ch"];
            $url[$i] = $row["url"];
            $name[$i] = $row["name"];
            $desc[$i] = $row["desc"];
            $cat[$i] = $row["cat"];
//print table info

print "<tr><td class="border2" align=center>" . $ch[$i] . "</td><td class="border2" align=center><a href=" . $url[$i] . "target=tv>". $name[$i] ."</a></td><td class="border2" align=center>" . $desc[$i] . "</td><td class="border2" align=center>" . $cat[$i] . "</td></tr>";
              ++$i;// <---this is line 28
         }
      }
   }
}
?>

The table tags are in the guide.php file and no errors

<?
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><link href="../player.css" rel="stylesheet" type="text/css"></head>
<body marginheight="0" marginwidth="0" topmargin="0" leftmargin="0" leftmargin="0" rightmargin="0">
<table border =0 CELLPADDING=0 CELLSPACING=0 align=center bgcolor="#8FA33F" width="500"><tr><td class="border2" align=center width="25%"> Channel </td><td class="border2" align=center width="25%"> Tune In </td><td class="border2" align=center width="25%"> Description </td><td class="border2" align=center width="25%"> Category </td></tr>
<? 
include ('guinc.php'); 
?>
</table>
</body></html>

Any help appreciated as I'm on a deadline for work.

Rachael

Jack_McSlay

if you're concatenatings strings and variables instead of putting variables inside strings, use single quotes, so you don't have to escape the double quotes inside the strings

example:

print '<tr><td class="border2" align=center>' . $ch[$i] . '</td><td class="border2" align=center>';

lilRachie

Ok that got rid of the error but the db info isn't printing out just the

Channel Tune In Description Category row

lilRachie

<?
//connect db
include ('connect.php');

//set variables
function show_data(){
$ch= array();
$url= array();
$name= array();
$desc= array();
$cat= array();
   $id = mysql_real_escape_string($_GET['id']);
   $i=0;
   if(isset($id)) {

//get table info
$query = "SELECT * FROM objects";
      if($result = mysql_query($query)) {
        $i = 0;
         while ($row = mysql_fetch_array ($result)) {
            $ch[$i] = $row["ch"];
            $url[$i] = $row["url"];
            $name[$i] = $row["name"];
            $desc[$i] = $row["desc"];
            $cat[$i] = $row["cat"];
//print table info

print '<tr><td class="border2" align=center>' . $ch[$i] . '</td><td class="border2" align=center><a href=' . $url[$i] . 'target=tv>'. $name[$i] .'</a></td><td class="border2" align=center>' . $desc[$i] . '</td><td class="border2" align=center>' . $cat[$i] . '</td></tr>';
              ++$i;
         }
      }
   }
}
?>

That's what I have but nothing is showing up in the table. No blanks no data no empty rows.😕

aduljr

<?php
//connect db
include ('connect.php');

//get table info
$query = "SELECT * FROM objects";

if($result = mysql_query($query)) {

while ($row = mysql_fetch_array ($result)) {

	//print table info
	print "<tr><td class=\"border2\" align=center>" . $row["ch"] . "</td><td class=\"border2\" align=center><a href=" . $row["url"] . "target=tv>". $row["name"] .
		  "</a></td><td class=\"border2\" align=center>" . $row["desc"] . "</td><td class=\"border2\" align=center>" . $row["cat"] . "</td></tr>";


}// end while

}// end if


?>

unless you need to reuse this script in more than one area, I rewrote it for you. This will just spit out what ever is returned from the query.

aduljr

we could take it one step further

<?php
//connect db
include ('connect.php');

//get table info
$query = "SELECT * FROM objects";

if($result = mysql_query($query)) {

while ($row = mysql_fetch_array ($result)) {

    //print table info
    print "<tr><td class=\"border2\" align=center>$row[ch]</td><td class=\"border2\" align=center><a href=\"$row[url]\"target=tv>$row[name] 
          </a></td><td class=\"border2\" align=center>$row[desc]</td><td class=\"border2\" align=center>$row[cat]</td></tr>";


}// end while

}// end if


?>

lilRachie

You are so "My Guru"! Thanks!