Retrieving data from database and displaying on web page not working

Question

I have a database called resources and a table inside that database called resources. I am trying to display some content and having some trouble. This is the code I am using:

mysql_connect('localhost', 'username', 'password', 'resources');
$query   = mysql_query('SELECT * FROM resources WHERE iss = 1 ORDER BY added DESC');
$company = 'company';
while ($rows = mysql_fetch_assoc($query)) {
    echo "Company: " . $rows[$company];
}

also, mysql is deprecated, no longer supported and may be insecure. You should use mysqli or PDO. — serakfalcon
– serakfalcon, Commented Jul 16, 2014 at 22:41
Hmmm i tried out your suggestions and still no luck. It loads my footer and title but still no content... :( — Nick Balistreri
– Nick Balistreri, Commented Jul 16, 2014 at 22:44

ihgann · Accepted Answer · 2014-07-16 23:08:05Z

2

A few things:

You need to properly open that div tag.
You need to select a database using mysql_select_db, not by adding the fourth parameter to mysql_connect.

This all also assumes your connections are working properly and everything is installed fine. Then, you should be able to get it working with something closer to this:

<div id="section_content">
<?php
    mysql_connect('localhost', 'username', 'password');
    mysql_select_db('resources');
    $query = mysql_query('SELECT * FROM resources WHERE iss = 1 ORDER BY added DESC');
    $company = 'company';
    while($rows = mysql_fetch_assoc($query)){
        echo "Company: " .$rows[$company];
    }
?>
</div>

edited Jul 16, 2014 at 23:08

answered Jul 16, 2014 at 22:46

ihgann

5053 silver badges11 bronze badges

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

1 Comment

Nick Balistreri Over a year ago

Thank you very much. That was very helpful. I didnt know that i didnt need that extra parameter. Once i moved it to "mysql_select_db" it started working. Thank you so much!

Collectives™ on Stack Overflow

Retrieving data from database and displaying on web page not working

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related