Help comparing mysql fields... example code inside... please help!!!!!!!!

[robbins]

i'm trying to run this in PHP Fusion to test a script out, but i can't seem to get it to work... It's the correct syntax for phpfusion since it uses it's own code stuff. Basically, I was wondering if you see any simple bugs... or anything that might have broke it. the db connection information is above it, and its working fine... so thats not it... its somewhere in the code snippet thats causing the problem.

 

Can someone give me a basic script to compare database fields against each other to see which value is higher (both ints) ... so i can run off of that...

 

<?php
$offense = $userdata[attack];
$defense = $data[security];
$lookup = $_GET['lookup'];

require_once "maincore.php";
include LOCALE.LOCALESET."members-profile.php";
include LOCALE.LOCALESET."user_fields.php";

$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='$lookup'");

if($offense < $defense) {
echo " You Lose! ";
}
elseif($offense > $defense) {
echo " You Win! ";
}

elseif($offense == $defense) {
echo " OMFG TIE.. THAT SUCKS! "
}
else {
echo "error!";
}
?>

 

[btherl]

What does dbquery() do if there is an error?