data not displaying for mysql

danville

I am working on a search page for a site. I have wrote the following code.

Search Page:
<html>
<head>
<title>Search</title>
</head>
</body>
Search:
<form method="post" action="search.php">
<input type="text" name="search" size=25 maxlength=100>
<input type="Submit" name="Submit" value="Search">
</form>
</body>
</html>

Results Page:

<?
$db=mysql_connect("host", "user", "password");
mysql_select_db("test",$db);
$search=$_POST["search"];
$result = mysql_query("SELECT * FROM email WHERE Name LIKE '%$search%'",$db);
if($row = mysql_fetch_array($result)){
do{
printf("%s\n<br>", $row["email"]); 
}while($row = mysql_fetch_array($result));
{
    $name=$row["name"];
    echo $name;
    echo "<br>";
}
} else {
echo "No Records Found!";
}
?>

It seems to search ok, (I get no errors.), but it does not display any data from the database. IE, I searched for an email address that I knew was in the datebase the source code from the returned page looked like this.

Any help here would be great. Thanks in advance.

xblue

I hardly use do-while loops, but I think your problem may be even before that:
if($row = mysql_fetch_array($result)) is already "consuming" one row - keep in mind that it returns one row, always the next one, whenever it is called.

One way to get around this:

if(mysql_num_rows($result)>0){
    while($row = mysql_fetch_array($result)){
        // customize the output as you need
        echo $row["email"];
        echo " - ";
        echo $row["name"];
        echo "<br>";
    }
} else {
echo "No Records Found!";
}

danville

xblue

I tried the code you posted above and get the following:
- <br>

Can you think of anything else?
Thanks again!

phpmoron

Hi,

I don't know if this will make a difference, but try this:

$db=mysql_connect("host", "user", "password");
mysql_select_db("test",$db);
$search=$_POST["search"];

$result_=_mysql_query("SELECT * FROM email WHERE Name LIKE '%$search%'",$db);
$numRows = mysql_num_rows( $result );

if( $numRows > 0 ) {
    while( $row = mysql_fetch_assoc( $result ) ) {
        echo $row['email'];
        echo " - ";
        echo $row['name'];
        echo "<br>";
    }
}
else {
    echo "No Records Found!";
}

I hope that helps,
phpmoron

danville

phpmoron,
I get the same thing as before.

BuzzLY

If you are getting the same thing as before, and not "No Records Found," then the problem is most likely with your column names. Make sure you are using the correct names, and that they are using the same case. In SQL, "email" and "Email" are not the same.

It's just an assumption, but I hope you fixed this line before running the code:

$result=mysql_query("SELECT * FROM email WHERE Name LIKE '%$search%'",$db);

Remove the first two underscores. I'm sure you did, but I have learned in this business to NEVER assume 🙂

Other than that, try running the query on your server and see what it's returning.

danville

You got it Buzzly, it was a captial letter that threw everything off. Thanks for all the help.