Hello, verybody, currently i got one question. i create a table in mysql database to store questions which have following column fields: questionnumber, questionbody, answers and etc. My problem is if i delete one row(question) how can i update the questionnumber in the easiest way which means mysql can do for me. Is it possible? or i have to write a method to update questionnumber. Any help will be much appreciated. bin
______________________________________________________________________ Music, Movies, Sports, Games! http://entertainment.yahoo.ca --------------------------------------------------------------------- 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