Printing Variables from MySQL doesn't work?

markz90 · September 16, 2009

Well, I have this script to create an online text-based game, and it's not working at all. And the funny thing is that it worked some months ago, but I runned it at a webserver, now I'm doing it local.

Check the attachment.

Here's the code for the page news.php (nyheter).

<?PHP
include("config.php");
$dbres = mysql_query("SELECT * FROM `users` WHERE `login`='{$_SESSION['login']}'");
$data = mysql_fetch_object($dbres);
?>
<html>
<head>
<title>Beta</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>

<body>
<table width="100%">
  <tr>
    <td class="subTitle"><b>Nyheter</b></td>
  </tr>
  <tr>
    <td> </td>
  </tr>
  <tr>
    <td class="mainTxt">**********<br>
  <?
  $pp = 10;
  $start= ($_GET['p'] >= 0) ? $_GET['p']*$pp : 0;
  $sql = mysql_query("SELECT id FROM `news`");
  $rows = mysql_num_rows($sql);	  
  if($start > $rows){
    $start = 0;
  }
  $sql = mysql_query("SELECT * FROM `news` ORDER BY time DESC LIMIT $start,$pp");
  while($news = mysql_fetch_object($sql)){
    $time = date('d/m/Y', $news->time);
    $title = $news->title;
	$text = $news->text;
    echo"<i><b>$title</b></i> $time<br><br>$text<br><br>**********<br><br>";
  }
  print "  <tr><td align=\"center\">";
      if($rows <= $pp){
        print "&#60;&#60; &#60; 1 &#62; &#62;&#62;";
  }
      else {
        if($start/$pp == 0){
          print "&#60;&#60; &#60; ";
	}
        else{
          print "<a href=\"?p=0\">&#60;&#60;</a> <a href=\"?p=". ($start/$pp-1) ."\">&#60;</a> ";
	}
        for($i=0; $i<$rows/$pp; $i++) {
	  if($i == $start/$pp){
	    print "<u>". ($i+1) ."</u> ";
	  }
	  else{
            print "<a href=\"?p=$i\">". ($i+1) ."</a> ";
	  }
        }
        if($start+$pp >= $rows){
          print " &#62; &#62;&#62; ";
	}
        else{
          print "<a href=\"?p=". ($start/$pp+1) ."\">&#62;</a> <a href=\"?p=". (ceil($rows/$pp)-1) ."\">&#62;&#62;</a>";
	}
      }
  ?>
</td>
  </tr>  
</table>
</body>
</html>

I'm using WAMP 2.0i, here is my PHP, MySQL and Apache version:

PHP: 5.2.9-2

MySQL: 5.1.36

Apache: 2.2.11

I'm just taking a wild guess, could this be because of the versions of PHP or something? Is there any extensions of the PHP i should enable? Could anyone give me some help?

Thanks, Markz

[attachment deleted by admin]

Sign In

Printing Variables from MySQL doesn't work?

Recommended Posts

markz90

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information