Thanks, I will try that once my site comes back up. :)
Edit:
=/ same things happening..I tried this
mysql_query("INSERT INTO show
(perf, showname, showid, totalstats, petname, petid) VALUES('$perf', '$showname', '$showid', '$totalstats', '$petname', '$petid') ")
or die(mysql_error());