nbbcj Posted June 12, 2012 Share Posted June 12, 2012 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> Link to comment https://forums.phpfreaks.com/topic/264078-dynamic-drag%E2%80%99n-drop-with-jquery-and-php/ Share on other sites More sharing options...
smoseley Posted June 13, 2012 Share Posted June 13, 2012 Do you have a database with a table named dragdrop? Or is that just from the example? Link to comment https://forums.phpfreaks.com/topic/264078-dynamic-drag%E2%80%99n-drop-with-jquery-and-php/#findComment-1353369 Share on other sites More sharing options...
nbbcj Posted June 13, 2012 Author Share Posted June 13, 2012 Yer have a db called dragdrop :S Thanks Link to comment https://forums.phpfreaks.com/topic/264078-dynamic-drag%E2%80%99n-drop-with-jquery-and-php/#findComment-1353412 Share on other sites More sharing options...
smoseley Posted June 13, 2012 Share Posted June 13, 2012 This will tell you what's failing: $result = mysql_query($query) or die(mysql_error()); Link to comment https://forums.phpfreaks.com/topic/264078-dynamic-drag%E2%80%99n-drop-with-jquery-and-php/#findComment-1353486 Share on other sites More sharing options...
nbbcj Posted June 13, 2012 Author Share Posted June 13, 2012 Ow yer for got bout that one ill give it a go c what error i get thx Link to comment https://forums.phpfreaks.com/topic/264078-dynamic-drag%E2%80%99n-drop-with-jquery-and-php/#findComment-1353588 Share on other sites More sharing options...
nbbcj Posted June 13, 2012 Author Share Posted June 13, 2012 sorted it silly me i had the db config setup wrong lol my bad thanks for the help tho nbbcj Link to comment https://forums.phpfreaks.com/topic/264078-dynamic-drag%E2%80%99n-drop-with-jquery-and-php/#findComment-1353603 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.