On Sun, 07 Mar 2004 10:07:41 +0000, Dariusz wrote:
Back to the problem, the POST to the PHP script would have a value of
say "video", but the database could have values for that field of
"video021" or "audio005" or "screensaver010" etc.. (file type and file
number).
So I need to match the first part of the file ID (and exclude the file
number, ie. "video" and not "video021")... then echo the row each time
the script found a match for "video" and move onto the next row for
other instances of "video" to echo.
Using MySQL? IMHO it's better to leave this to the db-engine...
SELECT ID, field_1 FROM video_tbl WHERE ID LIKE '%video%';
Also check the MySQL manual for Fulltext for a more "search engine like"
functionality.
--
mvh/regards
Joachim Mæland
If everything seems under control, you're just not going fast enough.
-Mario Andretti