[SOLVED] PHP + MySQL (if) help!

[rwachowiak]

<?php include 'libs/dbopen.php';
	$id = (isset($_GET['Userid']))? mysql_escape_string($_GET['Userid']) : "1";
	$query  = "SELECT SUM(week2-(week2hours*.25)) FROM staff JOIN project ON project.staff_id=staff.id WHERE project.staff_id='$id'";
	$result = mysql_query($query);
	$result = mysql_query($query) or die(mysql_error());
	while($row = mysql_fetch_array($result)){  

	if ($query >= 0)	{	echo "{$row['SUM(week2-(week2hours*.25))']}";	}
	else			{	echo "<span class='red'>({$row['SUM(week2-(week2hours*.25))']})</span>";	}
	}

	include 'libs/dbclose.php';?>

 

$query is either positive or negative, if its positive, i want it to just show as black text, if its negative i want it to show as red text with () around it... but no matter what number $query gives me, it stays black every time

 

help!

 

thanks!

[wildteen88]

You're using the wrong variable, $query holds a string which is your SQL query. You want to compare the $row['SUM(week2-(week2hours*.25))'] variable instead.

[taith]

i should also mention that

	$result = mysql_query($query);
	$result = mysql_query($query) or die(mysql_error());

 

theres no point in doubleing up that query

[rwachowiak]

wow duh thanks!