php mysql help

[jrobert755]

this is not working. it should get a list of values from a table, but it never does, and just stops running, displaying whats before it, and thats all (its in an include command on another page) could someone try to fix it?

mysql_connect("localhost", "jrobert7", "password");
    mysql_select_db("jrobert7_testing");
    $result= mysql_query("SELECT * FROM articles");
    while($results = mysql_fetch_array($result))
    {
        echo "<div class=\"summary\">
                <div class=\"body\">
                    <h2><u><a href=\"".$results['link']. "\">".$results['name']. "</a></u></h2>
                    <p style=\"margin-top:-2px;\">
                    <em>
                    ".$results['link']. "<small>(2 hits)</small>
                    </em>
                    "$results['description'] "<a  class=\"more\" href=\"".$results['link']. "\" style=\"color:#105CB6;\">More...</a>
                    </p>
                    <div class=\"options\">
                        <a class=\"space compick\" href=\"".$results['link']. "\">0 comments</a>
                        <a class=\"space share\" href=\"".$results['link']. "\">Share</a>
                        <a class=\"space views\" href=\"".$results['link']. "\">".$results['views']. "\"views</a>
                    </div>
                </div>
                <ul class=\"fav\">
                    <li class=\"favcount\">
                        <a class=\"favcount\" href=\"".$results['link']. "\"><strong>".$results['fav']. "</strong><br />
                        <span>favs</span></a>
                    </li>
                    <li class=\"favit\">
                        <a class=\"favit\" href=\"".$results['link']. "\">fav it</a>
                    </li>
                </ul>
            </div>";
    }

 

[blobtech]

First of all: its wise to not show your database password to the public.
You should edit that out =D.

But.. about your script. It seems fine, no PHP errors in it.
Are you sure it can succesfully connect to the database (as there is no code to catch the error when it can't)?

Try altering the lines

mysql_connect("localhost", "jrobert7", "password");
mysql_select_db("jrobert7_testing");

To

mysql_connect("localhost", "jrobert7", "password") or die("Could not connect: " . mysql_error());
mysql_select_db("jrobert7_testing") or die("Could select DB: " . mysql_error());

And tell us what output it gave.

Another error could be that the database is empty, and therefor the while loop never runs because mysql_fetch_array will return false as it can not find a row.

You can check the number of rows returned by your query with the following function
and output a message that there are no results when it equals 0:

$num = mysql_num_rows($result);

 

[VPmase]

1) Never reveal your password and name to anyone unless you know them completely...

2) I myself have had errors with using the \" inside "s so try this:

echo ‘<div class=“summary”>
                <div class=“body”>
                    <h2><u><a href=“’.$results['link']. ‘“>‘.$results['name']. ‘</a></u></h2>
                    <p style=“margin-top:-2px;”>
                    <em>
                    ‘.$results['link']. ‘<small>(2 hits)</small>
                    </em>
                    ‘$results['description'] ‘<a  class=“more” href=“’.$results['link']. ‘“ style=“color:#105CB6;”>More...</a>
                    </p>
                    <div class=“options”>
                        <a class=“space compick” href=“’.$results['link']. ‘“>0 comments</a>
                        <a class=“space share” href=“’.$results['link']. ‘“>Share</a>
                        <a class=“space views” href=“’.$results['link']. ‘“>‘.$results['views']. ‘“views</a>
                    </div>
                </div>
                <ul class=“fav”>
                    <li class=“favcount”>
                        <a class=“favcount” href=“’.$results['link']. ‘“><strong>‘.$results['fav']. ‘</strong><br />
                        <span>favs</span></a>
                    </li>
                    <li class=“favit”>
                        <a class=“favit” href=“’.$results['link']. ‘“>fav it</a>
                    </li>
                </ul>
            </div>‘;

 

[jrobert755]

changed my password (copy- paste error ). didn't work, no error and no results

tested it on a different host that i had before x10 and it works almost perfectly (need to work on css to get layout right though), and it got the data i wanted. its probably a restriction on the php on the server

 

[blobtech]

Just saw a mistake, but I do not understand why PHP does not error.

There are no dots around

$results['description'] // 6th line from the start of `echo`

and therefor the strings are not joined.

I tested a small script with something similar on my server, and it just returns a blank page, so I guess that this is it.

 

[jrobert755]

yeah, like i said, uploaded to another hosting site i had before, fixed that problem, and it worked like a charm.

 

[mephis]

try changin this line:

while($results = mysql_fetch_array($result))

to this:

while($results = mysql_fetch_assoc($result))

 

[blobtech]

Actually, mysql_fetch_assoc is almost the same thing.

mysql_fetch_assoc($result);

Is the equivelant of calling

mysql_fetch_array($result, MYSQL_ASSOC);

However, mysql_fetch_array has as default optional parameter MYSQL_BOTH. That means it will return an associative as well as a numeric array.

Which is the same as

mysql_fetch_row($result) + mysql_fetch_assoc($result);

There is no need for changing that line.

 

[brunoais]

this is not working. it should get a list of values from a table, but it never does, and just stops running, displaying whats before it, and thats all (its in an include command on another page) could someone try to fix it?

mysql_connect("localhost", "jrobert7", "password");
    mysql_select_db("jrobert7_testing");
    $result= mysql_query("SELECT * FROM articles");
    while($results = mysql_fetch_array($result))
    {
?> div class=\"summary\">
                <div class=\"body\">
                    <h2><u><a href="<?=$results['link'] ?>"><?=$results['name']?> "</a></u></h2>
                    <p style=\"margin-top:-2px;\">
                    <em>
                    <?=$results['link']?><small>(2 hits)</small>
                    </em>
                    <?=$results['description']?><a  class="more" href="<?=$results['link']?>"

etc....
It makes more simple coding and it's less probeble for you to make any mistakes.
just make a:
<?=
befora the variable and
?>
after the variable.