[RESOLVED] Error with my MySQL query

[spiritssight]

I am running the following code:

	// selects Col EIN from table and gives one result back with only the EIN col
	$query_s = "SELECT EIN FROM irs_rawdata LIMIT 0,1";
	$result_s = mysql_query($query_s) OR die("Sorry, unable to to select ein for the first record! <br /> ". mysql_error());
	$record = mysql_query($result_s['EIN']);
echo $record." --  Testing see if result shows with EIN";

when I run this query it does not show the results, I don't see any thing wrong with it, am I not calling the var up right?

Thanks ahead of time!

Christopher

[NogDog]

mysql_query() returns a resource ID, not the actual query results. (Or, it returns FALSE if the query fails.) You need to use a function such as [man]mysql_fetch_assoc/man to get the results from that resource ID.

[spiritssight]

Thanks again, I thought that you only need that when pulling more then one record.

could I use count and get the number of rows instead of having use the fetch and that when I only need to know if it found a match?

Sincerely,
Christopher

[bradgrafelman]

spiritssight wrote:

Thanks again, I thought that you only need that when pulling more then one record.

Nope, you can simply call it once to get the first row. Note that if you only have one column selected, you could use [man]mysql_result/man instead.

spiritssight wrote:

could I use count and get the number of rows instead of having use the fetch and that when I only need to know if it found a match?

Yup.