Selecting one row from MySQL using mysql API

Question

I have the following query   result   mysql query  quot SELECT option value FROM wp 10 options WHERE option name  homepage  quot     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

User · Answer

this shoude work        lt  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  lt  1   i          row  mysqli fetch assoc  result       emparray      row           echo  emparray       mysqli close  connection     gt

User · Answer

result   mysql query  SELECT option value FROM wp 10 options WHERE option name  homepage      row   mysql fetch assoc  result   echo  row  option value

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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   quot SELECT option value FROM wp 10 options WHERE option name  homepage  LIMIT 1 quot     row   mysqli fetch assoc  result   echo  row  option value

User · Answer

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

User · Answer

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

User · Answer

make sure your ftp transfers are in binary mode

User · Answer

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

User · Answer

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

User · Answer

use mysql fetch assoc to fetch the result at an associated array instead of mysql fetch array which returns a numeric indexed array

[php] Selecting one row from MySQL using mysql_* API

Examples related to php

Examples related to mysql