[SOLVED] gettype is null??

[The Little Guy]

Hey,

 

When I call news_results, and echo gettype the $sql is null, why is that? I thought I should get a resource instead.

 

Thanks for the help!

 

<?php
class News{
private $sql;
public function __construct($dir = 'ASC', $count = 3){
	$sql = mysql_query("SELECT * FROM news ORDER BY id $dir LIMIT $count") or die(mysql_error());
}
public function news_results(){
	echo gettype($sql);
	return mysql_fetch_array($sql);
}
}
?>

 

I am using the above like this:

<?php
$news = new News();
while($row = $news->news_results()){
echo $row['subject'];
}
?>

[Maq]

Do you mind sharing the correct code in case someone else runs into a similar issue?

[The Little Guy]

sure...

This line:

$sql = mysql_query("SELECT * FROM news ORDER BY id $dir LIMIT $count") or die(mysql_error());

 

Should be:

$this->sql = mysql_query("SELECT * FROM news ORDER BY id $dir LIMIT $count") or die(mysql_error());