[RESOLVED] error: mysql_fetch_array() boolean given

[fati]

Hello,

I get this error

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\www2\MobileApp\projects\HistoryNotes.php on line 52

this is the code

<?php
$sql = "SELECT * FROM  `app` WHERE Dname = 'Mobile Malaysian History Notes';"; 
$result = mysql_query($sql);
$result1 = mysql_fetch_array($result);

?>

I have tried the SQL code in MyPHPAdmin and it worked.

please help me

thank you

[bradgrafelman]

You should be checking the return value of [man]mysql_query/man and, if it is boolean FALSE, outputting (or logging) the MySQL error message (see [man]mysql_error/man).

EDIT: Also, where do you ever connect to MySQL and select the appropriate DB before executing queries?

[fati]

thank you bradgrafelman

the problem was that I have not selected the db,

so I selectd the db after config.php at the beginning of the html code

and adjusted the code to:

<?php
$sql = "SELECT * FROM  `app` WHERE Dname = 'Mobile Malaysian History Notes';"; 
$result = mysql_query($sql);
$result1 = mysql_fetch_array($result);
echo "$result1";
?>

but the output is "Array" not my data 🙁

[fati]

but if I change this

$sql = "SELECT * FROM app WHERE Dname = 'Mobile Malaysian History Notes';";

to this:

$sql = "SELECT Desc FROM app WHERE Dname = 'Mobile Malaysian History Notes';";

it gives me the same error

and what i want is to retrieve the cell data not the whole row

[bradgrafelman]

fati wrote:

but the output is "Array" not my data

Well of course - that's because the mysql_fetch_*() functions return an array (as documented).

fati wrote:

what i want is to retrieve the cell data not the whole row

In that case, you should: 1) not be doing a 'SELECT ' (in fact, you should almost never do a 'SELECT ' - only SELECT the columns from which you actually need data), and 2) consider using [man]mysql_result/man instead of the 'fetch' functions.

[fati]

I tried using:
<?php
$sql = "SELECT * FROM app WHERE Dname = 'Mobile Malaysian History Notes';";
$result = mysql_query($sql);
echo mysql_result($result, 2);
?>

I get this error:

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 2 on MySQL result index 5 in C:\xampp\htdocs\www2\MobileApp\projects\HistoryNotes.php on line 53

[bradgrafelman]

You're still using 'SELECT *'. Don't. List the column(s) that you actually want data from.

Additionally, you're telling PHP that you want the result from the first field in the 3rd row of the result set, but the error message suggests that less than 3 rows were returned.

[fati]

thank you very much for your responds

I finally solved the problem

what i did is:

<?php
$sql = "SELECT * FROM app WHERE Dname = 'Mobile Malaysian History Notes';";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);

echo $row["Desc"]; //Desc is the field name in the table
?>

thank you very much
I appreciate your intention to help

tnx tnx tnx

[bradgrafelman]

Don't forget to mark this thread resolved (if it is) using the link on the Thread Tools menu above.

[fati]

if you don't mind , would you please help me to understand the mysql_result. I found it not clear in the php reference

this is my code

$sql = "SELECT Desc FROM app ";
$result = mysql_query($sql);
echo mysql_result($result, 0);

and I get error
Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\www2\MobileApp\projects\HistoryNotes.php on line 52

but if I select * it returns the first column

???

[bradgrafelman]

Same response as my first post above; you aren't checking to see that mysql_query() executed successfully (or, just as important, unsuccessfully).