sql - How to select data from database where today date between startdate and enddate? -

-

i working select data today date between startdate , enddate. have tried not work. can give me solution on it?

this have tried :

$stmt = "select tbl1.* "._const_tbl_vote." tbl1, "._const_tbl_vote_answer." tbl2" ; $stmt .= " ".$date." between tbl1.publishing_startdate , tbl1.publishing_enddate";

try adding '' around $date variable like

$stmt = "select tbl1.* "._const_tbl_vote." tbl1, "._const_tbl_vote_answer." tbl2" ; $stmt .= " '".$date."' between tbl1.publishing_startdate , tbl1.publishing_enddate";

Comments

Post a Comment

Popular posts from this blog

php - render data via PDO::FETCH_FUNC vs loop -

-
i've been using 2 methods render data. the first one: function name($id,$name){ return '<div id="'.$id.'">'.$name.'</div>'; } echo implode($pdo->query("select id,name user")->fetchall(pdo::fetch_func,'name')); the second one: $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); foreach($users $user){ echo name($user->id,$user->name); } i don't understand how pdo::fetch_func works. tried figure out. however, not well-documented. could please explain fetch mode? , also, 1 performs better? thank you. both methods wrong , have learn how use templates , how separate business logic presentation logic. $users = $pdo->query("select id,name user")->fetchall(pdo::fetch_obj); tpl::assign('users', $users); is code business logic part. then in template <?php foreach $users $row): ?> <div id="<?=$...
Read more

c# - Why won't my code write to SQL? -

-
i'm writing app store texts sql database, code throws exception saying "the variable name @par1 has been declared", i'm not sure how working , fixing if possible please =] offending code below private void smsgetter() { try { decodedshortmessage[] messages = comm.readmessages(phonemessagestatus.all, phonestoragetype.sim); sqlconnection conn = new sqlconnection("data source=*********;initial catalog=********;user id=**********;password=***********"); sqlcommand com = new sqlcommand(); com.connection = conn; conn.open(); foreach (decodedshortmessage message in messages) { //com.commandtext = ("insert smsarchives(message,blacklist) values ('" + message.data.userdatatext + "', 'yes')"); //com.executenonquery(); com.commandtext = (...
Read more

c# - Avoiding duplicate methods for Task and Task<T> -

-
i have logic task , task<t> . there way avoid duplicating code ? my current code following: public async task<socialnetworkuserinfo> getme() { return await wrapexception(() => new socialnetworkuserinfo()); } public async task authenticateasync() { await wrapexception(() => _facebook.authenticate()); } public async task<t> wrapexception<t>(func<task<t>> task) { try { return await task(); } catch (facebooknointernetexception ex) { throw new noresponseexception(ex.message, ex, true); } catch (facebookexception ex) { throw new socialnetworkexception("social network call failed", ex); } } public async task wrapexception(func<task> task) { try { await task(); } catch (facebooknointernetexception ex) { throw new noresponseexception(ex.message, ex, true); } catch (facebookexception ex) { throw new soci...
Read more