[RESOLVED] Help with if code

PHPNewboy

i need to write a statement in php or sql to compare two results from a database

ie table has columns "predicted" and "actual" i need to check wheter the two have the same results in them and if they do run a query

i thought it would be like

if ( $predicted = $ $actual)
{

$query = insert whatever;

}

But not sure this is how one would do it

does any one have any hints or tips

Kudose

$query = @mysql_query("SELECT a.something FROM actual AS a, predicted AS p WHERE a.result=p.result");
$rows = mysql_num_rows($query);
if($rows !== 0)
  // do something

mykg4orce

sweet and simple and without any PHP.

PHPNewboy

Thanks for the replies Kudose and mykg4orce

i cant get that to work, sorry

would this not work instead

SELECT predicted, actual FROM table, WHERE predicted=actual

so should it be

SELECT actual,predicted FROM Table ,actual AS a, predicted AS p WHERE a.result=p.result

thanks in advance

PHPNewboy

test, dont think my reply worked

PHPNewboy

it didnt ok that didnt work,
is it as follows

SELECT predicted ,actual FROM Table AS a, predicted AS p WHERE
a.result=p.result

i keep getting errors

would this work -
select predicted,actual from table where predicted=actual;

thanks for the replies

laserlight

What is your relevant database schema (i.e., table and column names, as well as the column datatypes)? What exactly are you trying to do? Find all the rows where the predicted value is equal to the corresponding actual value? Find all rows where the predicted value is equal to some value (i.e., the actual value)?

PHPNewboy

table name is Results

columns are predicted and actual

i need to compare the values returned from these two columns and if they are the same value in the two of them

laserlight

i need to compare the values returned from these two columns and if they are the same value in the two of them

... what happens?

Kudose

SELECT actual, predicted FROM Results WHERE actual=predicted;

PHPNewboy

Thanks for the replys, i just need to compare the two field ie if prediction = 1 and result = 1 then it will display the row in which this occurance happens

i tried the "SELECT actual, predicted FROM Results WHERE actual=predicted;"
but get the following error ms - illegal mix of collations for operation '='

thanks for all the help guys

PHPNewboy

Kudose wrote:
SELECT actual, predicted FROM Results WHERE actual=predicted;

im still havin issues with this one - any one got any other ideas

Kudose

Your columns all need to have the same character set encoding and the same collation.

PHPNewboy

Kudose - your a legend

that was it one was a text one was a varchar