php/mysql error, Not fetching any information?

[ash992]

Hey guys, So I'm not quite sure why this isn't working but it Isn't echoing the information that's in the database, I've tried echoing the company name and that's working fine, and the company name does exist in the MySQL database, as does the UID on the same row? Any ideas? Thanks very much guys!

 

<?php
session_start();
include ("connect.php");
$Companyname = $_SESSION['Companyname'];
$a = mysql_query("SELECT * FROM Users
WHERE Companyname='$Companyname'") or die(mysql_error());  
$b = mysql_fetch_array( $a );
$UID = $b['UID'];
echo $UID;
?>

[jazzman1]

Take off the single quotes from your query statement:

<?php 
$a = mysql_query("SELECT * FROM Users WHERE Companyname=$Companyname");

[ash992]

Thank's very much

[PFMaBiSmAd]

The only way that removing the single quotes from inside the query statement would cause your code to start working is if the actual value in $_SESSION['Companyname']/$Companyname already has quotes around the data value. What's your code that is setting $_SESSION['Companyname']?

[jazzman1]

@ash992, take a look at how to php varible in sql query -> http://forums.mysql.com/read.php?52,144546,144546