View Single Post
  #9  
Old 08-22-2011, 11:40 PM
Iain M's Avatar
Iain M Iain M is offline
 
Join Date: Jul 2005
Location: Glasgow, Scotland
Posts: 256
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for the link. I had never came across that function before. I guess I didn't look hard enough!

Quote:
Well, now this query... must be getting done more times, right? Are you sure you actually need that one
Yes, that's right.

If I remove that query and use
PHP Code:
$optionselected = ($viewCountry['id'] == $editService['country']) ? 'selected="selected"' ''
as you suggested above, it adds selected to each row for each item.

For example:
Row 1: Dog Trainer in UK
HTML Code:
<td><select class="primary" name="country[3]" tabindex="1">
<option value="1" class="" >Australia</option> 
<option value="2" class="" >Canada</option> 
<option value="3" class="">New Zealand</option> 
<option value="4" class="" selected="selected">United Kingdom</option> 
<option value="5" class="" >United States</option>
</select></td>
Row 2: Baby Sitter in the US
HTML Code:
<td><select class="primary" name="country[3]" tabindex="1">
<option value="1" class="" >Australia</option> 
<option value="2" class="" >Canada</option> 
<option value="3" class="">New Zealand</option> 
<option value="4" class="" selected="selected">United Kingdom</option> 
<option value="5" class="" selected="selected">United States</option>
</select></td>
Row 3: Plumber in NZ
HTML Code:
<td><select class="primary" name="country[3]" tabindex="1">
<option value="1" class="" >Australia</option> 
<option value="2" class="" >Canada</option> 
<option value="3" class="" selected="selected">New Zealand</option> 
<option value="4" class="" selected="selected">United Kingdom</option> 
<option value="5" class="" selected="selected">United States</option>
</select></td>
I think you're on the right track tho, because that is the query running over and over and over and over again... by commenting it out, it dropped to 11 queries.

Thanks Kevin.

I'm gonna head off (almost 2am here), and play with this again tomorrow.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01156 seconds
  • Memory Usage 1,783KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_html
  • (1)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete