VeronMan

Ah well, and yeah, I thought it would be a "quick fix", but obviously not to be. So, i'll put out the question one last time, anybody know what this error below is? MYSQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_select_db('107887')' at line 1

I didn't have that before, but after adding that I still got an error, the one below. MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_select_db('107887')' at line 1 Still related to this mysql_select_database function, what's wrong with it?

Now i'm getting: MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_select_db('107887') CREATE TABLE `songs` ( `id` int

107887

Yeah, and I agree with that wholeheartedly, but I don't need any more than what i've got in these scripts right here, and the time this has taken is a little bit annoying, but personally, I reckon this error: MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_select_db($107887) CREATE TABLE `songs` ( `id` int( is the last one, because other than this selecting the database stuff (AndyB told me to put the mysql_select_database($107887) thing in), the SQL file looks fine, and same with all the PHP scripts. This is the last error i'll ask help for, as there may be more, and I don't want to waste your time, but this last error, I require help with. Thanks again.

Hmm, ok, so basically your saying I won't be able to get these scripts working?

If I remove the "mysql_select_db($107887)" I get the error which I stated in my post up a few posts. I'm not really interested in R.T.M as I just need a quick-fix sort of solution for these scripts, i'm not going to be developing my knowledge of PHP/MYSQL any further than this.

*Bump* Any help with the above error when I try to upload the SQL file?

Ack! Sorry, I rushed when I was posting that, here's the error: MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_select_db($107887) CREATE TABLE `songs` ( `id` int(

Okay, now i'm using the SQL file below, but i'm still getting yet another error message. I think it's somethink to do with my selecting of the database. ??? mysql_select_db($107887) CREATE TABLE `songs` ( `id` int(10) NOT NULL auto_increment, `artist` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `URL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `videos` ( `id` int(10) NOT NULL auto_increment, `picture` varchar(255) NOT NULL, `artist` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `URL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `ringtones` ( `id` int(10) NOT NULL auto_increment, `artist` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `URL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `backingmusic` ( `id` int(10) NOT NULL auto_increment, `artist` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `midURL` varchar(255) NOT NULL, `docURL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `projects` ( `id` int(10) NOT NULL auto_increment, `picture` varchar(255) NOT NULL, `language` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `URL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `pictures` ( `id` int(10) NOT NULL auto_increment, `pic` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `programs` ( `id` int(10) NOT NULL auto_increment, `picture` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `URL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); ---------------------------------------------------------------------- CREATE TABLE `codes` ( `id` int(10) NOT NULL auto_increment, `code` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `Users` ( `id` int(10) NOT NULL auto_increment, `Username` varchar(255) NOT NULL, `Password` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `Email` varchar(255) NOT NULL, `Date` varchar(255) NOT NULL, `Level` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); ---------------------------------------------------------------------- CREATE TABLE `animation` ( `id` int(10) NOT NULL auto_increment, `title` varchar(255) NOT NULL, `episodes` varchar(255) NOT NULL, `language` varchar(255) NOT NULL, `price` varchar(255) NOT NULL, `numcds` int(10) NOT NULL, PRIMARY KEY (`id`) ); Now what's the problem?

Cool, that worked fine, but now i'm getting this. Error SQL query: CREATE TABLE `songs` ( `id` int( 10 ) NOT NULL AUTO_INCREMENT , `artist` varchar( 255 ) NOT NULL , `title` varchar( 255 ) NOT NULL , `size` varchar( 255 ) NOT NULL , `URL` varchar( 255 ) NOT NULL , PRIMARY KEY ( `id` ) ); MySQL said: #1046 - No Database Selected There seems to be nothing wrong with the code...

Oh man, this is starting to suck real bad. Just tried to upload the SQL file I was given (below), and it came up with the following error: MySQL said: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `videos` ( `id` int(10) NOT NULL auto_increment And here's the SQL file, hopefully someone can quickly fix this up. CREATE TABLE `songs` ( `id` int(10) NOT NULL auto_increment, `artist` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `URL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `videos` ( `id` int(10) NOT NULL auto_increment, `picture` varchar(255) NOT NULL, `artist` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `URL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `ringtones` ( `id` int(10) NOT NULL auto_increment, `artist` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `URL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `backingmusic` ( `id` int(10) NOT NULL auto_increment, `artist` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `midURL` varchar(255) NOT NULL, `docURL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `projects` ( `id` int(10) NOT NULL auto_increment, `picture` varchar(255) NOT NULL, `language` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `URL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `pictures` ( `id` int(10) NOT NULL auto_increment, `pic` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `programs` ( `id` int(10) NOT NULL auto_increment, `picture` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `size` varchar(255) NOT NULL, `URL` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ---------------------------------------------------------------------- CREATE TABLE `codes` ( `id` int(10) NOT NULL auto_increment, `code` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `Users` ( `id` int(10) NOT NULL auto_increment, `Username` varchar(255) NOT NULL, `Password` varchar(255) NOT NULL, `Name` varchar(255) NOT NULL, `Email` varchar(255) NOT NULL, `Date` varchar(255) NOT NULL, `Level` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ---------------------------------------------------------------------- CREATE TABLE `animation` ( `id` int(10) NOT NULL auto_increment, `title` varchar(255) NOT NULL, `episodes` varchar(255) NOT NULL, `language` varchar(255) NOT NULL, `price` varchar(255) NOT NULL, `numcds` int(10) NOT NULL, PRIMARY KEY (`id`) ) Thanks for your time everyone!

Well, i'd just like to say thanks to everybody here on this forum that's helped me out with these scripts, and I know it's been a long and tedious process, but you've been great! Now, I managed to conjure up an SQL file from the scripts' author, so that should work perfectly! Once again, thanks for all your help!

Okay, so where's the problem lie in the "Unknown column 'Name' in 'field list'?" thing then?

Okay, so thats the SQL file there, posted above, what's wrong with my table? I posted my PHP register code on page 2 of this thread, so could somebody fix up the SQL table please? Thanks for your help!