PHP and Links

[davidf85]

I am trying to create a link with an ID from one of my MySQL records.

 

$data = mysql_query("SELECT * FROM USERS");

$info = mysql_fetch_array($data);

echo "<a href=a.php?'$info['id']'>hello</a>";

 

is what I am attempting, but this does not work. Any  ideas?

[harristweed]

$info = mysql_fetch_array($data);

Should be:

$info = mysql_fetch_array($data, MYSQL_ASSOC);

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

but I think better to use:

$info = mysql_fetch_assoc($data);

[voip03]

   		echo "<a href='a.php?id=".$info['id']."'>hello</a>";

[Pikachu2000]

To insert an associative array element into a quoted string, use complex notation; enclose it in curly braces.

 

echo "this is an {$array['element']} in a string";