Fetching data from mysql data base in php [duplicate]

Question

Possible Duplicate:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result

I am fetching data from MySQL data base in PHP but it gives error like following:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/i/h/u/ihus235/html/cs/emrapp/surveyList.php on line 97 []

Below is the query which I am using to select data:

 $query = mysql_query("SELECT * form survey_Profile where user_Id='".$user_id."' ");

You have an error in your sql syntax. Verify if survey_Profile table and user_Id field exists — Mihai Matei
– Mihai Matei, Commented Sep 20, 2012 at 6:04

Yogesh Suthar · Accepted Answer · 2012-09-20 06:05:20Z

5

change

$query = mysql_query("SELECT * form survey_Profile where user_Id='".$user_id."' ");

to

$query = mysql_query("SELECT * from survey_Profile where user_Id='".$user_id."' ");

answered Sep 20, 2012 at 6:05

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

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

5 Comments

Yogesh Suthar Over a year ago

why downvote the problem was in form, i changed it to from.

Mihai Matei Over a year ago

I saw it now.. sorry.. I switched my vote :)

GBD Over a year ago

yes downvote to "matei mihai"

FtDRbwLXw6 Over a year ago

@YogeshSuthar: In the future, it's a good idea to make note of what you change, to avoid situations like this where it's extremely hard to spot. Good catch. :-)

Yogesh Suthar Over a year ago

@drrcknlsn thanks...for advice...

CoursesWeb · Accepted Answer · 2012-09-20 06:10:42Z

2

The cause of tthat error can be that mysql returns False. You can add an:

echo "SELECT * form survey_Profile where user_Id='".$user_id."' ";

To see what string is send to mysql, eventualy test it directly in phpmyadmin. Also, add this code to see the error from mysql:

if (mysql_errno()) {
    echo "<br />". mysql_errno(). " : ". mysql_error(). "<br />";
}

answered Sep 20, 2012 at 6:10

CoursesWeb

4,2573 gold badges24 silver badges27 bronze badges

Comments

GBD · Accepted Answer · 2012-09-20 06:05:23Z

0

You are getting this error because user_id value doesn't exist into your table.

So before executing your resource into mysql_fetch_assoc(), check whether you got matching rows or not.

if(mysql_num_rows($query) > 0) {
//user mysql_fetch_assoc now
}

And also you have sql syntax error, in your query replace "form" to "from"

answered Sep 20, 2012 at 6:05

GBD

16k2 gold badges49 silver badges52 bronze badges

Collectives™ on Stack Overflow

Fetching data from mysql data base in php [duplicate]

3 Answers 3

5 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Linked

Related