[SOLVED] search clause help

AcidDriver · July 16, 2008

can someone identify is there is anything wrong with this search clause.

$data = mysql_query("SELECT * FROM hope WHERE upper($field) LIKE '%$find%'");

I can post the entire code if needed.

LooieENG · July 16, 2008

$data = mysql_query("SELECT * FROM hope WHERE upper('$field') LIKE '%$find%'");

I think

AcidDriver · July 16, 2008

I dont see where you changed anything. What did you do?

Well, you changed something, and removed those errors. THANKKKKKK YOU, i cant tell you how hard that was for me.

again, thank you so very very much, you saved my project.

AcidDriver · July 16, 2008

I have one more thing...

<?php

//Displays once search text is run through.

if ($_POST['searching'] =="yes")

{

echo "<h1>Your results: </h1>";

//If nothing is entered then return no search text.

if ($_POST['find'] == "")

{

echo "Please enter a search item in the query box</";

exit;

}

// Else, connect direct to the database

mysql_connect("localhost", "root", "") or die(mysql_error()); //Need to setup dedicated H.O.P.E server to link to mySQL, then input user/server info.

mysql_select_db("hope") or die(mysql_error());

//Search for search term once in database.

$data = mysql_query("SELECT * FROM hope WHERE upper('$field') LIKE '%$find%'");

I get this notice...

Notice: Undefined variable: field in H:\Documents\My Web Sites\HOPE Search Database\search.php on line 21

Notice: Undefined variable: find in H:\Documents\My Web Sites\HOPE Search Database\search.php on line 21

mike ronzetti

LooieENG · July 16, 2008

I added ' to upper('$field').

You always need to put variables inside ' marks for MySQL. (i.e. '$var' or '$_POST[example]')

Anyway, for the second question, where are $field and $find defined?

AcidDriver · July 16, 2008

they are defined in the index.html file.

<html>

<head>

<title>Welcome to the HOPE Database</title>

</head>

<body>

<h1>H.O.P.E Volunteer Database Search</h1>

Please enter your database query below.

Search: <input type="text" value="find" name="find" /> Category:

<Option value="fname">First Name</option>

<Option value="idnum">ID Number</option>

<option value="gradyear">Graduation Year</option>

</Select>

</form>

<a href="volunteer.htm">Input a new volunteer</a>

</body>

</html>

herer is the search again

<?php

//Displays once search text is run through.

if ($_POST['searching'] =="yes")

{

echo "<h1>Your results: </h1>";

//If nothing is entered then return no search text.

if ($_POST['find'] == "")

{

echo "Please enter a search item in the query box</";

exit;

}

// Else, connect direct to the database

mysql_connect("localhost", "root", "") or die(mysql_error()); //Need to setup dedicated H.O.P.E server to link to mySQL, then input user/server info.

mysql_select_db("hope") or die(mysql_error());

//Search for search term once in database.

$data = mysql_query("SELECT * FROM hope WHERE upper('$field') LIKE '%$find%'");

//Display results

while($result = mysql_fetch_array( $data ))

{

echo "";

echo $result['fname'];

echo " ";

echo $result['lname'];

echo " ID Number: ";

echo $result['idnum'];

echo " Graduation Year: ";

echo $result['gradyear'];

//echo " Donor: ";

//echo $result['donor'];

//echo " FOH/Community Partner: ";

//echo $result['foh'];

echo " Organization/Firm: ";

echo $result['org'];

//echo " HOPE Fellow: ";

//echo $result['fellow'];

//echo " HOPE Senior Fellow: ";

//echo $result['sfellow'];

//echo " Miami Scholar: ";

//echo $result['scholar'];

//echo " Public Interest Loan Reduction Recipient: ";

//echo $result['lreduce'];

echo " Home Address:";

echo $result['address'];

echo " ";

echo $result['city'] .", " .$result['state'] ." " .$result['zip'];

echo " Work Address: ";

echo $result['waddress'];

echo " ";

echo $result['wcity'] .", " .$result['wstate'] ." " .$result['wzip'];

echo " Work Phone:";

echo $result['wphone'];

echo " Fax number: ";

echo $result['fax'];

echo " Cell Phone: ";

echo $result['cphone'];

echo " Email:";

echo $result['email'];

//echo " Interests: ";

//echo $result['Interests'];

//echo " Project Leader: ";

//echo $result['project'];

//echo " HOPE Liason: ";

//echo $result['liason'];

//echo " Center for Ethics and Public Service Liason: ";

//echo $result['pliason'];

echo " Community Service Hours:";

echo $result['comtotalhours'];

echo " <dd>Project Name/Agency: </dd>";

echo $result['comagency'];

echo " <dd>Date of Project: </dd>";

echo $result['comdate'];

echo " <dd>Community Service Project Hours: </dd>";

echo $result['comhours'];

echo " Advocacy Service Hours: ";

echo $result['adtotalhours'];

echo " <dd>Project Name/Agency: </dd>";

echo $result['adagency'];

echo " <dd>Date of Project: </dd>";

echo $result['addate'];

echo " <dd>Hours Volunteered: </dd>";

echo $result['adhours'];

echo " <dd>Supervising Attorney: </dd>";

echo $result['adattorney'];

echo " <dd>Attorney Contact: </dd>";

echo $result['adattorneycon'];

//echo " Languages: ";

//echo $result['languages'];

echo " ";

}

//This counts the number or results - and if there wasn't any it gives them a little message explaining that

$matchnum=mysql_num_rows($data);

if ($matchnum == 0)

{

echo "There were no results for you mySQL query. ";

}

//Echo back what the user searched for:

echo "Searched For: " .$find;

echo "Number of Results: " .$matchnum;

echo " ";

echo '<a href="http://127.0.0.1/HOPE%20Database/index.htm">Search Again</a>';

}

?>

LooieENG · July 16, 2008

You have to define $find and $field like this

$find = $_POST['find']

Sign In

[SOLVED] search clause help

Recommended Posts

AcidDriver

Link to comment

Share on other sites

LooieENG

Link to comment

Share on other sites

AcidDriver

Link to comment

Share on other sites

AcidDriver

Link to comment

Share on other sites

LooieENG

Link to comment

Share on other sites

AcidDriver

Link to comment

Share on other sites

LooieENG

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information