Basic Listings Theme: Display User's Listings on Homepage

Thanks, Leo!

Hi Leo,

I am displaying a user's listing with the following code, which takes the user's num from the URL (userNum):

// get the createdByUserNum value from the URL
$listingOwner = " listings.createdByUserNum='".@$_REQUEST['userNum']."'";


// load records from 'listings'
list($showcasesRecords, $showcasesMetaData) = getRecords(array(
  'tableName'     => 'listings',
  'joinTable'     => 'accounts',
  'loadUploads'   => true,
  'allowSearch'   => true,
  'where'         => $listingOwner,
  'orderBy'       => $pricesort,
  'perPage'       => '1',
));

The problem is that when I change the URL to a permalink then the userNum value is lost.

Could you please tell me how I can get around this issue?

Thanks,

Greg

Hi Greg,

Did you generate the permalinks by using update tables feature or creating custom permalinks? Try using $_REQUEST['num'] instead of $_REQUEST['userNum'] and let me know if the issue is fixed.

Thanks,

Hi Leo,

Thanks for getting back to me.

The permalink is a field I have added to the accounts table and then I just manually choose a SEO friendly URL.

When I use $_REQUEST['num'] then the listing's num is retrieved rather than the createdByUserNum, which is what I want.

Thanks,

Greg

Hi Greg,

Can you try set getRecords() allowSearch to be false and use $_REQUEST['num'] for the where statement?