Jump to content

pemula

Members
  • Posts

    8
  • Joined

  • Last visited

Everything posted by pemula

  1. Dear Masters, Please help.. I want to make a image gallery in a sliding page. Thx a lot gallery image in a slider.txt
  2. Dear all, I have code for paging The problem is, one of them do not work properly This is OK http://www.amec-berca.co.id/abi/index.php?action=past-projects This is not OK http://www.parnaraya.net/beta/index.php?link=news My question: Is there any issues about PHP/Apache version? or something else? I used this script very often, and no problem so far except this time FYI, the host server using Virtualmin version 3.89 Thanks
  3. Hi all, I have table, named: tb_event (id, f_date, f_title, f_image, f_status) How to manage, while if 'f_status' from all records NOT EQUAL to 'Published' then show ABCDE Note: on tb_event should be only the latest record (1 record only) that will be shown/published I have code: <? $qry = mysql_query( "SELECT * FROM tb_event WHERE f_status = 'Published'") or die(mysql_error()); while($res = mysql_fetch_array($qry)) { if ($res[f_status] = "Published") { echo ' <img src="images/uploads/'.$res[f_image].'" border="0" /> '; } else { echo ' ABCDE '; } } ?> The result is 'ABCDE' not shown while f_image (all records) is OFF Please help me.. thx
  4. Dear guys, I need a simple recruitment online application.. simple but powerfull Could you recommend to me one of them please. Thankyou
  5. and it solved with this... SELECT * FROM tb_event WHERE YEAR(t_date)=YEAR(Now()) AND MONTH(t_date)=MONTH(Now()) AND DATE(t_date)>=DATE(Now()) thx for manohoo
  6. ooops sory, I didn't correct and recheck myposting Btw, thnks for reply
  7. My db: CREATE TABLE `tb_event` ( `id` tinyint(4) NOT NULL auto_increment, `t_date` date default NULL, `t_event` varchar(75) default NULL, `t_place` varchar(75) default NULL, `t_content` text, PRIMARY KEY (`id`) ) Records: 1, '2011-01-09', 'event 1', ... 2, '2011-05-12', 'event 2', ... 3, '2011-09-20', 'event 3', ... ------- My code here: <? $now = date("Y-m-d"); ... ... SELECT * FROM tb_acara WHERE t_tanggal >= $now ... ... ?> It will show all records.. I change >= with <= it didn't show anything ------- My goal is: I only want to show the event which in September (month of 9) on record number 3 Can you help me please guys?? Thanks
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.