Jump to content

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


robbins

Recommended Posts

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!";
}
?>

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.