CircleOfLinks

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

__________________
Danny.
Business Directory | Web and Graphic Design Specialist

jumpenjuhosaphat

The ?CID=1 isnt' the name of a file. Whenever you see a URL like http://www.....com/somefile.php?action=go&this=that
Everything from the ? on is part of a set of variables being passed. Chances are the information that you are looing for is in a data base table. You would need to look at the results.php file to try to determine the name of the table that your data is stored in, and then use phpmyadmin to change the table manually.

__________________
Storage Sheds
Lost Forum

CircleOfLinks

Not sure what part it is your talking about so i'll post the result.php here. can you tell me what part it is that it may be refereing to a database??


<?
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
?>

thanks danny

__________________
Danny.
Business Directory | Web and Graphic Design Specialist

jumpenjuhosaphat

You'll be looking for a table named tblbanner. Inside of that table should be the information that you would like to change.

__________________
Storage Sheds
Lost Forum

CircleOfLinks

Ok would the be on a different file??

__________________
Danny.
Business Directory | Web and Graphic Design Specialist

jumpenjuhosaphat

Well, it's actually a data base, you can't access it the same way that you would a file. If you have cPanel, go into Mysql Data Base's. From there scroll down to the bottom of the page, and there is a link there that says phpmyadmin, click on that.

Before you do that though, you might consider reading a little bit about phpmyadmin so that you don't accidentally do some damage to one of your data bases.

__________________
Storage Sheds
Lost Forum

CircleOfLinks

ahh ok,,, thanks i appreciate it.

good help

__________________
Danny.
Business Directory | Web and Graphic Design Specialist