Help with an sql error

[? Sparks ?]

I got one in my index page that I have absolutely no clue how to fix :S

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND us.userid != 1 AND u.user_level != 0' at line 1

Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.strength > AND us.userid != 1 AND u.user_level != 0

[Nicholas]

Re: Help with an sql error

on line 1. thats

<?php

i think

if its the index.php, here is index.php coding information

 

<?php
$housequery=1;
include "globals.php";
print "<h3>General Info:</h2>";
$exp=(int)($ir['exp']/$ir['exp_needed']*100);
print "<table><tr><td>[b]Name:[/b] {$ir['username']}</td><td>[b]Crystals:[/b] {$cm}</td></tr><tr>
<td>[b]Level:[/b] {$ir['level']}</td>
<td>[b]Exp:[/b] {$exp}%</td></tr><tr>
<td>[b]Money:[/b] $fm</td>
<td>[b]HP:[/b] {$ir['hp']}/{$ir['maxhp']}</td></tr>
<tr><td>[b]Property:[/b] {$ir['hNAME']}</td></tr></table>";
print "<hr><h3>Stats Info:</h3>";
$ts=$ir['strength']+$ir['agility']+$ir['guard']+$ir['labour']+$ir['IQ'];
$ir['strank']=get_rank($ir['strength'],'strength');
$ir['agirank']=get_rank($ir['agility'],'agility');
$ir['guarank']=get_rank($ir['guard'],'guard');
$ir['labrank']=get_rank($ir['labour'],'labour');
$ir['IQrank']=get_rank($ir['IQ'],'IQ');
$tsrank=get_rank($ts,'strength+agility+guard+labour+IQ');
$ir['strength']=number_format($ir['strength']);
$ir['agility']=number_format($ir['agility']);
$ir['guard']=number_format($ir['guard']);
$ir['labour']=number_format($ir['labour']);
$ir['IQ']=number_format($ir['IQ']);
$ts=number_format($ts);

print "<table><tr><td>[b]Strength:[/b] {$ir['strength']} [Ranked: {$ir['strank']}]</td><td>[b]Agility:[/b] {$ir['agility']} [Ranked: {$ir['agirank']}]</td></tr>
<tr><td>[b]Guard:[/b] {$ir['guard']} [Ranked: {$ir['guarank']}]</td><td>[b]Labour:[/b] {$ir['labour']} [Ranked: {$ir['labrank']}]</td></tr>
<tr><td>[b]IQ: [/b] {$ir['IQ']} [Ranked: {$ir['IQrank']}]</td><td>[b]Total stats:[/b] {$ts} [Ranked: $tsrank]</td></tr></table>";
if(isset($_POST['pn_update']))
{
$db->query("UPDATE users SET user_notepad='{$_POST['pn_update']}' WHERE userid=$userid");
$ir['user_notepad']=stripslashes($_POST['pn_update']);
print "<hr>[b]Personal Notepad Updated![/b]";
}
print "<hr>Your Personal Notepad:<form action='index.php' method='post'>
<textarea rows='10' cols='50' name='pn_update'>".htmlspecialchars($ir['user_notepad'])."</textarea>

<input type='submit' value='Update Notes' /></form>";
$h->endpage();
?>

[Lithium]

Re: Help with an sql error

 

I got one in my index page that I have absolutely no clue how to fix :S

QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND us.userid != 1 AND u.user_level != 0' at line 1

Query was SELECT count(*) FROM userstats us LEFT JOIN users u ON us.userid=u.userid WHERE us.strength > AND us.userid != 1 AND u.user_level != 0

problem is here...

... us.strength > AND us.userid != 1 ... (missing strength value)