sql/php $searchby help

[JoMarie]

I am attempting to code a simple page to display only certain results from the table, but it is displaying all results...here is the code I have, thanks in advance everyone!

<?php

 

//new database:

$databaseName = "*******";

$username = "*********";

$password = "*********";

$hostname = "***********";

$databaseName2 = "CoffeeDistribution";

$databaseTable = "distribution";

$tableName = 'distribution';

$searchby1 = "edition";

$searchdata1 = "Worcester East";

$order = "business";

 

$connection = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");

$db = mysql_select_db($databaseName, $connection) or die("Could not select db");

 

//find out how many items are in the clients list

$result = mysql_query("SELECT * FROM distribution WHERE " . $searchby1 . "= '" . $searchdata1 . "' ORDER BY  " . $order);

$numberOfClients = mysql_num_rows($result);

 

$totalPages = ceil($numberOfClients / 10);

$currentPage = $_GET['page'];

 

//error checking

if ((empty($currentPage)) || ($currentPage < 1) || ($currentPage > $totalPages)) {

$currentPage = 1;

}

 

// echo 'COUNT: ' . $numberOfClients . ' <br />';

// echo 'totalPages: ' . $totalPages . ' <br />';

// echo 'currentPage: ' . $currentPage . ' <br /><br /><br /><br />';

 

 

 

?>

???

[JoMarie]

If it helps......Version is MySQL5.0

Thanks!

[Bifter]

You really should change your password now!!!

[JoMarie]

Thanks! Duh!! Darn Rookies!! :-\

[fenway]

Please echo the sql query.