YouTube embed help

[richard_PHP]

Hello all,

 

Using a database backend and the WHILE function I'm wanting all YouTube videos entered in said database to show up in one loop. Simples. However, coded it's deciding that it does not want to play ball.

 

Code:

<?php
				// Start the connection to the database
				$conn = mysql_pconnect("****", "******", "*****");
				// Select the database to use
				mysql_select_db("*****", $conn);
				// Create the MySQL command to retrieve all records
				$sql = "SELECT * FROM videos";
				$result = mysql_query($sql, $conn);
				while ($array = mysql_fetch_array($result)) {
					$title = $array[title];
					$hlink = $array[hlink];
					$desc = $array[description];
					echo "<h2>$title</h2>";
					echo "<iframe width='560' height='315' src='$hlink' frameborder='0' allowfullscreen></iframe>";
					echo "<p>$desc</p><hr />";
				}
			?>

 

The YouTube embed is in an echo line with the link to the video (eg: 'http://www.youtube.com/*****') in variable '$hlink'. I've tried \" instead of single quotes and it still isn't working.

 

Hopefully someone can help.

 

Thanks in advance 

[thara]

At first I showed this from your code.

 

$title = $array[title];

$hlink = $array[hlink];

$desc = $array[description];

 

Strings in the square brackets need to be within single quotes.

 

$title = $array['title'];
$hlink = $array['hlink'];
$desc = $array['description'];

[Pikachu2000]

Maybe you explain just what about it "isn't working"?

[richard_PHP]

FAO thara: Changed that but it's still not working

 

FAO Pikachu2000: The webpage displays as normal but the YouTube embedded player (and thus video) don't show at all.

[thara]

show us your $hlink data

[richard_PHP]

Nevermind! I've got it working! 

 

Thanks all anyway!