Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Prev Previous Post   Next Post Next
  #1  
Old 02-07-2005, 02:34 PM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default while/conditional problem

PHP Code:
// ###################### groups by cat
            
$grps_categories $DB_site->query("
               SELECT grps.groupid, grps.title, grps.description,grps.catid, grps_catergories.title AS catname, grps.approved,grps.leaderid
                FROM grps
               LEFT JOIN grps_catergories ON(grps_catergories.catid = grps.catid)
                WHERE grps.approved=1
                ORDER BY grps_catergories.catid ASC, grps.title ASC
            "
);

            if (!
$DB_site->num_rows($grps_categories))
            { 
// nogroups, this becomes obselete after the first group gets created
                      
eval("\$grps_catbits = \"" fetch_template("groups_browse_cathead") ."\";");
                       
$grps_catbits .="<tr><td class=\"alt1\" align=\"center\">no groups found inthis catergory at this time</td></tr>";
                      eval(
"\$grps_catbits .= \"" fetch_template("groups_browse_catfoot") ."\";");
            }
            else
            { 
// display the information
                
$row "0";
               while (
$grps_categoryinfo =$DB_site->fetch_array($grps_categories))
                {
                    if (
$row == 0)
                    {
                      eval(
"\$grps_catbits .= \"" fetch_template("groups_browse_cathead") ."\";");

                       
// resetcatname store
                      
$grps_catidstore $grps_categoryinfo['catid'];
                    }
                   echo
"$grps_categoryinfo[catid]<br />";
                   if (
$grps_catidstore !=$grps_categoryinfo[catid] AND $row != 0)
                    {
                      eval(
"\$grps_catbits .= \"" fetch_template("groups_browse_cathead") ."\";");

                       
// resetcatname store
                      
$grps_catidstore $grps_categoryinfo['catid'];
                    }

                   
$grps_categoryinfo['title'] =stripslashes($grps_categoryinfo['title']);
                   
$grps_categoryinfo['description']= nl2br(stripslashes($grps_categoryinfo['description']));
                   
$grps_categoryinfo['catname'] =stripslashes($grps_categoryinfo['catname']);
                    
extract($grps_categoryinfo);

                    eval(
"\$grps_catbits .= \"" .fetch_template("groups_browse_catbit") . "\";");

                   if (
$grps_categoryinfo[catid] !=$grps_catidstore)
                    {
                       
// can't getinto this for some reason
                      
eval("\$grps_catbits .= \"" fetch_template("groups_browse_catfoot") ."\";");
                    }
//                    else
//                    {
//                      eval("\$grps_catbits .= \"" . fetch_template("groups_browse_catfoot") ."\";");
//                    }
                    
$row++;
                } 
//now echo the date into the template
            

the code above is actually perfect, well it works anyway, only problemis that it doesn't actually seem to work, i can't get into theconditonal that groups the data together rather than it just creating anew table, wondered if anyone could help please, as i havne't got aclue what's wrong with it, especially as echoing out the data manuallyshows that it should be doing what i'm trying to do.

basically $grps_catidstore echo's out
Code:
4
4
4
8
8
and $grps_catergoryinfo =
Code:
4
4
4
4
8
now based on that the first three should be in one table (it'sextracting one groups_browse_cathead and one groups_browse_catfoot) butfor some reason it won't do it
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:16 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04806 seconds
  • Memory Usage 2,677KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (3)bbcode_html
  • (4)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (11)postbit
  • (2)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • postbit_attachment
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete