I am trying to retrieve some results from a database

spyros

I am trying to retrieve some results from a database
And I get this error message:

Fatal error: Call to a member function on a non-object in c:\diphp\webroot\primemarine\prime test\1\con_flash2.php on line 12

If you have any idea what I am doing wrong please help !!!
Thank you

<?php


require("req_files.php");
require("config.php");

$connection = mysql_connect($db_host, $db_user, $db_password) or die("error connecting");
mysql_select_db($db_name, $connection);


$query = "SELECT * from news ORDER BY month desc";

line 12 ---- > $result = $connection->query($query);

//$result = mysql_query($query, $connection);

$words = '';
$count = 0;


while ($row = $result->fetch_assoc()) {

$words .= '&word'.$count.'='.urlencode($row['comments']);
$count++;

}

echo 'total='.$count.$words;

?>

thorpe

mysql_connect does not return an object. This code is the correct syntax....

$result = mysql_query($query, $connection);

spyros

Now I am getting this error:

Fatal error: Call to a member function on a non-object in c:\diphp\webroot\primemarine\prime test\1\con_flash2.php on line 19


<?php


require("req_files.php");
require("config.php");

$connection = mysql_connect($db_host, $db_user, $db_password) or die("error connecting");
mysql_select_db($db_name, $connection);


$query = "SELECT * from news ORDER BY month desc";
//$result = $connection->query($query);
$result = mysql_query($query, $connection);

$words = '';
$count = 0;


line 19 ---- >   while ($row = $result->fetch_assoc()) {

$words .= '&word'.$count.'='.urlencode($row['comments']);
$count++;

}

echo 'total='.$count.$words;
?>

ahundiak

Hmmm.
Since mysql_connect did not return an object then it might just be that mysql_query does not return one either.

http://www.php.net/manual/en/function.mysql-query.php

By the way, if you are using PHP 5.1.x then consider using the PDO database objects.

greenie2600

AFAIK, none of the MySQL functions return objects. Any code of the form $varname->whatever is therefore incorrect (unless you're using an object-based data abstraction layer library, which you're not).

Here is how you create a MySQL connection, issue a query, and then iterate through each record in the resultset:

$dbconn = mysql_connect( $hostname, $username, $password );
mysql_select_db( $dbname, $dbconn );

$query = "SELECT * FROM whatever";
$resultset = mysql_query( $query, $dbconn );

// iterate through each row in the resultset
while ( $row = mysql_fetch_array( $resultset ) ) {
    // do something with this record
    // for example:
    echo $row["column1name"] . ', ' . $row["column2name"] . '<br />';
}

greenie2600

By the way, this is why we have manuals 🙂

In the first error message, PHP told you that $connection was not an object. The value of $connection had been set by the output of the mysql_connect function, so you know that the mysql_connect was not returning an object as expected. Either PHP was malfunctioning (highly unlikely), or you made an incorrect assumption about its behavior (much more likely).

A quick look at the documentation for the mysql_connect() function shows that it does not, in fact, return an object, but the resource data type. Therefore, the method calls (e.g., $result->fetch_assoc()) make no sense, because only objects have methods.

RTFM!

ahundiak

Now now greenie. Try to keep the sarcasm subtle. It's more fun that way.