using echo

[PaulaRun]

I know this is stupid but I have spent hours on it! What can I use other than echo to display my search results in an html table within php code?

Any advise would be greatly appreciated!

Here is my code:

$query = 'SELECT * FROM products order by product_no';

$result = mysql_db_query($db,$query,$dbconnect) or die ("Could not execute query: $query. " . mysql_error());

$num=mysql_numrows($result);

mysql_close();

echo '<table border="0" cellpadding="2" style="border-collapse: collapse" width="100%" id="AutoNumber2">';

$i=0;
while ($i < $num) {

$row=mysql_fetch_array ($result);

echo "<tr>";
echo '<td width="33%" height="16"><font size="2">stripslashes($row["product_no"])</font></td>';
echo '<td width="33%" rowspan="4" height="105"><font size="2">';
echo '<img border="0" src="$row(["image_path"])" width="140" height="60"></font></td>';
echo '<td width="34%" rowspan="2" height="21"><font size="2">$row(["price"])</font></td>';
echo "</tr>";
echo "<tr>";
echo '<td width="33%" rowspan="3" height="82"><font size="2">$row(["description"])<br>';
echo "<br>";
echo "</font></td>";
echo "</tr>";
echo "<tr>";
echo '<td width="34%" height="27"><font size="2">$row(["option1"])</font></td>';
echo "</tr>";
echo "<tr>";
echo '<td width="34%" height="43"><font size="2">';
echo '<img border="0" src="images/dist_images2/addtocart.gif" width="85" height="27"></font></td>';
echo "</tr>";

++$i;
}

echo "</table>";
l 😕

[jerdo]

Look at the manual, there's print, printf, flush

[farrix]

Just an idea;

you could try going in and out of php;

<?php

while ($i=0; $i < $num; $i++)
{
?>

<table><tr><td>displaying normal text</td></tr></table>

<?php

} // end of while loop
?>

[PaulaRun]

Thanks for the idea but I was unable to make it work.

What happens when I use echo with more than just a <td> tag, is the stripslashes($row["product_no"]) code shows up rather than the item from the database.

I reworked the script to drop in and out of php and that turned out worse. I can't find any information about displaying a html table information within php.

Thanks again for your help.

Attached is the code I used to drop in and out of php.

$query = 'SELECT * FROM products order by product_no';

$result = mysql_db_query($db,$query,$dbconnect) or die ("Could not execute query: $query. " . mysql_error());

$num=mysql_numrows($result);

mysql_close();

$item=mysql_result($result,$i,"item");
$desc=mysql_result($result,$i,"description");
$option1=mysql_result($result,$i,"option1");
$price=mysql_result($result,$i,"price");

echo "<table border="0" cellpadding="2" style="border-collapse: collapse" width="100%" id="AutoNumber2">";

while ($i=0; $i < $num; $i++) {

  </script>

<tr>
<td width="33%" height="16"><font size="2">$item</font></td>
</tr>
<td width="33%" rowspan="4" height="105"><font size="2">
<img border="0" src="image" width="140" height="60"></font></td>
<td width="34%" rowspan="2" height="21"><font size="2">$price</font></td>
</tr>
<tr>
<td width="33%" rowspan="3" height="82"><font size="2">$desc<br>
<br>
</font></td>
</tr>
<tr>
<td width="34%" height="27"><font size="2">$option1</font></td>
</tr>
<tr>
<td width="34%" height="43"><font size="2">
<img border="0" src="images/dist_images2/addtocart.gif" width="85" height="27"></font></td>

<script language="php">

}

</script>

</table>

[TruckStuff]

Your original script si fine except your quotes are wrong. I have only been doing this for a month, so someone correct me if I am wrong.

PHP interprets strings within single quotes ('...') as literal text, i.e. whatever you put between the single quotes is EXACTLY what will appear in the output.

You need to use double quotes ("...") for PHP to attempt to evaluate any code within the string. For example:

echo '<td width="33%" height="16"><font size="2">stripslashes($row["product_no"])</font></td>';

should be

echo "<td width=\"33%\" height=\"16\"><font size=\"2\">".stripslashes($row["product_no"])."</font></td>";

Note the use of the \ escape character before double quotes in the string. Also note that the call to stripslashes is outside the double quotes.

It may be possible to put the function call into the double quotes, but I have not succeeded in doing so yet. But like I said, I've only been doing this for a month. 🙂

[PaulaRun]

Tha worked - thank you so much!!

I put the single quotes around it because I was getting a parse error due to the double quotes in the code. I didn't know about the escape character.

Thank you again!

[PaulaRun]

Yikes, how can I do this line since the function is embedded? Nothing seems to work with the escape character. I'm sure the answer is simple but I'm pulling my hair out!

echo "<img border=\"0\" src=".stripslashes($row["image_path"])." width=\"140\" height=\"60\"></font></td>";