[sac0o01]

I have been working on a script that creates a directory named after the logged in username and then the user will be able to upload to that directory.

I am using the following to try and get the username so that I might insert it into the upload script path.

PHP Code:

<?php

session_start();

include_once("dbc.php");

   if(isset($_SESSION['userSession']) && !empty($_SESSION['userSession']))

 

        include_once("dbc.php");

$username = mysql_query("SELECT * FROM users WHERE username =".$_SESSION['userId']); 

?>

When I run it I get the following:
Error: The directory (/home2/freefor3/public_html/ rotas/sigs/Resource id #4) doesn't exist

Now I understand why it is printing out "Resource id #4" My question is what can I do to get it to return the username itself?

[Jcbones]

What is the user ID, is it the auto increment column?

PHP Code:

<?php
session_start();
include_once("dbc.php");
   if(isset($_SESSION['userSession']) && !empty($_SESSION['userSession']))
 
        include_once("dbc.php");
$result = mysql_query("SELECT name FROM users WHERE username ='".$_SESSION['userId'] . "'"); 
$row = mysql_fetch_row($result);
$username = $row[0];
?>

Change the query (name) to reflect exactly what column your looking for. I'm assuming 'userid' is the integer of the row.

PS. you could always just save the username into a $_SESSION variable.

[sac0o01]

Perfect! Thanks, I have been messing with this for hours. I had tried that approach before and it didn't work. It was your advice on the column that helped the most. I guess I need to study a little bit on database queries.

Thanks a million.