valid MySQL result resource

mech

Hi guys, i keep getting " Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource "

Here is my code

<?php
$headline = $POST['headline'];
$category1 = $POST['category'];
$writer = $POST['writer'];
$source = $POST['source'];
$story = $POST['story'];
$rating = $POST['rating'];
$comment = $_POST['comment'];

                $host = "localhost";
                $user = "root";
                $pass = "";
                $db = "newsbook";

                // open connection
                $link = mysqli_connect($host, $user, $pass, $db);

                // build SQL statement
                $query = "SELECT * FROM addArticle WHERE category = '$category1'";

                // execute SQL statement
                $result = mysqli_query($link, $query) or die(mysqli_error($link));




                    echo "<table border='1'>";
                    echo "<tr> <th>Headline</th> <th>Category</th> <th>Writer</th> <th>Source</th> <th>Story</th> <th>Rating</th> <th>Comment</th>";

                    while($row = mysql_fetch_array($result)) {

                            echo "<tr><td>";
                            echo $row['headline'];
                            echo "</td><td>";
                            echo $row['category'];
                            echo "</td></tr>";
                            echo $row['writer'];
                            echo "</td></tr>";
                            echo $row['source'];
                            echo "</td></tr>";
                            echo $row['story'];
                            echo "</td></tr>";
                            echo $row['rating'];
                            echo "</td></tr>";
                            echo $row['comment'];
                            echo "</td></tr>";
                    }

                    echo "</table>";

Anyone knows where is the problem?

NogDog

If you're going to use mysqli_query(), then you need to use mysqli_fetch_array(), not mysql_fetch_array().

PS: If you're going to access the results by column name, I'd recommend using mysqli_fetch_assoc(), instead, just on the principle of only returning what you actually need (the associative array keys, not also the enumerated keys).

dalecosp

Is is that you called "mysql_fetch_array" on a "mysqli_connect" link and "mysqli_query" result?

mech

Thanks.. i also found alternative solution.

                    mysql_connect("localhost", "root", "") or die(mysql_error());
                    mysql_select_db("newsbook") or die(mysql_error());

                // Get all the data from the "example" table
                $result = mysql_query("SELECT * FROM addArticle WHERE category = '$category1' ")
                or die(mysql_error());

dalecosp

Well, it's the same solution, just reversed. You matched all the preceding calls to the system of the one the produced the problem. Since it's a MySQL RDBMS you're dealing with, either should work, but not in an integrated fashion; it's "all one or the other".

laserlight

mech wrote:
Thanks.. i also found alternative solution.

It is kind of a retrograde solution though. You are effectively saying that because your pen was unable to properly write your shopping list on a piece of clay, you would use a chisel to write and carry the piece of clay with the shopping list carved onto it to the shop instead of using your little note pad so you can write your shopping list using your pen and carry the slip of paper to the shop.

mech

laserlight;10968605 wrote:
It is kind of a retrograde solution though. You are effectively saying that because your pen was unable to properly write your shopping list on a piece of clay, you would use a chisel to write and carry the piece of clay with the shopping list carved onto it to the shop instead of using your little note pad so you can write your shopping list using your pen and carry the slip of paper to the shop.

Very chim ~ 😃