Hi,
i want to be able to edit my 'spnosored links' but I cant find any files or anything that has CID=1... eg/
if you click on 'accommodation' it comes up as www.aussiepages.com.au/results.php/?CID=1
i want to be able to update my affiliate part of that page? please can someone help
danny

CID=1 is a parameter been passed to your script.

You can use the $_GET['CID'] to retreive this parameter.

If you look at your script you will find a part with $_GET['CID'] inside it. Here is where the script will do something. Look at the code around here and make your changes.

Ibbo

not sure what part that is. i tried looking for it but couldnt find it. i'll post the result.php here please let me know if its in there.

<?
require("includes/config.php");
fnHeader();
function mailquote($text, $marker){
$text = str_replace("\n", "\n$marker", wordwrap($text, 85));
return $text;
}
?>
<table width="987" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="16" height="16" class="c1"><img src="images/clr.gif" alt="" width="16" height="16"></td>
<td width="955" height="16" class="bg1">&nbsp;</td>
<td width="16" height="16" class="c2"><img src="images/clr.gif" alt="" width="16" height="16"></td>
</tr>
<tr>
<td width="16" class="bg4"><img src="images/clr.gif" width="15" height="8"></td>
<td width="955">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="24%" valign="top" style="border-right:1px solid #cccccc;">
<table width="215" border="0" align="left" cellspacing="0" cellpadding="0">
<!-- <tr>
<td colspan=2>&nbsp;</td>
</tr>
<tr>
<td colspan=2>&nbsp;</td>
</tr> -->
<tr>
<td colspan=2 height="100%" class="orghead">Directories</td>
</tr>
<?
$arrCat=fnDisplayRecordsModS("tblcategory ","intCategoryID,vchCatName"," where chStatus = 'A'"," intCategoryID limit 0,50");
if(count($arrCat)>0)
{
foreach($arrCat as $arr)
{

?>
<tr>
<td width="14"><img src="images/bullet.gif" width="8" height="7"></td>
<td width="222" height="20" class="toplinks"><a href="results.php?CID=<?=$arr["intCategoryID"]?>" class="toplinks"><?=$arr["vchCatName"]?></a><br></td>
</tr>
<?
}
}
?>

</table>
</td>
<td width="76%" align="center" valign='top'>

<?
//-------------------------------
$p = new Pager;
$limit = 15;
$start = $p->findStart($limit);
//-------------------------------
$message = "";
// Get all the values supplied for search
$searchfor = $keywords;
if(strlen($keywords)==0 && !isset($CID))
{
$keywords = 'e';
$searchfor = '';
}
$where = '';
$flag = true;
if(!empty($intCategoryID))
{
$where .= " AND (a.intCategoryID = $intCategoryID or a.intCategoryID1 = $intCategoryID or a.intCategoryID2 = $intCategoryID) ";
}
if(!empty($vchState))
{
if($vchState != 'All States')
$where .= " AND a.vchState = '$vchState' ";
else
$where .= " ";
}
if(!empty($keywords))
{
$where .= " AND a.vchKeywords LIKE '%$keywords%' ";
}
//$strSql = "SELECT a.* FROM tblmembers a WHERE a.vchKeywords LIKE '%$keywords%' AND a.chStatus = 'A' AND a.chPlan <> 'F'";
$strSql = "SELECT a.* FROM tblmembers a WHERE a.chStatus = 'A' ";
$strSql = $strSql.$where;
//---------------------------
//from index page
//---------------------------
if(isset($CID)&& $CID !=0)
{
$strSql = "SELECT a.* FROM tblmembers a WHERE (a.intCategoryID = '$CID' AND a.chStatus = 'A') OR ( a.intCategoryID1 = '$CID' AND a.chStatus = 'A') OR (a.intCategoryID2 = '$CID' AND a.chStatus = 'A') ";
$searchfor = GiveValue("vchCatName","tblcategory"," where intCategoryID = ".$CID,0);
}
//print $strSql;
//print $wherecondition;
//exit;
$result1 = mysql_query($strSql,$link);
if(!$result1)
die("get row fatal error : ".mysql_error());
$count1 = mysql_num_rows($result1);
$pages = $p->findPages($count1, $limit);
$strSql .= " order by a.chPlan asc Limit ".$start.",".$limit;
//print $strSql;
$result = mysql_query($strSql,$link);
$count = mysql_num_rows($result);

