Shouldn't this work?

[zinja]

I am trying to get a value from a table and am using the following query. The company_name is a string (varchar). What am I doing wrong?

$companyname = mysql_query ("SELECT company_name FROM pmr_users WHERE login = '" . $loginid . "'" );

LJ Wilson

My personal saying - Just remember, it can always get worse, and usually will.

 

[sleipnir214]

mysql_query() does not return a value. It returns a handle to the resultset containing the value. This handle is similar to the filesystem handle fopen() returns in that you need additional functions to access the data through the handle.

You'll need one of the mysql_fetch_*() functions. Look at the example code here:

http://www.php.net/manual/en/function.mysql-fetch-assoc.php

Want the best answers? Ask the best questions! TANSTAAFL!

 

[jpadie]

mysql_query returns a resource handle.

to get the result you then need to do something like

$row = mysql_fetch_assoc($result);
print_r ($row);

read up on the mysql functions in the excellent online php manual