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

What makes a script your own?
If someone finds a login script online, and changes some variable names around and some other minor

mySQL and PHP search
Hello,
I am trying to code a project and ran into a brick wall with one of my pages. I am pretty

Displaying pictures
i have worked my way through storing images in directory and storing the location in mySQL db.Now i

Get content from table into a list, without repeating.
Alright this is kinda an odd thing, so I need some help.

I have a table "quote" wit

Pipe email to PHP - get mail adress from MySQL - send?
Hi all,

this is the challenge:

1) Our faculty at the college where I'm employed includ

MS Access data into a html table
Hi everyone, I am quite a novice at php but I have created some helpful scripts that fetch data
f

Problem executing bash script using shell_exec
Hi there,
I created a bash script file using following code to convert doc documents to pdf using

void* and sizeof()
Hi,

Using void* and sizeof is it possible to get the value of the object ?

I understan

question about header() security
is is safe to just use the header() function to redirect someone if they are, say, not logged in? or

Problems with array
This code is the last lines in an upload script that uploads 4 images at the same time and writes th