Mysql not pulling data?

i have a php page that should display results of a mysql query inside a table ... however no matter how many entries i have in the table it wont display any results
i have checked and verified the login data several times over it is all correct

i have also verified that all fields are correct and matching.

and i am getting 1 error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in index.php on line 10

please help

connect.php
[code=php]
<?php
$hostname='######';
$user='######';
$pass='######';
$dbase='######';
$connection = mysql_connect("$hostname" , "$user" , "$pass")
or die ("Can't connect to MySQL");
$db = mysql_select_db($dbase , $connection) or die ("Can't select database.");
?>
[/code]

index.php
[code=php]
<?php

error_reporting(E_ALL);
ini_set('display_errors', 'On');

include("connect.php");

$query = "SELECT * FROM join";
$result = mysql_query($query);
$num = mysql_num_rows ($result);

if ($num > 0 ) {
$i=0;
while ($i < $num) {
$id = mysql_result($result,$i,"ID");
$tagid = mysql_result($result,$i,"tagid");
$tsname = mysql_result($result,$i,"tsname");
$boatname = mysql_result($result,$i,"boatname");
$blevel = mysql_result($result,$i,"blevel");
$plevel = mysql_result($result,$i,"plevel");
$ep = mysql_result($result,$i,"ep");
$firstname = mysql_result($result,$i,"firstname");
$lastname = mysql_result($result,$i,"lastname");
$country = mysql_result($result,$i,"country");
$email = mysql_result($result,$i,"email");
$age = mysql_result($result,$i,"age");
$guild = mysql_result($result,$i,"guild");
$otherboats = mysql_result($result,$i,"otherboats");
$comments = mysql_result($result,$i,"comments");
$ip = mysql_result($result,$i,"ip");
$rank = mysql_result($result,$i,"rank");

echo "ID: $id ";
echo "Boat ID: $tagid ";
echo "TS Name: $tsname ";
echo "Boat Name: $boatname ";
echo "Boat Level: $blevel ";
echo "Pirate Level: $plevel ";
echo "EP: $ep ";
echo "First Name: $firstname ";
echo "Last Name: $lastname ";
echo "Country: $country ";
echo "Email: $email ";
echo "Age: $age ";
echo "Guild: $guild ";
echo "Other Boats: $otherboats ";
echo "Comments: $comments ";
echo "IP: $ip ";
echo "Rank: $rank ";
echo "<a href=\"update.php?id=$id\">Update</a> - <a href=\"delete.php?id=$id\">Delete</a>";
echo " ";

++$i; } } else { echo "The database is empty"; }
mysql_close();
?>
 
<a href="add.php">Add entry</a>
[/code]

i even tried to simplify it using

[code=php]
<?php
include("connect.php");

$query = "SELECT * FROM join";
$result = mysql_query($query);
$num = mysql_num_rows ($result);

echo $query;
echo $result;
mysql_close();
?>
[/code]

and still no display of results ... puzzuling

Mysql not pulling data?

jay7981

Frank_Rizzo

le_gber

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week