php get specific data from the same column in all row

Question

i have a php question, how can i get all the data from the same column from all row in a mysql table.

Table name : user
Here's my table structure:
name
url

How can i use php to get all the data in URL column from each row? (P/S i have my connection to database established , just not sure the musql query for this)

Thanks and have a nice day.

Madara's Ghost · Accepted Answer · 2011-12-24 09:10:08Z

3

This really is extremely basic stuff and you could have found this anywhere, it's even in the PHP manual. But alas, here you go.

$result = mysql_query("SELECT url FROM user");
while($row=mysql_fetch_assoc($result){
   echo $row['url'].'\n';
}

Please read up on some basic stuff to avoid asking these kind of questions: http://www.freewebmasterhelp.com/tutorials/phpmysql

edited Dec 24, 2011 at 9:10

Madara's Ghost

176k52 gold badges274 silver badges314 bronze badges

answered Dec 24, 2011 at 8:56

Derk Arts

3,4702 gold badges21 silver badges36 bronze badges

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

1 Comment

Derk Arts Over a year ago

True, matter of habit for some reason.

jogesh_pi · Accepted Answer · 2011-12-24 08:59:35Z

1

$query = "select url from user";
$result = mysql_query($query);

while( $row = mysql_fetch_assoc($result)){
echo $row['url'] . '<br>';
}

answered Dec 24, 2011 at 8:59

jogesh_pi

9,7745 gold badges40 silver badges65 bronze badges

Collectives™ on Stack Overflow

php get specific data from the same column in all row

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related