Warning: mysql_query() expects parameter 2 to be resource, string given on line 103

Question

Hello I AM getting this error i am a newbie pls help..

<?php
$queryyy=mysql_query($conn,"select * from comments where type='".$platform."' AND app_id=".$id." order by id DESC");
$queryyy = mysql_query($sql);
if (!$queryyy) {
   die('Invalid query: ' . mysql_error());
   }


while($rowww=mysql_fetch_array($queryyy))
{
echo $rowww['comm']."<hr/>";
}
?>

Here is my code..

for comment box ..where users can comment on downloading file — Punjabii, Oct 30 '14 at 06:14
Why are you using `mysql_query` twice? Remove one. Plus, you're using `mysqli_` connection syntax. Are you even connected to DB? — Funk Forty Niner, Oct 30 '14 at 06:17

arif_suhail_123 · Answer 1 · 2014-10-30T06:39:02.720

1

try this

    <?php
$queryyy=mysql_query("select * from comments where type='".$platform."' AND app_id=".$id." order by id DESC") or die(mysql_error());//it will give you the right error



while($rowww=mysql_fetch_array($queryyy))
{
echo $rowww['comm']."<hr/>";
}
?>

Learn mysqli or PDO.

And in MYSQL connection is optional and its second parameter not first.

edited Oct 30 '14 at 06:39

answered Oct 30 '14 at 06:13

arif_suhail_123

2,521
2
10
16

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given on line 105 – Punjabii Oct 30 '14 at 06:33
arif in last line.. of code – Punjabii Oct 30 '14 at 06:33
u solved my first error..but after using this code..error comes in last line. – Punjabii Oct 30 '14 at 06:34
@Punjabii that error simply means your query is not working. are you using the same code. means have you got `mysql_error();` as i have in my updated answer. ?? if yes than you should get error before that line – arif_suhail_123 Oct 30 '14 at 06:35
while($rowww=mysql_fetch_array($queryyy)) – Punjabii Oct 30 '14 at 06:36
arif error in this line line no 105 is this – Punjabii Oct 30 '14 at 06:37
and arif your 2nd code is not working for me first one is works..but error comes in last line – Punjabii Oct 30 '14 at 06:37
yes now error in this line bro..first one is working now..thanks pls solve issue of this line – Punjabii Oct 30 '14 at 06:43
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/appz on line 105 – Punjabii Oct 30 '14 at 06:51
this error bro of parameter 1 – Punjabii Oct 30 '14 at 06:51
1

Ask the OP what the DB connection is. Better yet, ask for full code including DB connection. This question is going nowhere. You've been at this for almost an hour now. – Funk Forty Niner Oct 30 '14 at 07:04

score 0 · Answer 2 · answered Oct 30 '14 at 06:25

Try this ...

<?php
//use your connection file here...
$queryyy=mysql_query("select * from comments where type='$platform' AND app_id='$id' order by id DESC");
if (!$queryyy) {
   die('Invalid query: ' . mysql_error());
   }
while($rowww=mysql_fetch_array($queryyy))
{
echo $rowww['comm']."<hr/>";
}
?>

Warning: mysql_query() expects parameter 2 to be resource, string given on line 103

2 Answers2