[RESOLVED] No Record?

StevenB

Stuff: Linux server, phpmyadmin 2.6.4, mysql 4.0.11

Problem: I've been through this a hundred times and I can't see it. Db shows the record but page connects and shows shows no record. Here's the code:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>TEST</title>
</head>
<body>
<center>
<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td width="6"><b>UID</b></td>
<td width="50"><b>UFName</b></td>
<td width="50"><b>ULName</b></td>
<td width="50"><b>UserName</b></td>
<td width="100"><b>UEmail</b></td>
<td width="100"><b>UStreetAdd</b></td>
<td width="100"><b>UStreetAdd2</b></td>
<td width="150"><b>UserName</b></td>
<td width="100"><b>UCity</b></td>
<td width="100"><b>UState</b></td>
<td width="5"><b>UZip</b></td>
<td width="20"><b>UPhone</b></td>
<td width="20"><b>UCell</b></td>
<td width="50"><b>UDateSince</b></td>
</tr>
<tr>
<td>
<? $hostname = "myhost.com"; //changed (correct in actual code)
$username = "user_name"; //changed (correct in actual code)
$password = "password"; //changed (correct in actual code)
$usertable = "Users";
$dbName = "db_name"; //changed (correct in actual code)
MYSQL_CONNECT($hostname, $username, $password) OR DIE("DB connection failed");
@mysql_select_db( "$dbName") or die( "Unable to find database");
?>
<?
//error message (no record message)
$ERR = "Sorry we can't find that record.";
//query details table begins
$query = mysql_query("SELECT * FROM Users WHERE $metode LIKE '%$search%' LIMIT 0, 30");
while ($row = @mysql_fetch_array($query))
{
$variable1=$row["UID"];
$variable2=$row["UFName"];
$variable3=$row["ULName"];
$variable4=$row["UserName"];
$variable5=$row["UEmail"];
$variable6=$row["UStreetAdd"];
$variable7=$row["UStreetAdd2"];
$variable8=$row["UCity"];
$variable9=$row["UState"];
$variable10=$row["UZip"];
$variable11=$row["UPhone"];
$variable12=$row["UCell"];
$variable13=$row["UDateSince"];
//table layout for results 
print ("<tr>");
print ("<td>$variable1</td>");
print ("<td>$variable2</td>");
print ("<td>$variable3</td>");
print ("<td>$variable4</td>");
print ("<td>$variable5</td>");
print ("<td>$variable6</td>");
print ("<td>$variable7</td>");
print ("<td>$variable8</td>");
print ("<td>$variable9</td>");
print ("<td>$variable10</td>");
print ("<td>$variable11</td>");
print ("<td>$variable12</td>");
print ("<td>$variable13</td>");
print ("</tr>");
}
if (!$variable1)
{
print ("$ERR");
}
//end 
?>
</table>
</center>
</body>
</html>

Real Problem: Having just left the NT/access/.asp world I'm new to all of this and can't figure if it's db or code.

TIA for any help!

Steve

matt72

Is $search set?

Using @ to stop errors being displayed is a bad idea, especially when you're trying to debug issues like this. It's better to avoid the errors in the first place.

<? $hostname = "myhost.com"; //changed (correct in actual code)
$username = "user_name"; //changed (correct in actual code)
$password = "password"; //changed (correct in actual code)
$usertable = "Users";
$dbName = "db_name"; //changed (correct in actual code)

//Get the connection handle
$conn = mysql_connect($hostname, $username, $password) OR DIE("DB connection failed");
//Add the connection param
mysql_select_db( "$dbName",$conn) or die( "Unable to find database");


//error message (no record message)
$ERR = "Sorry we can't find that record.";
//query details table begins
$query = mysql_query("SELECT * FROM Users WHERE $metode LIKE '%$search%' LIMIT 0, 30");

// if > 0 rows are returned
if(mysql_num_rows($query))
{
	while ($row = mysql_fetch_array($query))
	{
		//These variables don't need to be set... See below
		$variable1=$row["UID"];
		$variable2=$row["UFName"];
		$variable3=$row["ULName"];
		$variable4=$row["UserName"];
		$variable5=$row["UEmail"];
		$variable6=$row["UStreetAdd"];
		$variable7=$row["UStreetAdd2"];
		$variable8=$row["UCity"];
		$variable9=$row["UState"];
		$variable10=$row["UZip"];
		$variable11=$row["UPhone"];
		$variable12=$row["UCell"];
		$variable13=$row["UDateSince"];
		//table layout for results 
		print ("<tr>");
		print ("<td>" . $row["UID"] . "</td>"); //Add the variables with concatenation
		print ("<td>" . $row["UFName"] . "</td>");
		print ("<td>$variable3</td>"); //etc..
		print ("<td>$variable4</td>");
		print ("<td>$variable5</td>");
		print ("<td>$variable6</td>");
		print ("<td>$variable7</td>");
		print ("<td>$variable8</td>");
		print ("<td>$variable9</td>");
		print ("<td>$variable10</td>");
		print ("<td>$variable11</td>");
		print ("<td>$variable12</td>");
		print ("<td>$variable13</td>");
		print ("</tr>");
		}
	}
}
else
{
	print ("$ERR");
}
//end 
?>

StevenB

That did the trick! Turns out my connection was good, I just corrupted the record playing with mysql.

I really like the way you showed me to rework the tables - much cleaner.

Off to muck up an upload page now,

Thanks for your help!