Weird php error, not understanding

[andars]

alright, I have a method inside of a class that looks as follows:

function results($sql)
	{
		switch($this->config_sql_type) {
		case 'mysql':
			$query = mysql_fetch_array($sql) or die( mysql_error());
			return $query;
			break;
		case 'mysqli':
			$query = mysqli_fetch_array($sql);
			return $query;
			break;
		}
	}

Ok in another script, the file is called containing it.

The statement causing the trouble is this:

$sql = "SELECT * FROM d_config";

$config_query = $dbs->query($sql);

while( $row = $dbs->results($config_query) )
{
	$config_name = $row["name"];
	$config[$config_name] = $row["value"];
}

Everything works great, all array values assigned and such. However its like the script just stops, no errors, no timeouts, nothing, it won't do anything beyond that point unless I use the default function, rather then the method I created earlier.

while( $row = mysql_fetch_array($config_query) )
{
	$config_name = $row["name"];
	$config[$config_name] = $row["value"];
}

The above works, but I don't really want to "hardcode" the query. I can even type gibberish like this:

while( $row = $dbs->results($config_query) )
{
	$config_name = $row["name"];
	$config[$config_name] = $row["value"];
}
sdfghjjfgdgfsdrf!@T$#534564464

and I don't even get a parse error, though I know the arrays are being assigned because if I stick in the php function to print them out (http://php.net/print_r) it shows the values correctly. So something happens after that while loop, I know its not infinite, because the script would timeout and theres only 1 item in the database it can retrieve atm.

[dalecosp]

Well, the debugging phase is often tough.

How 'bout an <? echo "I'm currently at line x in script foo"; ?> after every line until you find the "blockage"?

[andars]

well, I know the error occurs after the while loop, but I'm not sure exactly what the error is.

[ahundiak]

The lack of a parse error implies that the code is never even getting included or that it's not surrounded by php tags or maybe it's commented out. Try making a simple file that just includes your dbs object, executes a the query and loops through the results. Maybe post the file if you are still having problems.

[andars]

<?php

class template
{
	function assign($var_name, $var_value)
	{
	global $tpl_array_names, $tpl_array_values;
		!$tpl_array_names ? $tpl_array_names = array("{".$var_name."}") : $tpl_array_names[] = "{".$var_name."}";
		!$tpl_array_values ? $tpl_array_values = array($var_value) : $tpl_array_values[] = $var_value;
	}

function display($display_var)
{
global $tpl_array_names, $tpl_array_values, $config;
	$tpl_file = file_get_contents("./templates/{$config["template_style"]}/$display_var");
	echo str_replace($tpl_array_names, $tpl_array_values, $tpl_file);


}

}

class sql
{
	var $config_sql_type = 'mysql';

function sconnect($host, $username, $password, $db)
{	
	switch($this->config_sql_type) {
	case 'mysql':
		mysql_connect($host, $username, $password);
		mysql_select_db($db);
		break;
	case 'mysqli':
		$link = mysqli_connect($host, $username, $password);
		mysqli_select_db($db);
		break;
	default:
		mysql_connect($host, $username, $password);
		mysql_select_db($db);

	}	
}

function query($sql)
{	
	switch($this->config_sql_type) {
	case 'mysql':
		$query = mysql_query($sql) or die( mysql_error());
		return $query;
		break;
	case 'mysqli':
		$query = mysqli_query($sql);
		return $query;
		break;
	default:
		$query = mysql_query($sql) or die( mysql_error());
		return $query;

	}	
}

function results($sql)
{
	switch($this->config_sql_type) {
	case 'mysql':
		$query = mysql_fetch_array($sql) or die( mysql_error());
		return $query;
		break;
	case 'mysqli':
		$query = mysqli_fetch_array($sql);
		return $query;
		break;
	default:
		$query = mysql_fetch_array($sql) or die( mysql_error());
		return $query;

	}
}



}

$config_host = 'localhost'; // usually localhost
$config_username = 'hedtech_be'; // sql username
$config_password = 'xxxx'; // sql password
$config_db = 'hedtech_delancey';


$config_db_prefix = 'd'; // database prefix, "yourprefix"_

define("CONFIG_TABLE", $config_db_prefix."_config"); // defines config table


$dbs = new sql();

$link = $dbs->sconnect($config_host, $config_username, $config_password, $config_db);



$sql = "SELECT * FROM d_config";

$config_query = $dbs->query($sql);



while( $row = $dbs->results($config_query) )
{
	$config_name = $row["name"];
	$config[$config_name] = $row["value"];

}


$tpl = new template();

$tpl->assign("LOGIN", "login box");

$tpl->display("new_cat.tpl");


?>

I can take out the tpl object and it doesn't change anything, usually the classes are included in other files, but I put them all in one file for debugging.