Click to See Complete Forum and Search --> : Why this error?


Perfidus
11-27-2003, 03:17 PM
<?php
//page2
session_start();
if (session_is_registered('usuario')){
}
else{
header("Location: acceso6.html?errorusuario=si");
}
$session= session_id();
$base="";
$conexion=mysql_connect("","","");
mysql_select_db($base,$conexion);
$pegar2 = "SELECT Inmo FROM Sesiones WHERE Sesion='$session'";
$row = mysql_fetch_array($pegar2);
$Inmo = $row["Inmo"];
?>

ERROR:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /chs/p1/costa4seasons.com/home/html/panelcontrol.html on line 13

pyro
11-27-2003, 03:45 PM
You never ran the query. Change this:

$pegar2 = "SELECT Inmo FROM Sesiones WHERE Sesion='$session'";
$row = mysql_fetch_array($pegar2);
to:

$pegar2 = "SELECT `Inmo` FROM `Sesiones` WHERE `Sesion`='$session'";
$results = mysql_query($pegar2);
$row = mysql_fetch_array($results);