Basic Listings Theme: Display User's Listings on Homepage

Hi Greg,

You just need to get the user's listings records by using their num (depending on how you link the listings with the user), and have a foreach loop to display them.

Let me know if you have any questions!

Thanks,

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?