Database warning may be session is the problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This might look only like a warning message but it has been bugging me since
quite sometime now. Seek expert advice from the members of this forum
please.

Session at the top of the page;

<?
session_start();
if(!session_is_registered(emailAddress)){
header("location:store-login.php");
}
$_SESSION['email'] = 'emailAddress'
?>

Error on the database:

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on
MySQL result index 5 in thepath/pagename.php on line 132

My code is:

<?php
// database information
include "../includes/conf.php";

$query="SELECT * FROM table WHERE email =
'".mysql_real_escape_string($_SESSION['email']). "'";
$result=mysql_query($query);
$num=mysql_numrows($result);

mysql_close();
{
$1=mysql_result($result,$i,"1");
$2=mysql_result($result,$i,"2");
$3=mysql_result($result,$i,"3");
$4=mysql_result($result,$i,"4");
$5=mysql_result($result,$i,"5");
$6=mysql_result($result,$i,"6");
$7=mysql_result($result,$i,"7");
$8=mysql_result($result,$i,"8");
$9=mysql_result($result,$i,"9");
$10=mysql_result($result,$i,"12");
$11=mysql_result($result,$i,"11");
//$sno=mysql_result($result,$i,"sno");
//$url="../storeDiscription.php?sno=$sno";
}
?>

Please suggest a way out.

Many thanks,

Chris
-- 
View this message in context: http://www.nabble.com/Database-warning-may-be-session-is-the-problem-tf4503195.html#a12842959
Sent from the Php - Database mailing list archive at Nabble.com.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux