Reply to thread

Message

<blockquote data-quote="Anonymous" data-source="post: 6822">And the fix <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />Fixes both &quot;only future&quot; and &quot;only title searched&quot;&nbsp; &nbsp; // only search for future programs&nbsp; &nbsp; $p_now = date(&quot;Ymdhis&quot;);&nbsp; &nbsp; $p_query = &quot;SELECT * FROM program WHERE (strTitle LIKE '%&quot;.$_GET[searchfor].&quot;%' OR strDescription LIKE '%&quot;.$_GET[searchfor].&quot;%') AND iStartTime &gt; &quot;.$p_now .&quot; ORDER BY iStartTime&quot;;&nbsp; &nbsp; $program = sqlite_query ($db,$p_query);My first PHP code ever&nbsp; <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" /> Kind regardsAnders</blockquote>

[QUOTE="Anonymous, post: 6822"] And the fix :-) Fixes both "only future" and "only title searched" // only search for future programs $p_now = date("Ymdhis"); $p_query = "SELECT * FROM program WHERE (strTitle LIKE '%".$_GET[searchfor]."%' OR strDescription LIKE '%".$_GET[searchfor]."%') AND iStartTime > ".$p_now ." ORDER BY iStartTime"; $program = sqlite_query ($db,$p_query); My first PHP code ever :D Kind regards Anders [/QUOTE]

Verification