Tejpal
Members-
Posts
33 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Everything posted by Tejpal
-
How To show category wise posts using custom fields i am use acf plugin and i want show custom fields page i have 3 custom fields 1 album 2 artist 3 lyrics and 2 category 1st remix 2nd top song i want creat deffrant page for all 3 fields like 1st page album where i can show all album with 1st category with paging See Below Attached file For Best Understanding
-
Done <?php $pst = date('m'); if($pst>4) { $y=date('Y'); echo $dtt=$y."-04-01<br/>"; $pt = date('Y', strtotime('+1 year')); echo $ptt=$pt."-03-31"; } else { $y=date('Y', strtotime('-1 year')); echo $dtt=$y."-04-01<br/>"; $pt =date('Y'); echo $ptt=$pt."-03-31"; } ?>
-
m Also use acctstarttime between 'invoice.date' and 'users.expiration' and acctstarttime between invoice.date and users.expiration but Result Not Right But when I Use Static Date both then working good can you explain sir how i done
-
Hello Every One I Want Show all USer last Useges Data From date of Last Recharge to To Date and condition With user owner by i Have 3 Table invoice - Need data from column date(need last invoice Last Recharge date For Below Table Condition Start ),username( Uniq In all table) acct - > Need data from column acctstarttime( For Start Date ),SUM( acct.acctinputoctets + acct.acctoutputoctets ) AS data(For Sum Of Useges Data ),SUM( acct.acctsessiontime ) AS acctsessiontime,username(Uniq In all table) users - > Need data from column username( Main Table Match username on this table base),owner,lastlogoff,expiration,uptimelimit,comobolimit, My Code is Here But Not working SELECT DATE( `acctstarttime` ) AS acctstarttime, SUM( acct.acctinputoctets + acct.acctoutputoctets ) AS data, acct.username, SUM( acct.acctsessiontime ) AS acctsessiontime, users.username, users.owner, users.lastlogoff, users.expiration, users.uptimelimit, .comblimit, users.enableuser,invoices.date FROM invoices,acct JOIN users ON acct.username = rm_users.username WHERE users.owner = 'admin' and acctstarttime between 'invoice.date' and 'users.expiration' GROUP BY MONTH( `acctstarttime` ) , acct.username ORDER BY invoices.date DESC LIMIT 0 , 30 I Think Problem in Where condition i want acctstarttime between 'invoice.date(Desc or User last recharge Date)' and 'users.expiration' I m very Confused How I dow Any One Can Help Thanks in Extra
-
How i submit form to other website and Get Result on my website Here Is An example site I want Make like this website http://singhfm.com/psebresult/ and here tagret website where i want pick data http://results2.indiaresults.com/pb/pseb/result-of-12-class-march-2016/query.htm How I Done Any one can help about this
-
Hello everyone I want Show Some Recorded according financial year For Example from 01-04-2016 to 31-3-2017 01-04-2017 to 31-03-2018 my Code $pst = date('Y'); $pt = date('Y', strtotime('+1 year')); $sql="SELECT *FROM mytable where date BETWEEN CAST('$pst-04-01' AS DATE) AND CAST('$pt-03-31' AS DATE)"; Anyone Can explain how i done this
-
i have my own webserver for my websites but google adsense Not working on it what i do anyone can solve this Thanks In advance
-
I want to show online user in my project where 2 field in mysql table 1st onlinestoptime and 2nd onlinestarttime when user login and online show in mysql onlinestoptime value null and onlinestarttime value is timestamp (show time when user online like 09/04/2016 12:01:02) my code here but not working so How i done and show online user <? date_default_timezone_set('Asia/Kolkata'); $dt=date('Y-m-d h:i:s '); echo $sql="SELECT *FROM mytable where onlinestoptime like '%%' and onlinestarttime<'$dt' "; $val=mysql_query($sql); ?> Thanks in advance
-
Hello Everyone I M in Problem i Am creat my 1st project for client so plesese help me that how i done i need how i calculate field in php like this Pic total of Credit total of debit and pending balance and grand total So tell Me how i done Below i attecthed
-
Thanks Dear justsomeguy Sir plz fully describe its becuase its not on any other compny used server its my local server made by me so plz tell me how i done all its
-
Hello Every One I Need Help about How i connect mysql Remotely i want use my database from my server ip to other hosting account How I done using php Thanks in Advance
-
Hello Everyone I Need Wordpress User Password as taxt formate(User Entered ex 12345678)For Spl perpose how i done plz help me Thanks in advance
-
Hello Every one I need help plz help me How i done this User can Pay Half payment in WooCommerce and user can edit payment before pay exam any item prince 600rs user can edit for payment 500 pending 100rs user can payment aftr 30day etc and User my acount show All transection credit or debit total and Show Pending Ammount etc Plz help me
-
Hello every one anyone can solve my prob my database not save my html data in mysql i want to save my hrml data in mysql but its work only for 755 characters after 755 755 no data save in database so plz tell me how i save my html 8000 characters data how to save in my db Thanks