Ad:

PHP Discussion Thread
Unsolved
Views: 12169

Mar 9th, 2004

Need help with HTMl Table echoing?

Expand Post »

Hi,

I need som assistance placeing an HTML table within a PHP script. I thought I could just echo it, but I am getting a parse error. Here is the PHP code: (the parse error comes on line 339

<?php
/* declare some relevant variables */
$DBhost = "localhost";
$DBuser = "username";
$DBpass = "password";
$DBName = "allin1em_catalog";
$table = "items";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");
$sqlquery = "SELECT * FROM $table WHERE store = 'Luminescents'";
$result = mysql_query($sqlquery);
while($row = mysql_fetch_array($result)) {
echo "<table cellpadding="2" cellspacing="2" border="1"
style="text-align: left; width: 400px;">
<tbody>
<tr>
<td
style="background-color: rgb(51, 51, 255); height: 25px; width: 400px; text-align: center; vertical-align: middle;"><span
style="color: rgb(153, 0, 0);"><span style="font-weight: bold;"><font
size="+1"><span style="font-family: arial;">". $row[title] .
"</span></font></span></span><br>
</td>
</tr>
</tbody>
</table>
<table cellpadding="2" cellspacing="2" border="1"
style="text-align: left; width: 400px;">
<tbody>
<tr>
<td
style="background-color: rgb(153, 153, 153); height: 150px; width: 150px; text-align: center; vertical-align: middle;"><img
src="http://www.allin1emall.com/images/". $row[thumb]. " title=" alt=""
style="width: 150px; height: 150px;"><br>
</td>
<td
style="text-align: center; vertical-align: middle; width: 250px; background-color: rgb(153, 153, 153); height: 150px;"><span
style="color: rgb(153, 0, 0);"><span style="font-weight: bold;"><font
size="+1"><span style="font-family: arial;">". $row[description]. "<br>". $row[retail]. "</span></font></span></span>
</td>
</tr>
</tbody>
</table>".;
}
if(mysql_num_rows($result)<1){
echo "<font face=Arial size=+0><b>No
Results!</b></font><br>";
}
mysql_free_result($result);
?>

Any help will be much appreciated.

Thanks,
Traci

Similar Threads

How to change the color of selected row of an HTML table without using CSS or Javascr in VB.NET
how to get the row id of the clicked row in a HTML table using c# in C#
get HTML table property on page load event in ASP.NET
cfgrid inside an HTML table... possible? in ColdFusion
Navigation (Paging) in HTML table in VB.NET. in VB.NET

sistrlynn

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Mar 2004

Permalink

Mar 9th, 2004

Re: Need help with HTMl Table echoing?

Oopps, since this isn't the full page with the entire code you have no idea which is line 339. It is either the while line of the echo line right after it. Hope that helps.

sistrlynn

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Mar 2004

Permalink

Mar 10th, 2004

Re: Need help with HTMl Table echoing?

[php]
echo "<table cellpadding="2" cellspacing="2" border="1" style="text-align: left; width: 400px;">
[/php]

The problem is that you're using double quotes inside double quotes (and you also forgot to end the statement properly). PHP thinks you've finished echoing, when you obviously haven't. Just change the outer pair to single quotes, like so:

[php]
echo '<table cellpadding="2" cellspacing="2" border="1" style="text-align: left; width: 400px;">
[/php]

and obviously the closing ".; to '; (why was that . there in the first place??)

Another solution is slightly simpler - get rid of the echo altogether, and close the php with ?> just before your table code, and <?php again afterwards.

Infact, I recommend you only use double quotes when neccessarily, as they add to execution time - the difference is as follows:

[php]
$var = 'cool';
echo "The var is: $var"; // It returns: The Var is: cool
echo 'The var is: $var'; // It returns: The Var is: $var
[/php]

So, with double quotes, the parser checks for any variables inside, which very slightly slows things down.

Roberdin

Team Colleague

Reputation Points: 63

Solved Threads: 6

Supreme Evil Overlord

Offline

282 posts
since Feb 2003

Permalink

Mar 11th, 2004

Re: Need help with HTMl Table echoing?

You can also do this:

[PHP] echo "<table cellpadding=\"2\" cellspacing=\"2\" border=\"1\"
style=\"text-align: left; width: 400px;\">";[/PHP]

Just sick a \ infrong of a PHP character you don't want to do anything so like $, ", ' etc change to \$, \", \' etc and the PHP engine will just treat them like any normal character while removing the \

Ragnarok

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

94 posts
since Mar 2004

Permalink

Mar 13th, 2004

Re: Need help with HTMl Table echoing?

For large blocks of HTML, I just close the php block and use regular HTML. If I have to do output of a PHP variable, I just use <?=$variable?>.

samaru

Team Colleague

Reputation Points: 262

Solved Threads: 18

a.k.a inscissor