Problem with MYSQL + PHP - TutorialNinja Forum

Posted on Saturday 11th August 2007 at 04:00 PM

Diablosblizz
Diablosblizz's Avatar

Hey, I am trying to make my own news system for my site. So far, I LOVE IT! But... problems lie ahead.

I have everything working, it display's the subject and message. If there is something in the $message variable it will display read more.

My problem is with the read more... Here is the code:

PHP Code

case 'readmore':
$id = $_GET[id];
$newsie = mysql_query("SELECT * FROM `news` WHERE `id` = '$_GET[id]'");
echo '<div align="center"><table width="90%" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
 
        <tr>
          <td width="1%" align="left" valign="top"><img src="images/blue_top_left.gif" width="7" height="7" /></td>
          <td width="98%" background="images/blue_top.gif"></td>
          <td width="1%" align="right" valign="top"><img src="images/blue_top_right.gif" width="7" height="7" /></td>
        </tr>
        <tr>
          <td background="images/test.png" style="background-repeat: repeat-y; background-color: #305F7F"></td>
          <td bgcolor="#305F7F" style="padding-bottom: 3px;"><div align="center"><span class="title">'; 
		  echo $newsie[subject]; echo '</span></div></td>
 
          <td background="images/blue_right_side.gif" bgcolor="#305F7F" style="background-position: right; background-repeat: repeat-y"></td>
        </tr>
 
      </table></td>
    </tr>
    <tr>
      <td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#000000">
        <tr>
          <td><table width="100%" border="0" cellpadding="1" cellspacing="0" bgcolor="#FFFFFF" style="padding: 5px;">
            <tr>
 
              <td><font size="1"><center>';
break;

That's just the "readmore" case. You see where it says $newsie[subject]? Well where that variable is defined is where the subject SHOULD show up, but it doesn't.

Does anybody have any ideas.