Search found 16 matches

by olm75
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....
by olm75
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...
by olm75
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'
by olm75
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...
by olm75
Sat Aug 13, 2005 8:42 pm
Forum: PHP - Code
Topic: php form
Replies: 25
Views: 796

sorry

no change at all
by olm75
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.....
by olm75
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...
by olm75
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...
by olm75
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.....
by olm75
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...
by olm75
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
by olm75
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...
by olm75
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...
by olm75
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);
by olm75
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...