Brian, Assuming your record number column is an auto-increment - read the user comments here
http://dev.mysql.com/doc/refman/4.1/en/example-auto-increment.html There are 2 methods discussed. Best Regards, Mike ----- Original Message ----- From: Brian E Boothe To: [email protected] Sent: Friday, November 03, 2006 10:29 AM Subject: [php_mysql] Index issues?? in mysql or php I need help on a project ; I have a mysql database Displaying records in a table whenever I delete one of them My record Number Stays at the last place it was so when I add another record it takes off the last place I was at Example: Record Id order number Customer 1 1234 FeedStore 2 1432 Sioux 3 1654 Whoever I delete record id 2 and 3 Then I go and add Another new record I have when I show the table Record Id order number Customer 1 1234 FeedStore 4 3455 Lyons How do I Fix this problem ? _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of ved prakash Sent: Friday, November 03, 2006 9:51 AM To: [email protected] Subject: [php_mysql] Need Help Hi All, I am new to this technology, now i am going to face interview , i want a set of interview question with answer, and if someone have any project then please send directly to me, i am very upset that i have nothing to show , can anyone help me i'll be thankfull. Regards, Ved [Non-text portions of this message have been removed] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.13.26/516 - Release Date: 11/3/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.13.26/516 - Release Date: 11/3/2006 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/php_mysql/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
