homepage Welcome to WebmasterWorld Guest from 54.161.175.231
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
PHP MySql Error
ddregallo




msg:3256459
 1:30 am on Feb 19, 2007 (gmt 0)

When the code below runs it gives me the following error.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in root/public_html/articleindex.php on line 24

I don't know why. Can anyone help? The second occurance of mysql_fetch_array() is where the problem is.


<?php
$acats_handle = mysql_connect($sql_host, $sql_username, $sql_password);
mysql_select_db($db, $acats_handle);

$acats_query = "SELECT record_number, Name, Description FROM Article_Categories;";
$acats_result = mysql_query($acats_query, $acats_handle);

print("<table>");
print("<tr class=\"cattable_head\"><td colspan=\"2\">Articles Table of Contents</td></tr>");
while($i = mysql_fetch_array($acats_result)) { // For each category
print("<tr>");// List this category
print("<td> <a href=\"?catid=$i[record_number]\">$i[Name]</a> </td>");
print("<td> <p>$i[Description]</p> </td>");
print("</tr>");
print("<tr>"); // List articles under this category
print("<td></td>"); // Bump to column 2
print("<table>");
$articles_result = mysql_query($articles_query, $acats_handle);
$articles_query = "SELECT record_number, title, synopsis FROM SC_Articles WHERE category_record_number=$i[record_number] AND visible=1;";
while($x = mysql_fetch_array($articles_result)) { // For each article in current category
print("<tr>");
print("<td> <a href=\"?article=$x[record_number]\">$x[title]</a> </td>");
print("<td> <p>$x[synopsis]</p> </td>");
print("</tr>");
}
}

print("</table>");
?>

 

phpmaven




msg:3256477
 2:22 am on Feb 19, 2007 (gmt 0)

You need to swap these two lines:
$articles_result = mysql_query($articles_query, $acats_handle);
$articles_query = "SELECT record_number, title, synopsis FROM SC_Articles WHERE category_record_number=$i[record_number] AND visible=1;";

You are trying to run the query before you define the value of $articles_query

camilord




msg:3256662
 9:03 am on Feb 19, 2007 (gmt 0)

$acats_handle = mysql_connect($sql_host, $sql_username, $sql_password);
mysql_select_db($db, $acats_handle);

$acats_query = "SELECT record_number, Name, Description FROM Article_Categories;";
$acats_result = mysql_query($acats_query);
$acats_limit = mysql_num_rows($acats_result);

if ($acats_limit > 0) {
for ($i = 0; $i < $acats_limit; $i++) {
$cid = mysql_result($acats_result,$i,'record_number');
//continue the statements here...
}
}

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved