Horizontal & Featured Listings With Styling

[SecondShoe]

I triple checked everything but still no luck. I have no idea what`s the cause.

[Eric Barnes]

Hey guys I just downloaded the functions and that one does have a php error.

At the top it has:

<?php
/*
 * Smarty plugin
 * -------------------------------------------------------------
 * Type:     function
 * Name:     random
 * Purpose:  output a latest number between $varIn and $varOut:
 *    {random in=$varIn out=$varOut}
<?php

Notice the two "<?php" lines. The second needs to be deleted.

[SecondShoe]

I deleted the second "<?php" but I still get the error.
I localized the problem. After a quick test I noticed that "function.css_random_listings_horizontal" is working properly on my site. The only difference between "function.css_random_listings_horizontal" and "function.css_latest_listings_horizontal" is a small piece of code:

"function.css_random_listings_horizontal" (working properly):

PHP Code:

$sSQL="SELECT id,title,price FROM ".PREFIX."listings WHERE display = 'Y' AND expiration > NOW() ORDER BY rand() LIMIT ".$number; 


"function.css_latest_listings_horizontal"(not working on my site):

PHP Code:

$sSQL="SELECT p.id, p.owner, p.title, p.featured, p.section, p.description, p.price, p.dateadded, p.expiration, p.pHighlighted, p.pBold, u.state, u.city, u.country FROM ".PREFIX."listings AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id WHERE p.expiration > NOW() AND p.display = 'Y' ORDER BY p.dateadded DESC LIMIT ".$number; 


My PHP knowledge is very limited and I can't find the problem.

[SecondShoe]

After a long copy/paste session I got it working (I don't know how). I am not sure but maybe there is something wrong with the formatting of the original function.css_latest_listings_horizontal.php .

[seymourjames]

I see the error on one of the plugins. Many thanks.

I have reposted the corrected plugin for download. It was passing on my machine between the comments but perhaps not on others. It looks like it was only the latest listings module and the others were ok.

Thanks for the heads up.