I need to change data in one column of my table- example: 19870301 to 1987-03-01

How can I do this for an entire column- as I have 7 hundred something rows of data- I don t want to update every single row individually.

All the data is like this- I need to make it to the date format. but if i use the date command all my data is gone. please help

I need to know exactly what to type in-
bad data column is: CDATE
table is: cefil3

-mySQL

SendRedirect("page.jsp");

Also plz tell me what php script to write for the following:-

There should be options to enter a username and password (i know how to do this i.e. by using form ) and to click on a login button (just like how we enter into yahoo mail). Now- after clicking the login button it has to be checked whether the username and password entered are valid or not (they are stored in a MySQL table) and if valid then control should navigate to a new page say list.php

There should be a form to enter a user s username and password with a login button. Let there be multiple users so there are multiple sets of username and password on entering any of which a particular php page should open up. These username and password sets will be stored in a table inside a MySQL database. So plz tell me how to write the php code which checks for valid username and password and then redirects to a page.

There should be a form to enter a user s username and password with a login button. Let there be multiple users so there are multiple sets of username and password on entering any of which a particular php page should open up. These username and password sets will be stored in a table inside a MySQL database. So plz tell me how to write the php code which checks for valid username and password and then redirects to a page.

I am trying to select all the values from a column called "08" in reverse numerical order. When I run the following- every row returned has a value of 8- even though the actual values in the database are numbers like 236- 36- and 5. Why does the following Select statement not return the actual numerical values in the column called "08"? The column called "08" has a field type of INT(08).

$result = mysql_query ("SELECT 08 FROM May08 ORDER BY 08 DESC");

while ($row = mysql_fetch_array ($result)) {

$val=$row[ 08 ];

echo $val;

}

mysql_query("UPDATE songs SET rating = ".$rating." WHERE song_name = ".$song_name." WHERE username = ".$username." ")or die ("NOT WORKING!");

Okay- the code above doesn t work- I want it to double confirm the row that has the song_name = $song_name and the username = $username. Uh.. there s php in there too.
Thanks!