Putting fields into an array

[apot]

im trying to get this function to work.

 

function get_fields()
{
$result = mysql_db_query($db,"SHOW FIELDS FROM product_type_prices");

$rows = array();

while ($row = mysql_fetch_assoc($result))
	{
	if ($row["Extra"] == "auto_increment") continue;

	$this_row = $row;

	if (stripos($row["Type"], "char") !== false)
		{
		$this_row["Type"] = "char";
		}
	else if (stripos($row["Type"], "date") !== false)
		{
		$this_row["Type"] = "date";
		} 
	else if (stripos($row["Type"], "int") !== false) 
		{
		$this_row["Type"] = "int";
		}
	else if (stripos($row["Type"], "dec") !== false) 
		{
		$this_row["Type"] = "dec";
		}
	$rows[$row["Field"]] = $this_row;
	}

return $rows;
}

$fields = get_fields();

echo "<PRE>";
var_dump($fields);
echo "</PRE>";

 

It works when it is not in a function but when in a function returns:

 

array(0) {

}

 

Any idea what is happening here?

[BlueSkyIS]

for your answer, add or die(mysql_error()):

 

$result = mysql_db_query($db,"SHOW FIELDS FROM product_type_prices") or die(mysql_error());

[apot]

Thanks that showed me that there is no database connection.  There is a connection at the beginning of the same script but not in the function.  Is this normal do you have to establish a connection within a function?

[BlueSkyIS]

You could try using the external connection by declaring the vars global inside of the function:

 

function xyz () {

global $db, $link, $whatever, $vars $youneedfromoutside;

 

}