Selecting one row from MySQL using mysql_* API

Question

I have the following query:

$result = mysql_query("SELECT option_value FROM wp_10_options WHERE option_name='homepage'");
$row = mysql_fetch_array($result);
print_r ($row);

and the output I am getting is:

Resource id #2

Ultimately, I want to be able to echo out a single field like so:

$row['option_value']

Without having to use a while loop, as since I am only trying to get one field I do not see the point.

I have tried using mysql_result with no luck either.

Where am I going wrong?

possible duplicate of Use Single Row Query with MySQL and PHP — Widor
– Widor, Commented May 15, 2012 at 16:59
This should work. Your error hides elsewhere. In your file, is there any sourcecode in between these lines? — Michael Seibt
– Michael Seibt, Commented May 15, 2012 at 17:01
Does this answer your question? Simple way to read single record from MySQL — Dharman
– Dharman ♦, Commented Aug 12, 2020 at 12:46

Moyed Ansari · Accepted Answer · 2012-05-15 17:38:22Z

35

Try with mysql_fetch_assoc .It will returns an associative array of strings that corresponds to the fetched row, or FALSE if there are no more rows. Furthermore, you have to add LIMIT 1 if you really expect single row.

$result = mysql_query("SELECT option_value FROM wp_10_options WHERE option_name='homepage' LIMIT 1");
$row = mysql_fetch_assoc($result);
echo $row['option_value'];

answered May 15, 2012 at 17:38

Moyed Ansari

8,4612 gold badges38 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Borna Over a year ago

Outed answer. mysql_* is deprecated.

JSowa Over a year ago

Solution for PHP 7. stackoverflow.com/a/62100523/7082164

PHP kid Over a year ago

$result = mysqli_query($connection, "SELECT option_value FROM wp_10_options WHERE option_name='homepage' LIMIT 1"); $row = mysqli_fetch_assoc($result); echo $row['option_value'];

JSowa · Accepted Answer · 2020-10-09 13:53:28Z

5

Functions mysql_ are not supported any longer and have been removed in PHP 7. You must use mysqli_ instead. However it's not recommended method now. You should consider PDO with better security solutions.

$result = mysqli_query($con, "SELECT option_value FROM wp_10_options WHERE option_name='homepage' LIMIT 1");
$row = mysqli_fetch_assoc($result);
echo $row['option_value'];

edited Oct 9, 2020 at 13:53

answered May 30, 2020 at 9:31

JSowa

10.8k7 gold badges66 silver badges70 bronze badges

Comments

Phix · Accepted Answer · 2012-05-15 17:02:15Z

4

$result = mysql_query("SELECT option_value FROM wp_10_options WHERE option_name='homepage'");
$row = mysql_fetch_assoc($result);
echo $row['option_value'];

answered May 15, 2012 at 17:02

Phix

10.1k4 gold badges39 silver badges65 bronze badges

Comments

Ehsan Khodarahmi · Accepted Answer · 2012-05-15 17:07:48Z

1

use mysql_fetch_assoc to fetch the result at an associated array instead of mysql_fetch_array which returns a numeric indexed array.

answered May 15, 2012 at 17:07

Ehsan Khodarahmi

4,97210 gold badges66 silver badges97 bronze badges

Comments

ByteHamster · Accepted Answer · 2015-05-09 15:46:03Z

1

Though mysql_fetch_array will output numbers, its used to handle a large chunk. To echo the content of the row, use

echo $row['option_value'];

edited May 9, 2015 at 15:46

ByteHamster

4,9619 gold badges41 silver badges56 bronze badges

answered May 9, 2015 at 15:29

Asuquo12

85518 silver badges27 bronze badges

Comments

Waseem shah · Accepted Answer · 2017-01-08 19:58:53Z

1

Try this one if you want to pick only one option value.

$result = mysql_query("SELECT option_value FROM wp_10_options WHERE option_name='homepage'");
$row = mysql_fetch_array($result);
echo $row['option_value'];

answered Jan 8, 2017 at 19:58

Waseem shah

4407 silver badges14 bronze badges

Comments

Narf · Accepted Answer · 2012-05-15 17:00:48Z

0

What you should get as output with this code is:

Array ()

... this is exactly how you get just one row, you don't need a while loop. Are you sure you're printing the right variable?

answered May 15, 2012 at 17:00

Narf

14.8k3 gold badges40 silver badges68 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

Ultimately, I want to be able to echo out a signle field like so:
   $row['option_value']

So why don't you? It should work.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered May 15, 2012 at 17:09

Daniel Pecher

2022 silver badges10 bronze badges

Comments

ketan · Accepted Answer · 2015-05-11 10:45:16Z

0

It is working for me..

$show = mysql_query("SELECT data FROM wp_10_options WHERE
 option_name='homepage' limit 1"); $row = mysql_fetch_assoc($show);
 echo $row['data'];

edited May 11, 2015 at 10:45

ketan

19.4k42 gold badges68 silver badges107 bronze badges

answered Jul 3, 2013 at 11:04

Deepak Ghayal

11

Comments

Kamil · Accepted Answer · 2016-01-22 12:53:56Z

0

is this is a WordPress? You shouldn't do it like you've done! To get option from DB use get_option!

answered Jan 22, 2016 at 12:53

Kamil

2274 silver badges16 bronze badges

Comments

soma · Accepted Answer · 2016-09-15 15:58:33Z

0

this shoude work

    <?php

require_once('connection.php');

 //fetch table rows from mysql db
$sql = "select  id,fname,lname,sms,phone from data";

    $result = mysqli_query($conn, $sql) or die("Error in Selecting " . mysqli_error($conn));

    //create an array
    $emparray = array();

for ($i = 0; $i < 1; $i++) {
   $row =mysqli_fetch_assoc($result);

} $emparray[] = $row;
         echo $emparray ;
    mysqli_close($connection);
?>

answered Sep 15, 2016 at 15:58

soma

711 silver badge10 bronze badges

Comments

tekagami · Accepted Answer · 2017-04-30 21:43:58Z

-2

make sure your ftp transfers are in binary mode.

answered Apr 30, 2017 at 21:43

tekagami

1012 silver badges5 bronze badges

Collectives™ on Stack Overflow

Selecting one row from MySQL using mysql_* API

12 Answers 12

3 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

12 Answers 12

3 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related