Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 350690" data-attributes="member: 36373">Rather than hard coding you could also make it a bit more elaborate.- I just used a premade table called &quot;texts&quot; which holds all your captioning on your hotel, just to have a field that will handle the news you want, this way you can add a page to change it VIA Housekeeping, and you can change it easily in the database without having to open up the page EVERY TIME.- You have to fetch the assoc in order to grab fields otherwise you won't be able to use the information- If you want to use this same setup, open your texts table and add identifier = &quot;news_id&quot; and display_text = &quot;2&quot; or whatever one you need.//Get$setID = mysql_fetch_assoc(mysql_query(&quot;SELECT `display_text` FROM `texts` WHERE `identifier` = 'news_id'&quot;));$news = mysql_query(&quot;SELECT * FROM cms_news WHERE id = '&quot;.$setID['setID'].&quot;'&quot;);- You can use this to simply post a form to update the news ID in your housekeeping//Set&lt;?phpif(isset($_POST['newsID']){$newID = filter($_POST['newsID']);if(is_numeric($newID)){mysql_query(&quot;UPDATE `texts` SET `news_id` = '&quot;.$newID.&quot;' WHERE `identifier = 'news_id'&quot;);}else{echo &quot;Not Numeric&quot;;}}None of this code is testing, I just coded it on my phone. Enjoy <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /></blockquote>

[QUOTE="JayC, post: 350690, member: 36373"] Rather than hard coding you could also make it a bit more elaborate. - I just used a premade table called "texts" which holds all your captioning on your hotel, just to have a field that will handle the news you want, this way you can add a page to change it VIA Housekeeping, and you can change it easily in the database without having to open up the page EVERY TIME. - You have to fetch the assoc in order to grab fields otherwise you won't be able to use the information - If you want to use this same setup, open your texts table and add identifier = "news_id" and display_text = "2" or whatever one you need. //Get $setID = mysql_fetch_assoc(mysql_query("SELECT `display_text` FROM `texts` WHERE `identifier` = 'news_id'")); $news = mysql_query("SELECT * FROM cms_news WHERE id = '".$setID['setID']."'"); - You can use this to simply post a form to update the news ID in your housekeeping //Set <?php if(isset($_POST['newsID']){ $newID = filter($_POST['newsID']); if(is_numeric($newID)){ mysql_query("UPDATE `texts` SET `news_id` = '".$newID."' WHERE `identifier = 'news_id'"); }else{ echo "Not Numeric"; } } [B][I]None of this code is testing, I just coded it on my phone. Enjoy :)[/I][/B] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members