View Single Post
  #1  
Old 01-27-2008, 08:27 AM
OnyxChase OnyxChase is offline
 
Join Date: Jul 2007
Posts: 79
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Simple MySQL Question

This questions is probably extremely simple for one of you programming gurus out there! I'm working on an addon for my vbulletin and I'm trying to get some information from the SQL database but I am getting an entire string instead of rows.

For example: if I do $title I will get "Signature of the MonthMember of the Month" which is two rows. How can I split these rows into different variables? Or to atleast get a break line between the two?

Thanks, any help will be greatly appreciated!

PHP Code:
    $query $db->query_read(
        SELECT candvoting_nominee.boothid, candvoting_nominee.userid, candvoting_pollbooth.title, candvoting_pollbooth.candvoting_pollboothid
        FROM " 
TABLE_PREFIX "candvoting_nominee as candvoting_nominee  
        LEFT JOIN " 
TABLE_PREFIX "candvoting_pollbooth as candvoting_pollbooth on (candvoting_nominee.boothid = candvoting_pollbooth.candvoting_pollboothid) 
        WHERE userid = 
$memberid"
); 
    
    while (
$row $db->fetch_array($query)) 
    {

$title $row['title']; 
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01175 seconds
  • Memory Usage 1,767KB
  • 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
  • (1)bbcode_php
  • (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