Chris Payne wrote:
I have a client who uses Lotus Notes for her database, now she wants it
converted to MySQL, is that possible? What format is notes DB in?
Basically I will write a new front-end and back-end for her so she doesn't
need notes anymore (Nasty, nasty software) but I need to import
Hello!
I'm writing a PHP script which accesses a MySQL database. As it turns
out, sometimes I get an empty row from a SELECT query which should
normally return one or more rows. The same query executed a while later,
on unchanged data, returns the rows perfectly fine. No errors are
returned,
SQL Statement:
select *,@xtotal := StkhistMonthqty06 + StkhistMonthqty07 +
StkhistMonthqty08 as total
from StkMast as sm inner join StkHist as sh using (STkCode)
where (StkAuthor like 'keller%')
and (sh.StkhistYear='2004')
and (@xtotal0);
Notice the use of @xtotal.
I have saved
Ross,
That's correct. From the MyQL manual:
Begin quote ..
In a SELECT statement, each expression is evaluated only when sent to the
client. This means that in a HAVING, GROUP BY, or ORDER BY clause, you
cannot refer to an expression that involves variables that are set in the
SELECT list.
Myles : Thanks for this info. Clears up that mystery for me.
However, when I try:
So why not: select *, (StkhistMonthqty06 + StkhistMonthqty07 +
StkhistMonthqty08) as total
.
. rest of statement ...
.
and total 0
I get a
[nativecode=1054 ** Unknown column 'total' in 'where clause']
I had
I am new in PHP. I've just started programming with php. I am going to build a
newsletter mailing of my own community.
I use a table where members' name, email and other information is stored. I would like
to send email to all member listed on member table. Could anyone give me functional
code