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

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

Problems with returning true or false in eval()'d code
Hi guys,

Would appreciate some help with a problem when running eval() on a function that sho

Text file to .Dat file Conversion in PHP
Hi All,
Could anybody provide code for Text file to .Dat file Conversion in PHP.

Tha

gettext translates ALWAYS?
I'm using gettext with the new version of XAMPP (5.3.0) on Windows Seven RTM (build 7600)
gettext

grouping within a foreach?
hello all,

I currently have a list of products spit out from my db via a foreach loop. Right

DOMDocument
Hello All,

I need to take an XML document, modify some of the nodes in it and then perform a

How to use php and sql to check if values match the ones in a table (for logins)
How would I code it that the script takes two variables that are passed to it (UserID and PIN), and

retrieving more than one max key from an array?
so i have an array of 20 numerical values (0-100) that i need to order from highest to lowest and th

losing variables between php brackets
Hi

have got this code:
Code: $id=mysql_result($result,0,"itemid");
$title=mys

Deleted Delivery but material wont return
We deleted a delivery but the material its still pending.

We made a reverse goods movemen