Select colum1, column2 from table where value=somevalue

Question

I want to select two columns value and use them with while, i tried but failed. new to php&Mysql..

Mytable = categories ↓

subcat1    |   subcat2   |   category  |
=======================================
High school| Pvt School  |   Education |
---------------------------------------
Jr College | Voc College |   Education |

=======================================

My Query:

sql="select distinct subcat1, subcat2 from categories where category='Education'";
$category=mysql_query($sql);

    <?php
       while ($cat = mysql_fetch_assoc($category))
    {
    ?>

    <a href="Category.php"> <?php echo $cat['subcat']; ?></a>

Output I want to get :

High School

Pvt School

Jr College

Voc College

Please Help me out.. ♥ Hearty Thanks ♥

You're echoing out `subcat` but your keys are `subcat1` and `subcat2` — , Oct 05 '15 at 05:39
Please read: http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php — , Oct 05 '15 at 05:42

Niranjan N Raju · Answer 1 · 2015-10-05T05:03:21.137

1

echo both values inside while loop

<?php
    while ($cat = mysql_fetch_assoc($category)) { ?>
        <?php if($cat['subcat1']) { ?>
            <a href="Category.php"> <?php echo $cat['subcat1']; ?></a>
        <?php } if($cat['subcat1']) { ?>
            <a href="Category.php"> <?php echo $cat['subcat2']; ?></a>
        <?php } ?>
<?php } ?>

edited Oct 05 '15 at 05:03

answered Oct 05 '15 at 04:49

Niranjan N Raju

12,047
4
22
41

You deserved to achieve ♥ from OP. – Hotdin Gurning Oct 05 '15 at 04:51
I tried this.. Actually if any selected don't have any value, It Showing like this..
Pvt School

Mr Akheel

Oct 05 '15 at 04:51

you want to put condition to remove blank `

`??

– Niranjan N Raju Oct 05 '15 at 04:53

Rohit Kumar · Answer 2 · 2015-10-05T05:09:12.823

0

Dour your stuff like below-

while ($cat = mysql_fetch_assoc($category))
{
    ?>
    <?php
        if($cat['subcat1']!="") {
        ?>
            <a href="Category.php"> <?php echo $cat['subcat1']; ?></a>
    <?php } ?>
    <?php
        if($cat['subcat2']!="") {
        ?>
            <a href="Category.php"> <?php echo $cat['subcat2']; ?></a>
     ?php } ?>
<?php } //while close ?>

OR better to modify your query only as

sql="select distinct subcat1, subcat2 from categories 
     where category='Education' AND subcat1<>'' AND subcat2<>''";

edited Oct 05 '15 at 05:09

answered Oct 05 '15 at 05:01

Rohit Kumar

1,948
1
11
16

Something went wrong... Programme not working, showing blank page.. I tried little modifications but :( – Mr Akheel Oct 05 '15 at 05:24
specify errors you got.. and what about modifications ?? – Rohit Kumar Oct 05 '15 at 05:31
No Errors.. Just showing blank.. Source : ---------- – Mr Akheel Oct 05 '15 at 05:51
did you change your query too?? go through either of above answer .. either check it in loop or change your query .. don't do both – Rohit Kumar Oct 05 '15 at 05:58

Select colum1, column2 from table where value=somevalue

My Query:

Output I want to get :

2 Answers2