Fetch only one row in PHP/MySQL

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, Dec 09 '12 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, Dec 09 '12 at 20:34

score 18 · Accepted Answer · edited Apr 08 '20 at 16:45

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 08 '20 at 16:45

Dharman

30,962
25
85
135

answered Dec 09 '12 at 20:35

jacoz

3,508
5
26
42

Obviously the SQL Query was done with the code you posted – wiredmark Dec 09 '12 at 20:35
1

+1. Please also provide the mysqli and/or PDO code to do it, as to have no excuse for not doing it. – Flavius Dec 09 '12 at 20:48
Thank you! I have chosen MySQLi and using it now :) – wiredmark Dec 24 '12 at 02:09

lupatus · Answer 2 · 2012-12-09T20:42:51.947

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 09 '12 at 20:42

answered Dec 09 '12 at 20:37

lupatus

4,208
17
19

score -2 · Answer 3 · answered Dec 09 '12 at 20:40

-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 09 '12 at 20:40

DrinkJavaCodeJava

812
8
22

Fetch only one row in PHP/MySQL

3 Answers3

Linked