printing results

Jess · 10-04-2007, 03:53 PM

Hello, I am a newb with PHP and MySQL, so please forgive me if I am way off here. I am attempting to search my resume database, for some reason I cannot get the results to display. I can't figure out what I am doing wrong!
Here is what I have, any suggestions on where to read more about doing this would be greatly appreciated!

$search=$_POST["search"];
//get mysql and store them in result
$result = mysql_query="SELECT * FROM resumes WHERE MATCH (body) AGAINST ('%search%')";

//grab all the content
while($r=mysql_fetch_array($result))
{
$lastname=$r["lastname"];
$body=$r["body"];
$id=$r["id"];
//display the row
echo "$lastname <br> $body <br> $id <br>";
}
?>

Village Idiot · 10-04-2007, 03:56 PM

change

PHP Code:


			
 $result = mysql_query="SELECT * FROM resumes WHERE MATCH (body) AGAINST ('%search%')";

to

PHP Code:


			
 $result = mysql_query("SELECT * FROM resumes WHERE MATCH (body) AGAINST ('%search%')");

mysql_query is a function

Jess · 10-04-2007, 04:22 PM

Thank you very much!

Village Idiot · 10-04-2007, 07:53 PM

Glad to help.

Tanax · 10-04-2007, 10:36 PM

Change

PHP Code:


			
$result = mysql_query("SELECT * FROM resumes WHERE MATCH (body) AGAINST ('%search%')");

to

PHP Code:


			
$result = mysql_query("SELECT * FROM resumes WHERE MATCH (body) AGAINST ('".%$search%."')");

You forgot to add the variable $search, right now you're not searching for the input search, you're actually search for the word "search".

PHP Code:


			
while($r=mysql_fetch_array($result))

to

PHP Code:


			
while($r=mysql_fetch_array($result, MYSQL_ASSOC))

PHP Code:


			
$lastname=$r["lastname"];
$body=$r["body"];
$id=$r["id"];

to

PHP Code:


			
$lastname=$r['lastname'];
$body=$r['body'];
$id=$r['id'];

Eventhough it won't make much difference, it's still the most used way to go..

Also, don't use html breaklines, use xhtml breaklines:

Code:

<br />

Jess · 10-05-2007, 05:49 PM

wow, thank you. :P No wonder this isn't working...

Tanax · 10-05-2007, 06:35 PM

Does it work now?

Jess · 10-07-2007, 02:11 AM

Bah..no it isn't, I am going to play with it some more on Monday.