Not finding results in db.

Anon

Can someone please help?

When searching for matching entries on a mysql database from a php page a result is only displayed if you search for the first entry on the db.

Other entries cannot be found even though they do exist.

What's going on?

Thanks,

Dave.

Anon

I have deleted the only user that gets found and now no-one can be found. I don't think it is a problem with the code, but here it is:

<PRE><?
// script to query inventory based on user-entered text strings

// connection information
$hostName = "localhost";
$userName = "username";
$password = "password";
$dbName = "sim";

// make connection to database
mysql_connect($hostName, $userName, $password) or die( "Unable to connect to host $hostName");

mysql_select_db($dbName) or die( "Unable to select database $dbName");

// Select all the fields in the sim table for
// records that match the form entries
$query = "SELECT * FROM sim WHERE User = '$Usersname' ORDER BY User";

$result = mysql_query($query);

// Determine the number of rows
$number = mysql_numrows($result);

if ($number == 0) {
print "Sorry, no SIM cards have been sent to $Usersname. Is the spelling correct?<a href='javascript:history.back()'><< Back</a>";
} else {
print "There are $number matching records in the inventory:
<table cellpadding=5 border=1 bordercolor='#000000'>
<tr bgcolor=black>
<td>User Name</td>
<td>Payroll</td>
<td>Remedy</td>
<td>SIM Number</td>
<td>Date Sent</td>
<td>Address</td>
<td>Senders Name</td>
<td>Fault Description</td>
<td>SIM ID</td></tr>";
// Print the results
for($i=0; $i<$number; $i++){
$User = mysql_result($result,$i, "User");
$Payroll = mysql_result($result,$i, "Payroll");
$Remedy = mysql_result($result, $i, "Remedy");
$Details = mysql_result($result, $i, "Details");
$SimNumber = mysql_result($result, $i, "SimNumber");
$DateSent = mysql_result($result, $i, "DateSent");
$Address1 = mysql_result($result, $i, "Address1");
$Address2 = mysql_result($result, $i, "Address2");
$Address3 = mysql_result($result, $i, "Address3");
$Postcode = mysql_result($result, $i, "Postcode");
$AgentName = mysql_result($result, $i, "AgentName");
$id = mysql_result($result, $i, "id");
/ print even-numbered rows with a grey background,
odd-numbered with a white background /
if ($i%2 == 0) {
print "<tr bgcolor=lightgrey>";
} else {
print "<tr>";
}
print "<td>$User</td>
<td>$Payroll</td>
<td>$Remedy</td>
<td>$SimNumber</td>
<td>$DateSent</td>
<td>$Address1 $Address2 $Address3 $Postcode</td>
<td>$AgentName</td>
<td>$Details</td>
<td align='center'>$id</td></tr>";
}
print "</table>";
}

// Close the database connection
mysql_close();

?></PRE>

Anon

You have $Username and $userName, those are different variables.

Anon

Are these three: 'userName' 'username' 'Usersname' suposed to be the same variables? (Please note the S in the third!) Maybe you want to use: $userName = "$username"; ??

If not: Watch out not to use too many similar variables: It can get you completely confused!

$userName = "username";

...

$query = "SELECT * FROM sim WHERE User = '$Usersname' ORDER BY User";

Cheers,

leatherback

Author: J Ferwerda (cc118315-a.ensch1.ov.nl.home.com)
Date: 2002-03-12 12:05:11

Are these three: 'userName' 'username' 'Usersname' suposed to be the same variables? (Please note the S in the third!) Maybe you want to use: $userName = "$username"; ??

If not: Watch out not to use too many similar variables: It can get you completely confused!

$userName = "username";

...

$query = "SELECT * FROM sim WHERE User = '$Usersname' ORDER BY User";

Cheers,

Anon

You folks are definately right.

After renaming the variables I got it to work.

Thanks a million.