bobby08

Hello, I was wondering if there anyway to Select rows where the date column falls into a certain range? For example, heres a table [code] The date field is generated automatically by MySQL with the DATE function Heres the table: [user] . [wins]. [date] bobby.......4..... 2006-08-21 boby1.......3..... 2006-08-22 boby2.......6..... 2006-08-24 …

Hi, I wish I could solve this on my own but I tried searching and googling but nothing doing. Althought worse comes to worse, I can use Perl to do what I want, but I would prefer having a SQL syntax that can handle it. Problem: 3 columns: username, daily …

Hello, I heard SELECT COUNT(*) can take a lot of resources if your counting a table with lots and lots of rows (hundred thousands, millions). What if you add A WHERE clause to it? So something like: SELECT COUNT(*) FROM table WHERE pid = ? (pid is a index too …

Hi, im running this website,,,worked so hard on it for about 5 months straight. i got it finally up and runnin, and the first 3 months went smooth. all of a sudden my MySQL DB drops...every table inside...just GONE. my site went down and error messages were received throughout my …

hi, I decided to build a quick forum system for my site. nothing too advanced...heres the db setup i have. create table ForumsTopics ( id int auto_increment not null, topic_id varchar(7) not null, title char(100) not null, cat char(1) not null, views char(6) not null, date DATETIME not null, last_mod …

Hi everyone, I feel like such a dumb*** because I don't know how to make automatic database backups. I would love to make backups every 3 days or so. Perhaps 3 times a week would be good, not daily though. I'm using MySQL and Windows and my current method of …

Hi, I have a row where it has multiple columns distinguishing the number of votes a user has. so it'll look like this: [inlinecode] [ user ] [ option_1 ] [ option_2 ] [ option_3 ] [ option_4 ] bobby........ 1 ......... 3 ............ 7 ......... 3 [/inlinecode] Is there …

Hi, I have a calendar table that has event comments and a date tagged to it. I would like to view "Upcoming Events" only. I was wondering what type of syntax I'll need to be using? heres how the table would look: comment | d1 | d2 | d3 ---------------------------- …

Hi, I have two fields...both are not unique, but both can't be the same. So two fields: user | fruit | joe11 apple angel bananna bobby apple jeff orange julie orange angel apple angel orange ---------- So lets say the above was my table, notice how both fields are not …