mysql error missing parameter and string

Question

I have an error in a mysql connection. It says mysql_query() expects parameter 1 to be string on line 37

mysql_fetch_array() expects parameter 1 to be resource, null given in in folowing lines:

$result = mysql_query($link,"SELECT Name, id FROM skoleni WHERE Grupa = '".$_GET['grupa']."';");
while($row = mysql_fetch_array($result))

The $link is not required for mysql_query, this is if you are using mysqli — Ryan
– Ryan, Commented Feb 27, 2014 at 13:37

Deepak Rai · Accepted Answer · 2024-02-15 08:22:59Z

2

mysql_query("SELECT Name, id FROM skoleni WHERE Grupa = '".$_GET['grupa']."';");

No need of specifying connection parameter in mysql_query() function. For further reference see this https://www.php.net/manual/en/function.mysql-query.php

edited Feb 15, 2024 at 8:22

answered Feb 27, 2014 at 13:37

Deepak Rai

2,2113 gold badges24 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sathish D · Accepted Answer · 2014-02-27 13:39:20Z

0

The $link is not required. Try this:

`$result = mysql_query("SELECT Name, id FROM skoleni WHERE Grupa = '".$_GET['grupa']."';");

answered Feb 27, 2014 at 13:39

Sathish D

5,04433 silver badges46 bronze badges

Comments

Bindiya Patoliya · Accepted Answer · 2014-02-27 13:39:22Z

0

Important:

Stop using mysql_* api, its deprecated and generally bad. Use PDO or mysqli instead

Try

       $result = mysqli_query($link,"SELECT Name, id FROM skoleni WHERE Grupa = '".$_GET['grupa']."';");

       $rowcount=mysqli_num_rows($result);

     if ($rowcount > 0)
     {
         while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) 
         {
         }
     }

answered Feb 27, 2014 at 13:39

Bindiya Patoliya

2,7821 gold badge18 silver badges16 bronze badges

1 Comment

The Blue Dog Over a year ago

If you were going to post an example using mysqli, you could have at least used a prepared statement to avoid the obvious injection!

Collectives™ on Stack Overflow

mysql error missing parameter and string

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related