strange recordset entries when underscore
When I try to apply the data assist wizard a strange behaviour occurs: If you take a look at the recordset you find a couple of missing params:
this is the code view:
<?php
$Paramkmysql_id_WADAkunden_mysql = "-1";
if (isset($_GET['kmysql_id'])) {
$Paramkmysql_id_WADAkunden_mysql = (get_magic_quotes_gpc()) ? $_GET['kmysql_id'] : addslashes($_GET['kmysql_id']);
}
$Paramkmysql_id2_WADAkunden_mysql = "-1";
if (isset($_GET['kmysql_id'])) {
$Paramkmysql_id2_WADAkunden_mysql = (get_magic_quotes_gpc()) ? $_GET['kmysql_id'] : addslashes($_GET['kmysql_id']);
}
$ParamSessionkmysql_id_WADAkunden_mysql = "-1";
if (isset($_GET['kmysql_id'])) {
$ParamSessionkmysql_id_WADAkunden_mysql = (get_magic_quotes_gpc()) ? $_GET['kmysql_id'] : addslashes($_GET['kmysql_id']);
}
mysql_select_db($database_lokal, $lokal);
$query_WADAkunden_mysql = sprintf("SELECT kmysql_id, kunden_id, mysql_server, mysql_db, mysql_login, mysql_passwd, changed FROM kunden_mysql WHERE kmysql_id = %s OR ( -1= %s AND kmysql_id= %s)", GetSQLValueString($Paramkmysql_id_WADAkunden_mysql, "int"),GetSQLValueString($Paramkmysql_id2_WADAkunden_mysql, "int"),GetSQLValueString($ParamSessionkmysql_id_WADAkunden_mysql, "int"));
$WADAkunden_mysql = mysql_query($query_WADAkunden_mysql, $lokal) or die(mysql_error());
$row_WADAkunden_mysql = mysql_fetch_assoc($WADAkunden_mysql);
$totalRows_WADAkunden_mysql = mysql_num_rows($WADAkunden_mysql);
?>
now take a look at the screenshots. You will notice that the URL params have disappeared whenever there is an underscore involved.
This only seems to happen if in the mysql database there are fields with underscores like "kunden_id"