stupid question from a newbie

[flashx]

Hi guys,

 

im needing to grab information out of a mysql database field called "clientname" thats inside a table called "clients"

 

how do i retrieve the clients name in html and display it?

 

heres what i have so far, am just needing the code to retrieve...

 

$host = localhost;		
$dbuser = user;		
$dbpass = pass;		
$dbname = mydb;	

$connection = mysql_connect($host, $dbuser, $dbpass);	
$db = mysql_select_db($dbname, $connection);

// code to retrieve a particular clients details

 

 

 

 

Cheers,

[grlayouts]

$client = mysql_fetch_array(mysql_query("select * from clients'"));
print"$client[name]";

 

That would display if you had a field called name in the clients table. edit as appropriate.

[flashx]

Hi grlayouts,

 

thanks for your reply. that seems to work, thanks heaps

 

Cheers