in a mysql_query you do not need the $c
since mccodes lite only has one database you could drop it (i still use it since its good practice and its there if i ever add a new database) as for using mysql_connect on every page you are your just using it via the "include" of mysql.php
if your going to use mccodes lite as i am i would suggest you look into getting a class file and doing it that way. class files are so much easier if you want to change a function on every page (course you could also just use functions that are added to global_func.php but thats not the same >< ) if you do pick to use a class file A simple, fast database class for PHP 4+ and MySQL is nice and the post has examples on how to use it in case your new :)