MySQL newbie seeking help and/or advice on storing data into a database. I have a poetry section I'm trying to add to my site that will allow users to submit some of their work for public viewing. An example is located here: http://www.nubiint.com/nuwoez/nuwoez.htm. By clicking on any one of the categories listed in the menu, the user is presented with a link that will allow them to complete a form and enter their text to be stored in the db I've created and made available for public viewing. The problem is that the data doesn't appear to store in the table in the database. After adding some test data I'm able to see the row added to the table, but I'm unable to see or view anything else, for instance the date(s) or data that's set as a mediumblob. How can I view this data to ensure that it is indeed in the table? Also how can I reset the ID field? After I delete the test data the ID doesn't reset, it continues to count from the last ID. Also how can I change the display of the date field? It currently shows as 0000-00-00. Is there anyway to change it to 00-00-0000???
TIA...Any response is appreciated. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
