$row = mysql_fetch_array(mysql_db_query(

[zevious]

Why won\'t this work?

while($row = mysql_fetch_array(mysql_db_query(\"WPro\",\"select CONCAT(last,\', \',first) as name,account,(metersort-1) as metersort from \".$co.\"_users where type=\'A\' order by last,first\")))

but this does:
$result=mysql_db_query(\"WPro\",\"select CONCAT(last,\', \',first) as name,account,(metersort-1) as metersort from \".$co.\"_users where type=\'A\' order by last,first\");
while($row = mysql_fetch_array($result))

?

[[deleted]]

HMm slashes are acting up again. i take it all thos escape slashes are not in your real code?

Anyway, why it doesn't work probably has to do with the order in which the functions are evaluated.
It's a bit of a trivial question really, because no sane person would code it like your first example (no offence) 🙂

[zevious]

Ahh ok. It must be evaluating it from the front to back instead of basing it on the ('s. Why wouldn't you code it that way? Why assign another array?

[[deleted]]

I must be growing ol not to have seen this before;
you have the whole thing in a while condition.
Every thing in the while condition gets evaluated for every loop.
So that could never work, it would start the query all over again all the time.

Second, coding it like this (everything nested) means:
- you can't do any error checking at all, which is bad.
- you need to read it four times to understand what you are doing.

[zevious]

Got it. Thanks for pointing out what should have been the obvious.