>The file is attached and is also available at >http://estore.homeip.net/time/pctimesheetnew.php.txt.; What do you mean by >supplying a column alias...how would I do that? Thanks.
Instead of writing: SELECT some-long-expression Write: SELECT some-long-expression AS xyz Then the output column will be named xyz, and you can do this: $total = mysql_result($result2, 0, "xyz"); But now that I look more closely at your code again, the problem is actually fairly simple. Your query is in $query2, but you're passing $query to mysql_db_query(). That's bound to give you a result you don't want. :-) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php