In MySQL I set up some users who have SELECT privileges on 4 out of 5 tables in a db. They do not have access to one table at all. In DOS I can issue "use dbname" as one of these users and the database is selected but in php the mysql_select_db fails because my users don't have SELECT rights on the database (just 4 of the tables in the database). Is there another function/approach I should be using in PHP to select the database?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem with mysql_select_db
- Thread starter mpopnoe
- Start date
- Status
Similar threads
- Locked
- Question