sanfly Posted April 25, 2007 Share Posted April 25, 2007 In your webhost root, do you have a file called .htaccess? Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-237657 Share on other sites More sharing options...
AndyB Posted April 25, 2007 Share Posted April 25, 2007 INSERT INTO users(`username <- get rid of that backtick! Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-237673 Share on other sites More sharing options...
sanfly Posted April 25, 2007 Share Posted April 25, 2007 INSERT INTO users(`username <- get rid of that backtick! Damn Andy, your eyes are so much sharper than mine!!!! Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-237679 Share on other sites More sharing options...
laron Posted April 25, 2007 Author Share Posted April 25, 2007 not that i can see (will i have to add one? i know i did before on another website using wordpress) edit: got rid of the tick as well... still no success Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-237680 Share on other sites More sharing options...
sanfly Posted April 25, 2007 Share Posted April 25, 2007 Check out this site, shows you how to turn on error reporting via htaccess http://support.easystreet.com/hosting/unix/dynamic-config.htm seach the page for "Show PHP Errors" to get to the right spot Once you get error reporting going it should hopefully become clear where the problem lies.... Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-237692 Share on other sites More sharing options...
laron Posted April 25, 2007 Author Share Posted April 25, 2007 ok thanks for the help, ill keep serching Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-237715 Share on other sites More sharing options...
rcorlew Posted April 25, 2007 Share Posted April 25, 2007 use this as your query: <?$sql = "INSERT INTO users (username,password,email,firstname etc....... ?> You only have to use the backtics if you are using a reserved sql function as a row/cell like date that is other than the sql native funtion. Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-237732 Share on other sites More sharing options...
laron Posted April 25, 2007 Author Share Posted April 25, 2007 ok changed, still no success, i think ill talk to the hosting admin. Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-237750 Share on other sites More sharing options...
laron Posted April 25, 2007 Author Share Posted April 25, 2007 could it possibly deal with the mysql database permissions? Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-238643 Share on other sites More sharing options...
sanfly Posted April 26, 2007 Share Posted April 26, 2007 Maybe I guess, but I would think on a commercial server all accounts would have access Do you have phpMyAdmin (or something similar) access? Try going in there and inserting the query using the SQL window. I would think that error reporting in phpMyAdmin would be on by default? Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-238646 Share on other sites More sharing options...
laron Posted April 26, 2007 Author Share Posted April 26, 2007 yeah, i have access to phpmyadmin, thats how i created the table in the database. its weird, because wordpress is on the same account using a mysql database, and works fine. Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-238758 Share on other sites More sharing options...
sanfly Posted April 26, 2007 Share Posted April 26, 2007 Well, I guess its probably not permissions then. Its going to be hard to diagnose the problem without error reporting switched on. Heard anything from your webhost yet? I just had a thought. Are you using addslashes() on your values before you insert them into the database? Perhaps there is an apostrophe or something in the data that is tripping things up? Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-238803 Share on other sites More sharing options...
laron Posted April 26, 2007 Author Share Posted April 26, 2007 well, i solved the problem. not by using the current database that ive been posting about, but since i have wordpress running on the same site i just created a new table in that database vs. creating a whole new database. it seems to work flawlessly. Link to comment https://forums.phpfreaks.com/topic/48364-solved-wont-insert-anything-into-my-mysql-database/page/2/#findComment-239425 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.