[Resolved] query does not want to run?!

phpjaco

hello

i have the following query:

$sql = "select * from temp_user where session_id = '$session_name'";

session_name is my session_id() taken from another page, and this also seems valid [echo($session_name) gives me the correct value]

session_id is of course stored on my database and is the same value as session_name?!

but this gives me no rows though i can see the rows in my phpMyAdmin and also when i print out the query it seems valid, why would this not work?

if i try it without the where section it works?

thanx in advancce

hmemnon

I know this is pretty obvious, but you do mysql_query($sql) the db, right?

Cheers

phpjaco

here is a little bit more of the code but it seems to get stuck whenever i put in the where in my sql query...

 $sql = "select * from temp_user where session_id = '$session_name'";

  $rs = mysql_query($sql,$conn);

  $num_rows = mysql_num_rows($rs);
  if ($num_rows > 0) {

is kinda strange cause i have never had this problem before..

phpjaco

ok so i know that session_name is there, since i printed out

$write_name = "session name : ".$session_name;

but when i try different queries for e.g

$sql = "select * from temp_user where session_id > ''";

this also gives me valid results, i just dont understand why my session_name disapears the moment i use it in my query?

hmemnon

If you are using a VARCHAR field, check for it's size, maybe it's truncating some of the sessid...

Cheers

phpjaco

indeed, it was.

on my other page i put $session_name = substr($session_name,0,24)

and problem has gone away...