I hope someone might be willing to help out.
I'm trying [still] to learn MySQL and php - to create some simply web based database.
I have installed quite a few php/MySQL web database apps from books, however, none of them will get data entered into my database.
When I create the database exactly as instructed, everything works great, but when I create the form to send/add a new record to my db then look at the db the new data is not there.
This happens repeatedly with every example I build. I can add records using a terminal or phpMyAdmin.
This sounds like an access rights problem. Is your MySQL server on the same machine as the WWW server?
I assume that you have included your MySQL username/password in your PHP script, but do the access rights on the MySQL server allow access for your MySQL account from the WWW server?
You might also want to check PHP error handling and reporting .
In particular make sure your code goes something like
$result = mysql_query("SELECT my_col FROM my_tbl")
or exit ("Invalid query");
I'm running MySQL 4.0.14, Mac OS X 10.3, PHP 4.3.2.
I installed 'tasks' - http://www.versiontracker.com/dyn/moreinfo/macosx/17996
and it works just fine! but it is too big for me to use to compare to my very simple scripts.
Here is one I have recently installed whose data will not enter:
http://hotwired.lycos.com/webmonkey/99/21/index3a_page4.html? tw=programming
I believe my db connection is being made (I may be wrong), after all my phpMyAdmin app also works fine.
I would be very grateful is there might be a kind soul who would work with me to help me to find out what is wrong? I have had dbs before that worked fine, I don't understand this problem at all.
Thanks, Ted
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
