Search found 7 matches
- Thu Feb 12, 2004 10:08 am
- Forum: Databases
- Topic: [SOLVED] Select works, Insert, delete and update don't
- Replies: 10
- Views: 1408
- Wed Feb 11, 2004 4:56 pm
- Forum: Databases
- Topic: [SOLVED] Select works, Insert, delete and update don't
- Replies: 10
- Views: 1408
Re: Select works, Insert, delete and update don't
Ok.. This one is SOLVED. It took a long while and a lot of compiling, but it works. The fix.. Created a new user in mysql with rights to the database and tables it was going to access.. it didn't solve the problem. I then decided to update PHP incrementally.. The original build on my server was 4.0....
- Tue Feb 10, 2004 5:05 pm
- Forum: Databases
- Topic: [SOLVED] Select works, Insert, delete and update don't
- Replies: 10
- Views: 1408
Re: Select works, Insert, delete and update don't
You ask a good question about the two tables. I had thought about doing something like that, but I just copied a design I used on a page at work, modified it for the son's 'Clan' site. This is his page I am having the trouble with. Still with one table, I can't update the 0 to a 1 with the problem I...
- Tue Feb 10, 2004 11:55 am
- Forum: Databases
- Topic: [SOLVED] Select works, Insert, delete and update don't
- Replies: 10
- Views: 1408
Re: Select works, Insert, delete and update don't
Ok.. I reinstalled mysql, configured it and checked the configuration of PHP (MySQL 4.0.17, PHP 4.3.2). Everything looks good.
I can perform insers, deletes, updates and selects from the command line, but am still unable to 'write' to the database from my php web page.
Any more ideas?
TIA,
Joe
I can perform insers, deletes, updates and selects from the command line, but am still unable to 'write' to the database from my php web page.
Any more ideas?
TIA,
Joe
- Mon Feb 09, 2004 5:48 pm
- Forum: Databases
- Topic: [SOLVED] Select works, Insert, delete and update don't
- Replies: 10
- Views: 1408
Re: Select works, Insert, delete and update don't
I decided to reinstall MySQL on the server. It is a production server, but this site I am building is the only one that is database driven, and it isn't 'in production' yet. I was connecting to the database as root.. I should have had all privs. that is where I was going nuts. I have completed the r...
- Mon Feb 09, 2004 4:08 pm
- Forum: Databases
- Topic: [SOLVED] Select works, Insert, delete and update don't
- Replies: 10
- Views: 1408
Select works, Insert, delete and update don't
I went through the code adding 'or die' statements, again, nothing gets returned.
- Mon Feb 09, 2004 3:49 pm
- Forum: Databases
- Topic: [SOLVED] Select works, Insert, delete and update don't
- Replies: 10
- Views: 1408
[SOLVED] Select works, Insert, delete and update don't
I have multiple webpages using PHP that do specific funtions, ie. look at registered members, update member info, delete them and move new members to a registered members database, so they will be able to log in. I have an INSERT.. SELECT statement that works fine at the Mysql command line, but retu...