|
|
Posted by Frankie on 07/29/06 04:05
"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:16bca$44caa404$8259c69c$29664@news1.tudelft.nl...
>
> Clarifiy your exact needs and correlation between tables. Without it, it's
> hard to come up with a suitable solution. Telling us what kind of database
> you're using is also a biog plus (and a question like this is usually more
> appropriate in a newsgroup about that partivular kind of DB).
Thanks for your response, Rik. You responded to another one of my questions
a couple weeks ago and were very helpful...a real asset to this group.
You're right, I'll take my question to the mySQL group.
Just FYI: it's a mySQL database and I'm trying to query one database which
holds 6 different tables for an entered search term which matches the common
"title" or "description" field of each table, and then display the results.
I might just simplify the query by requiring the user to enter which table
(category) to search in addition to the actual search term.
> Magic_quotes are unreliable at best (and IMHO a f*cking nuisance when
coding
> correctly). If using mysql (which people usually are),
> mysql_real_escape_string() is a good way to go. Using prepared statements
is
> better.
Again, thanks for your most helpful suggestion! I'll incorporate this
function into my repertoire.
Frank H.
Austin, TX
Navigation:
[Reply to this message]
|