query not getting var

[dflow]

if the var is hard coded it is fine

im getting the session var as well

 

$userid is echoed but not affecting the query

echo $userid=$_SESSION['userid'];
mysql_select_db($database_sp, $sp);
$query_RsgetApID = 'SELECT * FROM users LEFT JOIN bookings_admin_users ON bookings_admin_users.username = users.username WHERE users.userid='.$userid.' LIMIT 0 , 30 ';

[mikesta707]

You need to use session_start in order to access the $_SESSION super global.

 

session_start(): http://php.net/manual/en/function.session-start.php

[dflow]

You need to use session_start in order to access the $_SESSION super global.

 

session_start(): http://php.net/manual/en/function.session-start.php

 

sorry these are lust the snippets of the query

 

i have session_start and im echoing it correctly

[Pikachu2000]

Have you echoed the actual query string?

[dflow]

here is what is echoed

SELECT * FROM users LEFT JOIN bookings_admin_users ON bookings_admin_users.username = users.username WHERE users.userid=0a0a4721be44a75ae8465e8c576b863b LIMIT 0 , 30 Unknown column '0a0a4721be44a75ae8465e8c576b863b' in 'where clause'

[mikesta707]

oh well since you seem to be using a string, you need to surround your $userid variable with quotes. This is assuming ur userid column is of type varchar

 

$query_RsgetApID = "SELECT * FROM users LEFT JOIN bookings_admin_users ON bookings_admin_users.username = users.username WHERE users.userid='.$userid.' LIMIT 0 , 30 ";

 

unless thats some sort of hex typed column or something, but the default type for hex numbers in mysql is a string if I remember correctly

[dflow]

oh well since you seem to be using a string, you need to surround your $userid variable with quotes. This is assuming ur userid column is of type varchar

 

$query_RsgetApID = "SELECT * FROM users LEFT JOIN bookings_admin_users ON bookings_admin_users.username = users.username WHERE users.userid='.$userid.' LIMIT 0 , 30 ";

 

unless thats some sort of hex typed column or something, but the default type for hex numbers in mysql is a string if I remember correctly

 

ok found the solution, silly syntax i put the var inside '".$userid."' 

$query_RsgetApID = "SELECT * FROM users LEFT JOIN bookings_admin_users ON bookings_admin_users.username = users.username WHERE users.userid='".$userid."' LIMIT 0 , 30 ";

[mikesta707]

Oh sorry, didn't noticed I misstyped there. yes thats correct