mssql 2005&PHP:error " Invalid object name"

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

mssql 2005&PHP:error " Invalid object name"

Author

Topic

prabhatkr
Starting Member

6 Posts

Posted - 2008-08-04 : 10:12:40

Hi

I am trying my hands on a small search engine project.
The tutorial here[url]http://www.bestcodingpractices.com/search_engine_creation_101-12.html[/url] is in php mysql. But for some resource reasons , I have to convert it into MSSQL. Can someone plz help me converting?
Also what is this way of choosing database "FROM page p, word w,".
Please provide some knowledge link if you know one.


 SELECT p.page_title as title, p.page_url AS url, COUNT(*) AS occurrences FROM page p, word w, occurrence o WHERE p.page_id = o.page_id AND w.word_id = o.word_id AND w.word_word = "$keyword" GROUP BY p.page_id ORDER BY occurrences

pk from Asia

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-08-04 : 10:17:18

[code]SELECT p.page_title AS title, p.page_url AS url, COUNT(*) AS occurrences
FROM page p
INNER JOIN occurrence o ON p.page_id = o.page_id
INNER JOIN word w ON o.word_id = w.word_id
WHERE w.word_word = "$keyword"
GROUP BY p.page_title, p.page_url
ORDER BY occurrences[/code]

KH
[spoiler]Time is always against us[/spoiler]

prabhatkr
Starting Member

6 Posts

Posted - 2008-08-04 : 10:29:56

Thanks a lot Khtan,

This was herculean task for me. Still wanted to learn abt this. Could you please give some url.

Anyway.. a lot of thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources