robbins Posted March 6, 2007 Share Posted March 6, 2007 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!"; } ?> Link to comment https://forums.phpfreaks.com/topic/41364-help-comparing-mysql-fields-example-code-inside-please-help/ Share on other sites More sharing options...
btherl Posted March 6, 2007 Share Posted March 6, 2007 What does dbquery() do if there is an error? Link to comment https://forums.phpfreaks.com/topic/41364-help-comparing-mysql-fields-example-code-inside-please-help/#findComment-200453 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.