0

here is my sql data from my search.php page

mysql_connect("localhost", "username", "password") or die( mysql_error() );
mysql_select_db("dbname") or die( mysql_error() );
mysql_query("SET NAMES utf8");

$find = strtoupper($find); 
$find = strip_tags($find); 
$find = trim ($find); 
mysql_query("SET NAMES utf8");

$data = mysql_query("SELECT * from database WHERE upper($field) LIKE'%$find%' ORDER BY Catalog ASC"); 

while($result = mysql_fetch_assoc($data)) 
{   
$Catalog = $result['Catalog'];
echo "<center>";
echo "<table cellpadding=5 border=0 width=1000>";
echo "<td width=800 align=center><a href==/image/Set/".$result['Picture'].".jpg target=_blank><img src=/image/set/".$result['Picture'].".jpg></a></td></tr></table>";
echo "<table cellpadding=5 border=0 width=1000>";
echo "<tr><td width=50 align=middle bgcolor=#FFF380><a href=Detail.php?Catalog=".$Catalog.">".$Catalog."</a><br></td>"; 
echo "<td width=60 align=center bgcolor=#ADD8E6><font color=blue>English / Japan</font></td>"; 
echo "<td width=400>".$result['Title']."/".$result['japan_title']."</td>"; 
echo "<td width=60 align=center>".$result['Number of Products']."</td>"; 
echo "<td width=60 align=center>".$result['Date']." <hr> ".$result['Japan_date']."</td>"; 
echo "<td width=80 align=right><font color=red><b>".$result['Total Value']."</b></font><br></td></tr></table>"; 

Here is my detail.php page which I found on this site.

<?php
mysql_connect("localhost", "username", "password") or die( mysql_error() );
mysql_select_db("dbname") or die( mysql_error() );
mysql_query("SET NAMES utf8");

$sql =sprintf('SELECT * FROM database WHERE Catalog=%d', intval($_GET['Catalog']);
$result = mysql_query( $sql ) or die( "Error executing:$sql".mysql_error() ) ;
if( mysql_num_rows($result) )
{
echo '<div>No records found</div>';
}
else
{
$row=mysql_fetch_assoc($result);
echo '<table><thead>';
echo '<tr><th>' . implode('</th><th>', array_keys($row)) . '</th></tr></thead><tbody>';
do{
echo '<tr><td>' . implode('</th><th>', $row) . '</td></tr>';
}while($row=mysql_fetch_assoc($result));
echo '</tbody></table>';
}
?>

Here is the example of my search result

381 English Japan New Year - Doll 4 01-12-1988 01-12-2531 60

I tried to add a link (detail.php) to the catalog no. and in this case is 381

The webpage redirect to /Detail.php?Catalog=381

However, when I clicked on it, it said " Parse error: syntax error, unexpected " with the code on this line

$sql =sprintf('SELECT * FROM database WHERE Catalog=%d', intval($_GET['Catalog']);

I guess something is wrong somewhere around " Catalog=%d ", but I couldn't figure it out.

I am not really if I should use the codes on detail.php or not. From my understanding, I need to pass the catalog no. from my search page to my detail page which I am unable to do.

I created my database from phpmyadmin. Someone please help me out. I stuck on this thing for over 2 days now and have no clue.

I, also, don't really understand what " %d " is.

Thank you in advance.

2
Contributors
2
Replies
4
Views
5 Years
Discussion Span
Last Post by jeffadrian
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.