Getting mysql_fetch_array() error

Question

LastMitch

12 Years Ago

Hi

I'm getting mysql_fetch_array() expects parameter 1 to be resource, boolean,

I check the white space and maybe some can tell me what I did so I can corrrect the mistake. Thanks

  <?php
    session_start();
    header("Cache-control: private");
    require_once ('../include/init.php');
    include_once("../ckeditor/ckeditor.php");?>

    $page = $_GET['page'];
    $sqlcats="SELECT * FROM pages WHERE pagename = '".$page."'";
    //echo $sqlcats;
    $rscats= mysql_query($sqlcats) ;
    while($rowcats = mysql_fetch_array($rscats))
    {
    $thetext = $rowcats["editor1"];
    $pagename = $rowcats["pagename"];
    }
    <html>
    <head>
    <title>ADMIN</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <script type="text/javascript" src="../ckeditor/ckeditor.js"></script>
    <style type="text/css">
    <!--
    .style3 {font-family: Arial, Helvetica, sans-serif;font-size: 16px;font-weight: bold;}
    -->
    </style>
    </head>
    <body>
    <br>
    <p align="center" class="style3">ADMIN</p>
    <br>
    <p align="center" class="style4">
    <a href="index2.php">MAIN MENU</a>&nbsp;&nbsp;
    <a href="logout.php">LOG OUT</a>
    </p>
    <? include("modifymenu.php");?>
    <form action="../home.php" method="post" target="_blank">
    <?php
    $CKEditor->basePath = '/ckeditor/';
    $CKEditor = new CKEditor();
    $CKEditor->editor("editor1", $initialValue);
    $initialValue = '<p>This is some <strong>sample text</strong>.</p>';
    ?>
    <input type="submit" value="Submit"/>
    <?
    // SECURITY: You must explicitly enable this "connector". (Set it to "true").
    $initialized ['Enabled'] = true ;
    ?>
    </form>
    </body>
    </html>

mysql php

2 Contributors
9 Replies
162 Views
1 Day Discussion Span
Latest Post 12 Years Ago Latest Post by LastMitch

Red Dragon 0 Newbie Poster

12 Years Ago

Try:

$rscats = mysql_query("SELECT * FROM pages WHERE pagename ='$page'");
while ($rowcats = mysql_fetch_array($rscats)) { ... }

Red Dragon 0 Newbie Poster

12 Years Ago

does the table called 'pages' already exist on ur database? if so, what does it contain? you can't create a database table using SELECT statements.

Paste what you have again

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

LastMitch · Answer 1 · 2012-06-11T03:18:50+00:00

@Red Dragon

Thanks for the reply. I will test that now

LastMitch · Answer 2 · 2012-06-11T03:24:28+00:00

@Red Dragon

It's still saying that

Getting mysql_fetch_array() error

I double check my DB (mysql_select_db), just to make sure it's connected and it's connected.

I'm still getting the same error in this line again

while ($rowcats = mysql_fetch_array($rscats))

I appreciated you taking time to help me!

LastMitch · Answer 3 · 2012-06-11T03:48:48+00:00

Do I need to create a table in order to retrieve the data?

The only thing I'm trying to retrieve is the home.php it's only things I'm trying to do

That's why used

$page = $_GET['page'];

and I'm using this to retrieve the page

while($rowcats = mysql_fetch_array($rscats))
{
$thetext = $rowcats["editor1"];
$pagename = $rowcats["pagename"];
}

but I'm getting the same error in this line

while ($rowcats = mysql_fetch_array($rscats);

LastMitch · Answer 4 · 2012-06-11T16:49:30+00:00

@Red Dragon

No, I'm familiar with mysql, I think do have a table. The $page is home.php. On top of home.php I put this

       <?php
       $sql="SELECT * FROM pages WHERE pagename = 'home'";
       $rs= mysql_query($sql);
       $row = mysql_fetch_array($rs);
       ?>

This is the admin page which I posted above in the first post (which has the whole script):

       $page = $_GET['page'];
       $sqlcats="SELECT * FROM pages WHERE pagename = '".$page."'";
       //echo $sqlcats;
       $rscats= mysql_query($sqlcats) ;
       while($rowcats = mysql_fetch_array($rscats))
       {
       $thetext = $rowcats["editor1"];
       $pagename = $rowcats["pagename"];
       }

LastMitch · Answer 5 · 2012-06-11T22:20:56+00:00

Gosh, I forgot to double check my sentence. I meant to put the word not in the sentence

No, I'm familiar with mysql, I think do have a table. The $page is home.php. On top of home.php I put this

No, I'm not familiar with mysql, I think I do have a table and the $page is home.php. On top of home.php I put this

<?php
$sql="SELECT * FROM pages WHERE pagename = 'home'";
$rs= mysql_query($sql);
$row = mysql_fetch_array($rs);
?>

The home.php is on the server and that's why I'm using that code to to grab the file.

This is the admin page which I posted above in the first post (which has the whole script):

$page = $_GET['page'];
$sqlcats="SELECT * FROM pages WHERE pagename = '".$page."'";
//echo $sqlcats;
$rscats= mysql_query($sqlcats) ;
while($rowcats = mysql_fetch_array($rscats))
 {
$thetext = $rowcats["editor1"];
$pagename = $rowcats["pagename"];
}

The issues is that's getting this error:

mysql_fetch_array() expects parameter 1 to be resource, boolean

on this line:

while($rowcats = mysql_fetch_array($rscats))

I read other threads, members & moderator repeatly saying check for white space that's why I'm doing it but it's still saying

mysql_fetch_array() expects parameter 1 to be resource, boolean

LastMitch · Answer 6 · 2012-06-12T17:15:34+00:00

I'm still getting

mysql_fetch_array() expects parameter 1 to be resource, boolean

on this line:

while($rowcats = mysql_fetch_array($rscats))

I just want to resolve this error so I can go back to solve my original thread. which is

http://www.daniweb.com/web-development/php/threads/424568/create-a-archive-page

I can't work on that thread until I figure out this error:

mysql_fetch_array() expects parameter 1 to be resource, boolean

on this line:

while($rowcats = mysql_fetch_array($rscats))

I appreciated if someone can explain to me what to do and also help me with this. Once I solve this error I can go back to my old thread and work on it. That's why I create this thread to solve the other issue.

LastMitch · Answer 7 · 2012-06-12T22:18:17+00:00

Hi

I try to switch up from

while($rowcats = mysql_fetch_array($rscats))

to

while($rowcats = mysql_num_rows($rscats))

Instead of this:

mysql_fetch_array() expects parameter 1 to be resource, boolean

Now I have this:

mysql_num_rows() expects parameter 1 to be resource, boolean

Any suggestions>? or explanation will do.

I try the topic to search on DaniWeb and to see some solution but each thread has different answers based on the script itself. It doesn't tell you how to resolve this universal.

Any Advice?

I mean I can post all of the threads just to prove that I'm looking for an solution. That's like 8 years of work.

I'll pick the ones that is closes to mines.