PEAK XOOPS - Showing "There are X phots in our Database" in a custom block 
TOP
>
Forum
>
XOOPS Modules
>
myAlbum-P
>
Showing "There are X phots in our Database" in a custom block
Showing "There are X phots in our Database" in a custom block
- You cannot open a new topic into this forum
- Guests cannot post into this forum
Previous post
-
Next post
|
Parent
-
Children.1
|
Posted on 2006/6/8 1:15
tedsmith
Posts: 64
Posts: 64
I want to show the section of MyAlbum in a custom block elsewhere on my site but I'm not sure how to do it.
It's the bit where it says : "There are X photos in our Database". I want that same line to feature in a block on my home page somewhere so that it queries that database for the total number of photos and displays it on the homepage. What HTML would I have to write to achieve that (I do not want to make the module as the starting module for my site)?
Does anyone know how I do that?
Thank you
Ted
It's the bit where it says : "There are X photos in our Database". I want that same line to feature in a block on my home page somewhere so that it queries that database for the total number of photos and displays it on the homepage. What HTML would I have to write to achieve that (I do not want to make the module as the starting module for my site)?
Does anyone know how I do that?
Thank you
Ted
Votes:2
Average:10.00
GIJOE
Posts: 4110
Posts: 4110
The easiest way...
custom block (PHP)
custom block (PHP)
$db =& Database::getInstance();
list( $count ) = $db->fetchRow( $db->query( "SELECT COUNT(*) FROM ".$db->prefix("myalbum_photos")." WHERE status>0" ) ) ;
echo 'number :' . $count ;
Votes:9
Average:1.11
Previous post
-
Next post
|
Parent
-
No child
|
Posted on 2006/6/9 0:26
tedsmith
Posts: 64
Posts: 64
Excellent GIJOE, thank you.
Votes:7
Average:8.57
Login