Sqlite - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=41187.0&return_msg=41187.2"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=41187.1">1–7</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=41187.2">Sqlite</a> </h3> <div id="messages" data-navigation="41187_2_7_10"> <a name="a41187_2"></a><div class="message" id="message_41187_2"> <div class="message_header"> <div class="message_from"> From: CHYRON (DSMITHHFX)<span class="message_time"> 4 Sep 2014 15:33</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">2 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41187.2">41187.2</a></div> <div class="message_body"> At last (& at least) I'm now getting a value out of a query:<br /> <div class="quotetext"><strong>Code:</strong> </div> <pre class="code"> $stH = stPrep("SELECT * FROM schools ORDER BY ID DESC LIMIT 1"); stExec($stH,null); $row = $stH->fetch(PDO::FETCH_NUM); $newschool = $row[0]; echo '<pre>'; var_dump($newschool); echo '</pre>';</pre> <s>However var_dump returns</s> <div class="quotetext"><s><strong>Code:</strong> </s></div> <pre class="code"> <s>string(2) "11"</s></pre> <s> -- but all I want is the last digit(s). I suppose I could clean it with a regex, but isn't there a way to just get the value of that column? WTF is "string(2)"?</s><br /><br /> Oh. It worked. [extraneous stuff is what var_dump does]<div class="edit_text">EDITED: 4 Sep 2014 15:45 by DSMITHHFX</div> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41187.2&return_msg=41187.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41187.2"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41187_3"></a><div class="message" id="message_41187_3"> <div class="message_header"> <div class="message_from"> From: 99% of gargoyles look like (MR_BASTARD)<span class="message_time"> 4 Sep 2014 15:52</span> <div class="clearer"></div> </div><div class="message_to">To: CHYRON (DSMITHHFX) <span><span class="image post_read" title="Read: 4 Sep 2014 16:01"></span></span> <span class="message_count">3 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41187.3">41187.3</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41187.2#a41187_2" target="_self">41187.2</a></div> <div class="message_body"> I'm glad we were able to help. Don't hesitate to come back if you have any further problems.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41187.3&return_msg=41187.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41187.3"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41187_4"></a><div class="message" id="message_41187_4"> <div class="message_header"> <div class="message_from"> From: CHYRON (DSMITHHFX)<span class="message_time"> 4 Sep 2014 16:02</span> <div class="clearer"></div> </div><div class="message_to">To: 99% of gargoyles look like (MR_BASTARD) <span><span class="image post_read" title="Read: 5 Sep 2014 06:48"></span></span> <span class="message_count">4 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41187.4">41187.4</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41187.2#a41187_3" target="_self">41187.3</a></div> <div class="message_body"> You are a problem.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41187.4&return_msg=41187.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41187.4"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41187_5"></a><div class="message" id="message_41187_5"> <div class="message_header"> <div class="message_from"> From: Ken (SHIELDSIT)<span class="message_time"> 5 Sep 2014 00:34</span> <div class="clearer"></div> </div><div class="message_to">To: CHYRON (DSMITHHFX) <span><span class="image post_read" title="Read: 5 Sep 2014 00:42"></span></span> <span class="message_count">5 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41187.5">41187.5</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41187.2#a41187_4" target="_self">41187.4</a></div> <div class="message_body"> Good luck getting help with that problem! <span class="emoticon e_tongue" title=":-P"><span class="e__">:-P</span></span> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41187.5&return_msg=41187.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41187.5"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41187_6"></a><div class="message" id="message_41187_6"> <div class="message_header"> <div class="message_from"> From: CHYRON (DSMITHHFX)<span class="message_time"> 5 Sep 2014 00:45</span> <div class="clearer"></div> </div><div class="message_to">To: Ken (SHIELDSIT) <span><span class="image post_read" title="Read: 5 Sep 2014 00:46"></span></span> <span class="message_count">6 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41187.6">41187.6</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41187.2#a41187_5" target="_self">41187.5</a></div> <div class="message_body"> I'm starting to get more of a handle on PDO, previously only fucked around wif MySQL stuffs, a loong time ago.<div class="edit_text">EDITED: 5 Sep 2014 00:46 by DSMITHHFX</div> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41187.6&return_msg=41187.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41187.6"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a41187_7"></a><div class="message" id="message_41187_7"> <div class="message_header"> <div class="message_from"> From: 99% of gargoyles look like (MR_BASTARD)<span class="message_time"> 5 Sep 2014 06:49</span> <div class="clearer"></div> </div><div class="message_to">To: CHYRON (DSMITHHFX) <span><span class="image post_read" title="Read: 5 Sep 2014 09:25"></span></span> <span class="message_count">7 of 7</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=41187.7">41187.7</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=41187.2#a41187_4" target="_self">41187.4</a></div> <div class="message_body"> Well don't hesitate to come back if you <em>need </em>a problem then. Like I said, always happy to help!</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=41187.7&return_msg=41187.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="41187.7"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> </div> </body>