Cannot Display Array from Select Statement + Login question

Posted on 16th Feb 2014 07:03 pm by admin

Hi,
I'm new to PHP but so far so goog. I was assigend a project and I'm very close to completion.

I have a site that logs you in, sets a cookie, and then what I would like to do is depending on the user loging in, certain records from a table are selected and displayed

I have the following code:

Code: // Connects to your Database
mysql_connect("localhost", "root", "escrma") or die(mysql_error());
mysql_select_db("rma_portal") or die(mysql_error());

//Set Login Variable with the UserID
$login = $_COOKIE['ID_my_site'];

echo "This is it set to $login

";

// Collects data from "users" table
$data = mysql_query("SELECT *
FROM users, cust_info
WHERE cust_info.Cust_ID = '.$login'")
or die(mysql_error());

// puts the "users" info into the $info array
$info = mysql_fetch_assoc($data);

//Test Print of Login ID passed value
echo $data; WORKS Resource id #3
echo $info["Cust_Name"]; DOES NOT WORK
echo "$Cust_Name"; DOES NOT WORK

echo "$login

"; WORKS
echo $info["Cust_Company"]; DOES NOT WORK


1 Question is why I can echo the $login but then I canot pull anything from the query?
Table users
Cust_ID, Username, Password
Table cust_info
Cust_ID, Cust_Name, Cust_Company, Cust_Phone.....

2 I don't know if using the Cookie variable to use the login is a good idea. What would be the best way to pass the username to next page so I can use it in the SELECT ststement. Should I use a _SESSION global?

Thanks in advance

Your Answer:

Login to answer

Other forums

DOMDocument parsing
Hello, I am parsing an xml file from an API which I have converted into a DOMDocument in php. This i

PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing

Dynamic Array using glob?
Is there an easier way to do this?

I am trying to get create a dyamic array based on files wi

Sending CC Info by email
I am a little bit less knowledgable in the security area as most developers and I know I have a lot

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

Need Reporting Advice
My SQL server doesn't support MS SQL reporting services that comes with SQL Enterprise or Express. T

Conditions of info record - Error
When i created GR (901) and PO create automatic my PBXX is obtain the net price of info record but

Code doesn't print what i wanted it too. Please help!
Hi there,

I wrote this code to mae it so that in the form before it that the user said their

Give me all your tricks for minimizing jar file size

Hi, I'm coming close to releasing my J2ME game... I am kicking up against the 64k size barrier w

script is pulling more then they have....
I have this script for my game where they can change there race. This will cost them 2,500 points. H