Fetch only one row in PHP/MySQL [duplicate]

Question

Possible Duplicate:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in select

simple question here.

I have a SELECT query

SELECT FROM friendzone WHERE ID = '$editID'"

I am sure this is going to give me only one row as result, cause ID's can't be duplicate in my DB.

How can I access the column values?

$row = mysql_fetch_array($query);

I think this is useless since I don't have to make any array.. I have only one row!

If I don't put it into a While cicle, and try to do e.g.

.$row['ID'].

I get:

mysql_fetch_array() expects parameter 1 to be resource, boolean given

Thanks in advance everyone.

Are you trying to select a row with a specific id? If so do you want it to always select that row or do you want it done dynamically? — DrinkJavaCodeJava
– DrinkJavaCodeJava, Commented Dec 9, 2012 at 20:33
Your SELECT statement is invalid - you have no columns specified or SELECT * Your query fails, and you don't do any error checking. — Michael Berkowski
– Michael Berkowski, Commented Dec 9, 2012 at 20:34

Dharman · Accepted Answer · 2020-04-08 16:45:22Z

18

Please, don't use mysql_* functions in new code. They are no longer maintained and the deprecation process has begun on it. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

Try with:

$query = mysql_query("SELECT * FROM friendzone WHERE ID = '$editID'");
$row = mysql_fetch_array($query);

print_r($row);

MySQLi code:

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$conn = new mysqli('host', 'username', 'password', 'database');
$stmt = $conn->prepare("SELECT * FROM friendzone WHERE ID = ?");
$stmt->bind_param("s", $editID);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();

print_r($row);

edited Apr 8, 2020 at 16:45

Dharman♦

34k27 gold badges106 silver badges158 bronze badges

answered Dec 9, 2012 at 20:35

jaco

3,5265 gold badges28 silver badges43 bronze badges

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

3 Comments

wiredmark Over a year ago

Obviously the SQL Query was done with the code you posted

Flavius Over a year ago

+1. Please also provide the mysqli and/or PDO code to do it, as to have no excuse for not doing it.

wiredmark Over a year ago

Thank you! I have chosen MySQLi and using it now :)

lupatus · Accepted Answer · 2012-12-09 20:42:51Z

3

Probably your $query is equal false because something went wrong, try mysql_error() to see whats wrong.

And 2 small advices:

would be better to use PDO od mysqli as mysql_* functions are deprecated.
use at least mysql_real_escape_string() to escape the value before putting it into SQL string

edited Dec 9, 2012 at 20:42

answered Dec 9, 2012 at 20:37

lupatus

4,25320 silver badges19 bronze badges

Comments

DrinkJavaCodeJava · Accepted Answer · 2012-12-09 20:40:05Z

-2

Since I don't know what columns your trying to select the general syntax for select is

"SELECT column1, column2, column3 FROM friendzone WHERE ID ='$editID'"

Or if you want to select all columns just type

"SELECT * FROM friendzone WHERE ID = '$editID'"

answered Dec 9, 2012 at 20:40

DrinkJavaCodeJava

8089 silver badges22 bronze badges

Collectives™ on Stack Overflow

Fetch only one row in PHP/MySQL [duplicate]

3 Answers 3

3 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Linked

Related