Dynamic Drag’n Drop With jQuery And PHP

[nbbcj]

Hi all i downloaded and read the how to from this site

http://www.webresourcesdepot.com/dynamic-dragn-drop-with-jquery-and-php/

 

seems it the main one that comes up on google and its what i need for a backend project iv been working on for about a year now learning as i go but dont get much time now a days, but any way.. lol

 

i cant get it to work get this

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/sites/nbbcj.co.uk/public_html/4291/dnd/index.php on line 67

 

and im stumped

 

this is the part of the code

<div id="container">
  <div id="list">

    <div id="response"> </div>
    <ul>
      <?php
  	 error_reporting(E_ALL);
ini_set('display_errors', '1');
                include("connect.php");
			$query  = "SELECT id, text FROM dragdrop ORDER BY listorder ASC";
			$result = mysql_query($query);
			while($row = mysql_fetch_array($result, MYSQL_ASSOC))
			{

			$id = stripslashes($row['id']);
			$text = stripslashes($row['text']);

			?>
      <li id="arrayorder_<?php echo $id ?>"><?php echo $id?> <?php echo $text; ?>
        <div class="clear"></div>
      </li>
      <?php } ?>
    </ul>
  </div>
</div>

[smoseley]

Do you have a database with a table named dragdrop?  Or is that just from the example? 

[nbbcj]

Yer have a db called dragdrop

 

:S

Thanks

[smoseley]

This will tell you what's failing:

 

$result = mysql_query($query) or die(mysql_error());

[nbbcj]

Ow yer for got bout that one ill give it a go c what error i get

 

thx

[nbbcj]

sorted it silly me i had the db config setup wrong lol my bad

 

thanks for the help tho

 

nbbcj