uberfred
-
Posts
4 -
Joined
-
Last visited
Never
Posts posted by uberfred
-
-
Thanks for the suggestion but no good - same reply for default variable of 1.
-
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.
-
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?
Search using Dreamweaver GUI
in Editor Help (PhpStorm, VS Code, etc)
Posted
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.