Both seem to work beautifully!

Thanks!

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...

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...

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...

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...

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...

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?

...

Hello,

I was wondering if there anyway to Select rows where the date column falls into a certain range?

For example, heres a table


The date field is generated automatically by MySQL with...

Hi,

I have a row where it has multiple columns distinguishing the number of votes a user has.

so it'll look like this:

[ user ] [ option_1 ] [ option_2 ] [ option_3 ] [ option_4 ]
...

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