SQL Session Variable match to DB

[Sitehelp]

Anyone know why I cannot match the clientID (which is passed in the session) with a clientID in the DB. Code is:

<?php
session_start() ;
$Client_OpenCallList = &quot;1&quot;;
if (isset($HTTP_SESSION_VARS['ClientID'])) {
$Client_OpenCallList = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['ClientID'] : addslashes($HTTP_SESSION_VARS['ClientID']);
}
mysql_select_db($database_MARTIN, $MARTIN);
$query_OpenCallList = sprintf(&quot;SELECT * FROM callinfo WHERE callinfo.ClientID = %s&quot;, $Client_OpenCallList);
$OpenCallList = mysql_query($query_OpenCallList, $MARTIN) or die(mysql_error());
$row_OpenCallList = mysql_fetch_assoc($OpenCallList);
$totalRows_OpenCallList = mysql_num_rows($OpenCallList);
?>

It is bringing an error message saying Unknown CLIENTID in the Where clause

Cheers!

 

[sleipnir214]

What query are you sending to MySQL?

If you print it to the browser, copy-and-paste it into your preferred MySQL admin tool and run the query, does it return the results you expect?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

Also, unless you're using a version of PHP older than 4.1.0, you can use $_SESSION instead of $HTTP_SESSION_VARS. $_SESSION is both superglobal and easier to type.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Sitehelp]

the query is:

SELECT *
FROM callinfo
WHERE callinfo.ClientID = Client

Where client refers to

$_SESSION ['ClientID']

So basically when the user clicks onto the page, as they already signed into the session on a previous page, they should immiediately see all the calls they have open under there clientid name. The clientID is the username they typed in on the login page, I know this is working as it is working for other pages, but for different commands. for some reason on this page I recieve the message:

Unknown column 'THE CLIENT ID ENTERED ON LOGIN PAGE' in 'where clause'

Cheers for the help here!

 

[Sitehelp]

dont ask me how but its working now, If I find the reason I will post it here! cheers anyway!

 

[sleipnir214]

I have general advice on debugging PHP database access code in my FAQ: faq434-2999

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!