[RESOLVED] sql query result is not getting displayed

[tendral]

Hello,

book_list.php is not displaying the sql query result. When I debugged the sql stmt, it is selecting the correct data but it is not getting displayed. I have highlighted the portion that is supposed to display the query result.

function show_book_list($sql)
{$result=mysql_query($sql) or die(mysql_error());

//*********02/27 validation if no records match selection criteria********

if (mysql_num_rows($result)==0)
   {print '<font style="font-family:arial;">';
	 echo "<H2>No records matches your selection criteria. Please try again!</H2>";

 print 'Looking for suggestions? Browse subjects:
 <hr size="1" color="red" NOSHADE><br>';
 print '</font>';
 disp_subject();
} 

else
{


[COLOR="Red"]print '<table class="book_list" width=100%>

<tr  bgcolor="red" align=center>
					<th>Book Title</th>
					<th>Author</th>
					<th>Price</th>
					<th>Add?</th>
</tr>';

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

print
'<tr> 
<td width="30%"  height="25"> 
<?php echo $row["title"]; ?>
</td> 
<td width="25%" height="25"> 
<?php echo $row["author"]; ?> 
</td> 
<td width="35%" height="25" align="right"> 
$<?php echo $row["price"]; ?> 
</td> 
<td width="20%" height="25"> 
<a href="cart.php?action=add_item&isbn=<?php echo $row["ISBN"]; ?>&qty=1">Add To Cart</a> 
</td> 
</tr> 
<tr> 
<td colspan="4"> 
<hr size="1" NOSHADE> 
</td> 
</tr> ';[/COLOR]}//END OF WHILE LOOP 

print '</table>';

can u please help me? thank you.

[niroshan]

Hi tendral,

Why are you using echo statement inside a print statement? please refer the PHP manual for string concatenation.

This will fix your problem,

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

print
'<tr> 
<td width="30%"  height="25"> '.$row["title"].'
</td> 
<td width="25%" height="25">'.$row["author"].'
</td> 
<td width="35%" height="25" align="right">$.'$row["price"].'
</td> 
<td width="20%" height="25"> 
<a href="cart.php?action=add_item&isbn='.$row["ISBN"].'&qty=1">Add To Cart</a> 
</td> 
</tr> 
<tr> 
<td colspan="4"> 
<hr size="1" NOSHADE> 
</td> 
</tr> ';
}//END OF WHILE LOOP 

Thanks,
regards,
Niroshan

[tendral]

your solution worked! thanks a lot.