Page 2 of 2

Re: Best tutorials to help create a search engine for databa

Posted: Wed Mar 02, 2011 4:11 pm
by pickle
I said output the query - not the results. Outputing the query can show you what the actual query looks like - it'll give you the reason why you get the results.

Re: Best tutorials to help create a search engine for databa

Posted: Wed Mar 02, 2011 4:31 pm
by peachiness
pickle wrote:I said output the query - not the results. Outputing the query can show you what the actual query looks like - it'll give you the reason why you get the results.
Oh sorry, I am unfamiliar to that concept.. how do I output the query?

echo $query
echo $query2

?

Re: Best tutorials to help create a search engine for databa

Posted: Wed Mar 02, 2011 4:36 pm
by pickle
No offense intended, but this is why I said you might not have the skill level to get help. Outputting a string is pretty rudimentary. You need to learn a bit more about what the script is doing and, to be honest, more of how PHP works, before you should start attempting something like this. I don't have the time to walk you through every little step.

Re: Best tutorials to help create a search engine for databa

Posted: Wed Mar 02, 2011 4:49 pm
by peachiness
pickle wrote:No offense intended, but this is why I said you might not have the skill level to get help. Outputting a string is pretty rudimentary. You need to learn a bit more about what the script is doing and, to be honest, more of how PHP works, before you should start attempting something like this. I don't have the time to walk you through every little step.
oh, I meant to put

echo "$query";
echo "$query2";

This was the output when I searched for popp
SELECT * FROM publications WHERE author1 LIKE 'popp' OR year LIKE 'popp' limit 0,10Resource id #3
This was output when i searched for popp 2003
SELECT * FROM publications WHERE author1 LIKE 'popp 2003' OR year LIKE 'popp 2003' AND year >= '2003' limit 0,10
Big problem...it's not exploding my search ...

What does resource id # mean?!