sanfly Posted April 25, 2007 Share Posted April 25, 2007 In your webhost root, do you have a file called .htaccess? Quote Link to comment 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! Quote Link to comment 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!!!! Quote Link to comment 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 Quote Link to comment 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.... Quote Link to comment 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 Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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? Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.