Need some help with a mysql query

[bpotter666]

Hello

I'm a bit of a noob where it comes to PHP & MySQL.

At the moment all of my content for my site is in a MySQL database. Each row has the fields

| content | title | url |

Somehow I want to use a mysql query to fetch all of the url cells into an array.

i have no idea how to do this ~ and any help is greatly appreciated!

Thanks 😃
Ben

[rincewind456]

Your sql statement would look something like:

$sql = "SELECT url FROM table_name ORDER BY url ASC";

then you would retrieve like this:

$result = mysql_query($sql) or die(mysql_error());

if (!$result) {
	echo "No results found";
}

while ($row = mysql_fetch_array($result)) {
	$url[] = $row['url']		//Adds each result row into an array
}

Then $url would hold an array of your url's.

[bpotter666]

Wow thanks that was exactly what I was looking for!

Thanks a lot!
Ben