Making Search by category list update

OOPs.. Forgot .. 2 more things :

1. am not adding the new records from the web browser, but from MyPhpAdmin directly through an SQL Query .
   
2. Here is the code I am using to display the "Search by category list"" (I took it from one of the template it understood its logic and modified it to suit my DB :
   global $strSQL,
   
   //** Custom code ****
   
   // put your custom code here
   $conn,$strTableName;
   
   echo "
   <b>Search by category</b>
   ";
   
   echo "

";

//categories

$str = "select count(category) as numbers, Category from ".$strTableName." group by Category";

$rs = db_query($str,$conn);

while ($data = db_fetch_array($rs))

{

$category = str_replace(" ","+",$data["Category"]);

$message = "<a style=\"color: black;\" href=\"booklibrary_list.php?a=search&value=1&SearchFor=".$category."&SearchOption=Contains&SearchField=Category\">".$data["Category"]." (".$data["numbers"].")</a>
";

echo $message;

}
Hope some one can help.
thanks .

nadimo.

Could be a caching issue. In case it is, I recommend adding these lines to dbcommon.php -

Could be a caching issue. In case it is, I recommend adding these lines to dbcommon.php -

Hi,
Thanks for trying to help , but it did not work .

I added the code inside dbcommon.php after :
header("Content-type: text/html;
charset=".$cCharset);
also tried at start after : <?php, no luck .
It is so frustrating .
what next <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=28490&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
nadimo

I have updated the Cars database from outside the web browser (I am talking about the cars template example ).and going back to see if the category list is updated . It is indeed .So I guess there is something missing in my code . I paste below the cars php file that displaus the categories list , maybe some PHP guru can figure out what is missing in my code .:
global $strSQL,$conn, $smarty;
//search by brand

$message="<b>Search by Brand
";
$str = "select count(Model) as numbers, Make from cars group by Make";

$rs = db_query($str,$conn);

while ($data = db_fetch_array($rs))

{

$make = str_replace(" ","+",$data["Make"]);

$message = $message ."<a href=\"cars_list.php?a=search&value=1&SearchFor=".$make."&SearchOption=Contains&SearchField=Make\">".$data["Make"]." (".$data["numbers"].")</a>";

$message = $message ."
";

}
//show all

$message = $message ."
<a href=\"cars_list.php?a=showall&value=1&SearchFor=&SearchOption=&SearchField=\">show all</a>

";.........
thanks for any help.

nadimo.

Hi,
your code looks good.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.

Hi,
I fixed the problem , I replaced
"&SearchOption=Contains&SearchField=Category
with "&SearchOption=Equals&SearchField=Category
and the category list is now ok when clicked at .
thanks for your kind help.

nadimo.