results

[0x00]

hey,

say i have a table such as this -

 

CREATE TABLE test_oh (value1 int not null, value2 int not null)

 

and did a query like so -

$query = "SELECT value1, value2 FROM test_oh WHERE (value1 * value2 >= 300) ";

how without redoing the calculation could i also get the result, say a bit like this (but not) -

 

$query = "SELECT value1, value2, x FROM test_oh WHERE (value1 * value2 >= 300) as x ";

 

thanx

[pocobueno1388]

Try this

 

SELECT value1, value2, (value1 * value2) as total FROM test_oh WHERE total >= 300

[0x00]

that doesnt work...

Unknown column 'total' in 'where clause'

 

im currently looking at subqueries, but not sure if its what i need?

$query = "SELECT value1, value2, x  FROM test_oh WHERE ( (SELECT (value1 * value2) FROM test_oh AS x) >= 300) ";

p.s. this also throws an error...

[fenway]

Try:

 

SELECT value1, value2, (value1 * value2 ) AS x FROM test_oh HAVING x >= 300