Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
Why dosent this work ?
Hi!
Have this function in my php file:
This function is called from a another php file:
And i have tested that the returnd value is correct.
Value from database is a varchar..
But get an error message from this line:
Error message is:
Unknown column 'K007' in 'where clause'
What is wrong ?
Have this function in my php file:
function brukerident($bruker_ID)
{
$uuk = mysql_real_escape_string($_COOKIE["uuk"]);
$sql = "SELECT Bruker_id FROM brukere WHERE uuk = '$uuk' LIMIT 1";
$res = mysql_query($sql);
// IF THE QUERY SUCCEEDED
if ($res)
{
// THERE SHOULD BE ONE ROW
$num = mysql_num_rows($res);
if ($num)
{
// RETRIEVE THE ROW FROM THE QUERY RESULTS SET
$row = mysql_fetch_assoc($res);
// STORE THE USER-ID IN THE SESSION ARRAY
return $row["Bruker_id"];
}
}
}
This function is called from a another php file:
$brukerID = brukerident('xxx');
And i have tested that the returnd value is correct.
Value from database is a varchar..
But get an error message from this line:
$result3 = mysql_query("SELECT Navn FROM {$table1} WHERE Bruker_id={$brukerID}") or die(mysql_error());
Error message is:
Unknown column 'K007' in 'where clause'
What is wrong ?
Asked:
Who is Participating?
What is Navn Data type ?? did you test printing the query.
break the sql to
and in your above function why do you are passing parameter $bruker_ID which is not using anywhere in function?
break the sql to
echo $q="SELECT Navn FROM {$table1} WHERE Bruker_id={$brukerID}";
$r=mysql_query($q) or or die(mysql_error());
and in your above function why do you are passing parameter $bruker_ID which is not using anywhere in function?
function brukerident($bruker_ID)
{
$uuk = mysql_real_escape_string($_COOKIE["uuk"]);
$sql = "SELECT Bruker_id FROM brukere WHERE uuk = '$uuk' LIMIT 1";
$res = mysql_query($sql);
// IF THE QUERY SUCCEEDED
if ($res)
{
// THERE SHOULD BE ONE ROW
$num = mysql_num_rows($res);
if ($num)
{
// RETRIEVE THE ROW FROM THE QUERY RESULTS SET
$row = mysql_fetch_assoc($res);
// STORE THE USER-ID IN THE SESSION ARRAY
return $row["Bruker_id"];
}
}
}
Hi!
The function returns correctly..
Have tested this by using echo...
Tested the output from the query :
SELECT Navn FROM Kontroller WHERE Bruker_id=K007
And that is correct ?
The function returns correctly..
Have tested this by using echo...
Tested the output from the query :
SELECT Navn FROM Kontroller WHERE Bruker_id=K007
And that is correct ?
Your error is related to table field
Unknown column 'K007' in 'where clause'can you fetch the record using above query?
SELECT Navn FROM Kontroller WHERE Bruker_id=K007
SELECT Navn FROM Kontroller WHERE Bruker_id='K007'
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
The problem was that i must use ' like this:
$result3 = mysql_query("SELECT Navn FROM {$table1} WHERE Bruker_id='{$brukerID}'") or die(mysql_error());