Ad:

PHP Discussion Thread
Unsolved
Views: 1317

Sep 3rd, 2008

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

Expand Post »

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

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);

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 } ?>

Similar Threads

CzechRock3

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

33 posts
since Mar 2008

Permalink

Sep 3rd, 2008

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

Replace the $result in this one:

Click to Expand / Collapse Quote originally posted by CzechRock3 ...

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.

ryan_vietnow

Reputation Points: 28

Solved Threads: 71

Posting Pro

Offline

578 posts
since Aug 2007

Permalink

Sep 4th, 2008

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

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

CzechRock3

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

33 posts
since Mar 2008

Permalink

Sep 4th, 2008

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

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

CzechRock3

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

33 posts
since Mar 2008

Permalink

Sep 4th, 2008

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

ok,just mark this thread solved, ayt? cheers!

ryan_vietnow

Reputation Points: 28

Solved Threads: 71

Posting Pro

Offline

578 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Fatal error: Call to undefined function form()

Next Thread in PHP Forum Timeline: Images in PHP

DaniWeb Message

Cancel Changes

User Name
Password