Jump to content

uberfred

New Members
  • Posts

    4
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

uberfred's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I wondered whether it was too complex for DW. I can't see many tutorials on this specific topic. As for = or LIKE I want to be able to try them both and compare results. Thanks for your replies.
  2. Thanks for the suggestion but no good - same reply for default variable of 1.
  3. 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.
  4. 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?
×
×
  • 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.