Marvin, Monday, September 23, 2002, 6:52:23 AM, you wrote: MC> MySQL newbie seeking help and/or advice on storing data into a database. MC> 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. MC> 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 MC> 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 MC> I'm unable to see or view anything else, for instance the date(s) or data that's set as a mediumblob. MC> How can I view this data to ensure that it is indeed in the table? MC> 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.
You can do it with ALTER TABLE or with myisamchk -A http://www.mysql.com/doc/en/ALTER_TABLE.html http://www.mysql.com/doc/en/myisamchk_other_options.html MC> 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 MC> 00-00-0000??? Take a look at DATE_FORMAT() function: http://www.mysql.com/doc/en/Date_and_time_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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