?>
<style type="text/css">
.alia{width:100%}
.alia a{text-decoration:none;}
.alia img{display:block}
</style>
<table width="708" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="22" colspan=2 class="pageheading" align='left'>Search Results for&nbsp;<?=$searchfor?></td>
</tr>
<tr>
<td colspan=2><?ErrMsg_fun($itemName="",$message);?></td>
</tr>

<!-- start here -->
<?
$strSql2 = "select * from tblbanner where intCategoryID = ".$CID;
$result2 = mysql_query($strSql2,$link);
$count2 = mysql_num_rows($result2);

If($count2==0)
{ //print "<tr><td><span class='error'>Sorry, no records found.</span></td> </tr>";
}
Else
{
?>
<tr>
<td align='left'>
<table width="475" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td width="16" height="16" class="c1-new"><img src="images/clr.gif" alt="" width="16" height="16"></td>
<td width="955" height="16" class="bg1-new">&nbsp;</td>
<td width="16" height="16" class="c2-new"><img src="images/clr.gif" alt="" width="16" height="16"></td>
</tr>
<!-- <tr>
<td align='left'><font color='#CCCCFF'>Sponsered links</font></td>
</tr> -->
<tr>
<td width="16" class="bg4-new"><img src="images/clr.gif" width="15" height="8"></td>
<td width="475">
<font color='#C0C0C0'><B>Sponsored Links</B></font><br>
<?
for($i=0;$i<$count2;$i++)
{
$row2 = mysql_fetch_array($result2);
$txtCode = $row2['txtCode'];
//$txtCode = mailquote($txtCode, '<br>');

?> <table width="475" border="0" cellspacing="1" cellpadding="1">
<tr>
<td valign='center'><img src="images/bullet.gif" width="8" height="7">&nbsp;</td>
<td align='left' class="alia"><font face='arial'><?=$txtCode?></font></td>
</tr>
</table>
<?
}
?>
</td>
<td width="16" height="16" class="bg3-new"><img src="images/clr.gif" alt="" width="16" height="8"></td>
</tr>
<tr>
<td width="16" height="16" class="c4-new"><img src="images/clr.gif" alt="" width="16" height="16"></td>
<td width="475" height="16" class="bg2-new"><img src="images/clr.gif" alt="" width="475" height="1"></td>
<td height="16" class="c3-new"><img src="images/clr.gif" alt="" width="16" height="16"></td>
</tr>
</table>

</td>
</tr>
<?
}
?>

