Error while running the SQL to fetch data from DB

Question

I have been trying to find what is wrong with the code below as I keep seeing the error saying mysql_fetch_array() expects parameter 1 to be mysql. I know that the issue is with the SQL statement itself. The first SQL statement is successfully executed, populating the DB with the inserted data. Please have a look to see what could have gone wrong with the SQL statement. Thanks a lot.

$address      = addslashes($_POST['address']);
$query        = mysql_query("insert into crd_article_desc(article_desc,article_title,article_category) values ('$address','$_POST[title]','$_POST[category]')");
$query        = mysql_query("SELECT article_desc from crd_article_desc where article_title=$_POST[title]");
$article_desc = mysql_fetch_array($query);

Using mysql, not mysqli.

sql injection alert. Also you might want to change the variable names. You have $query twice. — Rotimi
– Rotimi, Commented Feb 21, 2017 at 10:44
Please use either mysqli or pdo. mysql functions are no longer supported. — Rotimi
– Rotimi, Commented Feb 21, 2017 at 10:55
@phpdev. Yes. I am using mysqli on all current projects. The example I had issue with is from an old script. — CodeForGood
– CodeForGood, Commented Feb 21, 2017 at 10:58

Pankaj Makwana · Accepted Answer · 2017-10-17 06:16:56Z

1

I think you should use single quotes for string like this:

<?php
$query = mysql_query(
        "SELECT 
            article_desc 
        FROM 
            crd_article_desc 
        WHERE 
            article_title='" . mysql_real_escape_string($_POST['title']) . "'"
);

edited Oct 17, 2017 at 6:16

Pankaj Makwana

3,0486 gold badges33 silver badges49 bronze badges

answered Feb 21, 2017 at 10:47

Maha Dev

3,9653 gold badges34 silver badges53 bronze badges

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

3 Comments

Maha Dev Over a year ago

@Pramod, please accept my answer if it really helped you :)

CodeForGood Over a year ago

Yes! Most definitely in a few mins as it won't allow to accept answers within a few minutes of posting the answer.

Maha Dev Over a year ago

@Pramod Thanks bro :)

Collectives™ on Stack Overflow

Error while running the SQL to fetch data from DB

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related