www.webdeveloper.com
Results 1 to 8 of 8

Thread: More effecient coding...

  1. #1
    Join Date
    Nov 2006
    Posts
    250

    More effecient coding...

    Is there a more effecient way to do this??

    PHP Code:
    // Retrieve all the data from the "example" table
    $result1 mysql_query("SELECT * FROM home WHERE id='1'");
    $result2 mysql_query("SELECT * FROM home WHERE id='2'");

    // store the record of the "example" table into $row
    $row1 mysql_fetch_array$result1);
    $row2 mysql_fetch_array$result2);
    // Print out the contents of the entry 

    $id1 $row1['id'];
    $title1 $row1['title'];
    $content1 $row1['content'];
    $image1 $row1['image'];

    $id2 $row2['id'];
    $title2 $row2['title'];
    $content2 $row2['content'];
    $image2 $row2['image'];
    ?> 

  2. #2
    Join Date
    Jul 2007
    Location
    Orlando, FL
    Posts
    13

    this might make debug easier

    I am not sure if this helps; but it would seem to make debug easier.

    PHP Code:

    // Retrieve all the data from  table 1
    $result1 mysql_query("SELECT * FROM home WHERE id='1'");

    $row1 mysql_fetch_array$result1); 
               
    $id1 $row1['id']; 
            
    $title1 $row1['title']; 
          
    $content1 $row1['content']; 
            
    $image1 $row1['image']; 
     


    // Retrieve all the data from  table 2
    $result2 mysql_query("SELECT * FROM home WHERE id='2'"); 

    $row2 mysql_fetch_array$result2); 
               
    $id2 $row2['id']; 
            
    $title2 $row2['title']; 
          
    $content2 $row2['content']; 
            
    $image2 $row2['image']; 

  3. #3
    Join Date
    Jul 2007
    Posts
    357
    extract()
    PHP Code:
    $result1 mysql_query("SELECT * FROM `home` WHERE id='1'"); 
    $row1    mysql_fetch_assoc($result1);
    extract($row1);
    // do what you want with row 1

    $result2 mysql_query("SELECT * FROM `home `WHERE id='2'"); 
    $row2    mysql_fetch_assoc($result2);
    extract($row2);
    // do what you want with row 2 
    Unless you are trying to compare stuff from the first and second... Then you can change the second extract to be extract($row2, EXTR_PREFIX_SAME, 'b')
    so you vars for the second row would be $b_(column name)
    Last edited by ellisgl; 08-01-2007 at 11:42 AM.

  4. #4
    Join Date
    Nov 2006
    Posts
    250
    thankyou!!!

  5. #5
    Join Date
    Jul 2007
    Posts
    357
    No problem!

  6. #6
    Join Date
    Jan 2005
    Location
    Alicante (Spain)
    Posts
    7,742
    Quote Originally Posted by novemberGrey
    Is there a more effecient way to do this??
    The real trouble is your code is static. You could do this with one query and a loop.
    Code:
    SELECT * FROM `home` WHERE `id`<0 ORDER BY `id` ASC LIMIT 2

  7. #7
    Join Date
    Jul 2007
    Posts
    357
    Of course - the limit 2 may not be what he is after...

  8. #8
    Join Date
    Jan 2005
    Location
    Alicante (Spain)
    Posts
    7,742

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center

"

"

X vBulletin 4.2.2 Debug Information

  • Page Generation 0.19617 seconds
  • Memory Usage 2,930KB
  • Queries Executed 13 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_code
  • (3)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (8)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (70):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates