PHP 5 PDO

[mpar612]

I am working on converting some old PHP 4 scripts to PHP 5. I used to use the PEAR DB module in PHP 4 and in PHP 5 I want to use PDO.

I am using this code to connect to the DB:

$dbh = new PDO('mysql:host=localhost;dbname=name', 'username', 'password');

Later on in the same page I use this code and it works just fine:

foreach($dbh->query('SELECT artist_id, artist_name FROM 10spot_artist ORDER BY artist_name') as $row) {
							$id = $row['artist_id'];
							$name = stripslashes($row['artist_name']);
							echo "<tr>
								<td width=\"240\" height=\"35\" background=\"images/ArtistColumnBack.gif\">
								<b><font face=\"Arial\" size=\"2\" color=\"#FFFFFF\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
								<a href=\"Artist.php?id=$id\" style=\"text-decoration: none\">$name</a></font></b></td>
							</tr>";
							}
							$dbh = null;

Later on in the same page I use the following code and it doesn't work. I don't get any errors or anything the page just stops executing right at this code. I'm new to using PDO. Any thoughts on why this doesn't work? Thanks in advance!

$head_sel_sql = $dbh->query('SELECT select_id, headline_id FROM 10spot_head_sel');
					$headline_id = $head_sel_sql['headline_id'];
					$dbh = null;

				$head_display = $dbh->query('SELECT headline_id, date, headline, headline_description FROM 10spot_headlines WHERE headline_id = $headline_id');
				$display_head = stripslashes($head_display['headline']);
				$display_date = $head_display['date'];
				$display_description = stripslashes($head_display['headline_description']);
				echo "<tr>
					<td><i><b><font face=\"Arial\" color=\"#BE2E2E\">$display_head</font></b></i></td>
					<td>
					<p align=\"right\"><font size=\"2\" face=\"Arial\">$display_date</font></td>
				</tr>
				<tr>
					<td colspan=\"2\">
					<font face=\"Arial\" style=\"font-size: 9pt\">$display_description</font></td>
				</tr>";
				$dbh = null;