Jump to content

Recommended Posts

My project is a recipe database. I just want to be able to search one field in one table for key words.

 

It would also be easier to do if I can work out how to do it using the Dreamweaver (MX 2004) GUI to do it.

 

SO far I have set a recordset with:

SELECT *

FROM tbl_recipes

WHERE tbl_recipes.recipe_detail LIKE svar

 

Then I've gone on to define the svar variable which is a search variable passed in the URL.

 

Variable name: svar

Default Value: 0

$_GET["txt_searchterms"]

 

When I run the search it returns an error saying Unknown column 'whateversearchtermused' in 'where clause'

 

How can I fix my record set? Is this just a syntax problem?

Link to comment
https://forums.phpfreaks.com/topic/1798-search-using-dreamweaver-gui/
Share on other sites

Based on what I understood from your post, it has all the makings of at least a syntax error. Is your field name really tbl_recipes.recipe_detail (or is it recipe_detail)?Post the actual php code you have that retrieves the search word(s), along with the actual database query you're using, and someone can offer a suggestion/solution.

Thanks for the response. The recordset query is (all generated by DW):

 

<?php

$svar_rsrecipes = "0";

if (isset($_GET["txt_searchterms"])) {

$svar_rsrecipes = (get_magic_quotes_gpc()) ? $_GET["txt_searchterms"] : addslashes($_GET["txt_searchterms"]);

}

mysql_select_db($database_recipes, $recipes);

$query_rsrecipes = sprintf("SELECT * FROM tbl_recipes WHERE tbl_recipes.recipe_detail LIKE %s", $svar_rsrecipes);

$rsrecipes = mysql_query($query_rsrecipes, $recipes) or die(mysql_error());

$row_rsrecipes = mysql_fetch_assoc($rsrecipes);

$totalRows_rsrecipes = mysql_num_rows($rsrecipes);

?>

 

The rest is just echo statements with a loop to display the results.

 

Thanks again for any responses.

WHERE tbl_recipes.recipe_detail LIKE svar

 

I believe you are making you query to complex for DMX

 

 

SELECT *

FROM tbl_recipes

WHERE recipe_detail LIKE 'svar'

 

do you want it to be like or equal what "svar" equals

 

if you are going for exact I would do

 

SO far I have set a recordset with:

SELECT *

FROM tbl_recipes

WHERE recipe_detail = 'svar'

 

 

I think DMX like the '-----' around the variable too for whatever reason so you might try just adding those.

 

 

 

 

 

 

 

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.