Search found 16 matches
- Wed Aug 24, 2005 3:39 am
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
need example
does any on have a full working example or tutorial of a search page that allows the viewer to search by 1 or any combination of fields....search must have at least 5 fields on it.....for some reason i cant do a query with more than combination of 2 fields....
- Wed Aug 17, 2005 3:47 pm
- Forum: PHP - Code
- Topic: search query question
- Replies: 1
- Views: 203
search query question
so if the fields in my form are: txt_Venuename txt_Areacode opt_Venuetype opt_Agegroup opt_Musictype and the db columns are: venuename areacode venuetype agegroup musictype it should look like this: Code: $sql = 'SELECT * FROM `some_db` WHERE '; $flag=0; if( $_REQUEST['text1'] ) { $sql .= "fiel...
- Sun Aug 14, 2005 2:53 am
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
i'm sorry
how will that translate to this:
Code: Select all
SELECT venuename, address, city, `state`, zip, phone, areacode
FROM venues_new
WHERE venuename LIKE 'MMColParam%' AND areacode = 'varAC'- Sun Aug 14, 2005 1:37 am
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
ok
i think my problem mostly lies in the query itself...this is what i have: SELECT venuename, address, city, `state`, zip, phone, areacode FROM venues_new WHERE venuename LIKE 'MMColParam%' AND areacode = 'varAC' but what i want to do is allow the viewer to search with 1 or any combination of fields i...
- Sat Aug 13, 2005 8:42 pm
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
sorry
no change at all
- Sat Aug 13, 2005 11:05 am
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
ok, but
you know it would be helpful if you show me what you are talking about.....
- Fri Aug 12, 2005 5:27 pm
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
y 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 ' , venuetype, agegroup, musictype, address, FROM venues_new WH and the query is : mysql_select_db($database_connNightspotz, $connNightspotz); $query_rsSRCH = sprintf...
- Fri Aug 12, 2005 8:30 am
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
ok so
ok so what do i use then.....can u please give me a solution...
thanks...
thanks...
- Thu Aug 11, 2005 6:18 pm
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
lol
ok what is the solution can somebody test the code and see what they get so i can get a solution to this problem......why am i getting the error from my above post.....
- Wed Aug 10, 2005 5:43 am
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
ok im getting error
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home2/nightsp/public_html/search_results.php on line 104 here's the code: this is line 104: mysql_query($query_venue,$srch); <?php require_once('../Connections/connNightspotz.php'); ?> <?php $currentPage = $_SERVER[&quo...
- Wed Aug 10, 2005 4:15 am
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
ok
hello is anybody there.....pulling my hair out here
- Wed Aug 10, 2005 12:17 am
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
ok here it is
1st http://www.nightspotz.com/testsearch.php can u go here and test the search out. 2cd its not querying it just shows all the records in the table when u hit submit....now im new to this programming thing but it leaves me to believe that the query is all messed up... i want this so the viewer can u...
- Tue Aug 09, 2005 2:38 am
- Forum: PHP - Code
- Topic: php search form to mysql database
- Replies: 5
- Views: 1118
thanks guys, but
ok now the test worked 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 u guys 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..... her...
- Tue Aug 09, 2005 12:33 am
- Forum: PHP - Code
- Topic: php search form to mysql database
- Replies: 5
- Views: 1118
sorry
that didnt work any other suggestions....
these are the lines that have the errors.....
line 38:
if ($MatchRecordRow = mysql_fetch_array($SearchMatch)) {
line 46:
mysql_free_result($SearchMatch);
these are the lines that have the errors.....
line 38:
if ($MatchRecordRow = mysql_fetch_array($SearchMatch)) {
line 46:
mysql_free_result($SearchMatch);
- Tue Aug 09, 2005 12:00 am
- Forum: PHP - Code
- Topic: php form
- Replies: 25
- Views: 796
php form
ok i know how much PHP guys hate Dreamweaver but for some reason the form is not querying the variables..... here is the code:ex of the form at http://www.nightspotz.com/testsearch.php DW is easier for me right now im in the process of learning PHP with MySQL more SORRY forgive me...... <?php requir...