What is the error in my code that I get mysql_fetch_array warning?

Question

I am trying to display some data from mySQL, the db details are correct but I get this.

*Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource*

What is the error with my code below?

<?php

$con = mysql_connect("localhost"," "," ");
mysql_select_db(" ", $con);
mysql_query('set names utf8');

$query = "SELECT * FROM products WHERE id = '13' LIMIT 1";
$row = mysql_fetch_array(mysql_query($query));
echo $row['name'];

?>

UPDATE

I found my error it was a typo. This is what you get if you still use notepad...

Sheesh. Downvoting spree... Would the anonymous coward who hates all the correct answers please step forward and explain themselves? — Marc B
– Marc B, Commented Aug 15, 2011 at 15:37
@Greg: Note the timestamps on the answers. They were all done at pretty much the same time. You don't get notified by SO immediately when an answer is posted. — Marc B
– Marc B, Commented Aug 15, 2011 at 15:49
... and no matter what, it's not good form to downvote correct answers @Greg. If you see a pile of "me too" answers, just leave them alone (or leave an acidic comment) — Pekka
– Pekka, Commented Aug 15, 2011 at 16:06

cdhowie · Accepted Answer · 2011-08-15 15:32:18Z

1

$query will be FALSE because the query you have entered is not valid; the return from mysql_query is FALSE when there was some error compiling or executing the query.

Change LIMT to LIMIT and try again.

answered Aug 15, 2011 at 15:32

cdhowie

172k25 gold badges303 silver badges324 bronze badges

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

Comments

ace · Accepted Answer · 2011-08-15 15:32:27Z

1

Wrong spelling...

$query = "SELECT * FROM products WHERE id = '13' LIMT 1";

should be

$query = "SELECT * FROM products WHERE id = '13' LIMIT 1";

answered Aug 15, 2011 at 15:32

ace

7,6513 gold badges25 silver badges28 bronze badges

Comments

Marc B · Accepted Answer · 2011-08-15 15:32:30Z

1

You've got an error somewhere. Try:

$con = mysql_connect(...) or die(mysql_error());

mysql_select_db(...) or die(mysql_error());

$res = mysql_query(...) or die(mysql_error());
$row = mysql_fetch_array($res);

answered Aug 15, 2011 at 15:32

Marc B

362k44 gold badges433 silver badges508 bronze badges

Comments

Ed Heal · Accepted Answer · 2011-08-15 15:32:51Z

1

You have a typo, LIMT -> LIMIT

answered Aug 15, 2011 at 15:32

Ed Heal

60.3k18 gold badges91 silver badges137 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:34:23Z

1

Use error handling to get information about errors. The message will tell you that you have a syntax error (LIMT instead of LIMIT).

A minimal example:

$query = "SELECT * FROM products WHERE id = '13' LIMT 1";

if (!$query) trigger_error("mySQL Error: ".mysql_error(), E_USER_ERROR);

The use of trigger_error() instead of die() is so you can avoid the message getting shown on a live site. Other than that, die() is also fine.

See also Reference: What is a perfect code sample using the mysql extension?

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Aug 15, 2011 at 15:33

Pekka

451k150 gold badges990 silver badges1.1k bronze badges

1 Comment

EnexoOnoma Over a year ago

Thank you for the reference, it will help me as a beginner to write better code.

JK. · Accepted Answer · 2011-08-15 15:32:18Z

0

Simple typo: LIMT should be LIMIT

answered Aug 15, 2011 at 15:32

JK.

5,1261 gold badge29 silver badges26 bronze badges

Collectives™ on Stack Overflow

What is the error in my code that I get mysql_fetch_array warning?

6 Answers 6

Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related