[RESOLVED] Trying to SELECT but returning empty result

alack06

Hey I am very new to php. I have been trying to get this php script to return a simple 'SELECT * FROM inventory' statement however I am having a problem. When I test the page I get 0 errors however it doesnt put any information in the table's cells that were created. My code is the following:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTDxhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>
    <title>Campbell Sales</title>
    <meta http-equiv="content-type" content="text/html;charset=utf-8" />
</head>

<body>

<h1>Campbell Sales</h1>

<?php

   // Connect and select a database
   // mysql_connect("localhost", "root", "");
   // mysql_select_db("cambellsales");
   $con = mysql_connect("", "root", "", "cambellsales");
   if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("cambellsales", $con);

   //Run a query
   $result = mysql_query("SELECT * FROM inventory WHERE partNumber='606 ZZ'") or die("Query failed with error: ".mysql_error());








echo "<table border='1' cellpadding='8' cellspacing='3'
	    summary=\"Table holds Cambell inventory information\">
	<tr>
	     <th>isle</th>
	     <th>col</th>
	     <th>r</th>
	     <th>rows</th>
	     <th>quantity</th>
	     <th>partnumber</th>
	     <th>surplus</th>
	     <th>description</th>
	     <th>cost</th>
	     <th>entryorder</th>
	     <th>icrr</th>
	     <th>irrc</th>
	     <th>rowm</th>
	</tr>";





// Loop through all table rows
while($row = mysql_fetch_row($result)) {
	echo "<tr>";
	echo "<td>" . $row['isle'] . "</td>";
	echo "<td>" . $row['col'] . "</td>";
	echo "<td>" . $row['r'] . "</td>";
	echo "<td>" . $row['rows'] . "</td>";
	echo "<td>" . $row['quantity'] . "</td>";
	echo "<td>" . $row['partnumber'] . "</td>";
	echo "<td>" . $row['surplus'] . "</td>";
	echo "<td>" . $row['description'] . "</td>";
	echo "<td>" . $row['cost'] . "</td>";
	echo "<td>" . $row['entryorder'] . "</td>";
	echo "<td>" . $row['icrr'] . "</td>";
	echo "<td>" . $row['irrc'] . "</td>";
	echo "<td>" . $row['rowm'] . "</td>";
	echo "</tr>";
    }

    // Free result memory and close database connection
    mysql_free_result($result);
    mysql_close($con);


 ?>
 </table>
  </body>

  </html>

dagon

I don't see any errors wit the code, are you sure there is a row with part number ''606 ZZ' ?

alack06

Yes. I tested the 'SELECT * FROM inventory' multiple times but it wasnt pulling anything up. I figured it may be because there are 4000+ rows. I added the 'WHERE' clause to see if it could display at least one row.

dagon

add

echo mysql_num_rows($result);

after $result.

dagon

   	while($row = mysql_fetch_row($result)) {

should be

   	while($row = mysql_fetch_array($result)) {

alack06

I made both of the changes. It didnt work. The table still comes up but blank...?

dagon

mysql_num_rows returned nothing? not 0 ?

alack06

Actually, it said 4101 above the table...

alack06

And when I tried it with the 'WHERE' clause it had the number 1 instead

dagon

so its returning rows, the problem is with your output of the rows

after

while($row = mysql_fetch_row($result)) {

add

print_r($row);

alack06

That put the information on the page. But it did not fill the table. It is written above it in a way that proves to be very difficult to read.

dagon

well it was for information to debug the issue. can you paste it here for me to see.

alack06

It is too much information to copy. Unless your talking about the code. I attached a small image of what the screen looks like.


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTDxhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>
    <title>Campbell Sales</title>
    <meta http-equiv="content-type" content="text/html;charset=utf-8" />
</head>

<body>

<h1>Campbell Sales</h1>

<?php

   // Connect and select a database
   // mysql_connect("localhost", "root", "");
   // mysql_select_db("cambellsales");
   $con = mysql_connect("", "root", "", "cambellsales");
   if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("cambellsales", $con);

   //Run a query
   $result = mysql_query("SELECT * FROM inventory") or die("Query failed with error: ".mysql_error());
   echo mysql_num_rows($result);








echo "<table border='1' cellpadding='8' cellspacing='3'
	    summary=\"Table holds Cambell inventory information\">
	<tr>
	     <th>isle</th>
	     <th>col</th>
	     <th>r</th>
	     <th>rows</th>
	     <th>quantity</th>
	     <th>partnumber</th>
	     <th>surplus</th>
	     <th>description</th>
	     <th>cost</th>
	     <th>entryorder</th>
	     <th>icrr</th>
	     <th>irrc</th>
	     <th>rowm</th>
	</tr>";





// Loop through all table rows
while($row = mysql_fetch_array($result)) {
	print_r($row);
	echo "<tr>";
	echo "<td>" . $row['isle'] . "</td>";
	echo "<td>" . $row['col'] . "</td>";
	echo "<td>" . $row['r'] . "</td>";
	echo "<td>" . $row['rows'] . "</td>";
	echo "<td>" . $row['quantity'] . "</td>";
	echo "<td>" . $row['partnumber'] . "</td>";
	echo "<td>" . $row['surplus'] . "</td>";
	echo "<td>" . $row['description'] . "</td>";
	echo "<td>" . $row['cost'] . "</td>";
	echo "<td>" . $row['entryorder'] . "</td>";
	echo "<td>" . $row['icrr'] . "</td>";
	echo "<td>" . $row['irrc'] . "</td>";
	echo "<td>" . $row['rowm'] . "</td>";
	echo "</tr>";
    }

    // Free result memory and close database connection
    mysql_free_result($result);
    mysql_close($con);


 ?>
 </table>
  </body>

  </html>

dagon

ok i see the problem

$row['isle']

should be

$row['Isle']

the variables are case Sensitive, all your db cols start with a capatil

alack06

THANK YOU SO MUCH. I finally got it. You have no idea how much you helped.