Connecting to db via win32 (Word or Excel)

Hi all I'm a mysql beginner. I have my database up and running and can query it via php and apache. I would like to set things up so that MSExcel and or MSWord can query the database and extract info from it. For this reason I downloaded the and installed MyODBC-standard-3.51.04-win.exe. No er

This thing called MOD

Hi All I'm a bit perplexed..perhaps its a language thing,,but the MYSQL reference manual says that MOD ..Returns the remainder of N divided by M... and gives an example SELECT MOD(234,10) --> 4 This I do not understand. remainder of N divided by M - isn't that simply divisi

MySQL query problem in conjunction with PHP

Hi I found an instruction on the net concerning "Date Arithmetic" and which seems to be exactly what I need to hel me get going..however there seems to be either a mistake on my behalf or on the writers behalf. Can anyone say whats wrong with this query $query2="UPDATE KK_Fatalie SET datum = D

Date calculation and displaying the right date

Hi All I've not been able to find a good answer to this or figure out what would be the best approach - bear in mind I am a beginner. I have tried the following > USE databas > SELECT Item_A AS 'Something 1', > Item_B AS 'Something 2', > Item_C AS 'Something 3', > INTERVAL 6 MONTH + Item_B AS 'So