I m used to doing them in SQLServer- but I ve had no luck getting them to work in MySql.

Basically- I want to do something like:
select @Matches = count(*) from Table;
if(@Matches>0) then
update Table set Row1 = @Param;
else
insert into Table (Row1) values @Param;

If there s a different construct that If-Then-Else in MySql that lets you do this- that would be fine too.

Pertaining we have 100 results- I only want to get the first- the eleventh- and etc... how can i query it in mysql in just one query? Please HELP....

Can MySQL query results have a temporary numbering field (as in- 1- 2- 3- 4- 5) that s different from the field showing IDs?

Okay- I will admit this. This is a homework question but I flipping through my Windows 2000 Server book and I am unable to find anything on it (Still flipping through the book- its huge.. >.< ) and I have tried Googling the question but most of the articles deal with MySQL or say go Linux.

From where I remember on MySQL/PHP servers there is a "www" folder that basically webmasters would have access to but I don t believe it is the same for Windows Server 2000 or even Windows Server 2003. Any direction to the answer would be helpful. Thanks! :P
Basically- I came down to something along these lines for the answer...
"A webmaster should have access to the folders that have to deal with the publishing of the website- a mock-test of the website for testing- and basically folders that deal with the website in general with limited access. Also- if the backups of the website are saved on the same server- access to this material would be nice if he has to start from a backup file."

I believe this sounds correct but any additional information would be helpful from the peanut gallery. :P

i have over 10-000 articles in a table and i want to organize them by alphabet- so i need to scan all the titles and figure out the first string to see if it should go under A-B-C... or not...
is there a way to do is easily?
THANKS