Connecting to Database and Displaying the Row

[cello10]

So I've followed this code, corrected about 12 error, talked to my hosting and I am so done. I have tried everything but the error won't go away. The code is pasted below. As it's really late any help would be appreciated that would make my day the next day... 

 

<?PHP

//connect to server

$connect = mysql_connect("localhost","cello10_import","brigite27");

//connection to database

mysql_select_db("cello10_import");

//query the database

$query = mysql_query("SELECT * FROM users WHERE cover_image = 'http://d1w7fb2mkkr3kw.cloudfront.net/assets/images/book/small/9781/2500/9781250038821.jpg' ");

//fetch the results / convert into array

 

WHILE($rows = mysql_fetch_array(query)):

 

$cover_image = $rows['cover_image'];

$title = $rows['title'];

$author = $rows['author'];

 

echo "$cover_image<br>$title<br>$author<br><br><br>";

 

endwhile;

?>

 

The error experienced is: 

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in /home/cello10/public_html/display.php on line 10

 

Thanks for your help   

[bsmither]

 

WHILE($rows = mysql_fetch_array(query)):

Can you tell us what query is?

 

Specifically, query without the dollar sign that, if present, would indicate it is a variable?

[cello10]

What do you mean with query? It's all I have besides the database... I didn't create anything else??? Please elaborate...

[Barand]

Let's be less subtle and try the spoonfeeding approach

 

 

 

WHILE($rows = mysql_fetch_array(query)):

 

should be

 

 

WHILE($rows = mysql_fetch_array($query)):

[cello10]

OK, I'm sure it works, try it out in a moment but I want to know how the solution works in response to the error?

 

Thanks for the "spoonfeeding approach".    

[cello10]

Let's be less subtle and try the spoonfeeding approach

 

 

 

 

should be

Still gives the same error.   Any other ideas? 

[cello10]

bump

[Barand]

Are you sure it is exactly the same error message?

 

Try

 

echo mysql_error();

 

after the query and tell us what that gives

[cello10]

OK, when there is no $ sign on the query the message is as follows

 

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in /home/cello10/public_html/display.php on line 10 

 

if it's $query as you told me then it's

 

 

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/cello10/public_html/display.php on line 10

Edited December 1, 2014 by cello10

[Barand]

 

 

Try

 

echo mysql_error();

 

after the query and tell us what that gives

[cello10]

 

 

 

Try

 

echo mysql_error();

 

after the query and tell us what that gives

 

Already tried that but still generates the same result.

[Barand]

The reason you get the error message

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/cello10/public_html/display.php on line 10

 

is because the query failed for some reason. What that reason is will be given by the contents of mysql_error().

 

If you don't want to tell us what that it is, then fine, you sort it because we cannot see it for ourselves. Bye.

[cello10]

OK, how can I find the content of the mysql_error()? And yes that is exactly the error message.

Edited December 2, 2014 by cello10

[Ch0cu3r]

OK, how can I find the content of the mysql_error()? And yes that is exactly the error message.

You echo it as Barand has told you to do in posts #8, #10 and #12 all of you which you have ignored!