Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

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

0
mimoser
Asked:
mimoser
  • 4
  • 3
  • 3
1 Solution
 
XemorphCommented:
You have a '.' at the end of your statement, that will cause a parse error
0
 
flob9Commented:
Please, show us the fields of the table voc2_gift.
0
 
mimoserAuthor Commented:
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
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
XemorphCommented:
I would try to check your PHP logs.  That will tell you if there was a fatal error that occurred, and what it was.
0
 
flob9Commented:
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.
0
 
mimoserAuthor Commented:
[15-Jul-2009 18:59:13] PHP Parse error:  syntax error, unexpected ';' in public_html/gift.php on line 118

0
 
flob9Commented:
remove the dot before ";" :)
0
 
XemorphCommented:
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.
0
 
mimoserAuthor Commented:
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.
0
 
flob9Commented:
nice one :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 4
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now