asked on

SQL Error

I'm trying to add a line to the coding below. The one I am having issues with is commented out, put it is causing a white page to occur. I know it's a simple syntex error that I'm over looking.
The line above, and below work fine, so I copied one of them and simply changed the information it was calling. Please help!!

<?php
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 
mysql_select_db($db) or die ("Unable to select database!"); 
$query = "SELECT * 
FROM `voc2_gift` 
LIMIT 0 , 30 "; 
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 
if (mysql_num_rows($result) > 0) { 
echo "<table bgcolor=#000000 cellpadding=50 width=100 border=1 bordercolorlight=#00FF00 bordercolorlight=#00FF00 bordercolordark=#00FF00>";
 
  $numItems = mysql_numrows($result);
  $itemsPerRow = 4;
  $itemsCounter = 0;
 
  for($i=0;$i<$numItems;$i++) {
    if($itemsCounter==0) { echo "<tr>"; }
    echo "<td><center><img src='".mysql_result($result,$i,"GiftURL")."'>";
echo "<input type=button value='Send' onclick='sendImage(".mysql_result($result,$i,"GiftURL").")'>";
    // echo "<p>".mysql_result($result,$i,"GiftPrice").;
    echo "<p>".mysql_result($result,$i,"GiftName")."</center></td>"; 
 
    if($itemsCounter==3) { echo "</tr>"; }
    $itemsCounter = ($itemsCounter+1)%$itemsPerRow;
  }
 
  echo "</table>"; 
 
} else { 
  echo "No rows found!"; 
} 
?>

Open in new window

ASKER CERTIFIED SOLUTION

Xemorph

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

flob9

Please, show us the fields of the table voc2_gift.

mimoser

ASKER

I left the period in the line, because the line below also has a period at the begining and end, which works.

Those table fields are

GiftID
GiftName
GiftURL
GiftPrice

Xemorph

I would try to check your PHP logs. That will tell you if there was a fatal error that occurred, and what it was.

flob9

Add this before the mysql_connect :

error_reporting(E_ALL);

then, uncomment the line

echo "<p>".mysql_result($result,$i,"GiftPrice");

and tell us what happen.

mimoser

ASKER

[15-Jul-2009 18:59:13] PHP Parse error: syntax error, unexpected ';' in public_html/gift.php on line 118

flob9

remove the dot before ";" :)

Xemorph

If line 118 is line 19 in your posted code, I believe it is the '.' like I said before. If the code changed at all, post what was ran.

Thanks.

mimoser

ASKER

That worked. Thank you, it had me confused because of the . in front of
.mysql_result
so I thought one was needed at the end as well.

flob9

nice one :)