<!-- ends here -->
<tr>
<td align='left' >&nbsp;</td>
</tr>
<?
If($count==0)
{
print "<tr><td><span class='error'>Sorry, no records found.</span></td> </tr>";
}
Else
{
for($i=0;$i<$count;$i++)
{
$row = mysql_fetch_array($result);
$show = "";
$vchWebsite = $row['vchWebsite'];
$vchUrl = $row['vchUrl'];
$txtDesc = $row['txtDesc'];
$vchAddress = $row['vchAddress'];
$vchStatex = $row['vchState'];
if($vchStatex == 'All States')
$vchStatex = '';
if(strlen($vchStatex)>0)
$vchStatex = ' '.$vchStatex;
$chPlan = $row['chPlan'];
$vchEmail = $row['vchBannerPlace'];
if(strlen($vchEmail)>0 && $vchEmail != 'null')
$show = " <B>Email Us</B> - <a href='mailto:".$vchEmail."?subject=Contact From AussiePages - SUBJECT:'>".$vchWebsite."</a>";
$txtDesc = mailquote($txtDesc, '<br>');
if($chPlan == "P")
$colr = "style='border:1px solid #FF9933;'";
else
$colr = "style='border:1px solid #FFFFFF;";
?>
<tr>
<td align='left'>
<?if($chPlan == "P"){?>
<table width="475" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td width="16" height="16" class="c1"><img src="images/clr.gif" alt="" width="16" height="16"></td>
<td width="955" height="16" class="bg1">&nbsp;</td>
<td width="16" height="16" class="c2"><img src="images/clr.gif" alt="" width="16" height="16"></td>
</tr>
<tr>
<td width="16" class="bg4"><img src="images/clr.gif" width="15" height="8"></td>
<td width="475"><?}?>

<table width="475" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align='left'><B><?=$vchWebsite?></B></td>
</tr>
<tr>
<td colspan=2 ><br><?=$txtDesc?></td>
</tr>
<tr>
<td colspan=2><?=$vchAddress?>&nbsp;<?=$vchStatex?></td>
</tr>
<tr>
<td align='left'><a href='http://<?=$vchUrl?>' target='_blank'><?=$vchUrl?></a>&nbsp;&nbsp;&nbsp;&nbsp;<?=$show?></td>
</tr>
</table>
<?if($chPlan == "P"){?>
</td>
<td width="16" height="16" class="bg3"><img src="images/clr.gif" alt="" width="16" height="8"></td>
</tr>
<tr>
<td width="16" height="16" class="c4"><img src="images/clr.gif" alt="" width="16" height="16"></td>
<td width="475" height="16" class="bg2"><img src="images/clr.gif" alt="" width="475" height="1"></td>
<td height="16" class="c3"><img src="images/clr.gif" alt="" width="16" height="16"></td>
</tr>
</table><?}?>

</td>
</tr>
<tr>
<td colspan=2 align="left"><hr width='70%' align="left" color='#cccccc'></td>
</tr>
<?
}
mysql_free_result($result);
print"<tr><td align='center' >";
$pagelist = $p->pageList($_GET['page'], $pages,"&keywords=$keywords&CID=$CID&intCategoryID =$intCategoryID&vchState=$vchState");
print "$pagelist";
print"</td></tr>";
if(empty($page))
$page = 1;
}
?>
</table>
</td>
</tr>
</table>
</td>
<td width="16" height="16" class="bg3"><img src="images/clr.gif" alt="" width="16" height="8"></td>
</tr>
<tr>
<td width="16" height="16" class="c4"><img src="images/clr.gif" alt="" width="16" height="16"></td>
<td width="955" height="16" class="bg2"><img src="images/clr.gif" alt="" width="955" height="1"></td>
<td height="16" class="c3"><img src="images/clr.gif" alt="" width="16" height="16"></td>
</tr>
</table>
<?
fnFooter();
//ALTER TABLE `tblbanner` CHANGE `intBannerID` `intCategoryID` INT NOT NULL AUTO_INCREMENT;
//ALTER TABLE `tblbanner` CHANGE `vchSize` `txtCode` TEXT NOT NULL ;
//ALTER TABLE `tblbanner` CHANGE `intCategoryID` `intCategoryID` INT( 11 ) NOT NULL
?>

After reviewing your script with the find function in notepad I have concluded that the variable $CID is set in includes/config.php Post this script and I'll be able to help you. Also this may not be it because $CID does not use the get method but it was most likely defined from $_GET['cid'] in the configuration file.

unless register globals is assumed to be on

The link is being generated here:

PHP Code:

foreach($arrCat as $arr)
{ . . .
<a href="results.php?CID=<?=$arr["intCategoryID"]?>" class="toplinks"><?=$arr["vchCatName"]?></a>
. . .
}

Which is pulling the data from a database:

PHP Code:

$arrCat=fnDisplayRecordsModS("tblcategory ","intCategoryID,vchCatName"," where chStatus = 'A'"," intCategoryID limit 0,50"); 


So, you can view and edit the data in your database using phpMyAdmin if your control panel (from your host) has it installed. Its table tblcategory with the intCategoryID as the id number for that record.

hey
thanks very much mgraphic, extremly helpful

Man, I feel 'nooby' now. Sorry I messed up like that.

hehe, all good

just an update.... i wish i never touched the phpmyadmin,.. mmm not sure what ive done but one thing i know i did is stuff up some directoried

Can you tell us exactly what you did in PHPMyAdmin?

nah not really sorry. i was just clicking on stuff,, pressing the 'go' button a few times. i played in tblcategory","intCategoryID -
its ok know. i figured out where the 'sponsored links' are, there in tblbanner then tblcategory..

thanks everyone for your help,. i apreciate it.