Getting data from several database table as an array with PHP

Question

I want to get all column1's data that has "asde" in its column2 and use them to create a dropdown list. How can i do that?

I used this

    $deneme = "SELECT column1 FROM table1 WHERE column2 LIKE '%INSE%'";
    $deneme2 = mysql_query($deneme);
    $deneme3 = mysql_fetch_array($deneme2);

Which part are you having trouble with? The query? Putting them into an array, or creating a dropdown list from the array? Please show what you've written so far so we can help you fix it. We're not here to write your whole script for you. — Barmar
– Barmar, Commented Apr 20, 2014 at 5:36

Alex · Accepted Answer · 2014-04-20 06:58:04Z

1

SQL:

$q = mysql_query("select column1, column2 from table where column2 LIKE '%asde%'");

Then use it for dropDownList options:

echo '<select name="fhdfh">';
while ($row = mysql_fetch_array($q, MYSQL_NUM))
    echo '<option value="'.$row[0].'" selected>'.$row[1].'</option>';
echo '</select>';

edited Apr 20, 2014 at 6:58

answered Apr 20, 2014 at 5:35

Alex

8,0827 gold badges44 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Zeki Over a year ago

I should have been more clear. I want to select them with for loop. I selected but when i try to echo them out i can't.

Alex Over a year ago

@user3552536 give us example of code that doesn't work

Zeki Over a year ago

I deleted it because it didn't work. But i wrote similar to one that i used.

Zeki Over a year ago

It says Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given on line 40 | Line 40-> $data = mysql_fetch_array($q);

Zeki Over a year ago

Thanks a lot!. But there is one thing that i want to do. It's not that important like the one before. What if i want to do this for all 114 table. $q will be array. What about $row. Is will be like kind of multidimensional array?

|

Ronak Shah · Accepted Answer · 2014-04-20 05:46:58Z

0

Try this

select distinct column1 from table where column2 = 'asde'

answered Apr 20, 2014 at 5:46

Ronak Shah

1,5592 gold badges13 silver badges20 bronze badges

Collectives™ on Stack Overflow

Getting data from several database table as an array with PHP

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related