Topic: 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.