Re: MySQL query problem in conjunction with PHP

Thomas Nyman wrote: 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_

Re: MySQL query problem in conjunction with PHP

Thomas Nyman wrote: 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_Fatal

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

Re: Access to MySQL query problem

Mehta" <[EMAIL PROTECTED]> 3/29/04 12:18:37 AM >>> please include the query, you are using with no success and also specify the version of your mysql. Nitin - Original Message - From: "Ed Reed" < [EMAIL PROTECTED] > To: < [EMAIL PROTECTED] > S

Re: Access to MySQL query problem

Mehta" <[EMAIL PROTECTED]> 3/29/04 12:18:37 AM >>> please include the query, you are using with no success and also specify the version of your mysql. Nitin - Original Message - From: "Ed Reed" < [EMAIL PROTECTED] > To: < [EMAIL PROTECTED] > S

Re: Access to MySQL query problem

please include the query, you are using with no success and also specify the version of your mysql. Nitin - Original Message - From: "Ed Reed" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 29, 2004 1:27 PM Subject: Access to MySQL query proble

Access to MySQL query problem

I'm coverting an Access database to MySQL 4.1.1 and I need help with a near impossible query. In the Access DB I used a stored procedure; I think I should be able to solve this problem with a subselect in MySQL but so far I'm not having any luck. Here's the problem; In my stored precedure query I

Access to MySQL query problem

I'm coverting an Access database to MySQL 4.1.1 and I need help with a near impossible query. In the Access DB I used a stored procedure; I think I should be able to solve this problem with a subselect in MySQL but so far I'm not having any luck. Here's the problem; In my stored precedure query I

RE: MySQL Query Problem

* Kory Wheatley [...] > I'm seeing some discrepancy in the operation of the SEC_TO_TIME > function, however. Let's say my Duration is a value of 9.25. When I > multiply 9.25 by 3600, I get 33300.00. When I use > SEC_TO_TIME(33300.00), it returns 09:15:00, the correct value. But when > > I try

MySQL Query Problem

I'm working with an event calendaring system that keeps track of the time an event starts and the time the event ends. The Duration field holds a decimal value equivalent to the length of time the event lasts. Here is the description of the Schedule table which holds this field: mysql> describe

Re: MSVC++ and MYSQL++ query problem

Jeff Costanzo writes: > with this code: > > Query myQuery = pDatabase->query(); > myQuery << "Select * from repdata"; > myQuery.store(); > > I get an > Debug Assertion Failed > in file dbgheap.c > line 1017 > Expression: _BLOCK_TYPE_IS_VALIDE(pHead->nBlockUse) > > pDatabase is a pointer to a co

MSVC++ and MYSQL++ query problem

with this code: Query myQuery = pDatabase->query(); myQuery << "Select * from repdata"; myQuery.store(); I get an Debug Assertion Failed in file dbgheap.c line 1017 Expression: _BLOCK_TYPE_IS_VALIDE(pHead->nBlockUse) pDatabase is a pointer to a connection object. I am connected to the database

MySQL Query problem, possible bug?

Hello, Today, I tried to move a part of one of my websites, a forum (vBulletin, www.vbulletin.com) to a new server: a FreeBSD server. I installed the package mysql-3.23.40-unknown-freebsdelf4.3-i386.tar.gz on that server, and everything seemed to work perfectly: installation complete, and phpM

Re: MySQL query problem...

Hi What happens if you use search_users.Age between 30 and 40 search_users.Age between 35 and 35 search_users.Age = 35 I would be interested in know these results before speculating and answer. Simon On Thursday 29 March 2001 03:05, you wrote: > I am having problems with a MySQL query. I

MySQL query problem...

I am having problems with a MySQL query. I use the following query: SELECT search_users.ID FROM search_users,users WHERE search_users.Step=4 AND users.ID=search_users.ID AND search_users.Login<>'' AND search_users.LookForSex="M" AND search_users.Sex="F" AND search_users.Country="US" AND searc