olm75

ok thanks, but do i just do that for all of the if statements or just that 1st one....

y is my query not bringing results....not found...i want the viewers to search using 1 or any combination of fields..... [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] $querystring = \"select * from venues\"; if ($VN != \"\" AND $AC == \"\" AND $AG == \"\") {$querystring .= \" where (venuename like \'%$VN%\')\";} if ($VN != \"\" AND $AC != \"\" AND $AG == \"\") {$querystring .= \" where (venuename like \'%$VN%\') AND (areacode like \'%$AC%\')\";} if ($VN != \"\" AND $AC == \"\" AND $AG != \"\") {$querystring .= \" where (venuename like \'%$VN%\') AND (agegroup like \'%$AG%\')\";} if ($VN == \"\" AND $AC != \"\" AND $AG == \"\") {$querystring .= \" where (areacode like \'%$AC%\')\";} if ($VN == \"\" AND $AC != \"\" AND $AG != \"\") {$querystring .= \" where (areacode like \'%$AC%\') AND (agegroup like \'%$AG%\')\";} if ($VN == \"\" AND $AC == \"\" AND $AG != \"\") {$querystring .= \" where (agegroup like \'%$AG%\')\";} if ($VN == \"\" AND $AC == \"\" AND $AG == \"\") {} [/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

i get this error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '%""%' at line 1

