mysql LIMIT

[Zester]

HI All,

I just can not get the LIMIT to work, I comment it out then the code work find.

Code: Select all

if ($_SESSION['playeraccess'] >= 2) {
	  	$charslots = "$invenlordmax";
  	}
else {
		$charslots = "$invenmax";
	}
		$query = "select * from `lqlotl.inventory` where `inventory.charid` = `$charid` limit 0,`$charslots` ";
  $result = mysql_query($query) or die("Could not find chars invetory ");
  $num_rows = mysql_num_rows($result);
  $result2 = mysql_fetch_array($result);
  if ($result2) {
		echo " <center>
	<h1>" . $charname . "s Inventory slots </h1><br /><br />
	<h2> Used: " . $num_rows . " out off " .  $charslots . " <h2>
	<table border='2' >
	  	<tr>
    	<th scope='col' >Slot<font color='#FFFFFF'>____ </font></th>
    	<th scope='col'>Name<font color='#FFFFFF'>____ </font

[Jackolantern]

Right after this line:

Code: Select all

$query = "select * from `lqlotl.inventory` where `inventory.charid` = `$charid` limit 0,`$charslots` "; 

echo out $query. Inspect the final SQL query produced. You can even try copy and pasting it and typing it into the SQL tab in phpMyAdmin to see how the direct SQL query produced by your code performs. If it works as expected there, then the problem is elsewhere in the script.

This is generally how I go about debugging MySQL issues in PHP

EDIT: Oh, and of course you should be using mysql_error() and mysql_errno() to get specific mysql errors right in your PHP script.

[Chris]

I think the problem lies in the `'s: Only use them when your are getting fields, tables or database names. Not when passing numbers or other data.

Code: Select all

$query = "select * from `lqlotl.inventory` where `inventory.charid` = `$charid` limit 0,`$charslots`"; 

Should be

Code: Select all

$query = "select * from `lqlotl.inventory` where `inventory.charid` = `$charid` limit 0,$charslots"; 

[Jackolantern]

Ohhh yeah, I forgot that was going to be a number. Yes, that will cause a problem. Numbers in SQL queries must be "raw", with no quotation marks or back-ticks or they are taken as strings, which will cause a type error in MySQL