It connects fine to the MySQL database, and doesn't throw me any error messages or anything, but when I come to look at the database the table just isn't there! Thanks in advance

firepages

06-03-2004, 02:56 AM

you need to ask for the error messages ..
try adding <?echo mysql_error();?> after each SQL call

though pretty sure here its the 'desc' fieldname which though I do not think is a MySQL reserved word still causes me issues from time to time , to counter it (and its good practice anyway) enclose the fieldnames with backticks ... I just did `desc` here but you can do them all

ohh..I didn't know that, thanks! But, that's not the problem, because when that didnt work, I tried just adding a basic 2 field table username TEXT, password TEXT, and it wouldn't let me do that either. So I'm not sure what it is, but any ideas and let me know!!! Thanks

MrShed

06-03-2004, 08:51 AM

ok ive tried changing desc to description and it works!!!! No idea why my basic 1 failed b4 then. Thanks for all the help guys much appreciated