unidentified problem

akuenigma_143

<HTML>
<HEAD>
<TITLE> PRODUCT INFORMATION </TITLE>

</HEAD>
<BODY>
<?php

//proplem here ----> $org =$_GET['product_id'];
?>
<TD ALIGN=LEFT VALIGN=TOP WIDHT=83%>
<TABLE BORDER=1 CELLPADDING=5 WIDHT=100%><TR><TD ALIGN=LEFT VALIGN=MIDDLE>
<H2> TESTING <?php print ("$org"); //passed from URL
?></H2><BR></TD></TR>

<TR><TD WIDTH=50% ALIGN=LEFT>
<?php
$dbh = mysql_connect('localhost') or die("Unable to open database");
mysql_select_db("digitalcash") or die("Unable to access database");
$query = "SELECT product_id, category_id, price FROM product";
$qresult = mysql_query($query) or die(mysql_error());
    $blurb = mysql_fetch_array($qresult) or die(mysql_error());
print('$blurb[0]');
?>
</TD></TR>
<TR><TD ALIGN=LEFT>
	<TABLE BORDER=1 CELLPADDING=3>
	<?php
	$query2 = "SELECT product_id, ,description, title, author_first, author_last FROM product WHERE btitle='$org' ORDER BY author_last";
	$qresult2 = mysql_query($query2) or die(mysql_error());
	while ($titlelist = mysql_fetch_array($qresult2)) {
		$bookID = $titlelist[0];
		$title = $titlelist[1];
		$authorfirst = $titlelist[2];
		$authorlast = $titlelist[3];
		print("<TR><TD><A HREF=\"book.php?bn=$bookID\" class=\"roll\">$title</A></TD><TD>$authorfirst $authorlast</TD>");
	}
	?>
 	</TR></TABLE>
</TD></TR></TABLE>

</TD></TR></TABLE>
</BODY></HTML>
<TR><TD ALIGN

devinemke

unidentified symptom(s) too

cheese

What makes you say that

//proplem here ----> $org =$_GET['product_id'];

is the problem.

Have you tried


echo $_GET['product_id'] // to check the value of the passed variable
echo $org // to check the org variable

You may need $POST or $GET depending oh how the variable was sent across

Also, passing on something that was passed to me instead of

Instead of


while ($titlelist = mysql_fetch_array($qresult2)) { 
$bookID = $titlelist[0]; 
$title = $titlelist[1]; 
$authorfirst = $titlelist[2]; 
$authorlast = $titlelist[3]; 
print("<TR><TD><A HREF=\"book.php?bn=$bookID\" class=\"roll\">$title</A></TD><TD>$authorfirst $authorlast</TD>"); 
}

Try

while ($titlelist = mysql_fetch_array($qresult2)) 
{ 
print "<tr><td><a href='book.php?bn=" . $titlelist[0] . "'  class='roll'>" . $titlelist[1] . "</a></td><td>" . $titlelist[2]. "&nbsp" . $titlelist[3] . "</td></tr>"; 
}

Should work exactly the same, but far less code (thanks to whoever it was that told me to do it that way!!)

Also, try giving us a clue as to what is wrong and a bit of interaction with other users makes for a much better place for us all to post to. (Also helps people looking for solutions via a search later on)

Cheers,

Neil.