I want to be able to click on a link that will return a list from a table of only certain records to another page.
This is what i'm working with, but I don't know how it fits together:
This is the link I've made:
<a href=http://www.phpbuilder.com/board/archive/index.php/"../mainlist3.php3?subject=%legal%">Legal Issues</a>
(When entereing the data, the SUBJECT field can have several types listed separated by commas, i.e., legal, technical, education, etc. So i need to pull out only entries that have certain words in the SUBJECT field)
In the mainlist3.php3 page I have this:
$Query = "SELECT * from $TableName where subject LIKE'$subject_search' ORDER BY subject";
the $subject_search should be the result of this: subject=%legal%
How do I get the $subject_search and the subect=%legal% to mean the same thing?
Thanks in advance!!!
This is what i'm working with, but I don't know how it fits together:
This is the link I've made:
<a href=http://www.phpbuilder.com/board/archive/index.php/"../mainlist3.php3?subject=%legal%">Legal Issues</a>
(When entereing the data, the SUBJECT field can have several types listed separated by commas, i.e., legal, technical, education, etc. So i need to pull out only entries that have certain words in the SUBJECT field)
In the mainlist3.php3 page I have this:
$Query = "SELECT * from $TableName where subject LIKE'$subject_search' ORDER BY subject";
the $subject_search should be the result of this: subject=%legal%
How do I get the $subject_search and the subect=%legal% to mean the same thing?
Thanks in advance!!!