vb.org Archive - Query not returning right..

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Query not returning right.. (https://vborg.vbsupport.ru/showthread.php?t=173329)

MrApples

03-17-2008 07:21 PM

Query not returning right..

This really is a simple noob error (I think), I am probaly not using mysql_fetch_array right. - just to clarify, looks a lot bigger than it really is

I am apparently selecting a string array wrong. Of the two used fields, one CatID should always be 52, and the Words 'This', 'Is', 'A', 'Category', but it gives weird 1 character results.

The same query put into phpMyAdmin displays properly.

PHP Code:


		
			
    $q = "SELECT * FROM dub_catWords WHERE worth = '1'";
                echo '<br /> query ' . $q; // TESTING    
    $r = mysql_query($q);
    $words = mysql_fetch_array($r, MYSQL_ASSOC);
    foreach ($words as $w){ // Acts as if word not exist
        echo '<br />word ' . $w['word']; // TESTING    
        echo '<br />catID ' . $w['catID']; // TESTING

That displays...

Code:

query SELECT * FROM dub_catWords WHERE worth = '1'

word 3

catID 3

word 5

catID 5

word n

catID n

word 1

catID 1

When it should display

Code:

word this

catID 52

word is

catID 52

word a

catID 52

word category

catID 52

MoT3rror

03-17-2008 08:55 PM

PHP Code:


		
			
$q = "SELECT * FROM dub_catWords WHERE worth = '1'";
                echo '<br /> query ' . $q; // TESTING    
    $r = mysql_query($q);
    while($words = mysql_fetch_array($r, MYSQL_ASSOC))){ // Acts as if word not exist
        echo '<br />word ' . $word['word']; // TESTING    
        echo '<br />catID ' . $word['catID']; // TESTING
}

MrApples

03-17-2008 09:02 PM

Could you explain? Not disagreeing just I am curious. That would mean extra function calls wouldn't it?

PS: It works.

MoT3rror

03-17-2008 11:33 PM

I am not really for sure, sorry but you can read about the mysql_fetch_array here. Maybe you will find your answer there.

Dismounted

03-18-2008 04:57 AM

mysql_fetch_array() fetches the results as an array. And the while construct loops through the array until it ends.

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01034 seconds Memory Usage 1,728KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: