Solved

SQL Error

Posted on 2009-07-15
10
182 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 500 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
 
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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

919 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now