Retrieve One Row Of MySQL

[Lamer]

How do I retrieve only one row of database info? here's what I have so
far
<?php
$db_host = "localhost";
$db_user = "username";
$db_pwd = "password";
$db_name = "dbname";
mysql_connect($db_host, $db_user, $db_pwd);
mysql_select_db($db_name);
?>
<table>
<?php
$sql = "SELECT * FROM colors";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
echo "<tr>";
echo "<td>".$row['name']."</td>";
echo "<td>".$row['favoriteColor']."</td>";
echo "</tr>";
}
?>
</table>
</body>
</html>

Any help would be great. Thanks again!

[Rik Wasmus]

On Wed, 03 Oct 2007 16:41:08 +0200, Lamer <Ga******@gmail.comwrote:

How do I retrieve only one row of database info? here's what I have so
far
$sql = "SELECT * FROM colors";

http://dev.mysql.com/doc/refman/4.1/en/select.html
Check out the 'LIMIT' clause.
--
Rik Wasmus

[Claudio Corlatti]

On 3 oct, 11:41, Lamer <[e-mail]:

How do I retrieve only one row of database info? here's what I have so
far

<?php
$db_host = "localhost";
$db_user = "username";
$db_pwd = "password";
$db_name = "dbname";
mysql_connect($db_host, $db_user, $db_pwd);
mysql_select_db($db_name);
?>
<table>
<?php
$sql = "SELECT * FROM colors";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
echo "<tr>";
echo "<td>".$row['name']."</td>";
echo "<td>".$row['favoriteColor']."</td>";
echo "</tr>";}

?>
</table>
</body>
</html>

Any help would be great. Thanks again!

Hello,
well i didn't understand your question very well, but i suppose that
you want to obtain just one row from the table "colors".

to do that you need to add a "where" clause in your mysql query, for
instance "select * from colors where idColor=1"
or you can remove the while and keep only the line $row =
mysql_fetch_array($query); but is not the best way.

bye
Claudio

[axlq]

In article <11*********************@o80g2000hse.googlegroups. com>,
Claudio Corlatti <co******@gmail.comwrote:

>well i didn't understand your question very well, but i suppose that
you want to obtain just one row from the table "colors".

to do that you need to add a "where" clause in your mysql query, for
instance "select * from colors where idColor=1"

That will work, but a LIMIT should also be specified for efficiency.
The query "SELECT * FROM MyColorTable WHERE ColorID=26 LIMIT 1" will
cause MySQL to stop searching the table as soon as one row is found.
Otherwise it will keep searching for other rows with ColorID=26.

-A

[Shelly]

"axlq" <ax**@spamcop.netwrote in message
news:fe**********@blue.rahul.net...

In article <11*********************@o80g2000hse.googlegroups. com>,
Claudio Corlatti <co******@gmail.comwrote:

>>well i didn't understand your question very well, but i suppose that
you want to obtain just one row from the table "colors".

to do that you need to add a "where" clause in your mysql query, for
instance "select * from colors where idColor=1"

That will work, but a LIMIT should also be specified for efficiency.
The query "SELECT * FROM MyColorTable WHERE ColorID=26 LIMIT 1" will
cause MySQL to stop searching the table as soon as one row is found.
Otherwise it will keep searching for other rows with ColorID=26.

-A

WHY does the OP wand to stop at one? Is this simply check for the
existinance of some value in a particular field/ If that is so, why not use
the COUNT operator in the sql call?

Shelly

[rf]

"Gary L. Burnore" <gb******@databasix.comwrote in message
news:fe**********@blackhelicopter.databasix.com...

You sure quoted a lot

as did you :-)

to say "I agree" :)

[Claudio Corlatti]

On 3 oct, 21:09, [e-mail] (axlq) wrote:

In article <[e-mail]. com>,
Claudio Corlatti <[e-mail]:

well i didn't understand your question very well, but i suppose that
you want to obtain just one row from the table "colors".

to do that you need to add a "where" clause in your mysql query, for
instance "select * from colors where idColor=1"

That will work, but a LIMIT should also be specified for efficiency.
The query "SELECT * FROM MyColorTable WHERE ColorID=26 LIMIT 1" will
cause MySQL to stop searching the table as soon as one row is found.
Otherwise it will keep searching for other rows with ColorID=26.

-A

yes, you are right the limit function is the best option in this case.