PHP to Array - Troubleshooting

Question

I know I am making rookie errors here, and that I need to make a variable to pass forward - though I am not sure how to approach this one, and searching online tutes is not helping. If someone can steer me in the right direction I would be really grateful.

I would like to have the results echo into an array. That is; have 'xmlurl' row field from the 'xml' table display in the $rss array. I hope that makes sense.

// Get URLs from Database
$result = mysql_query("SELECT * FROM xml");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
printf("'%s',", $row["xmlurl"]);
}
mysql_free_result($result);

// Take the URLs (xmlurl) and place them in an array
$rss = array(
'http://www.xmlurl.com.au',
'http://www.xmlurl.com.au'
);

deceze · Accepted Answer · 2012-05-25 01:33:56Z

7

$rss = array();
while (...) {
    $rss[] = $row['xmlurl'];
}

answered May 25, 2012 at 1:33

deceze♦

525k89 gold badges806 silver badges954 bronze badges

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

Comments

Ian Hunter · Accepted Answer · 2012-05-25 01:33:45Z

3

Try this:

$rss = array();

$result = mysql_query("SELECT * FROM xml");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $rss[] = $row["xmlurl"];
}
mysql_free_result($result);

answered May 25, 2012 at 1:33

Ian Hunter

9,86413 gold badges63 silver badges79 bronze badges

1 Comment

Brandrally Over a year ago

Thank you for your responses. They are very much appreciated!

random_user_name · Accepted Answer · 2012-05-25 01:34:06Z

2

// Get URLs from Database
$result = mysql_query("SELECT * FROM xml");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $rss[] = $row["xmlurl"]);
}
mysql_free_result($result);

print_r($rss); // Outputs the $rss array, listing all of the xmlurls'

answered May 25, 2012 at 1:34

random_user_name

26.3k7 gold badges81 silver badges119 bronze badges

Collectives™ on Stack Overflow

PHP to Array - Troubleshooting

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related