You are here:  » amended external

Support Forum



amended external

Submitted by Paul1107 on Thu, 2009-07-02 18:54 in

Hi David,

some time ago you kindly helped me with mod to external.php which allowed me to place a number of products into a horizontal space using and sql query. example below.

if ($content)
{
switch($content)
{

case "a":
$sql = "SELECT * , MIN( price ) AS minPrice, MAX( price ) AS maxPrice, COUNT( id ) AS numMerchants FROM `".$config_databaseTablePrefix."products` WHERE merchant='Lipsy Beachwear' GROUP BY name LIMIT 5";

it works great on the site which I had originally intended for, but I have employed it on another site, as the pt installation is shared but the results even though fine need tweak from aesthetic point of view.

The questions are: How do I centre the results (larger gap to the right than to the left)? And and how can I stop the title wrapping so they continue on a second line which knocks the images out of alignment in the row making look untidy, or truncating the title, which I think you did in the previous mod, just don't how you did it. I thought it would have been searchresults.php, but that seems to have no influence over it, and didn't want to change for fear I mess up the other site?

thanks for any pointers you can give.

Cheers!

Paul

Submitted by support on Fri, 2009-07-03 11:25

Hi Paul,

If you could email me your modified external.php i'll check which display modules are being included for those specified queries...

Cheers,
David.