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!

Okay, here's my exported phpMyAdmin file. -- phpMyAdmin SQL Dump -- version 2.9.2-rc1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Apr 02, 2007 at 03:43 AM -- Server version: 4.0.26 -- PHP Version: 4.4.2 -- -- Database: `107887` -- CREATE DATABASE `107887`; USE 107887; -- -------------------------------------------------------- -- -- Table structure for table `Names` -- CREATE TABLE `Names` ( `names` varchar(80) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table `Names` -- -- -------------------------------------------------------- -- -- Table structure for table `Users` -- CREATE TABLE `Users` ( `firstname` varchar(30) NOT NULL default '', `surname` varchar(30) NOT NULL default '', `email` varchar(80) NOT NULL default '', `username` varchar(50) NOT NULL default '', `password` varchar(18) NOT NULL default '', `confirm` varchar(18) NOT NULL default '', `Names` varchar(50) NOT NULL default '' ) TYPE=MyISAM COMMENT='Registration Table'; -- -- Dumping data for table `Users` -- -- -------------------------------------------------------- -- -- Table structure for table `codes` -- CREATE TABLE `codes` ( `activation` varchar(6) NOT NULL default '', `code` varchar(6) NOT NULL default '', `id` varchar(10) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table `codes` -- -- -- Database: `test` -- CREATE DATABASE `test`; USE test; Right now, i'm also attempting to obtain an SQL file from the creator of these PHP scripts, but I don't think he has one. But worth a try!

*Bump* Any help with the error: Unknown column 'Name' in 'field list'?

The error: Unknown column 'Name' in 'field list'

*Bump* Can anybody help with the current error message i'm recieving?

I'm still getting the error after messing around with the database a bit, so what exactly do I need to do? Add the field Names to the Users table? Create a table called Names? I'm really confused. ???

Sorry about that DeathStar. Anyway, so, yeah, I'm getting this error now: Unknown column 'Name' in 'field list' How do I fix that up?

No, sorry, I wasn't.

Done, but now i'm getting: Unknown column 'Name' in 'field list' What's wrong here?

Ah, no, I have no SQL file. There's no doc either. So now i've added a table called codes, and in that table there's a field called code. Now, i'm getting the error: Unknown column 'id' in 'where clause' What's the problem with this? :-\

Ok, what should the other two entries be? And yes, the PHP script was supplied to me.