A database for my data - 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=35356.0&return_msg=35356.130"> <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=35356.1">1–10</a>…<a href="lmessages.php?webtag=DEFAULT&msg=35356.111">111–120</a><a href="lmessages.php?webtag=DEFAULT&msg=35356.121">121–130</a><a href="lmessages.php?webtag=DEFAULT&msg=35356.131">131–140</a><a href="lmessages.php?webtag=DEFAULT&msg=35356.141">141–150</a><a href="lmessages.php?webtag=DEFAULT&msg=35356.151">151–158</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=35356.130">A database for my data</a> </h3> <div id="messages" data-navigation="35356_130_158_10"> <a name="a35356_130"></a><div class="message" id="message_35356_130"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 6 Jun 2012 18:51</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">130 of 158</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=35356.130">35356.130</a></div> <div class="message_body"> I need some more database coding help.<br /> <br /> I have a row with a list of comma separated image filenames.<br /> <br /> eg<br /> <div class="quotetext" id="code-"><b> code:</b></div><pre class="code">image1.jpg,image2.jpg,image3.jpg,image4.jpg</pre><br /> <br /> I generally PHP echo out the contents of a row using a nice and simple<br /> <div class="quotetext" id="code-PHP"><b>PHP code:</b></div><pre class="code">{$row[images]}</pre><br /> <br /> That would obviously just chuck out the text with the commas, useless. I want each imagen.jpg wrapped in some HTML without the commas.<br /> eg<br /> <div class="quotetext" id="code-HTML"><b>HTML code:</b></div><pre class="code"><img src="image1.jpg" /><img src="image2.jpg" /><img src="image3.jpg" /><img src="image4.jpg" /></pre><br /> <br /> HOW?!</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=35356.130&return_msg=35356.130" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="35356.130"> <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="a35356_131"></a><div class="message" id="message_35356_131"> <div class="message_header"> <div class="message_from"> From: Drew (X3N0PH0N)<span class="message_time"> 6 Jun 2012 18:58</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 6 Jun 2012 18:58"></span></span> <span class="message_count">131 of 158</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=35356.131">35356.131</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=35356.130#a35356_130" target="_self">35356.130</a></div> <div class="message_body"> <div class="quotetext" id="code-php"><b>php code:</b></div><pre class="code">$blah = split(",", $row[images]); foreach ($blah as $beep) { echo "<img src=\"" . $beep . "\" />"; } </pre><br /> <br /> Probably a neater way which PB or Matt will come along and embarrass me with.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=35356.131&return_msg=35356.130" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="35356.131"> <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="a35356_132"></a><div class="message" id="message_35356_132"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 6 Jun 2012 19:29</span> <div class="clearer"></div> </div><div class="message_to">To: Drew (X3N0PH0N) <span><span class="image post_read" title="Read: 6 Jun 2012 19:42"></span></span> <span class="message_count">132 of 158</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=35356.132">35356.132</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=35356.130#a35356_131" target="_self">35356.131</a></div> <div class="message_body"> <p>And how do I pop that within a current big echo?</p> <p> </p> <p>I'm trying (honest <span class="emoticon e_embarrassed" title=":$"><span class="e__">:$</span></span> )</p></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=35356.132&return_msg=35356.130" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="35356.132"> <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="a35356_133"></a><div class="message" id="message_35356_133"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 6 Jun 2012 19:41</span> <div class="clearer"></div> </div><div class="message_to">To: Drew (X3N0PH0N) <span><span class="image post_read" title="Read: 6 Jun 2012 19:42"></span></span> <span class="message_count">133 of 158</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=35356.133">35356.133</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=35356.130#a35356_131" target="_self">35356.131</a></div> <div class="message_body"> To help more, I'd like the images somewhere within this lot....<br /> <br /> <div class="quotetext" id="code-PHP"><b>PHP code:</b></div><pre class="code"> $car = $_GET['car']; $query = "SELECT * FROM cars WHERE carcode = '$car' "; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) echo " <table> <tr> <th rowspan='5'><a href='#'><img src='./photos/{$row[thumb]}' /></a> <br /> <td colspan='2' width='300px'><a href='car.php?car={$row[carcode]}'>{$row[title]}</a></td> </tr> <tr> <td width='250px'>{$row[year]}<br /> {$row[mileage]}<br /> {$row[engine]}<br /> {$row[fuel]}<br /> {$row[gearbox]}<br /> </td> <td width='250px'>{$row[colour]}<br /> {$row[mot]}<br /> {$row[tax]}<br /></td> </tr> <tr> <td colspan='2'>{$row[extra]}</td> </tr> <tr> <td colspan='2' align='right' valign='bottom'><b>&pound;{$row[price]}</b></td> </tr> <tr> <td colspan='2'>FULL WIDTH</td> </tr> </table> "; </pre></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=35356.133&return_msg=35356.130" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="35356.133"> <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="a35356_134"></a><div class="message" id="message_35356_134"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 6 Jun 2012 19:49</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">134 of 158</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=35356.134">35356.134</a></div> <div class="message_body"> <p>I think I'm doing this totally wrong, because I actually want to do some stuff with the output from the other rows depending on what it is rather than just showing their content.</p> <p> </p> <p>Back to the drawing board possibly.</p></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=35356.134&return_msg=35356.130" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="35356.134"> <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="a35356_135"></a><div class="message" id="message_35356_135"> <div class="message_header"> <div class="message_from"> From: Drew (X3N0PH0N)<span class="message_time"> 6 Jun 2012 19:50</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 6 Jun 2012 19:54"></span></span> <span class="message_count">135 of 158</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=35356.135">35356.135</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=35356.130#a35356_133" target="_self">35356.133</a></div> <div class="message_body"> Indicate where in that you'd want the images. But essentially you'd do...<br /> <br /> <div class="quotetext" id="code-"><b> code:</b></div><pre class="code"> $blah = split(",", $row[images]); foreach ($blah as $beep) { $stringading .= "<img src=\"" . $beep . "\" />"; } </pre><br /> <br /> And then just add $stringading in where you want the images echoed. So like...<br /> <br /> <div class="quotetext" id="code-"><b> code:</b></div><pre class="code"> $car = $_GET['car']; $query = "SELECT * FROM cars WHERE carcode = '$car' "; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) echo " <table> <tr> <th rowspan='5'><a href='#'><img src='./photos/{$row[thumb]}' /></a> <br /> <td colspan='2' width='300px'><a href='car.php?car={$row[carcode]}'>{$row[title]}</a></td> </tr> <tr> <td width='250px'>{$row[year]}<br /> {$row[mileage]}<br /> {$row[engine]}<br /> {$row[fuel]}<br /> {$row[gearbox]}<br /> </td> <td width='250px'>{$row[colour]}<br /> {$row[mot]}<br /> {$row[tax]}<br /></td>" . $stringading . " </tr> <tr> <td colspan='2'>{$row[extra]}</td> </tr> <tr> <td colspan='2' align='right' valign='bottom'><b>&pound;{$row[price]}</b></td> </tr> <tr> <td colspan='2'>FULL WIDTH</td> </tr> </table> "; </pre><br /> <br /> (which is a nonsensical place to dump them but you get the idea)<br /> <br /> If you want more code around them, like table cells or whatever you'd do it in the foreach loop like:<br /> <br /> <div class="quotetext" id="code-"><b> code:</b></div><pre class="code"> $blah = split(",", $row[images]); $stringading = "tr"; foreach ($blah as $beep) { $stringading .= "<td><img src=\"" . $beep . "\" /></td>"; } $stringading .= "</tr>"; </pre></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=35356.135&return_msg=35356.130" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="35356.135"> <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="a35356_136"></a><div class="message" id="message_35356_136"> <div class="message_header"> <div class="message_from"> From: Drew (X3N0PH0N)<span class="message_time"> 6 Jun 2012 19:56</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 6 Jun 2012 20:17"></span></span> <span class="message_count">136 of 158</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=35356.136">35356.136</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=35356.130#a35356_135" target="_self">35356.135</a></div> <div class="message_body"> Can't edit that ^ post for some reason. Can edit other posts fine, but trying to edit that one results in a long wait and then a generic beehive 'error: retry' page thing.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=35356.136&return_msg=35356.130" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="35356.136"> <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="a35356_137"></a><div class="message" id="message_35356_137"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 6 Jun 2012 20:09</span> <div class="clearer"></div> </div><div class="message_to">To: Drew (X3N0PH0N) <span><span class="image post_read" title="Read: 6 Jun 2012 21:07"></span></span> <span class="message_count">137 of 158</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=35356.137">35356.137</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=35356.130#a35356_135" target="_self">35356.135</a></div> <div class="message_body"> <p>That shows all the images <span class="emoticon e_cheering" title="(cheer)"><span class="e__">(cheer)</span></span></p> <p> </p> <p>But it breaks everything else and nothing else outputs <span class="emoticon e_csad" title=":C"><span class="e__">:C</span></span></p></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=35356.137&return_msg=35356.130" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="35356.137"> <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="a35356_138"></a><div class="message" id="message_35356_138"> <div class="message_header"> <div class="message_from"> From: Matt<span class="message_time"> 6 Jun 2012 20:46</span> <div class="clearer"></div> </div><div class="message_to">To: Drew (X3N0PH0N) <span><span class="image post_read" title="Read: 6 Jun 2012 21:07"></span></span> <span class="message_count">138 of 158</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=35356.138">35356.138</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=35356.130#a35356_136" target="_self">35356.136</a></div> <div class="message_body"> So I see. It's getting stuck in a while loop which basically reads:<br /> <br /> <div class="quotetext" id="code-"><b> code:</b></div><pre class="code">function func_name() { while (1) { if ($condition) { func_name(); } if ($other_condition) { break; // exit the while loop } } }</pre><br /> <br /> So it's recursively calling itself, in a infinite loop. It's code Andy wrote and bless his cotton socks he really did like using variables like $a, $b, $i, $j, $tmp, which while I'm sure have meaning to him mean fuck all to me.<br /> <br /> Because I can't work it out, I'll remove it <span class="emoticon e_pipe" title=":Y"><span class="e__">:Y</span></span><br /> <br /> It's probably not important any how.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=35356.138&return_msg=35356.130" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="35356.138"> <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="a35356_139"></a><div class="message" id="message_35356_139"> <div class="message_header"> <div class="message_from"> From: Drew (X3N0PH0N)<span class="message_time"> 6 Jun 2012 21:08</span> <div class="clearer"></div> </div><div class="message_to">To: Matt <span><span class="image post_read" title="Read: 6 Jun 2012 22:22"></span></span> <span class="message_count">139 of 158</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=35356.139">35356.139</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=35356.130#a35356_138" target="_self">35356.138</a></div> <div class="message_body"> <span class="emoticon e_happycry" title=":'D"><span class="e__">:'D</span></span></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=35356.139&return_msg=35356.130" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="35356.139"> <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 class="message_page_footer"> <ul> <li class="right_col"><form accept-charset="utf-8" method="get" action="lmessages.php" target="_self"><input type="hidden" name="webtag" id="webtag" class="bhinputtext" value="DEFAULT" dir="ltr" /><input type="hidden" name="msg" id="msg" class="bhinputtext" value="35356.140" dir="ltr" /><input type="submit" name="submit" id="keep_reading" value="Keep reading…" class="button" /></form></li> </ul> </div> </div> </body>