<?php

	include("db-config.inc");

	function obtenir_butxaques($connection)

	{

		$resultat = mysql_query("SELECT id,nom FROM butxaques ORDER BY nom ASC", $connection);

		if (!$resultat)

		{

?>

			<p> <STRONG>ERROR:</STRONG> Error al obtenir

				<STRONG>gent</STRONG>! </p>

<?php

			echo "Error MYSQL:" . mysql_errno().": ".mysql_error()."<BR>";

		}

		while ($fila = mysql_fetch_row($resultat))

			$butxaques[$fila[0]] = $fila[1];

		return $butxaques;

	}

	// FUNCIONS PER GENERAR CODI HTML

	function select_butxaques($variable, $default=-1)

	{

		global $butxaques;

		echo "<SELECT name=\"$variable\">\n";

		foreach(array_keys($butxaques) as $i)

		{

			echo "<OPTION value=\"" .$i . "\"";

			if ($default == $i)

				echo " selected";

			echo ">" . strtohtml($butxaques[$i]) . "\n";

		}

		echo "</SELECT>";

	}

	function strforquotes($cadena)

	{

		$new= ereg_replace("\"", "&quotes;", $cadena);

		return $new;

	}

	function strfromquotes($cadena)

	{

		$new= ereg_replace("&quotes;", "\"", $cadena);

		return $new;

	}

?>