Posted by Stefan Rybacki on 11/12/99 11:21

Geoff Berrow wrote:
> I noticed that Message-ID: <W5ydndoO85Kf20XfRVn-1g@is.co.za> from Peter
> Butler contained the following:
>
>
>>I am trying to get php to dynamically create the correct combination of
>>arguments to formulate a complex Mysql query, based on which combination of
>>$vars have been passed to the result.php script.
>
>
> Well If you are basing a query on 14 variables then, as you've worked
> out, there are a lot of combinations. Most people here will be thinking
> that you can do this with the query itself but we need to know the exact
> nature of the problem.

Thats what I stated before. An example of what he is trying to do would be nice. ;)

>
> Lets take a simple case. Say I sell shoes and I have three fields,
> size, colour and type.
>
> After sanitizing the input from the form (using
> mysql_real_escape_string() ) we could end up with three variables $size,
> $colour and $type
>
> The query would then be something like
>
> $sql= "SELECT * FROM `shoes` WHERE size='$size' AND colour='$colour' AND
> type='$type'";

Yes or seperated with OR, whatever without an example of what he really wants it's just
guessing.

So Peter please show us what you're trying to do. Thanks.

Regards
Stefan

[Back to original message]