viric@0: <?php
viric@0: 	include("db-config.inc");
viric@0: 
viric@0: 	function obtenir_butxaques($connection)
viric@0: 	{
viric@0: 		$resultat = mysql_query("SELECT id,nom FROM butxaques ORDER BY nom ASC", $connection);
viric@0: 
viric@0: 		if (!$resultat)
viric@0: 		{
viric@0: ?>
viric@0: 			<p> <STRONG>ERROR:</STRONG> Error al obtenir
viric@0: 				<STRONG>gent</STRONG>! </p>
viric@0: <?php
viric@0: 			echo "Error MYSQL:" . mysql_errno().": ".mysql_error()."<BR>";
viric@0: 		}
viric@0: 
viric@0: 		while ($fila = mysql_fetch_row($resultat))
viric@0: 			$butxaques[$fila[0]] = $fila[1];
viric@0: 		return $butxaques;
viric@0: 	}
viric@0: 
viric@0: 	// FUNCIONS PER GENERAR CODI HTML
viric@0: 
viric@0: 	function select_butxaques($variable, $default=-1)
viric@0: 	{
viric@0: 		global $butxaques;
viric@0: 
viric@0: 		echo "<SELECT name=\"$variable\">\n";
viric@0: 
viric@0: 		foreach(array_keys($butxaques) as $i)
viric@0: 		{
viric@0: 			echo "<OPTION value=\"" .$i . "\"";
viric@0: 			if ($default == $i)
viric@0: 				echo " selected";
viric@0: 			echo ">" . strtohtml($butxaques[$i]) . "\n";
viric@0: 		}
viric@0: 
viric@0: 		echo "</SELECT>";
viric@0: 	}
viric@0: 
viric@0: 	function strforquotes($cadena)
viric@0: 	{
viric@0: 		$new= ereg_replace("\"", "&quotes;", $cadena);
viric@0: 
viric@0: 		return $new;
viric@0: 	}
viric@0: 
viric@0: 	function strfromquotes($cadena)
viric@0: 	{
viric@0: 		$new= ereg_replace("&quotes;", "\"", $cadena);
viric@0: 
viric@0: 		return $new;
viric@0: 	}
viric@0: 
viric@0: ?>