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
