Tejpal
-
Posts
33 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts 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.dateFROM invoices,acctJOIN users ON acct.username = rm_users.usernameWHERE users.owner = 'admin' and acctstarttime between 'invoice.date' and 'users.expiration'GROUP BY MONTH( `acctstarttime` ) , acct.usernameORDER BY invoices.date DESCLIMIT 0 , 30I 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 -
no M Not Have Any Api How I Do using cUrl can u explan sir
Thanks
-
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
-
in mysql all ok field type date
i think prob in current year dynmic $cyear
and when date 1-1-$cyear then not show of 3 months
-
not show record of jan feb march
i think when date 1 jan then my condition 1-4-17 to 31-3-18
so this not working good
-
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
-
field is date/time
plese describe How i do PDO instead of the mysql extension
-
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 -
thanks sir
-
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
-
You need to configure MySQL to allow remote connections, make sure that firewalls aren't going to block anything, and then you can connect with the IP or host name.
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
-
thanks every one
-
I found my solution creating re Enter pass new field and get plan text and pass is sequre
-
i am admin dear and i want give some feacture for user so i want
-
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
-
Thanks Done
-
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
How To show category wise posts using custom fields
in PHP
Posted
not its not right answere sorry But I think thats possibal