Search found 7 matches

by JoeyCA
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....
by JoeyCA
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...
by JoeyCA
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
by JoeyCA
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...
by JoeyCA
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.
by JoeyCA
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...