Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: anthracite98
- Order by date
-
primary key is an auto increment field, how can i reuse #'s
basic example users table: userID | username ----------------- 1|joe 2|jeff 3|nancy 4|phil userID is unique and autoincrement, so when i insert, i dont specify userID. if i delete jeff, then insert dave, dave gets inserted as userID:5. Is there anyway to automatically recover/reuse the deleted...- anthracite98
- Thread
- Replies: 1
- Forum: MySQL
-
mysql ?: need help with complex joins in select statements
Here's the deal. I have a table full of user info. Another table of possible music genres, another of possible subgenres (all associated with the genre table) and another table that links userInfo with subGenre. (i.e. linkID,userID,subGenreID)-since any user can have any number of associated...- anthracite98
- Thread
- Replies: 1
- Forum: MySQL
-
Need help sorting and printing file in a directory
Have a script the reads a directory of uploaded files and prints them out. I need to 1: sort them by date (newest printed first) and then 2: print the date next to the filename. Can anyone help me? thanks. -mo script below: opendir(FILES,"$SAVE_DIRECTORY"); @allfiles =...- anthracite98
- Thread
- Replies: 2
- Forum: Perl
