character session variable
Now I have tested the query and found that using a session variable which is a number the graph displays perfectly, but when using a text session variable the data does not show in the graph.
Here is the query with the number session variable which is working perfectly:
<?php
$WADWCs_bygd_WADWCaldursbyti_bygd = "-1";
if (isset($_SESSION['s_bygd'])) {
$WADWCs_bygd_WADWCaldursbyti_bygd = $_SESSION['s_bygd'];
}
mysql_select_db($database_manntal, $manntal);
$query_WADWCaldursbyti_bygd = sprintf("SELECT aldur AS XLABEL, m_tal AS YVALUE FROM aldursbyti_bygd WHERE aldur = %s", GetSQLValueString($WADWCs_bygd_WADWCaldursbyti_bygd, "int"));
$WADWCaldursbyti_bygd = mysql_query($query_WADWCaldursbyti_bygd, $manntal) or die(mysql_error());
$row_WADWCaldursbyti_bygd = mysql_fetch_assoc($WADWCaldursbyti_bygd);
$totalRows_WADWCaldursbyti_bygd = mysql_num_rows($WADWCaldursbyti_bygd);
?>
Do you have any suggestion what to do when using a text session variable?
Sincerely Lena


