PHP and SQL making pages

[boyjack]

when i have more than one entry in the database it will not allow it in the script.

<?php

$dbh=mysql_connect ('localhost', 'jdlewis_jamie', '*****') or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ('jdlewis_jamie'); 
$sql = 'SELECT articlename,message FROM anaylze_entries order by articlename asc limit 999';
$sql_result = mysql_query($sql, $dbh) or die('Sorry it failed to find query');
while ($row = mysql_fetch_array($sql_result)) {
   $message = $row['message'];
   $articlename = $row['articlename'];

echo "<a href='?jamie=anaylze&op=$articlename'>$articlename</a><BR>";
};

$dbh=mysql_connect ('localhost', 'jdlewis_jamie', '*****') or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ('jdlewis_jamie'); 
$sql = 'SELECT articlename,message FROM anaylze_entries order by articlename asc limit 999';
$sql_result = mysql_query($sql, $dbh) or die('Sorry it failed to find query');
while ($row = mysql_fetch_array($sql_result)) {
   $message = $row['message'];
   $articlename = $row['articlename'];

if ($op == $articlename) {
echo "<? $message ?>";
break;
};
};
?>

http://www.monkeyevolution.com/JW/?jamie=anaylze

as you can see there is My Individual World and whatever. But when you view My Individual World it shows the data, but it also shows the links too. When you attempt to view the whatever link it just shows the links instead of the data. whats going on?

[HalfaBee]

You don't appear to be using the $_GET['anaylze'] data in the query.

Also you only need to connect to the DB at the start of the script.

HalfaBee

[boyjack]

but I am connecting to the database in the beginning of the script, thats $dbh string. Where do I put the "$_GET['anaylze']" or what do I need to do with it?

[HalfaBee]

I must have been tired yesterday.

$_GET['jamie'] isn't used.

Not knowing how your table is set up it is a bit hard.
Your SQL should have a WHERE column_name=$_GET['jamie'] in it to select the correct data.