Query not working the way I want it to

[Shockhazard30]

This query is supposed to pull the three links that are in the database out, but instead it pulls the first link out and displays it three times? any suggestions?

 

$conn  = mysql_connect("localhost", "root", "pass");
$select = mysql_select_db("main", $conn);
$sql = "SELECT * FROM links";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$addy = $row["address"];
$display = $row["linkdisplay"];
   

	 for ($i = 0; $i < 3; $i++){
		print "<A Class = 'link1' HREF='$addy'>$display</a>";
	 }//end for

 

Thanks

[jskywalker]

how many times do you do a "mysql_fetch_assoc"?

 

for a nice example look at:

http://php.net/manual/en/function.mysql-fetch-assoc.php

[Shockhazard30]

Thanks for the resource this is what I have now:

$conn  = mysql_connect("localhost", "root", "pass");
$select = mysql_select_db("main", $conn);
$sql = "SELECT * FROM links";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

$linkdata = "<A Class = 'link1' HREF='";
$blinkdata = "'>";

while($row = mysql_fetch_array($result)){
echo "$linkdata" . $row['address'] . "$blinkdata" . $row['linkdisplay'] . "</a>";
//echo $row['address']. " - ". $row['linkdisplay'];
echo "<br />";
}

[Shockhazard30]

That is not quite working properly, It doesn't look like it pulls the first record from the data base. Any other ideas?

[jskywalker]

how often does the "mysql_fetch_array" gets executed before you echo the results?

 

it think you do it 2 (two) times....

[Shockhazard30]

Thanks,

I just pulled out the first one and left the while loop in...

I am sure you can see I am new to this stuff.

I appreciate the help.