Forums

Show only certin records

dwaynencsu 03 Jun, 2009
I've been using ChronoConnectivity & Forms on my website and it has worked great! Today, i'm trying to show a subset of records and I'm not really sure how to do it. I've got an If statement working to let the user select the type of records to be shown, but for this use, I want to only allow one type to be show? Right now I have:

    ?>    <?php
    if(JRequest::getVar('county_find')){
    ?>
    WHERE county =
    "<?php echo JRequest::getVar('county_find') ; 


How would I change this if I only want to show County A every time?

Thanks so much for your help!
GreyHead 03 Jun, 2009
Hi dwaynencsu,

Just
WHERE `county` = 'County_A'

Bob
This topic is locked and no more replies can be posted.