PHP - A Mysql Function Does Not Produce An Exploitable Value In A Php Script

Hey guys, I'm building an E-commerce store for a T-Shirt selling company, I've assembled the shopping cart etc correctly but I am having problems within building a forum based system for the site admin to post Bulletins and Notices to the homepage + a blogging page.
I am using a while loop which should iterate the results at the end of each cycle through my variable $postResult

Here is my code...

<?php

include_once "../scripts/db_connect.php"; // Connect to the database
// Get the section ID from the url variable coming in
$sqlout = mysql_query("SELECT * FROM blog_posts ORDER BY ordered ASC LIMIT 10");

if (isset($_GET['id']) && $_GET['id'] != "") {
   $sid = preg_replace('#[^0-9]#i', '', $_GET['id']); // filter all characters except numbers for security
} else {
   echo "ERROR: Variables to run this script have been removed from the URL.";
   exit();
}
// Query the database for that section id, make sure it exists and get the section title
$sql = mysql_query("SELECT * FROM blog_category WHERE forum_id='$sid' LIMIT 1");
$numRows = mysql_num_rows($sql);
if ($numRows < 1) {
   echo "ERROR: That section deos not exist you have tampered with our URLs.";
   exit();
}
while($row = mysql_fetch_array($sql)){
   $sectionTitle = $row["forum_title"];
}
// Use the section ID to query the "forum_posts" table in the database to get all the threads for this section
$sql = mysql_query("SELECT * FROM blog_posts WHERE type='a' AND section_id='$sid' ORDER BY date_time DESC LIMIT 10");
$postResult = '';
$numRows = mysql_num_rows($sql);
if ($numRows < 1) {
   $postResult = "There are no threads in this section yet. You can be the first to post.";
} else {
   while($row = mysql_fetch_array($sql)){
       $thread_id = $row["id"];
      $post_author = $row["post_author"];
      $post_author_id = $row["post_author_id"];
      $date_time = $row["date_time"];
      $convertedTime = ($myAgoObject -> convert_datetime($date_time));
        $whenPost = ($myAgoObject -> makeAgo($convertedTime));
      $thread_title = $row["thread_title"];
      $dynamicList .= '<img src="style/threadPic.jpg" width="26" height="18" alt="Topic" /> ' . $post_author . ' - <a href="view_thread.php?id=' . $thread_id . '">' . $thread_title . '</a> - ' . $whenPost . '<br />';
   }
}
?>

And here is a snippet of where I echo the results in my HTML:

      <br /><br />
      <div style="margin-left:12px; "><?php echo $postResult; ?></div>
    <br /><br /><br /></td>

I have been slaving over this for hours now, the first $postResult variable will always iterate its text of "There are no threads in this section yet. You can be the first to post.", I can't see anything wrong in my SQL syntax as I have a similar set up to iterate my products to different pages and that has always worked fine

Any input on this would be great

Kind Regards

Alex.

Hi there,    My friend asked me to help him perform a task today and I was completely stumped as to how I should complete it. Being someone who is reasonably experienced with PHP programming I didn't think I would find it absolutely impossible to complete, maybe hard, but not impossible. So I wondered if someone would now be able to explain to me in order to assist me in expanding my knowledge how to complete this task.    https://www.dropbox....B8M6cr_z7a?dl=0   Here is a link to the files he sent me, please ignore the C++ section.   If anyone could help / begin to give an explanation please fire away. I feel so bad about myself for NOT knowing that I'm now motivated to learn more!   Many thanks!

im trying to write a simple script. Pretty much to scrape a page content. maybe you can help me.  This is what i got so far

<?php
$url = 'http://www.solecollector.com/forums/memberlist.php';
$output = file_get_contents($url);
echo $output;
?>

which works good. Now how could i have it navigate to the next page and run the script again, and do so untill it reaches the last page.

Any help its appreciated or point me on the right direction.

  Why doesn't this code update two mysql databases (on two servers)? What am I doing wrong?

//SERVER 1 
$link = mysql_connect("localhost","usern1","pw1"); 
mysql_select_db("db_one1"); 

//SERVER 2 
$link = mysql_connect("xxx.xxx.xx.xxx","usern2","pw2"); 
mysql_select_db("db_one2"); 

$query = "INSERT INTO db1(subject, search, News, img) VALUES('$hsubject','$key','$news','$img')"; 
$result = mysql_query($query); 

$query = "INSERT INTO db2(subject, search, News, img) VALUES('$hsubject','$key','$news','$img')"; 
$result = mysql_query($query); 

$sentOk = "The data has been added to the database."; 
echo "sentOk=" . $sentOk;