MySQL

Mysql select tip

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2008

Posts: 136

Reputation: rajeesh_rsn is an unknown quantity at this point

Solved Threads: 0

rajeesh_rsn rajeesh_rsn is offline

Offline

Junior Poster

Mysql select tip

Oct 11th, 2009

Hai,

I had a mysql database and it contain columns like "id" and "name".

I am using the following query for selecting a name with an id .

My code is

Help with Code Tags

(Toggle Plain Text)

$row=mysql_select("SELECT * FROM table where id='1'") or die(mysql_error());
$result=mysql_fetch_array($ROW);

$name=$result['name'];

It works and my problem is please let me know whether it is the easy way ? Or there is any other way to do this ?

Thanks in advance
Rajeesh

•

Join Date: Dec 2007

Posts: 190

Reputation: mwasif is an unknown quantity at this point

Solved Threads: 25

mwasif

Offline

Junior Poster

Oct 11th, 2009

This is the way to do. If you need only name from the db, then simply use name in the SELECT statement instead of *.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$row=mysql_select("SELECT name FROM table where id='1'") or die(mysql_error());
$row=mysql_select("SELECT name FROM table where id='1'") or die(mysql_error());