Displaying Values of MYSQL Result via PHP

Question

OK, this is an amateur question but I am having the most trouble displaying the values of my database. I want to display the entire 'phone' column so my mysql query is this:

$result = mysql_query('SELECT phone FROM contactList WHERE phone != 1') or die(mysql_error());
$row = mysql_fetch_array($result)

My PHP script is as this:

while(isset($rows))
{
echo $rows['phone'] . "html break tag";
}

It looks like though I'm only getting the first result instead of looping through the entire column.

Do I need to increment the ID in my loop and get value via ID? The only problem with that is my auto-incremental ID column starts @ 130 and skips some numbers here and there.

Infinity · Accepted Answer · 2011-08-28 01:10:42Z

1

try this instead

While($row = mysql_fetch_array($result))
  echo $row['phone'];

That should help you looping through the whole array.

answered Aug 28, 2011 at 1:10

Infinity

3,9452 gold badges29 silver badges35 bronze badges

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

2 Comments

Stephan B Over a year ago

@Howdy_McGee mysql_fetch_array() fetches all columns of one row into an array. In your case, one phone number ; )

Howdy_McGee Over a year ago

Ohhhhh so by looping through all the rows I can pull the specific column that makes sense. Thanks!

Collectives™ on Stack Overflow

Displaying Values of MYSQL Result via PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related