rubiks

thank you very much that has help me loads cheers matthew

I am writing up a project work i am producing reseach on mysql but i am have troble writing it down has i have to explain why i using this. what are the main advantages and disavantages of using MySQL i have reliabe and ease of use 

ok cheers i will look into it thanks very much matt

whops cheers forgot about that i get an error of Access denied for user 'web22-matthew-1'@'%' to database 'gigs'

hello there i am new to all of this and i trying to display recods from the database i have created and i am having errors [code]             <?                 //connect to mysql                 $db_gigs=mysql_connect("localhost","web22-XXX","XXX                    if (!$db_gigs) {                     // db error function                     echo db_error("$db_gigs");                     die();                     }                                     //select which database you want to edit                 mysql_select_db("gigs");                 //select the table                 $result = mysql_query("select * from gigs");                 //grab all the content                 while($r=mysql_fetch_array($result)){                                 //the format is $variable = $r["nameofmysqlcolumn"];                 $id=$r["id"];                 $event=$r["event"];                 $venue=$r["venue"];                 $date=$r["date"];                 $rating=$r["rating"];                 //display the row                 echo "$id <br> $event <br> $venue <br> $date | $rating <br />";                 }                 ?>[/code] Thats what i have now and i am getting a error which says [quote]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sites/reesweb.co.uk/public_html/mattbay/music.php on line 38[/quote] Any ideas thanks Matthew