[PHP-DB] Re: First Script

2002-05-20 Thread Coert Metz
I don't know how mysql_fetch_array() works. I think you have to handle this by yourself by putting something in the loop. You can also make a query for it (SELECT sum(*) FROM time) Coert "César l . aracena" <[EMAIL PROTECTED]> schreef in bericht 002901c1feed$5695b2c0$94c405c8@gateway">news:00290

[PHP-DB] RE: First Script

2002-05-18 Thread César L . Aracena
Thanx for the help. I have it almos finished. Now, the script throws all the colums for all the rows of the table. My only problem now is how to print the TOTAL for the column named time. Can I use mysql_fetch_array() instead of mysql_fetch_row() to accomplish this? How can I add it? Here's wh

[PHP-DB] Re: First Script

2002-05-18 Thread Coert Metz
Hello The problem is that you only apply mysql_fetch_row one time to the result. The query 'select * from time where id>0' gives an array which can have multiple rows. For every row you have to apply mysql_fetch_row. So you have to do something like this: $total=0; while ($row = mysql_fetch_row