mysql_fetch_array mysql_num

Question

I received the following warning :

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

When I try this code :

$wyn_sport = mysql_query("SELECT a.title, a.content, a.id, FROM article a
LEFT JOIN section s
ON a.id`enter code here`_section=s.id
WHERE s.name='Sport'
ORDER BY date_art desc");
$sport = mysql_fetch_array($wyn_sport, MYSQL_NUM);

$wyn_film = mysql_query( "SELECT a.title, a.content, a.id FROM article a
LEFT join section s on a.id_section=s.id
WHERE s.name='Film'
ORDER BY date_art desc");
$film = mysql_fetch_array($wyn_film, MYSQL_NUM);

$wyn_nauka = mysql_query( "SELECT a.title, a.content, a.id FROM article a
LEFT join section s on a.id_section=s.id
WHERE s.name='Nauka'
ORDER BY date_art desc");
$nauka = mysql_fetch_array($wyn_nauka, MYSQL_NUM);

Note that your first query has `'enter code here'` in the middle of it. I assume that is a copy/paste issue, and not with your code? — Ken Herbert, Mar 26 '13 at 22:59
Query fails, please update the question to the current query that your using — kabuto178, Mar 27 '13 at 02:10

score 0 · Answer 1 · answered Mar 26 '13 at 22:56

0

That would probably mean your query is failing and returns false. You are then trying to perform mysql_fetch_array() on a value of false.

answered Mar 26 '13 at 22:56

Ken Herbert

5,127
5
28
37

Look at the comment with the link as a possible duplicate above (second one for your actual question) - it will give you some ideas on how to sift out errors like that. – Ken Herbert Mar 26 '13 at 23:14

What have you tried · Answer 2 · 2013-03-26T23:16:09.513

0

@winterblood already pointed this out, but this is clearly the issue ... You have some random enter_code_here in your query where it doesn't belong

    $wyn_sport = mysql_query("SELECT a.title, a.content, a.id, FROM article a
    LEFT JOIN section s
    ON a.id =s.id
    WHERE s.name='Sport'
    ORDER BY date_art desc");
    if(!$sport = mysql_fetch_array($wyn_sport, MYSQL_NUM)){
    echo mysql_error();

}

The above should work

edited Mar 26 '13 at 23:16

answered Mar 26 '13 at 23:07

What have you tried

10,650
4
30
45

Damn man you really think I am so stupid? :D – user2213627 Mar 26 '13 at 23:10
hm? ... I'm not sure how to respond to that – What have you tried Mar 26 '13 at 23:11
Sorry man for that, I didn't read it correctly :D but its still not working :( – user2213627 Mar 27 '13 at 00:07
@user2213627 Use the latest update, it will give you the error that is occurring if one actually does occur. Notice the use of `mysql_error()` – What have you tried Mar 27 '13 at 00:10

mysql_fetch_array mysql_num

2 Answers2