Best tutorials to help create a search engine for database?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

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

Post 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.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
peachiness
Forum Commoner
Posts: 41
Joined: Mon Oct 11, 2010 1:33 pm

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

Post 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

?
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

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

Post 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.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
peachiness
Forum Commoner
Posts: 41
Joined: Mon Oct 11, 2010 1:33 pm

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

Post 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?!
Post Reply