[thelist] PHP Code not working as expected....

Mike Migurski mike at saturn5.com
Sun Dec 8 05:16:00 CST 2002


>This is all the page does.  There is nothing above this point except the
>database connect info. This is running against 300,000 records and is
>taking forever to run.  Just started this today.
>$sqlPrim = mysql_query("select prodID, prodSecCat from jandr_items order by
>prodSecCat asc limit 0, 10") or die(mysql_error());
>
>while($row = mysql_fetch_array($sqlPrim)){
>         echo $row[0] . " " . $row[1] . " " . "<br>";
>}
>
>Here is what is returned.
<snip>
>
>Can anyone tell me why row[1] is returning array and row[0] is not?

Hard to say without knowing the specifics. Can you provide the results of
print_r() on each row, so it's more obvious what's actually there?

-mike.

---------------------------------------------------------------------
michal migurski- contact info and pgp key:
                 http://www.saturn5.com/mike/contact.html

                "Freedom! Horrible, horrible freedom!"







More information about the thelist mailing list