can someone help me find wats wrong with this code?

[JackOfBlades]

//after connecting to the database

$query = "SELECT *
FROM bulletinBoard";

   $result = mysql_query($query);

   $row = mysql_num_rows($result);


 if($row != 0)
 {
    while($data = mysql_fetch_array($result))
     {
	   echo(" <a href = \"subBulletin.php?id=\$data['bulletID']\"> $bulletTitle </a> ");

	 }
 }

as u can see in the code it's suppose to print out all data from the bulletin board my table for the bulletin board already has data in each row and column but its not printed in the site...i dont know wats wrong with the code i made hope you guys can help me out here thanks

[foid025]

Here's how I do it:

// Connecting, selecting database
	$link = mysql_connect('domain', user, password)
	   or die('Could not connect: ' . mysql_error());
	mysql_select_db('db') or die('Could not select database');

// Performing SQL query
$query = "SELECT * FROM main;
$result = mysql_query($query, $link) or die('Query failed: ' . mysql_error());

//get db data
while ($row = mysql_fetch_object($result)) 
{
	$blogs = $row->blog;
} 

not sure what if anything is wrong in yours :S

[foid025]

errr on second thoughts. I think the problem might be with your echo line...

echo(" <a href = \"subBulletin.php?id=\$data['bulletID']\"> $bulletTitle </a> ");

I find php doesn't like when you put a bunch of " characters in variables or echo statements. otherwise it considers it as end / beginning of the echo statement.

try this instead:

$print = "<a href= \subBulletin.php?id=" . $data['bulletID'] . "> " .
$bulletTitle . "</a>";
echo $pring;

[thorpe]

Assuming bulletTitle is comming from your query...

echo "<a href=\"subBulletin.php?id={$data['bulletID']}\">{$data['bulletTitle']}</a>";

[JackOfBlades]

thanks for your help guys now its working but i have another problem..hope you can bear with me i just started learning php and there are some syntax and other stuff that i get confused about... heres my prob. in my mainBulletin.php they now display the title to the bulletins that were made and they were linked to the subBulletin.php where their news will be show through this code which you guys helped:

while($data = mysql_fetch_array($result))
{
echo(" <a href = \"subBulletin.php?id={$data['bulletID']}\"> {$data['bulletTitle']} </a> ");

	 }

as u can see the id tag is to be passed to the subBulletin and here's my subBulletin code:

$identifier = $_GET['id'];

if($_GET['id'] != NULL)
 {
     $query2 = "SELECT *
                FROM bulletinBoard
			    WHERE bulletID = '$identifier'";


        $result = mysql_query($query2);
        $data = mysql_fetch_array($result);

}

and in the text area i placed this:

<textarea rows = "15" cols = "40" name = "newsbody" ><?php
if($identifier == NULL)
echo("Post your news ");
else
echo($data['bulletBody']);
?>

		 </textarea>

but it juz prints out the default "Post you news here" meaning it never got the id from main bulletin..whats wrong here? ? thanks in advance