Resource No 6

[davespring]

Im having trouble returning the amount of rows in a mysql table? Any ideas why resource id 6 is appearing?

<?php
session_start();
$page = array();
$page['title'] = 'OpenTheBox | DuffLotto';
$slot = $_SESSION['slot'];
$name = 'duffrynmad';
if (!$slot) {
	echo 'No slot chosen! &nbsp;'; echo "<a href=otb.php>Click here go back and play again.</a>";
	die();
	exit();
}
include('header.php');
require_once('/home/davespri/hidden/dbcon.php');
$connect = mysql_connect($host, $user, $pass);
if (!$connect) {
	echo 'Failure to connect to Database';
	die();
	exit();
}
mysql_select_db('davespri_Gamerecords', $connect);
$val = mysql_query("SELECT * FROM OpenTheBox2 WHERE Slot = '$slot' ");
$val2 = mysql_fetch_array($val);
if (!$val) {
	echo 'Spot not validated';
	echo $val2['Nickname'];
	exit();
	die();
}
if (!$val2['Nickname'] == null) {
	echo 'Slot already purchased, please go back and choose another slot';
	echo '<a href=otb.php><button>Click here to go back to the selction menu</button></a>';
	die();
}


$update = mysql_query("UPDATE OpenTheBox2 SET Nickname = '$name' WHERE Slot = '$slot' ");
if ($update) {
	echo 'Transaction successful!';
	echo 'You have been given slot&nbsp;'; echo $slot; echo '<br />';
	echo '<a href=otb.php><button>Click here to go back to the selection menu</button></a>';
}

$sql = "SELECT * FROM OpenTheBox2 WHERE Nickname IS null";
$result = mysql_query($sql,$connect);

if ($result == 0) {
	mysql_query("UPDATE OpenTheBox2 SET Nickname = NULL ");
	}
echo '<br />';
echo $result;

include('footer.php');
?>

Its the thats causing the problems

$sql = "SELECT * FROM OpenTheBox2 WHERE Nickname IS null";
$result = mysql_query($sql,$connect);

[Kudose]

$result is a resource identifier (to the query), not the data. You need to fetch it as well.

[davespring]

Which function of mysql should I use?

[Kudose]

I would use mysql_fetch_assoc

echo '<br />';
$result = mysql_fetch_assoc($result);
print_r($result); // since mysql_fetch_assoc returns an array 

[Kudose]

Also, you should use either [man]die[/man] or [man]exit[/man] as a die before an exit never gets to the exit and an exit before the die never gets to the die.

You should use die to provide information as to why the script died, but should not use die with this information in a production environment. You should use exit there and have your own logging in place.

mysql_query() or die(mysql_error())

[Weedpacket]

Kudose wrote:

Also, you should use either die or exit as a die before an exit never gets to the exit and an exit before the die never gets to the die.

In fact they do exactly the same thing; and you know what they say: "you can only die once".