db queries

[stew]

hiya! the following code gives errors for the db_query and the fetch_array.

global $retid;

if ($type = 'all') {

$SQL = " SELECT * FROM gigs ORDER BY date ";
$retid = mysql_db_query($db, $SQL, $cid);

while ($row = mysql_fetch_array($retid))  {

just wondering if anyone is abel to help?!??

thanks in advance

[stolzyboy]

<?
$conn = mysql_connect("localhost", "xxxx", "xxxx") or die ("Could not connect to database!");
$db = mysql_select_db("xxxx") or die ("Could not select database");

$query = "SELECT * FROM gigs ORDER BY date;";
$result = mysql_query($query) or die ("Could not select records");

while ($row = mysql_fetch_array($result))
{
echo $row['fieldname'];
}
?>