[MrApples]

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...

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

word this
catID 52
word is
catID 52
word a
catID 52
word category
catID 52