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

webpage with (simple) login & mysql-db
Hi all,

What I was looking for before was a multi-user password manager, web-based! The offer

Help If user voted, block them
On my Prayer request site, i let users Click a button to Pray for somone that has posted a pray, i g

form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how

Parse Error with doctype
I'm getting a parse error with this simple code. I don't get it. It worked one time then when I relo

Files in current folder. Should be an easy fix.
Never mind. I've asked about this before and just found my answer. Anyway to delete this?

standard ALV application toolbar, into custom report....
HI,

I have a question regarding displaying standard ALV menu path and application toolbar

keeps going back to index.html ???????
ok so i started making my site using mostly.html files now i have added a fair chunk of php. My inde

delete comma
HI,

How to delete "," at the end of the string.
Code: $match = 2009/02/03/a2corr

Checking BOM Authorization Group
Hai Friends,

I have developed a mulitilevel BOM display report. End users have been assig

DYNPRO_FIELD_CONVERSION
Hi gurus,

I got a dump when I run one of my program. the dump is described below: