Getting error while fetching array in php loop using Mysql

Question

I have the following code that has two queries. The first gets an ID that is going to be used on the next query. I this error on the second query:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\b\pprincipal.php on line 132

Here is the first query (For the ID of the user that has data present in that table)

$query2 = mysql_query("SELECT DISTINCT competencias, id_user FROM ce");
$ut = array();
while ($result = mysql_fetch_array($query2)) $ut[] = $result;
   foreach ($ut as $u){
 $id_user=$u[1];
 echo "<li class='has-sub'><a>" .$u[0]. "</a>";
}

And here is the Query that is giving me the error:

$query3 = mysql_query("SELECT id, nome FROM utilizadores WHERE id=$id_user");
$utt = array();
while ($result2 = mysql_fetch_array($query3, $con)) $utt[] = $result2;
foreach ($utt as $u2){
   echo "<ul><li><a>". $u2[0]. "</a></li>";
}

This second query is done right, because i have echoed the array and it was okay. But it gives me the error on the WHILE loop.

what is this 'mysql_fetch_array($query3, $con)' $con for ? you don't need it :) — Dwza, May 06 '14 at 08:56
Have you check your syntax of query? Columns names ? Please test your query at phpmyadmin's editor first. — abmussani, May 06 '14 at 08:58
You should have a look on mysql_error and check if your query was correctly answered by the server. — Daniel, May 06 '14 at 08:59
Side note: The `mysql_*` functions are becoming deprecated and will be removed from future PHP versions. Your code will stop working then. If you write new code use `mysqli_*` or PDO instead. — Gerald Schneider, May 06 '14 at 08:59

dx4 · Accepted Answer · 2014-05-06T09:13:25.890

5

I think the error could be here:

$query3 = mysql_query("SELECT id, nome FROM utilizadores WHERE id=$id_user");

If the "nome" indeed "nome" and not "name" then try this query:

$query3 = mysql_query("SELECT `id`, `nome` FROM utilizadores WHERE id='$id_user'");

Note that the ` is different than the '.

edited May 06 '14 at 09:13

answered May 06 '14 at 08:56

dx4

78
7

This made it work. Didn't know that there was a difference. Thank you very much :) – user3536315 May 06 '14 at 09:04

score 1 · Answer 2 · answered May 06 '14 at 08:57

1

you could try this

$query3 = mysql_query("SELECT id, nome FROM utilizadores WHERE id=$id_user");
$utt = array();
while ($result2 = mysql_fetch_array($query3)) $utt[] = $result2;
foreach ($utt as $u2){
   echo "<ul><li><a>". $u2[0]. "</a></li>";
}

you can't use connection handle on the mysql_fetch_array :)

array mysql_fetch_array ( resource $result [, int $result_type = MYSQL_BOTH ] )

btw you should use mysqli or pdo for db handling :)

answered May 06 '14 at 08:57

Dwza

6,358
4
38
66

I have tried that solution. But i got it solved. Thank you anyway :) – user3536315 May 06 '14 at 09:03
so if my answere didn't helped... i would be exited to hear how you solved it ?!?!?! :) – Dwza May 06 '14 at 09:06
Changeed the query3 to $query3 = mysql_query("SELECT `id`, `nome` FROM utilizadores WHERE id='$id_user'"); – user3536315 May 06 '14 at 09:14

score 0 · Answer 3 · answered May 06 '14 at 08:59

0

$query3 = mysql_query("SELECT id, nome FROM utilizadores WHERE id=$id_user");
$utt = array();
while ($result2 = mysql_fetch_array($query3, $con)) $utt[] = $result2;
foreach ($utt as $u2){
   echo "<ul><li><a>". $u2[0]. "</a></li>";
}

remove $con in your second while loop

answered May 06 '14 at 08:59

el3ien

5,121
1
15
31

read posts befor answering with the same content :) – Dwza May 06 '14 at 08:59
probably writing at the same time sry :) – el3ien May 06 '14 at 09:00

Getting error while fetching array in php loop using Mysql

3 Answers3