search problems

itworks

i have a index page that works with a topFrame and a mainFrame.

in the topFrame i have a little form with a text field and a button to perform a search in a MySQL db, it's kinda like this:

<form action="search.php" method="post" name="search" target="mainFrame" onsubmit="search.php">
<input type="text" name="name" value="Search" size="15"></input>
<input type="submit" onclick="search.php" value="Search" name="Search" target="mainFrame"></input>

it calls the search.php script to process and display the results in the mainFrame.

the problem is that you have to type in the search term exactly, otherwise it won't show any results.

can anyone help me with this? i can attach the files if you want.

cgraz

What does your query look like? Are you using LIKE?

SELECT * FROM your_table WHERE search_field LIKE '%$searchterm%'

Cgraz

itworks

here is the search.php script attached has txt file.

PLEASE, take a look and see if you come up with a way that i can do this.

thanks.

cgraz

where? 😉

itworks

sorry i had problems with my connection, i thought the post wasn't even sent.

here it is.

PS. yes i do use LIKE in the query, why?! i shouldn't?!

cgraz

What i'd do is print $sql to see what your query looks like before it actually gets run. Also, use mysql_error()

And should

$result = mysql_db_query ("omdb", $sql);

$result = mysql_query ($sql);

and you can print the query and add mysql error
print $sql . "<br>";
$result = mysql_query($sql) or die(mysql_error());

$sql is the string you want to query. What is omdb? I think that's what's being sent as the query, and it's thinking that $sql is your connection parameters.

Cgraz

itworks

omdb is the database name, don't i have to mention it somewhere?

see, the script i attached if i call it and run a search it works perfectly. the problem is when i run the search from another page in a topFrame with the form i described in my first post.

so what i'm thinking is, isn't the problem really in the topFrame.htm page that the form just doesn't POST the search to the script the way i want? just guessing?

i really appretiate your help.

cgraz

I'm not to sure. Try this and let me know what it prints.

$result = mysql_query ($sql) or die(mysql_error()); 
print $sql . "<br>";

And no, you don't need to mention the database name.

Cgraz

itworks

doesn't work. i get this result with the code you posted:

if i don't put "omdb" (which is my database) he prints that i haven't selected a database for the search.

if i put "omdb" but i use mysql_query instead of mysql_db_query the output is that i have no results.

i can't figure out why?😕

cgraz

Connect to your server and select your database like this

mysql_connect("server", "username", "password") or die(mysql_error();

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

$sql ="select * from main where ";
$sql .= $sql1. " order by name asc";

$result = mysql_query ($sql) or die(mysql_error()); 
print $sql . "<br>";

Cgraz

itworks

your code didn't really change anything but thanks to the PRINT you gave me it printed the search and i found the error.

basically the problem was that i had in this line

$sql1=($name) ? "name like '".$name."%'" :"" ;

and i forgot the % symbol before the $name so this works:

$sql1=($name) ? "name like '%".$name."%'" :"" ;

i'm sorry that i've troubled you over a syntax error that i so stupidly made, but if it conforts you i couldn't have founded it without you.

thanks 😉

cgraz

no problem, atleast you learned how to discover these kinds of errors. Print them out and use mysql_error()

Cgraz