Hello, I'm sure there is a simple solution to this, but I've been tearing my hair out for the last couple of hours, I have a form that generates a URL with multiple variables:
I cant for the life of me get the variables included into a MySQL query.
The parameters in the URL are exactly the same as the Fields in my Table that I am querying.
I want to retrieve and display information below a certain price, above a certain storage and above a certain bandwidth.
I've been playing with the query for hours and it's a bit of a mess - I'll post it below.
N.B. The urls work for individual queries created in DW, but not when I combine them.
Many thanks in advance for your help.
$query_hostingsearch = ("SELECT `Host`, Package, Rating, Storage, `Data Transfer`, `Included Domains`, Setup, Price
FROM UKshared WHERE Type = %s", GetSQLValueString($colname_Type, "double") AND PriceGBP <= %s", GetSQLValueString($colname_PriceGBP, "double") AND StorageGB >= %s", GetSQLValueString($colname_StorageGB, "double") AND DataTransferGB >= %s", GetSQLValueString($colname_DataTransferGB, "double") ORDER BY PriceGBP ASC ");
$query_limit_hostingsearch = sprintf("%s LIMIT %d, %d", $query_hostingsearch, $startRow_hostingsearch, $maxRows_hostingsearch);
$hostingsearch = mysql_query($query_limit_hostingsearch, $webhosting) or die(mysql_error());
$row_hostingsearch = mysql_fetch_assoc($hostingsearch);