Resource Id#2 ?

[Gem]

Hi ..  anyone know what that means??

 

When the code below loads, I get a link for Resource Id # 2 ???

 

<?php
// database connection info
$conn = mysql_connect("80.94.196.33","user","password") or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('bssql',$conn) or trigger_error("SQL", E_USER_ERROR);



$title = mysql_query ("SELECT title, subtitle FROM articles ORDER BY ID DESC");

 echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$title'>$title</a>"; 
?>

[PFMaBiSmAd]

http://www.phpfreaks.com/forums/index.php/topic,246110.msg1150427.html#msg1150427

[wildteen88]

mysql_query does not return anything. It only returns a result resource.

 

You need to use one of the mysql_fetch_* functions to get the results from a query.

 

For example

$result = mysql_query ("SELECT title, subtitle FROM articles ORDER BY ID DESC");
while(list($title, $subtitle) = mysql_fetch_row($result))
{
    echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$title'>$title</a>";
}

[Gem]

Thank you, that did it.  I have another problem now but will post as new topic.

 

Thanks again

 

Gem