Not loading from MySQL database, i dont know whats wrong with the code

alfrin · #1 (**permalink**) 02-12-05, 01:51 AM

I changed the database table that i was using, i change what i though need to be changed, can any one help, heres the code:
it was "news" but i changed i to emc_news

Code:

<?php $page_title = "Title Here";
include 'library/config.php';
include 'library/opendb.php';

$query="SELECT * FROM `ems_news` WHERE 1";
$news = mysql_query($query);
$num = mysql_numrows($news);
mysql_close();
 ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>CSS Page Template - Three Column Pixel Perfect - Header
&amp; Footer</title>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css"
href="css/first.css" />
</head>
<body>
<?php include '/includes/header.php'; ?>
<div id="c-block">
<div id="c-col">
<h3 align="center">Three Column Pixel Perfect with Header &amp;
Footer - MK 1</h3>
<div align="center" style="color:red;">Ver 2.3</div>
<p>&nbsp;&nbsp;&nbsp;&nbsp; This program is intended to be free under the GPL/GNU liceansing and Should for <strong>NO</strong> reason whatsoever be sold at any price. The program is fully commented and should stay that way. </p>
<p> The only place in which I allocate this source to be publicly developed is at <a href="http://www.beta-projects.org" title="Beta Projects" target="_blank">Beta-Projects</a>. I would appreciate it if you kept the copyright notice on the bottom of this page when installing this on your website.</p>
<p>Also this site is built on donations and any would be appreciated. </p>
<p>&nbsp;</p>
<hr />
 <?php
 $i=$num;
 while ($i <= $num && $i > 0){
 $title=mysql_result($news,$i,"title");
 $content=mysql_result($news,$i,"content");
 echo "<strong>$title</strong><br />$content<br /><br />";
 $i--;
 }
 ?>
<br />
</div>
<!-- end of center column -->
</div>
<!-- end c-block -->
<div id="ftr" align="center">
  <p>&copy;Copyright MamerCorp 2005 </p>
  </div>
<!-- left column -->
<div id="lh-col">
     Navigation <br />
     <br />
     <br />
     <br />
     <br />
     <br />
     <br />
     <br />
  
</div>
<!-- end of left column -->
<!-- right column -->
<div id="rh-col"><br />
<h4 align="center">Right Column</h4>
<p align="center">More links?<br />
Advertisements?</p>
</div>
<!-- end of right column -->
</body>
</html>

ben.periton · #2 (**permalink**) 02-12-05, 06:27 AM

You said you changed it to emc_news but you have ems_news
query="SELECT * FROM `ems_news` WHERE 1";

alfrin · #3 (**permalink**) 02-12-05, 11:09 AM

weird, i dont know where that came from, it still doenst work after removing it

Tempestshade · #4 (**permalink**) 02-12-05, 11:50 AM

don't remove it change it to
query="SELECT * FROM `emc_news` WHERE 1";

NeverMind · #5 (**permalink**) 02-12-05, 11:59 AM

2 notes:
- use or die() after mysql_query()
- it's mysql_num_rows() not mysql_numrows().. the latter one is deprecated ..

PHP Code:


			
$news = mysql_query($query)or

die(mysql_error());



$num = mysql_num_rows($news);

I suggest you raise the error reporting level by putting:

PHP Code:


			
error_reporting(E_ALL):

at the top of each page to help you debugging your code,,,

and please use [ php ] instead of [ code ] to color your code..

alfrin · #6 (**permalink**) 02-12-05, 03:26 PM

Quote:

Originally Posted by NeverMind

2 notes:
- use or die() after mysql_query()
- it's mysql_num_rows() not mysql_numrows().. the latter one is deprecated ..

PHP Code:


			
$news = mysql_query($query)or

die(mysql_error());



$num = mysql_num_rows($news);

I suggest you raise the error reporting level by putting:

PHP Code:


			
error_reporting(E_ALL):

at the top of each page to help you debugging your code,,,

and please use [ php ] instead of [ code ] to color your code..

O, didn't see the php code, anyways ive changed the stuff but its loading from the wrong table now, which doenst make sense since it doesnt exist, on the admin page it loads from the right place, maybe it would help to show the page http://www.codingsource.org/ems/index.php and the admin page http://www.codingsource.org/ems/admin/admin.php