MobileRead Forums - View Single Post

edent · 11-19-2011, 04:11 PM

D'oh! That did the trick. Thanks!

Is there any way to get the size of a file out of the DB? So I can format it "MOBI 2.5MB" etc?

It doesn't seem to work when I change the DB query to

PHP Code:


			
$data = $this->db->query(sprintf('SELECT format,name,size

(and then loop through the array).

EDIT: the column name is "uncompressed_size" - using that works to get file size.

Love the server - is there a more formal way to contribute patches / bugs / change request?

11-19-2011, 04:11 PM	#147
edent Connoisseur Posts: 51 Karma: 94224 Join Date: Dec 2009 Location: UK Device: Likebook Ares, Kindle 3G, Nook STR, 511eb	D'oh! That did the trick. Thanks! Is there any way to get the size of a file out of the DB? So I can format it "MOBI 2.5MB" etc? It doesn't seem to work when I change the DB query to PHP Code: `$data = $this->db->query(sprintf('SELECT format,name,size` (and then loop through the array). EDIT: the column name is "uncompressed_size" - using that works to get file size. Love the server - is there a more formal way to contribute patches / bugs / change request? Last edited by edent; 11-19-2011 at 04:45 PM.