MySQL 4.0.12 SQL statement

[Hoangsta]

before i upgraded MySQL to 4.0.12 my search engine works...now when i search it just gives me "You have not entered a search" may someone help me? My codes are below...

trim($searchterm);
if (!$searchterm)
{
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;You have not entered a search.<br><br>";
//echo "You have not entered a search. Please go <a href=\"index.html\">Back</a> and try again.";
include 'footer.php';
exit;
}
$searchterm = addslashes($searchterm);
include 'db.php';
if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("SacramentoDirectory");
$sql = "SELECT DISTINCT `business_name`,`business_address`,`bus_city`,`businessacct_state_country`,`bus_zip`,`business_phone`,`business_fax`,`webpagelink` FROM `BusinessName` WHERE business_name LIKE '%$searchterm%' LIMIT 0, 30"; 

[Mordecai]

That's not a MySQL thing, that's a PHP thing, seeing as it's an if where you're having your problem. Where're you getting $searchterm? Is it from a form? If so, are you redefining it using $GET["searchterm"] or $POST["searchterm"]?

[Hoangsta]

it's not from a form at all, my backend is phpMyAdmin 2.3.2, i stored all of my data there...

[Mordecai]

This isn't a MySQL problem, it has to be PHP, since it's something with the if. Where is it getting $searchterm?

[Hoangsta]

it's getting it from a form...sorry.

 <INPUT size=40 name=searchterm type=text> &nbsp;&nbsp;&nbsp; 
                  <INPUT type="submit" name="submit" value="search"> </TD>

[Mordecai]

Originally posted by Mordecai
Is it from a form? If so, are you redefining it using $GET["searchterm"] or $POST["searchterm"]?

[Hoangsta]

now, whatever i input in for my search is blank....is there a reason?

if ($_GET['!$searchterm'])

that works, thanks! Now, i modified my sql statement

$sql = 'SELECT DISTINCT `business_name`,`business_address`,`bus_city`,`businessacct_state_country`,`bus_zip`,`business_phone`,`business_fax`,`webpagelink` FROM `BusinessName` WHERE business_name LIKE \'%$searchterm%\' LIMIT 0, 30'; 

[Mordecai]

You can leave everything you had the same, just add this line at the top:
$searchterm = $GET["searchterm"];
or
$searchterm = $POST["searchterm"];
depending on how you sent the form. You could also use $_REQUEST[].

You can check it like this:
if (!$GET["searchterm"]) {}
or
if (!isset($GET["searchterm"]) {}

[Hoangsta]

$searchterm = $_GET["searchterm"];

that did it, thanks!!!! 🙂 what books do u use for php?

[Mordecai]

Never read a PHP book, actually.