polymaker

It works great now. Thanx!

Site page example:
https://polyathlon-russia.com/sportsmen?pdb=563

Interesting, it works differently on localhost and on site:
– on local host it shows only standard [pdb_list] without any filters and fields
– on site it works perfectly with defined parameters like:
<?php echo do_shortcode(‘[pdb_list filter=”last_name=Smith” fields=”last_name,first_name,club,start_name”]’); ?>

but has error when using $this:
<?php echo do_shortcode(‘[pdb_list filter=”last_name=’.$this->participant_values[‘last_name’].'” fields=”last_name,first_name,club,start_name”]’); ?>

Error is (displays on the bottom of the page):
Fatal error: Using $this when not in object context in /home/k.bashevoy/data/www/polyathlon-russia.com/wp-content/themes/pinboard/template-sidebar-content.php on line 16

Yes, version’s 1.4.9.3.
Error logs show only:
[03-May-2013 21:00:12 UTC] PDb_List::_build_shortcode_query list query= SELECT p.id, p.last_name, p.first_name, p.club, p.shooting_result, p.sprint_result, p.swimming_result, p.cross_result, p.start_name, p.sprint_pres FROM wp_participants_database p ORDER BY p.date_updated ASC

last_name, first_name etc are the fields of my database.

Maybe there’s a system error in wordpress, need to reinstall plugin and try again

Yes, I tried to add this code to the custom template of the page.
But filters and fields’re not working by unknown reason. It places the whole table of shortcode [pdb_list] with standard fields.

I even tried to add simple filter like
<?php echo do_shortcode(‘[pdb_list fields=”last_name,city” filter=”last_name=Smith”]’) ?>
But result is the same – whole table without any filter.

Sorry for misunderstanding.

I have a page containing [pdb_single] showing data of one record (sportsman results at particular competition). I need to add table to that page showing results of that sportsman on other competitions. To have something like “sportsman profile”.

That’s why in the first message I tried to get for example name of the sportsman in [pdb_single] (in variable $lastname). And after that call do_shortcode with filter like:
<?php
echo do_shortcode(‘[pdb_list filter=”.$lastname.”]’)
?>

Thanx for the answer.

Please consult how to transform user profile URL (associated with pdb-single-default.php) from “https://example.com/sportsmen?pdb=567&#8221; to “https://example.com/sportsmen?pdb=567&search_field=state&value=CA&submit=Search&#8221;? Where record pdb=567 has ‘state’ value ‘CA’.

It must be rather stupid question I suppose, be I’m not good at php, sorry.