Solved

SQL Error

Posted on 2009-07-15
10
181 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
Comment Utility
You have a '.' at the end of your statement, that will cause a parse error
0
 
LVL 14

Expert Comment

by:flob9
Comment Utility
Please, show us the fields of the table voc2_gift.
0
 

Author Comment

by:mimoser
Comment Utility
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
Comment Utility
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
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:mimoser
Comment Utility
[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
Comment Utility
remove the dot before ";" :)
0
 
LVL 4

Expert Comment

by:Xemorph
Comment Utility
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
Comment Utility
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
Comment Utility
nice one :)
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

This article describes some very basic things about SQL Server filegroups.
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

763 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

6 Experts available now in Live!

Get 1:1 Help Now