[SOLVED] brain fart - please help

[dmccabe]

I am having a memory blank moment.

 

I am running this query

 

			$editnewusers_qry = "SELECT * FROM `tbl_newsusers` WHERE `nuid` = '$nuid' ORDER BY nuid ASC";
			$editnewusers_result = mysql_query($editnewusers_qry);
			$first_name = $editnewusers_result['first_name'];	

 

Works fine apart from the setting a value for $first_name which doesnt contain a value, but should

 

Where am I going wrong now?

[conker87]

That's because you've not put it in an array, that's just running the query not getting any results.

 

Use mysql_fetch_array or mysql_fetch_row

[dmccabe]

sorry you lost me?

[kenrbnsn]

You have to use one of the mysql fetch functions to get the actual data.

 

<?php
$editnewusers_qry = "SELECT * FROM `tbl_newsusers` WHERE `nuid` = '$nuid' ORDER BY nuid ASC";
$editnewusers_result = mysql_query($editnewusers_qry);
$editnewusers_row = mysql_fetch_assoc($editnewusers_result);
$first_name = $editnewusers_row['first_name'];	
?>

 

Ken

[dmccabe]

ah ha!  thank you both kindly!

 

p.s. compliments to this forum as well, I have always received friendly courteous advice rather than people calling me a nublett

[conker87]

Most other forums are populated by 13 year old kids waring about which console will give them bigger and better graphics.

 

At PHPFreaks we take kindly on the beginners. And teach them the ancient* art of PHP.

 

 

(*note: PHP may not be ancient)