venuename is the database column txtVenuename is the form_field $VT = $_POST['txtVenuename'] so it should look like this: [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] [span style=\"color:#0000BB\"]<?php $VN [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]venuename[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]areacode[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]agegroup[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#FF8000\"]//-----HOW DO I ADD THESE TO VARIBLES TO THE QUERY FROM MY SEARCH FORM--------- [/span][span style=\"color:#0000BB\"]$VT [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]venuetype[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$MT [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]musictype[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#FF8000\"]//----------------------------------------------------- [/span][span style=\"color:#0000BB\"]$mysql_mylink [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_pconnect[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"localhost\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"nightsp\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"babystuff\"[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); [/span][span style=\"color:#0000BB\"]mysql_select_db [/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]nightsp_nightspotz[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); echo [/span][span style=\"color:#DD0000\"]\"<TABLE class=\'sortable\' id=\'Identify\' BORDER=1 align=center>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<TD>VENUENAME</TD><TD>AREACODE</TD><TD>AGE GROUP</TD><TD>CITY</TD><TD>STATE</TD>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"SELECT * FROM venues_new\"[/span][span style=\"color:#007700\"]; if (isset([/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'txtVenuename\'[/span][span style=\"color:#007700\"]])) { [/span][span style=\"color:#0000BB\"]$VN [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'txtVenuename\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"].= [/span][span style=\"color:#DD0000\"]\" WHERE venuename LIKE %\\"[/span][span style=\"color:#0000BB\"]$VT[/span][span style=\"color:#007700\"]&[/span][span style=\"color:#FF8000\"]#092;\"%\"; [/span][span style=\"color:#007700\"]} [/span][span style=\"color:#0000BB\"]$SearchMatch [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query [/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$querystring[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$mysql_mylink[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); if ([/span][span style=\"color:#0000BB\"]$MatchRecordRow [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"])) { do{ echo [/span][span style=\"color:#DD0000\"]\"<TR><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'venuename\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'areacode\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'agegroup\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'city\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'state\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; } while([/span][span style=\"color:#0000BB\"]$MatchRecordRow [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"])); } else {echo [/span][span style=\"color:#DD0000\"]\"<center>Sorry, No Records Were Found!</center>\"[/span][span style=\"color:#007700\"];} echo [/span][span style=\"color:#DD0000\"]\"</table>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]mysql_free_result[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?> [/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

i think my problem mostly lies in the query itself...this is what i have: [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] SELECT venuename, address, city, `state`, zip, phone, areacode FROM venues_new WHERE venuename LIKE \'MMColParam%\' AND areacode = \'varAC\' [/span][!--PHP-Foot--][/div][!--PHP-EFoot--] but what i want to do is allow the viewer to search with 1 or any combination of fields in the search form...to get results or narrow results, what this query is doing is making them choose both fields without having the option to choose just one...if they want a much broader search....and i have 4 more list/menu search fields to add on.... here is the form: http:// http://www.nightspotz.com/search1.php

what would $CRT be

is this !@#$ really this hard or what, come on y aint this !@#$ working can anybody help im getting to !@#$ frustrated....all i want to do is make a search page with different search fields that narrow down a search to a viewer....!@#$ has anbody on here ever made a search page with more thatn 1 field.....

ok that just tells me the query was empty when i submit the form .....

ok here is my code but im getting an error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '0' at line 1 [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] [span style=\"color:#0000BB\"]<?php $VN [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]venuename[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]areacode[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]agegroup[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#FF8000\"]//-----HOW DO I ADD THESE TO VARIBLES TO THE QUERY FROM MY SEARCH FORM--------- [/span][span style=\"color:#0000BB\"]$VT [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]venuetype[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$MT [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]musictype[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#FF8000\"]//----------------------------------------------------- [/span][span style=\"color:#0000BB\"]$mysql_mylink [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_pconnect[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"localhost\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"nightsp\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"babystuff\"[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); [/span][span style=\"color:#0000BB\"]mysql_select_db [/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]nightsp_nightspotz[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); echo [/span][span style=\"color:#DD0000\"]\"<TABLE class=\'sortable\' id=\'Identify\' BORDER=1 align=center>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<TD>VENUENAME</TD><TD>AREACODE</TD><TD>AGE GROUP</TD><TD>CITY</TD><TD>STATE</TD>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"select * from venues\"[/span][span style=\"color:#007700\"]; if ([/span][span style=\"color:#0000BB\"]$VN [/span][span style=\"color:#007700\"]!=[/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"where (venuename like \'%$VN%\') \"[/span][span style=\"color:#007700\"];} if ([/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]!=[/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"and (areacode like \'%$AC%\') \"[/span][span style=\"color:#007700\"];} if ([/span][span style=\"color:#0000BB\"]$AG[/span][span style=\"color:#007700\"]!=[/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"and (agegroup like \'%$AG%\')\"[/span][span style=\"color:#007700\"];} [/span][span style=\"color:#0000BB\"]$SearchMatch [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query [/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$querystring[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$mysql_mylink[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); if ([/span][span style=\"color:#0000BB\"]$MatchRecordRow [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"])) { do{ echo [/span][span style=\"color:#DD0000\"]\"<TR><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'venuename\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'areacode\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'agegroup\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'city\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'state\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; } while([/span][span style=\"color:#0000BB\"]$MatchRecordRow [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"])); } else {echo [/span][span style=\"color:#DD0000\"]\"<center>Sorry, No Records Were Found!</center>\"[/span][span style=\"color:#007700\"];} echo [/span][span style=\"color:#DD0000\"]\"</table>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]mysql_free_result[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?> [/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

ok either im blind, or dumb ass hell but wjat did u change besides the space between +" where can u change the code to say what u mean can u put the correction in the code itself......then maybe i can see it alot better....

ok i fixed some of the problems but now the the variables arent working because i cant do any type of search i can only hit submit but i think the SQL qyery is jacked up can you help with this i want the viewers to be able to search by using 1 or all of the search fields to narrow the search down..... here is the working form... http://www.nightspotz.com/testsearch.php can you go and check it out oh by the way the mistake was $querystring = "select * from '$Table'"; had to get rid of the ' ' around the $Table..... can you help with the rest please...you dont know how much of a relief this is... [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] [span style=\"color:#0000BB\"]<?php $VN [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]venuename[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]areacode[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]agegroup[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#FF8000\"]//-----HOW DO I ADD THESE TO VARIBLES TO THE QUERY FROM MY SEARCH FORM--------- [/span][span style=\"color:#0000BB\"]$VT [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]venuetype[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$MT [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]musictype[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#FF8000\"]//----------------------------------------------------- [/span][span style=\"color:#0000BB\"]$mysql_mylink [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_pconnect[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]localhost[/span][span style=\"color:#007700\"], *****, *****) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); [/span][span style=\"color:#0000BB\"]mysql_select_db [/span][span style=\"color:#007700\"](********) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); echo [/span][span style=\"color:#DD0000\"]\"<TABLE class=\'sortable\' id=\'Identify\' BORDER=1 align=center>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<TD>VENUENAME</TD><TD>AREACODE</TD><TD>AGE GROUP</TD><TD>CITY</TD><TD>STATE</TD>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"select * from venues\"[/span][span style=\"color:#007700\"]; if ([/span][span style=\"color:#0000BB\"]$VN [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"where (venuename like \'%$VN%\') and (areacode like \'%$AC%\') and (agegroup like \'%$AG%\')\"[/span][span style=\"color:#007700\"];} if ([/span][span style=\"color:#0000BB\"]$VN [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"where (venuename like \'%$VN%\') and (areacode like \'%$AC%\')\"[/span][span style=\"color:#007700\"];} if ([/span][span style=\"color:#0000BB\"]$VN [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"where (venuename like \'%$VN%\')\"[/span][span style=\"color:#007700\"];} if ([/span][span style=\"color:#0000BB\"]$VN [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"where (venuename like \'%$VN%\') and (agegroup like \'%$AG%\')\"[/span][span style=\"color:#007700\"];} [/span][span style=\"color:#0000BB\"]$SearchMatch [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query [/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$querystring[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$mysql_mylink[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]()); if ([/span][span style=\"color:#0000BB\"]$MatchRecordRow [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"])) { do{ echo [/span][span style=\"color:#DD0000\"]\"<TR><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'venuename\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'areacode\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'agegroup\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'city\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'state\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; } while([/span][span style=\"color:#0000BB\"]$MatchRecordRow [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"])); } else {echo [/span][span style=\"color:#DD0000\"]\"<center>Sorry, No Records Were Found!</center>\"[/span][span style=\"color:#007700\"];} echo [/span][span style=\"color:#DD0000\"]\"</table>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]mysql_free_result[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?> [/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

ok i'm getting an error message: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/nightsp/public_html/testcode.php on line 38 Sorry, No Records Were Found! Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home2/nightsp/public_html/testcode.php on line 46 and here is the code can you read the notes i put in please thanks, i greatly appreciate this: by the way $AG = $_POST[agegroup], $VT = $_POST[venuetype] $MT = $_POST[musictype]; are list boxes as u can see on the page nightspotz.com [!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--] [span style=\"color:#0000BB\"]<?php $VN [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]venuename[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]areacode[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]agegroup[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#FF8000\"]//-----HOW DO I ADD THESE TO VARIBLES TO THE QUERY FROM MY SEARCH FORM--------- [/span][span style=\"color:#0000BB\"]$VT [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]venuetype[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$MT [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]musictype[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#FF8000\"]//----------------------------------------------------- [/span][span style=\"color:#0000BB\"] $HostID [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]localhost[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]$UserID [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][*******]; [/span][span style=\"color:#0000BB\"]$PassID [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][*******]; [/span][span style=\"color:#0000BB\"]$dbname [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][********]; [/span][span style=\"color:#0000BB\"]$Table [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#0000BB\"]venues[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#FF8000\"]//----------CAN I TAKE THIS TABLE OUT OR WAS THIS JUST TO ECHO AND SEE IF IT WORKS..I DONT NEED ANY OF //---THESE TABLES I\'LL FORMAT IT IN DREAMWEAVER BUT CAN U SHOW ME HOW TO JUST GET THE RESULTS WITH THE //----PHP ICON SO I CAN JUST POSITION THEM IN DREAMWEAVER...THANKS... [/span][span style=\"color:#007700\"]echo [/span][span style=\"color:#DD0000\"]\"<TABLE BORDER=1 align=center>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<TD>First Name</TD><TD>Last Name</TD><TD>Street Address</TD><TD>City</TD><TD>State</TD><TR>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$VN[/span][span style=\"color:#007700\"].[/span][span style=\"color:#DD0000\"]\"</td><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$AC[/span][span style=\"color:#007700\"].[/span][span style=\"color:#DD0000\"]\"</td><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$AG[/span][span style=\"color:#007700\"].[/span][span style=\"color:#DD0000\"]\"</td>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$City[/span][span style=\"color:#007700\"].[/span][span style=\"color:#DD0000\"]\"</td><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$State[/span][span style=\"color:#007700\"].[/span][span style=\"color:#DD0000\"]\"</td>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"</TR></table><p>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#FF8000\"]//--------------------------------------------------------------------------------------------- [/span][span style=\"color:#0000BB\"]mysql_select_db [/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$dbname[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]$mysql_mylink [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_pconnect[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$HostID[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$UserID[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$PassID[/span][span style=\"color:#007700\"]); echo [/span][span style=\"color:#DD0000\"]\"<TABLE class=\'sortable\' id=\'Identify\' BORDER=1 align=center>\"[/span][span style=\"color:#007700\"]; echo [/span][span style=\"color:#DD0000\"]\"<TD>VENUENAME</TD><TD>AREACODE</TD><TD>Street Address</TD><TD>city</TD><TD>state</TD>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"select * from \'$Table\'\"[/span][span style=\"color:#007700\"]; if ([/span][span style=\"color:#0000BB\"]$VN [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"where (venuename like \'%$VN%\') and (areacode like \'%$AC%\') and (agegroup like \'%$AG%\')\"[/span][span style=\"color:#007700\"];} if ([/span][span style=\"color:#0000BB\"]$VN [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"where (venuename like \'%$VN%\') and (areacode like \'%$AC%\')\"[/span][span style=\"color:#007700\"];} if ([/span][span style=\"color:#0000BB\"]$VN [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"where (venuename like \'%$VN%\')\"[/span][span style=\"color:#007700\"];} if ([/span][span style=\"color:#0000BB\"]$VN [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AC [/span][span style=\"color:#007700\"]== [/span][span style=\"color:#DD0000\"]\"\" [/span][span style=\"color:#007700\"]&& [/span][span style=\"color:#0000BB\"]$AG [/span][span style=\"color:#007700\"]!= [/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"]) {[/span][span style=\"color:#0000BB\"]$querystring [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$guerystring [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#DD0000\"]\"where (venuename like \'%$VN%\') and (agegroup like \'%$AG%\')\"[/span][span style=\"color:#007700\"];} [/span][span style=\"color:#0000BB\"]$SearchMatch [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query [/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$querystring[/span][span style=\"color:#007700\"]); if ([/span][span style=\"color:#0000BB\"]$MatchRecordRow [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"])) { [/span][span style=\"color:#0000BB\"] do[/span][span style=\"color:#007700\"]{ [/span][span style=\"color:#0000BB\"] echo [/span][span style=\"color:#DD0000\"]\"<TR><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'venuename\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"] echo [/span][span style=\"color:#DD0000\"]\"<td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'areacode\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'agegroup\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"] echo [/span][span style=\"color:#DD0000\"]\"<td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'city\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD><td>\"[/span][span style=\"color:#007700\"].[/span][span style=\"color:#0000BB\"]$MatchRecordRow[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'state\'[/span][span style=\"color:#007700\"]].[/span][span style=\"color:#DD0000\"]\"</TD>\"[/span][span style=\"color:#007700\"]; } while([/span][span style=\"color:#0000BB\"]$MatchRecordRow [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_array[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"])); } else {echo [/span][span style=\"color:#DD0000\"]\"<center>Sorry, No Records Were Found!</center>\"[/span][span style=\"color:#007700\"];} echo [/span][span style=\"color:#DD0000\"]\"</table>\"[/span][span style=\"color:#007700\"]; [/span][span style=\"color:#0000BB\"]mysql_free_result[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$SearchMatch[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?>[/span] [/span][!--PHP-Foot--][/div][!--PHP-EFoot--]

ok thanks do u have on with listboxes and other types of fields instead of textboxes...or does it really matter..... ex: goto my page nightspotz.com

try what, the link doesnt work.....