DaniWeb Forum Index > Web Development > PHP

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2008

Posts: 31

Reputation: CzechRock3 is an unknown quantity at this point

Solved Threads: 2

CzechRock3 CzechRock3 is offline

Offline

Light Poster

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Sep 3rd, 2008

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/fellowes/public_html/createaccount.php on line 108

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
include("conf.inc.php");
	$tbl_name="tbl_courses";
 
	$sql=mysql_query("SELECT * FROM $tbl_name WHERE crs_semister=1 AND crs_period='A'") or die(mysql_error());
	$result=mysql_num_rows($sql);
include("conf.inc.php");
	$tbl_name="tbl_courses";
	
	$sql=mysql_query("SELECT * FROM $tbl_name WHERE crs_semister=1 AND crs_period='A'") or die(mysql_error());
	$result=mysql_num_rows($sql);

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 <?php while($rows=mysql_fetch_array($result)) { ?>
                        <option><?php echo $rows['crs_code']; ?>//Line 108</option>
                    <?php } ?>
 <?php while($rows=mysql_fetch_array($result)) { ?>
                        <option><?php echo $rows['crs_code']; ?>//Line 108</option>
                    <?php } ?>

im a zombie killer

•

Join Date: Aug 2007

Posts: 570

Reputation: ryan_vietnow is an unknown quantity at this point

Solved Threads: 71

ryan_vietnow ryan_vietnow is offline

Offline

Posting Pro

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resou

Sep 3rd, 2008

Replace the $result in this one:

•

Originally Posted by CzechRock3

Help with Code Tags

PHP Syntax (Toggle Plain Text)
 <?php while($rows=mysql_fetch_array($result)) { ?>
                        <option><?php echo $rows['crs_code']; ?>//Line 108</option>
                    <?php } ?>
<?php while($rows=mysql_fetch_array($result)) { ?> <option><?php echo $rows['crs_code']; ?>//Line 108</option> <?php } ?>

to $sql because your $sql variable is what holds your query.
$result holds the mysql_num_rows value.

http://www.ryantetek.com/

•

Join Date: Mar 2008

Posts: 31

Reputation: CzechRock3 is an unknown quantity at this point

Solved Threads: 2

CzechRock3 CzechRock3 is offline

Offline

Light Poster

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Sep 4th, 2008

When I change it nothing appears... And there are two fields in the table...

im a zombie killer

•

Join Date: Mar 2008

Posts: 31

Reputation: CzechRock3 is an unknown quantity at this point

Solved Threads: 2

CzechRock3 CzechRock3 is offline

Offline

Light Poster

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Sep 4th, 2008

Sorry... I haven't slepped well for the past couple days... School just started so I have been making stupid mistakes I shouldn't be making... Your right... I just realized what I did wrong. Thanks again

im a zombie killer