Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Error

Posted on 2009-07-15
10
Medium Priority
?
190 Views
Last Modified: 2012-05-07
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
Comment
Question by:mimoser
  • 4
  • 3
  • 3
10 Comments
 
LVL 4

Accepted Solution

by:
Xemorph earned 2000 total points
ID: 24865192
You have a '.' at the end of your statement, that will cause a parse error
0
 
LVL 14

Expert Comment

by:flob9
ID: 24865207
Please, show us the fields of the table voc2_gift.
0
 

Author Comment

by:mimoser
ID: 24865216
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 4

Expert Comment

by:Xemorph
ID: 24865254
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
 
LVL 14

Expert Comment

by:flob9
ID: 24865275
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
 

Author Comment

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

0
 
LVL 14

Expert Comment

by:flob9
ID: 24865379
remove the dot before ";" :)
0
 
LVL 4

Expert Comment

by:Xemorph
ID: 24865382
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
 

Author Closing Comment

by:mimoser
ID: 31604046
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
 
LVL 14

Expert Comment

by:flob9
ID: 24865510
nice one :)
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question