Mysql select tip

Expand Post »

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

(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

Similar Threads

MySQL SELECT rows In a Date Range in MySQL
MySQL multitable select problem. in MySQL
Mysql select query takes more time in MySQL
Displaying a limited number of words from MySQL in PHP
how to view the data accessed using mysql select statement in Visual Basic 4 / 5 / 6

rajeesh_rsn

Reputation Points: 10

Solved Threads: 0

Posting Whiz in Training

Offline

265 posts
since Sep 2008

Permalink

Oct 11th, 2009

Re: Mysql select tip

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

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());

mwasif

Reputation Points: 29

Solved Threads: 47

Posting Whiz

Offline

312 posts
since Dec 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: mysql query

Next Thread in MySQL Forum Timeline: MySql Service doesn't run

DaniWeb Message

Cancel Changes

User Name
Password