Posted by Nyoka on 11/07/67 11:53

If you change your SQL to the form WHERE gender LIKE '$gender' then you
can make use of the mySQL wildcard '%' to get all results.

tallalex85@gmail.com wrote:
> Hi,
>
> I'm quite new to MySQL and php so please go easy. Thanks!
>
> I'm trying to design a very basic php script which displays the
> contents of the table, then I want to enable the user to filter out
> certain results. So I went about writing a MySQL query something like
> .....WHERE gender="$gender" AND group="$group" and then wrote a
> form which sets the variables $gender and $group. Now is there a way of
> setting $gender and $group to something that would display the whole
> table?
>
> And is this the right way of going about this? Or is there a better
> way... Infact does anyone know of a good site that might guide me in
> creating such a script?
>
> Thanks
>
> Alex

[Back to original message]