Getting value from existing query

[none]

Hi all, now if I've understood the code below correctly, if I add the
line;

$session_dean_id = $hResult('dean_id');

At the bottom I will create a new variable named '$session_dean_id'
which will have the value grabbed from the table 'iUser' from the
'dean_id' column. Am i right or way off?

Many thanks
$sQuery = "
Select iUser, dean_id
From tblUsers
Where sGUID = '$sGUID'";
$hResult = mysql_query($sQuery, $hDB);
if(!mysql_affected_rows($hDB)) {
// No match for guid
header('Location: ../login.php?refer='.urlencode($PHP_SELF.'?'.$HTTP_SE RVER_VARS['QUERY_STRING']));
}

[Jan Pieter Kunst]

In article <86**************************@posting.google.com >,
ki*****@aol.com (none) wrote:

Hi all, now if I've understood the code below correctly, if I add the
line;

$session_dean_id = $hResult('dean_id');

At the bottom I will create a new variable named '$session_dean_id'
which will have the value grabbed from the table 'iUser' from the
'dean_id' column. Am i right or way off?

Many thanks
$sQuery = "
Select iUser, dean_id
From tblUsers
Where sGUID = '$sGUID'";
$hResult = mysql_query($sQuery, $hDB);
if(!mysql_affected_rows($hDB)) {
// No match for guid
header('Location:
../login.php?refer='.urlencode($PHP_SELF.'?'.$HTTP_SE RVER_VARS['QUERY_STRING']
));
}

No, it should be:

if (mysql_num_rows($hResult) == 0) {

// mysql_num_rows is for SELECT queries
// mysql_affected_rows for UPDATE, INSERT and DELETE queries

// no match for guid

} else {

list($iuser, $session_dean_id) = mysql_fetch_row($hResult);
}

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.

[none]

Jan Pieter Kunst <de*****@cauce.org> wrote in message news:<de***************************@news1.news.xs4 all.nl>...

In article <86**************************@posting.google.com >,
ki*****@aol.com (none) wrote:

Hi all, now if I've understood the code below correctly, if I add the
line;

$session_dean_id = $hResult('dean_id');

At the bottom I will create a new variable named '$session_dean_id'
which will have the value grabbed from the table 'iUser' from the
'dean_id' column. Am i right or way off?

Many thanks
$sQuery = "
Select iUser, dean_id
From tblUsers
Where sGUID = '$sGUID'";
$hResult = mysql_query($sQuery, $hDB);
if(!mysql_affected_rows($hDB)) {
// No match for guid
header('Location:
../login.php?refer='.urlencode($PHP_SELF.'?'.$HTTP_SE RVER_VARS['QUERY_STRING']
));
}

No, it should be:

if (mysql_num_rows($hResult) == 0) {

// mysql_num_rows is for SELECT queries
// mysql_affected_rows for UPDATE, INSERT and DELETE queries

// no match for guid

} else {

list($iuser, $session_dean_id) = mysql_fetch_row($hResult);
}

JP

Right, i'm a little lost. The query code I grabbed from a login script
which checks if the user is logged in when accessing the page. I
wanted to get the 'dean_id' value at the same time this is happening
on each page by 'dean_id' to the query and creating a new variable
from it.

Are you saying then that the code I have used from an example I saw on
the net is wrong?

Many thanks.

[Jan Pieter Kunst]

In article <86**************************@posting.google.com >,
ki*****@aol.com (none) wrote:

Are you saying then that the code I have used from an example I saw on
the net is wrong?

What I'm saying is that in this code fragment:

$sQuery = "
Select iUser, dean_id
From tblUsers
Where sGUID = '$sGUID'";

$hResult = mysql_query($sQuery, $hDB);

if(!mysql_affected_rows($hDB)) {

}

mysql_affected_rows() is not used correctly. See
<http://nl.php.net/manual/en/function.mysql-affected-rows.php> for the
official word.

JP

--
Sorry, <de*****@cauce.org> is een "spam trap".
E-mail adres is <jpk"at"akamail.com>, waarbij "at" = @.