Waht means this error message?

Elhombrebala

Resource id #4 :You have an error in your SQL syntax near 'Resource id #4' at line 1

LordShryku

It means you're querying against a function. Like you did this

$blah = mysql_query("SELECT* FROM somewhere");
mysql_query($blah);

Elhombrebala

I think I found the problem you told me, but now code staumbles here. I'm storing sessions with user and pass, when I make this query I get no answer but it should give at least 1 result, because session is unique.
Why it doesn't give me any feed back?
(If I echo $session, it exist, is the same as session_id())

<?php
session_start();
if (session_is_registered('usuario')){
echo "";
}
else{
header("Location: acceso6.html?errorusuario=si");
}
$session=session_id();
echo $session;
?>
<?
$link = mysql_connect ('', '', '');
mysql_select_db("aa3968",$link);
$result = mysql_query("SELECT Inmo FROM DatosInmueble WHERE (Sesion='$session')", $link);
echo $result["Inmo"];

LordShryku

becuase again, echo $result["Inmo"]; should do nothing but echo the resource id. You need to fetch the row using mysql_fetch_row, mysql_fetch_array, mysql_fetch_object, etc.

Pig

The problem is that you are trying to echo the result, when the result is simply a mathematical pointer to the actual results of query. It is simply a handle to get at the results. You need to use mysql_fetch_array, mysql_fetch_row, mysql_fetch_assoc to get the results.

Elhombrebala

<?
$link = mysql_connect('', '', '');
mysql_select_db("aa3968",$link);
$result = mysql_query("SELECT Inmo FROM DatosInmueble WHERE (Sesion='$session')", $link);
while($row = mysql_fetch_array($result)) {
echo $row["Inmo"];

}
mysql_free_result($result);
?>

I have tried this, but I get an extrange error or echoing:

echo $result["Inmo"]; echo $result['Inmo']; echo $result[Inmo]; //$base="aa3968"; //$tabla="Clientes"; //$tabla2="DatosInmueble"; //$conexion=mysql_connect("mysql.gestionar.info","aa1126","massiveA"); //mysql_select_db($base,$conexion); //$pegar2 = "SELECT Inmo FROM DatosInmueble WHERE (Sesion='$session')"; //$result = mysql_fetch_row($pegar2); //$Inmo = $result["Inmo"]; //echo $Inmo; ?>

Elhombrebala

It is not any echoing, is just that I'm so stupid that I left some code outside of <?¿>
But anyway, it is echoing nothing by the way.
What's wrong?

Pig

echo mysql_num_rows to see how many records it is returning.