A little Help..i Just started PHP

benvalmont

Hey Guys

I just need some Help with a PHP script, some guys wrote it some times ago and i'm trying to understand it, for me to add 5 Thumbnail to Display,

The Script currently Display only 1 thumbnail with the Paging as well to count the thumbnails displayed,

i Just want to add 5 more thumbnails to display, as i'm new to PHP this is a bit of a confusing for me..I hope u guys understand, and if anyone wants to help me out i will appreciate it.

Here is the Code :

<?php
if (trim($GET["aid"])!=""){
$scwwlppid = trim($GET["aid"]);
$scwqrytxt = "SELECT * FROM ".trim(mysql_result($product_qry, 0, "table_name"))." s WHERE s.id=".trim($_GET["aid"])." and (date(\"".date("Y")."-".date("m")."-".date("d")."\") between date(s.web_start) AND date(s.web_end) or s.show_always=\"Y\")";
$tprdctresult = mysql_query ($scwqrytxt);

if (!$tprdctresult) die('Invalid query: ' . mysql_error());
$num_rows = mysql_num_rows($tprdctresult);
if ($num_rows>0) {
echo '<table width="550" border="0" cellspacing="2" cellpadding="0"><tr><td align="center">';
echo ''.str_replace("\","",QuoteSmart(mysql_result($tprdctresult, 0, 'name'))).' ';
echo '<img src="'.$scwsiteurl.'/media/products/'.trim(mysql_result($product_qry, 0, "folder_name")).'/'.mysql_result($tprdctresult, 0, "id").'/'.str_replace("\","/",trim(mysql_result($tprdctresult, 0, "thumbnail"))).'" border="0" />';
$scwwlppbrowse = mysql_query ("SELECT s.id FROM ".trim(mysql_result($product_qry, 0, "table_name"))." s where (date(\"".date("Y")."-".date("m")."-".date("d")."\") between date(s.web_start) AND date(s.web_end) or s.show_always=\"Y\")");

$scwwlppnum = mysql_num_rows($scwwlppbrowse);
if ($scwwlppnum>0){
for ($scws=0;$scws<$scwwlppnum;$scws++)
$scwwlpparray[$scws] = mysql_result($scwwlppbrowse, $scws);
$scwwlpppos = 0;
for ($scws=0;$scws<$scwwlppnum;$scws++)
if ($scwwlpparray[$scws]==$scwwlppid) $scwwlpppos = $scws;
echo " <div align=\"center\" class=\"btxtsm\">";
if ($scwwlpppos!=0) echo '<a href="?rc=1&aid='.$scwwlpparray[$scwwlpppos-1].'">&lsaquo; previous</a>   ';
//echo '<a href="view_videos.php">gallery</a>';
if ($scwwlpppos<($scwwlppnum-1)) echo '    <a href="?rc=1&aid='.$scwwlpparray[$scwwlpppos+1].'">next &rsaquo;</a>';
echo "</div>";}
echo '</td><td width="10"></td><td valign="top">';
if (trim(mysql_result($tprdctresult, 0, "description"))!="") echo " ".str_replace("\","",QuoteSmart(trim(mysql_result($tprdctresult, 0, "description")))).' ';
if (trim($trow["instructional_text"])!="") echo trim(str_replace("\","",QuoteSmart($trow["instructional_text"]))).' ';
if (trim(mysql_result($tprdctresult, 0, "video_v1"))!="") {
echo '<a href="#" ';
echo 'onclick="IsPopupBlocker(\'../products/'.mysql_result($product_qry, 0, "name").'low.php?aid='.mysql_result($tprdctresult, 0, 'id').'\',\''.mysql_result($product_qry, 0, "name").'low_'.mysql_result($tprdctresult, 0, 'id').'\',\'width=240,height=164,toolbar=no,';
echo 'location=no,directories=no,status=no,menubar=no,scrollbars=no,copyhistory=no,resizable=no\')">';
echo 'Low Bandwidth</a> - ('.str_replace("\","/",trim(mysql_result($tprdctresult, 0, "video_v1_size"))).') '; }
if (trim(mysql_result($tprdctresult, 0, "video_v1"))!="") {

echo '<a href="#" ';
echo 'onclick="IsPopupBlocker(\'../products/'.mysql_result($product_qry, 0, "name").'med.php?aid='.mysql_result($tprdctresult, 0, 'id').'\',\''.mysql_result($product_qry, 0, "name").'med_'.mysql_result($tprdctresult, 0, 'id').'\',\'width=352,height=236,toolbar=no,';
echo 'location=no,directories=no,status=no,menubar=no,scrollbars=no,copyhistory=no,resizable=no\')">';
echo 'Medium Bandwidth</a> - ('.str_replace("\","/",trim(mysql_result($tprdctresult, 0, "video_v2_size"))).') '; }
if (trim(mysql_result($tprdctresult, 0, "video_v1"))!="") {

echo '<a href="#" ';
echo 'onclick="IsPopupBlocker(\'../products/'.mysql_result($product_qry, 0, "name").'high.php?aid='.mysql_result($tprdctresult, 0, 'id').'\',\''.mysql_result($product_qry, 0, "name").'high'.mysql_result($tprdctresult, 0, 'id').'\',\'width=352,height=236,toolbar=no,';
echo 'location=no,directories=no,status=no,menubar=no,scrollbars=no,copyhistory=no,resizable=no\')">';
echo 'High Bandwidth</a> - ('.str_replace("\","/",trim(mysql_result($tprdctresult, 0, "video_v3_size"))).') '; }
echo '</td></tr></table>';
}
else echo "No result found for ".trim(mysql_result($product_qry, 0, "display_name"))."";
}
else {
switch(trim($GET["ob"])) {
case ("na"):
$scworderby = "order by s.name";
$scwarrloc = "na";
break;

	case ("nd"):
	$scworderby = "order by s.name desc";
	$scwarrloc = "nd";
	break;

	default:
	$scworderby = "";
	$scwarrloc = "";
	break;

}

if (trim($trow["full_text"])!=""){
$content = str_replace("\r\n"," ",QuoteSmart($trow["full_text"]));
$content = str_replace(" ","  ",$content);
$content = str_replace("\","",$content);
print_r($content);

echo '  ';}
$scwqrytxt = "SELECT s.id as hid, s.name as hname, s.thumbnail FROM ".trim(mysql_result($product_qry, 0, "table_name"))." s where (date(\"".date("Y")."-".date("m")."-".date("d")."\") between date(s.web_start) AND date(s.web_end) or s.show_always=\"Y\")";
$scwqrytxt = $scwqrytxt." ".$scworderby;
$tprdctresult = mysql_query ($scwqrytxt);

if (!$tprdctresult) die('Invalid query: ' . mysql_error());
$num_rows = mysql_num_rows($tprdctresult);
if ($num_rows>0) {
$currentpage = $GET["cp"] ;
if (trim($currentpage)==""){$currentpage=1;}
$noofrecs = $num_rows;
if (trim($GET["prfr"])==1) $display_items_no=180;
else $display_items_no = 9;
$noofpgs = ceil($noofrecs / $display_items_no);
if ($noofrecs > 0){
$startrow = (($currentpage -1) $display_items_no);
$news_count = 1;
echo 'Displaying results '.($startrow+1).'-';
if (($startrow+$display_items_no)<$noofrecs) echo ($startrow+$display_items_no);
else echo ($startrow+($noofrecs+$display_items_no-($noofpgs$display_items_no)));
echo ' of ';
echo ''.$num_rows.' results found for '.trim(mysql_result($product_qry, 0, "display_name")).'';

echo $plusisland;
	echo $plustype;
echo '<br /><br />';
echo '<table width="100%" cellspacing="2" cellpadding="2" border="0" class="btxt"><tr>';
$scwrowcolor="#FFFFFF";

$scwt=1;
while ($news_count <= $display_items_no)
{
if ($startrow<$noofrecs){
if ($scwt>3) {
echo '</tr><tr height="20"><td width="33%" height="20"></td><td width="33%" height="20"></td><td width="33%" height="20"></td></tr><tr>';
$scwt=1;}

echo '<a href="?rc=1&aid='.mysql_result($tprdctresult, $startrow, 'hid').'"><img src="'.$scwsiteurl.'/media/products/'.trim(mysql_result($product_qry, 0, "name")).'/'.mysql_result($tprdctresult, 0, "hid").'/'.str_replace("\","/",trim(mysql_result($tprdctresult, $startrow, "thumbnail"))).'" alt="'.str_replace("\","",QuoteSmart(unhtmlspecialchars(mysql_result($tprdctresult, $startrow, 'hname')))).'" title="'.str_replace("\","",QuoteSmart(unhtmlspecialchars(mysql_result($tprdctresult, $startrow, 'hname')))).'" border="0" /></a></td>';

echo '<td width="33%" align="left">';
echo str_replace("\","",QuoteSmart(unhtmlspecialchars(mysql_result($tprdctresult, $startrow, 'hname'))));
echo " ";

$startrow++;
$scwt++;
}
$news_count++;
}
}
echo '</tr></table>';
echo " Page(s):";
if ($currentpage > 1){echo " <a href='?isl=".$GET["isl"]."&cp=1&pr=".$GET["pr"]."&bct=".$GET["bct"]."&ob=".$scwarrloc."'>«</a> <a href='?isl=".$GET["isl"]."&cp=".($currentpage-1)."&pr=".$GET["pr"]."&bct=".$GET["bct"]."&ob=".$scwarrloc."'>&lsaquo;</a>";}
$cpg = 1;
while ($cpg <= $noofpgs) {
if ($cpg == $currentpage)
{ echo " ".$cpg.""; }
else { echo " <a href='?isl=".$GET["isl"]."&cp=".$cpg."&pr=".$GET["pr"]."&bct=".$GET["bct"]."&ob=".$scwarrloc."'>".$cpg."</a>"; }
$cpg++;
}
if ($currentpage < $noofpgs){echo " <a href='?isl=".$GET["isl"]."&cp=".($currentpage+1)."&pr=".$GET["pr"]."&bct=".$GET["bct"]."&ob=".$scwarrloc."'>&rsaquo;</a> <a href='?isl=".$GET["isl"]."&cp=".$noofpgs."&pr=".$GET["pr"]."&bct=".$_GET["bct"]."&ob=".$scwarrloc."'>»</a>";}
} else echo "No result found for ".trim(mysql_result($product_qry, 0, "display_name"))."";
}
?>

Kudose

Please put your code between the [noparse]

[/noparse] tags

Warmaster

I know it is hard to comprehend, but all the code was there:

<?php 
if (trim($_GET["aid"])!=""){
$scwwlppid = trim($_GET["aid"]);
$scwqrytxt = "SELECT * FROM ".trim(mysql_result($product_qry, 0, "table_name"))." s WHERE s.id=".trim($_GET["aid"])." and (date(\"".date("Y")."-".date("m")."-".date("d")."\") between date(s.web_start) AND date(s.web_end) or s.show_always=\"Y\")";
$tprdctresult = mysql_query ($scwqrytxt);

if (!$tprdctresult) die('Invalid query: ' . mysql_error());
$num_rows = mysql_num_rows($tprdctresult);
if ($num_rows>0) {
echo '<table width="550" border="0" cellspacing="2" cellpadding="0"><tr><td align="center">';
echo '<span class="bsubttlblu">'.str_replace("\\","",QuoteSmart(mysql_result($tprdctresult, 0, 'name'))).'</span><br /><br />';
echo '<img src="'.$scwsiteurl.'/media/products/'.trim(mysql_result($product_qry, 0, "folder_name")).'/'.mysql_result($tprdctresult, 0, "id").'/'.str_replace("\\","/",trim(mysql_result($tprdctresult, 0, "thumbnail"))).'" border="0" />';
$scwwlppbrowse = mysql_query ("SELECT s.id FROM ".trim(mysql_result($product_qry, 0, "table_name"))." s where (date(\"".date("Y")."-".date("m")."-".date("d")."\") between date(s.web_start) AND date(s.web_end) or s.show_always=\"Y\")");

$scwwlppnum = mysql_num_rows($scwwlppbrowse);
if ($scwwlppnum>0){
for ($scws=0;$scws<$scwwlppnum;$scws++)
$scwwlpparray[$scws] = mysql_result($scwwlppbrowse, $scws);
$scwwlpppos = 0;
for ($scws=0;$scws<$scwwlppnum;$scws++)
if ($scwwlpparray[$scws]==$scwwlppid) $scwwlpppos = $scws;
echo "<br /><br /><div align=\"center\" class=\"btxtsm\">";
if ($scwwlpppos!=0) echo '<a href="?rc=1&aid='.$scwwlpparray[$scwwlpppos-1].'">&lsaquo;&nbsp;previous</a>&nbsp;&nbsp;&nbsp;';
//echo '<a href="view_videos.php">gallery</a>';
if ($scwwlpppos<($scwwlppnum-1)) echo '&nbsp;&nbsp;&nbsp;&nbsp;<a href="?rc=1&aid='.$scwwlpparray[$scwwlpppos+1].'">next&nbsp;&rsaquo;</a>';
echo "</div>";}
echo '</td><td width="10"></td><td valign="top">';
if (trim(mysql_result($tprdctresult, 0, "description"))!="") echo "<br /><br />".str_replace("\\","",QuoteSmart(trim(mysql_result($tprdctresult, 0, "description")))).'<br /><br />';
if (trim($trow["instructional_text"])!="") echo trim(str_replace("\\","",QuoteSmart($trow["instructional_text"]))).'<br /><br />';
if (trim(mysql_result($tprdctresult, 0, "video_v1"))!="") {
echo '<a href="#" ';
echo 'onclick="IsPopupBlocker(\'../products/'.mysql_result($product_qry, 0, "name").'_low.php?aid='.mysql_result($tprdctresult, 0, 'id').'\',\''.mysql_result($product_qry, 0, "name").'_low_'.mysql_result($tprdctresult, 0, 'id').'\',\'width=240,height=164,toolbar=no,';
echo 'location=no,directories=no,status=no,menubar=no,scrollbars=no,copyhistory=no,resizable=no\')">';
echo 'Low Bandwidth</a> <span class="btxtsmg">- ('.str_replace("\\","/",trim(mysql_result($tprdctresult, 0, "video_v1_size"))).')</span><br /> '; } 
if (trim(mysql_result($tprdctresult, 0, "video_v1"))!="") {

echo '<a href="#" ';
echo 'onclick="IsPopupBlocker(\'../products/'.mysql_result($product_qry, 0, "name").'_med.php?aid='.mysql_result($tprdctresult, 0, 'id').'\',\''.mysql_result($product_qry, 0, "name").'_med_'.mysql_result($tprdctresult, 0, 'id').'\',\'width=352,height=236,toolbar=no,';
echo 'location=no,directories=no,status=no,menubar=no,scrollbars=no,copyhistory=no,resizable=no\')">';
echo 'Medium Bandwidth</a> <span class="btxtsmg">- ('.str_replace("\\","/",trim(mysql_result($tprdctresult, 0, "video_v2_size"))).')</span><br /> '; } 
if (trim(mysql_result($tprdctresult, 0, "video_v1"))!="") {

echo '<a href="#" ';
echo 'onclick="IsPopupBlocker(\'../products/'.mysql_result($product_qry, 0, "name").'_high.php?aid='.mysql_result($tprdctresult, 0, 'id').'\',\''.mysql_result($product_qry, 0, "name").'_high_'.mysql_result($tprdctresult, 0, 'id').'\',\'width=352,height=236,toolbar=no,';
echo 'location=no,directories=no,status=no,menubar=no,scrollbars=no,copyhistory=no,resizable=no\')">';
echo 'High Bandwidth</a> <span class="btxtsmg">- ('.str_replace("\\","/",trim(mysql_result($tprdctresult, 0, "video_v3_size"))).')</span><br /> '; } 
echo '</td></tr></table>';
}
else echo "No result found for <strong>".trim(mysql_result($product_qry, 0, "display_name"))."</strong>";
}
else {
switch(trim($_GET["ob"])) {
case ("na"):
$scworderby = "order by s.name";
$scwarrloc = "na";
break;

case ("nd"):
$scworderby = "order by s.name desc";
$scwarrloc = "nd";
break;

default:
$scworderby = "";
$scwarrloc = "";
break;
}

if (trim($trow["full_text"])!=""){
$content = str_replace("\\r\\n","<br />",QuoteSmart($trow["full_text"]));
$content = str_replace(" "," &nbsp;",$content);
$content = str_replace("\\","",$content);
print_r($content);

echo '&nbsp;<br /><br />';}
$scwqrytxt = "SELECT s.id as hid, s.name as hname, s.thumbnail FROM ".trim(mysql_result($product_qry, 0, "table_name"))." s where (date(\"".date("Y")."-".date("m")."-".date("d")."\") between date(s.web_start) AND date(s.web_end) or s.show_always=\"Y\")"; 
$scwqrytxt = $scwqrytxt." ".$scworderby;
$tprdctresult = mysql_query ($scwqrytxt);

if (!$tprdctresult) die('Invalid query: ' . mysql_error());
$num_rows = mysql_num_rows($tprdctresult);
if ($num_rows>0) {
$currentpage = $_GET["cp"] ;
if (trim($currentpage)==""){$currentpage=1;}
$noofrecs = $num_rows;
if (trim($_GET["prfr"])==1) $display_items_no=180;
else $display_items_no = 9;
$noofpgs = ceil($noofrecs / $display_items_no);
if ($noofrecs > 0){
$startrow = (($currentpage -1) * $display_items_no);
$news_count = 1;
echo 'Displaying results <strong>'.($startrow+1).'-';
if (($startrow+$display_items_no)<$noofrecs) echo ($startrow+$display_items_no);
else echo ($startrow+($noofrecs+$display_items_no-($noofpgs*$display_items_no)));
echo '</strong> of ';
echo '<strong>'.$num_rows.'</strong> results found for <strong>'.trim(mysql_result($product_qry, 0, "display_name")).'</strong>';

echo $plusisland;
echo $plustype;
echo '<br /><br />';
echo '<table width="100%" cellspacing="2" cellpadding="2" border="0" class="btxt"><tr>';
$scwrowcolor="#FFFFFF";
$scwt=1; 
while ($news_count <= $display_items_no)
{
if ($startrow<$noofrecs){
if ($scwt>3) { 
echo '</tr><tr height="20"><td width="33%" height="20"></td><td width="33%" height="20"></td><td width="33%" height="20"></td></tr><tr>';
$scwt=1;}


echo '<a href="?rc=1&aid='.mysql_result($tprdctresult, $startrow, 'hid').'"><img src="'.$scwsiteurl.'/media/products/'.trim(mysql_result($product_qry, 0, "name")).'/'.mysql_result($tprdctresult, 0, "hid").'/'.str_replace("\\","/",trim(mysql_result($tprdctresult, $startrow, "thumbnail"))).'" alt="'.str_replace("\\","",QuoteSmart(unhtmlspecialchars(mysql_result($tprdctresult, $startrow, 'hname')))).'" title="'.str_replace("\\","",QuoteSmart(unhtmlspecialchars(mysql_result($tprdctresult, $startrow, 'hname')))).'" border="0" /></a></td>';





echo '<td width="33%" align="left"><span class="bsubttlblu">';
echo str_replace("\\","",QuoteSmart(unhtmlspecialchars(mysql_result($tprdctresult, $startrow, 'hname'))));
echo "</span><br /><br />";





$startrow++;
$scwt++;
}
$news_count++;
}
}
echo '</tr></table>';
echo "<br /><strong>Page(s):</strong>";
if ($currentpage > 1){echo "&nbsp;<font face='Verdana, Arial'><a href='?isl=".$_GET["isl"]."&cp=1&pr=".$_GET["pr"]."&bct=".$_GET["bct"]."&ob=".$scwarrloc."'>«</a>&nbsp;<a href='?isl=".$_GET["isl"]."&cp=".($currentpage-1)."&pr=".$_GET["pr"]."&bct=".$_GET["bct"]."&ob=".$scwarrloc."'>&lsaquo;</a></font>";}
$cpg = 1;
while ($cpg <= $noofpgs) {
if ($cpg == $currentpage)
{ echo "&nbsp;<strong>".$cpg."</strong>"; }
else { echo " <a href='?isl=".$_GET["isl"]."&cp=".$cpg."&pr=".$_GET["pr"]."&bct=".$_GET["bct"]."&ob=".$scwarrloc."'>".$cpg."</a>"; }
$cpg++; 
}
if ($currentpage < $noofpgs){echo "&nbsp;<font face='Verdana, Arial'><a href='?isl=".$_GET["isl"]."&cp=".($currentpage+1)."&pr=".$_GET["pr"]."&bct=".$_GET["bct"]."&ob=".$scwarrloc."'>&rsaquo;</a>&nbsp;<a href='?isl=".$_GET["isl"]."&cp=".$noofpgs."&pr=".$_GET["pr"]."&bct=".$_GET["bct"]."&ob=".$scwarrloc."'>»</a></font>";}
} else echo "No result found for <strong>".trim(mysql_result($product_qry, 0, "display_name"))."</strong>";
} 
?>

leatherback

Warmaster wrote:
I know it is hard to comprehend, but all the code was there:

Well.. -and sorry to be a pain- You are asking people to help you for free in their free time. The least you can do is make sure we can read the code. Besides.. Even with the tags, the code is so poorly laid out that in order to understand it, one would have to sit down and do some serious documenting & formatting to make sure that editing one line does not mess up the rest..

Warmaster

I apologize if I came across rude, it took me all of 15 seconds to reply with the code in the php tags. I read the stickies as well as Benvalmont should have to know to do that. I do understand where you are coming from though and was not intending for this to get off topic by my reply.

To get back on topic, Benvalmont, it would help if you could run through the code and put some structure to the code. It is all running together and could use some spacing and indentation. Just look at other sample code to see where and how to structure it.

I am too new to php to help you with this but for what it was worth I ran through the code and could not figure it out. best of luck to you!

Warmaster

HalfaBee

Source beautified a bit.

<?php
if( trim( $_GET[ 'aid' ] ) != '' )
{
	$scwwlppid = trim( $_GET[ 'aid' ] );
	$scwqrytxt = 'SELECT * FROM ' . trim( mysql_result( $product_qry, 0, 'table_name' ) ) . ' s WHERE s.id=' . trim( $_GET[ 'aid' ] ) . ' and (date("' . date( 'Y' ) . '-' . date( 'm' ) . '-' . date( 'd' ) . '") between date(s.web_start) AND date(s.web_end) or s.show_always="Y")';
	$tprdctresult = mysql_query( $scwqrytxt );

if( !$tprdctresult )
{
	die( 'Invalid query: ' . mysql_error() );
}

$num_rows = mysql_num_rows( $tprdctresult );

if( $num_rows>0 )
{
	echo '<table width="550" border="0" cellspacing="2" cellpadding="0"><tr><td align="center">';
	echo '<span class="bsubttlblu">' . str_replace( '\', '', QuoteSmart( mysql_result( $tprdctresult, 0, 'name' ) ) ) . '</span><br /><br />';
	echo '<img src = "'.$scwsiteurl.'/media/products/'.trim(mysql_result($product_qry, 0, "folder_name")).'/'.mysql_result($tprdctresult, 0, "id').\'/\'.str_replace('\\','/",trim(mysql_result($tprdctresult, 0, "thumbnail" ) ) ) . '" border="0" />';
	$scwwlppbrowse = mysql_query( 'SELECT s.id FROM ' . trim( mysql_result( $product_qry, 0, 'table_name' ) ) . ' s where (date("' . date( 'Y' ) . '-' . date( 'm' ) . '-' . date( 'd' ) . '") between date(s.web_start) AND date(s.web_end) or s.show_always="Y")' );
	$scwwlppnum = mysql_num_rows( $scwwlppbrowse );

	if( $scwwlppnum>0 )
	{
		for( $scws = 0; $scws<$scwwlppnum; $scws++ )
		{
			$scwwlpparray[ $scws ] = mysql_result( $scwwlppbrowse, $scws );
		}

		$scwwlpppos = 0;

		for( $scws = 0; $scws<$scwwlppnum; $scws++ )
		{
			if( $scwwlpparray[ $scws ] == $scwwlppid ) $scwwlpppos = $scws;
		}

		echo '<br /><br /><div align="center" class="btxtsm">';

		if( $scwwlpppos != 0 )
		{
			echo '<a href="?rc=1&aid=' . $scwwlpparray[ $scwwlpppos-1 ] . '">&lsaquo;&nbsp;previous</a>&nbsp;&nbsp;&nbsp;';
		}//echo '<a href="view_videos.php">gallery</a>';
		if( $scwwlpppos<( $scwwlppnum-1 ) )
		{
			echo '&nbsp;&nbsp;&nbsp;&nbsp;<a href="?rc=1&aid=' . $scwwlpparray[ $scwwlpppos+1 ] . '">next&nbsp;&rsaquo;</a>';
		}

		echo '</div>';
	}

	echo '</td><td width="10"></td><td valign="top">';

	if( trim( mysql_result( $tprdctresult, 0, 'description' ) ) != '' ) echo '<br /><br />' . str_replace( '\', '', QuoteSmart( trim( mysql_result( $tprdctresult, 0, 'description' ) ) ) ) . '<br /><br />';

	if( trim( $trow[ 'instructional_text' ] ) != '' )
	{
		echo trim( str_replace( '\', '', QuoteSmart( $trow[ 'instructional_text' ] ) ) ) . '<br /><br />';
	}

	if( trim( mysql_result( $tprdctresult, 0, 'video_v1' ) ) != '' )
	{
		echo '<a href="#" ';
		echo 'onclick = "IsPopupBlocker(\'../products/'.mysql_result($product_qry, 0, "name").'_low.php?aid='.mysql_result($tprdctresult, 0, 'id').'\',\''.mysql_result($product_qry, 0, "name").'_low_'.mysql_result($tprdctresult, 0, 'id').'\',\'width=240,height=164,toolbar=no,';
echo 'location=no,directories=no,status=no,menubar=no,scrollbars=no,copyhistory=no,resizable=no\')">';
			echo 'Low Bandwidth</a> <span class="btxtsmg">- (' . str_replace( '\', "/",trim(mysql_result($tprdctresult, 0, "video_v1_size" ) ) ) . ')</span><br /> ';
		}

	if( trim( mysql_result( $tprdctresult, 0, 'video_v1' ) ) != '' )
	{
		echo '<a href="#" ';
		echo 'onclick = "IsPopupBlocker(\'../products/'.mysql_result($product_qry, 0, "name").'_med.php?aid='.mysql_result($tprdctresult, 0, 'id').'\',\''.mysql_result($product_qry, 0, "name").'_med_'.mysql_result($tprdctresult, 0, 'id').'\',\'width=352,height=236,toolbar=no,';
echo 'location=no,directories=no,status=no,menubar=no,scrollbars=no,copyhistory=no,resizable=no\')">';
			echo 'Medium Bandwidth</a> <span class="btxtsmg">- (' . str_replace( '\', "/",trim(mysql_result($tprdctresult, 0, "video_v2_size" ) ) ) . ')</span><br /> ';
		}

	if( trim( mysql_result( $tprdctresult, 0, 'video_v1' ) ) != '' )
	{
		echo '<a href="#" ';
		echo 'onclick = "IsPopupBlocker(\'../products/'.mysql_result($product_qry, 0, "name").'_high.php?aid='.mysql_result($tprdctresult, 0, 'id').'\',\''.mysql_result($product_qry, 0, "name").'_high_'.mysql_result($tprdctresult, 0, 'id').'\',\'width=352,height=236,toolbar=no,';
echo 'location=no,directories=no,status=no,menubar=no,scrollbars=no,copyhistory=no,resizable=no\')">';
			echo 'High Bandwidth</a> <span class="btxtsmg">- (' . str_replace( '\', "/",trim(mysql_result($tprdctresult, 0, "video_v3_size" ) ) ) . ')</span><br /> ';
		}

	echo '</td></tr></table>';
}
else
{
	echo 'No result found for <strong>' . trim( mysql_result( $product_qry, 0, 'display_name' ) ) . '</strong>';
}
}
else
{
	switch( trim( $_GET[ 'ob' ] ) )
	{
		case( 'na' ):
		$scworderby = 'order by s.name';
		$scwarrloc = 'na';
		break;
		case( 'nd' ):
		$scworderby = 'order by s.name desc';
		$scwarrloc = 'nd';
		break;
		default:$scworderby = '';
		$scwarrloc = '';
		break;
	}

if( trim( $trow[ 'full_text' ] ) != '' )
{
	$content = str_replace( "\\r\\n", '<br />', QuoteSmart( $trow[ 'full_text' ] ) );
	$content = str_replace( ' ', ' &nbsp;', $content );
	$content = str_replace( '\', '', $content );
	print_r( $content );
	echo '&nbsp;<br /><br />';
}

$scwqrytxt = 'SELECT s.id as hid, s.name as hname, s.thumbnail FROM ' . trim( mysql_result( $product_qry, 0, 'table_name' ) ) . ' s where (date("' . date( 'Y' ) . '-' . date( 'm' ) . '-' . date( 'd' ) . '") between date(s.web_start) AND date(s.web_end) or s.show_always="Y")';
$scwqrytxt = $scwqrytxt . ' ' . $scworderby;
$tprdctresult = mysql_query( $scwqrytxt );

if( !$tprdctresult )
{
	die( 'Invalid query: ' . mysql_error() );
}

$num_rows = mysql_num_rows( $tprdctresult );

if( $num_rows>0 )
{
	$currentpage = $_GET[ 'cp' ] ;

	if( trim( $currentpage ) == '' )
	{
		$currentpage = 1;
	}

	$noofrecs = $num_rows;

	if( trim( $_GET[ 'prfr' ] ) == 1 )
	{
		$display_items_no = 180;
	}
	else
	{
		$display_items_no = 9;
	}

	$noofpgs = ceil( $noofrecs / $display_items_no );

	if( $noofrecs > 0 )
	{
		$startrow = ( ( $currentpage -1 ) * $display_items_no );
		$news_count = 1;
		echo 'Displaying results <strong>' . ( $startrow+1 ) . '-';

		if( ( $startrow+$display_items_no )<$noofrecs )
		{
			echo( $startrow+$display_items_no );
		}
		else
		{
			echo( $startrow+( $noofrecs+$display_items_no-( $noofpgs*$display_items_no ) ) );
		}

		echo '</strong> of ';
		echo '<strong>' . $num_rows . '</strong> results found for <strong>' . trim( mysql_result( $product_qry, 0, 'display_name' ) ) . '</strong>';
		echo $plusisland;
		echo $plustype;
		echo '<br /><br />';
		echo '<table width="100%" cellspacing="2" cellpadding="2" border="0" class="btxt"><tr>';
		$scwrowcolor = '#FFFFFF';
		$scwt = 1;

		while( $news_count <= $display_items_no )
		{
			if( $startrow<$noofrecs )
			{
				if( $scwt>3 )
				{
					echo '</tr><tr height="20"><td width="33%" height="20"></td><td width="33%" height="20"></td><td width="33%" height="20"></td></tr><tr>';
					$scwt = 1;
				}

				echo '<a href = "?rc=1&aid='.mysql_result($tprdctresult, $startrow, 'hid').'"><img src = "'.$scwsiteurl.'/media/products/'.trim(mysql_result($product_qry, 0, "name")).'/'.mysql_result($tprdctresult, 0, "hid').\'/\'.str_replace('\\','/",trim(mysql_result($tprdctresult, $startrow, "thumbnail'))).\'' alt = '\'.str_replace('\\','",QuoteSmart(unhtmlspecialchars(mysql_result($tprdctresult, $startrow, 'hname')))).'" title = '\'.str_replace('\\','",QuoteSmart(unhtmlspecialchars(mysql_result($tprdctresult, $startrow, 'hname')))).'" border = '0' /></a></td>';
				echo '<td width="33%" align="left"><span class="bsubttlblu">';
				echo str_replace( '\', '', QuoteSmart( unhtmlspecialchars( mysql_result( $tprdctresult, $startrow, 'hname' ) ) ) );
				echo '</span><br /><br />';
				$startrow++;
				$scwt++;
			}

			$news_count++;
		}
	}

	echo '</tr></table>';
	echo '<br /><strong>Page(s):</strong>';

	if( $currentpage > 1 )
	{
		echo '&nbsp;<font face=\'Verdana, Arial\'><a href=\'?isl=' . $_GET[ 'isl' ] . '&cp=1&pr=' . $_GET[ 'pr' ] . '&bct=' . $_GET[ 'bct' ] . '&ob=' . $scwarrloc . '\'>&#171;</a>&nbsp;<a href=\'?isl=' . $_GET[ 'isl' ] . '&cp=' . ( $currentpage-1 ) . '&pr=' . $_GET[ 'pr' ] . '&bct=' . $_GET[ 'bct' ] . '&ob=' . $scwarrloc . '\'>&lsaquo;</a></font>';
	}

	$cpg = 1;

	while( $cpg <= $noofpgs )
	{
		if( $cpg == $currentpage )
		{
			echo '&nbsp;<strong>' . $cpg . '</strong>';
		}
		else
		{
			echo ' <a href=\'?isl=' . $_GET[ 'isl' ] . '&cp=' . $cpg . '&pr=' . $_GET[ 'pr' ] . '&bct=' . $_GET[ 'bct' ] . '&ob=' . $scwarrloc . '\'>' . $cpg . '</a>';
		}

		$cpg++;
	}

	if( $currentpage < $noofpgs )
	{
		echo '&nbsp;<font face=\'Verdana, Arial\'><a href=\'?isl=' . $_GET[ 'isl' ] . '&cp=' . ( $currentpage+1 ) . '&pr=' . $_GET[ 'pr' ] . '&bct=' . $_GET[ 'bct' ] . '&ob=' . $scwarrloc . '\'>&rsaquo;</a>&nbsp;<a href=\'?isl=' . $_GET[ 'isl' ] . '&cp=' . $noofpgs . '&pr=' . $_GET[ 'pr' ] . '&bct=' . $_GET[ 'bct' ] . '&ob=' . $scwarrloc . '\'>&#187;</a></font>';
	}
}
else
{
	echo 'No result found for <strong>' . trim( mysql_result( $product_qry, 0, 'display_name' ) ) . '</strong>';
}
}
?>

bigdaddysheikh

Hey man,

I know you are new to PHP, but I honestly do not want to read the full code. Did the previous developers leave behind any documentation or commenting of the script?