Ad:

PHP Discussion Thread
Marked Solved
Views: 1390

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Sep 10th, 2008

php warning fetching a record from database

Expand Post »

hi ,

PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Domains\eazygurus.com\wwwroot\courses.php on line 45

im getting this error please help me out from this. im attaching the php file and copying my database values........

Table structure for table `course`
--

sql Syntax (Toggle Plain Text)
CREATE TABLE `course` (
  `id` INT(50) NOT NULL AUTO_INCREMENT,
  `course` VARCHAR(50) NOT NULL,
  `subcourse` VARCHAR(50) NOT NULL,
  `fee` INT(50) NOT NULL,
  `content` VARCHAR(1000) NOT NULL,
  `DATE` TEXT NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=INNODB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;
 
--
-- Dumping data for table `course`
--
 
INSERT INTO `course` (`id`, `course`, `subcourse`, `fee`, `content`, `DATE`) VALUES
(24, 'java', 'dddddddddddsssssssss', 212121, '11111111111111111111111', '2008-08-29');
CREATE TABLE `course` (
  `id` int(50) NOT NULL auto_increment,
  `course` varchar(50) NOT NULL,
  `subcourse` varchar(50) NOT NULL,
  `fee` int(50) NOT NULL,
  `content` varchar(1000) NOT NULL,
  `date` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

--
-- Dumping data for table `course`
--

INSERT INTO `course` (`id`, `course`, `subcourse`, `fee`, `content`, `date`) VALUES
(24, 'java', 'dddddddddddsssssssss', 212121, '11111111111111111111111', '2008-08-29');

Attached Files

courses.php (3.7 KB, 17 views)

Last edited by peter_budo; Sep 10th, 2008 at 3:43 pm. Reason: Keep It Organized - please use [code] tags

prashanth18

Reputation Points: 8

Solved Threads: 1

Newbie Poster

Offline

15 posts
since Jul 2008

Permalink

Sep 10th, 2008

Re: php warning fetching a record from database

where is your mysql_connect ?

pritaeas

Sponsor

Featured Poster

Reputation Points: 550

Solved Threads: 728

Bite my shiny metal ass!

Offline

4,166 posts
since Jul 2006

Permalink

Sep 10th, 2008

Re: php warning fetching a record from database

When you go to "courses.php" for the FIRST TIME, do you have a query after the .php ?

Something like:
.../courses.php?course=course_name&subcourse=something

(Toggle Plain Text)

// courses & subcourse values are mandatory as programmed with:
$course=$_GET['course']
$subcourse= $_GET['subcourse'];

Last edited by NormandP; Sep 10th, 2008 at 9:52 am. Reason: ameliorate

NormandP

Reputation Points: 12

Solved Threads: 3

Newbie Poster

Offline

21 posts
since Jul 2008

Permalink

Sep 10th, 2008

Re: php warning fetching a record from database

this line should be like this:

php Syntax (Toggle Plain Text)
  $query=("select * from course where course='".$course."'") or die(mysql_error());
  $query=("select * from course where course='".$course."'") or die(mysql_error());

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Sep 11th, 2008

php warning fetching a record from database

Hi Shanthi..
here the total code working properly...
the problem arises when i write where condition......
here

PHP Syntax (Toggle Plain Text)
$course=$_GET['course'];
 
 $query=("select * from course where course='".$course."' ) or die(mysql_error());
while($result=mysql_fetch_array($query))
{
 
}
 
$course=$_GET['course'];

 $query=("select * from course where course='".$course."' ) or die(mysql_error());
while($result=mysql_fetch_array($query))
{

}

This is the part of the code where i m getting an error.
Error:mysql_fetch_array(); supplied arguement is not a valid mysql resource.

saikishore

Reputation Points: 10

Solved Threads: 7

Unverified User

Offline

41 posts
since Jul 2008

Permalink

Sep 11th, 2008

Re: php warning fetching a record from database

hello kishor..
echo this line and tel me wat u got:
echo $course=$_GET['course'];
and also echo this statement:

php Syntax (Toggle Plain Text)
echo $r="select * from course where course='".$course."'";
echo $r="select * from course where course='".$course."'";

Last edited by Shanti C; Sep 11th, 2008 at 7:26 am.

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Sep 11th, 2008

Re: php warning fetching a record from database

try this

PHP Syntax (Toggle Plain Text)
echo $r="select * from course where course=$course;
 
echo $r="select * from course where course=$course;

vssp

Reputation Points: 5

Solved Threads: 5

Junior Poster

Offline

197 posts
since Jul 2006

Permalink

Sep 11th, 2008

Re: php warning fetching a record from database

hi shanthi,
when i echo$r= "select * from course where course='".$course."'";
i am getting the output as
select * from course where course="

more over in the echo $course=$_get['course'];
doesn't print anything

saikishore

Reputation Points: 10

Solved Threads: 7

Unverified User

Offline

41 posts
since Jul 2008

Permalink

Sep 11th, 2008

Re: php warning fetching a record from database

so, you didn't get any data in $_GET['course'];
tel me ,from where you are getting this variable..
or post needed code...

Last edited by Shanti C; Sep 11th, 2008 at 7:41 am.

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Sep 11th, 2008

Re: php warning fetching a record from database

PHP Syntax (Toggle Plain Text)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title></title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="description" content="Small Corporation" />
	<meta name="keywords" content="small, corporation" />
	<link rel="stylesheet" href="style.css" type="text/css" />
    <style type="text/css">
<!--
.style4 {color: #FFFFFF}
 
.style5 {color: #2D5181}
-->
    </style>
</head>
<body>
 
	<div id="contentcourse">
	  <div id="header"></div>
  <ul id="menu">
			<li><a class="current" href="index.php">Home</a></li>
			<li><a href="aboutus.php">About Us</a></li>
			<li><a href="courses.php">Courses</a></li>
			<li><a href="demo_registration.php">Demo Class Registration</a></li>
			<li><a href="faq.php">FAQ's</a></li>
			<li><a href="order.php">How To Order</a></li>
			<li><a href="payment.php">Payment Options</a></li>
			<li><a href="enquiry.php">Enquiry</a></li>
<li><a href="contact.php">Contact Us</a></li>
 
	  </ul>
 
	  <div id="course">
			<div id="title">
			  <h3>Sub Courses</h3>
			</div>
	<br/>
 
	          <?php 
		include("config.php");
			$course=$_GET['course'];
	  $query=("select course,subcourse from course WHERE course=$course") or die(mysql_error());
	   $ress1=mysql_query($query);	
	  while($rows=mysql_fetch_array($ress1))
	   {
	   $subcourse= $rows['subcourse'];
	    ?>
			     <font color="#666666"> <a href="courses.php?course=<?php echo $course ;?>&subcourse=<?php echo $subcourse ;?>" >    
               <?php 
	   echo $subcourse;
	   echo "<br>"; 
	   ?>
	               </a></font>
			  <?php
	   }?>
 
          <?php  $course=$_GET['course'];
	   $subcourse= $_GET['subcourse'];
 
	   $ress2=mysql_query("select * from course where  subcourse='$subcourse'") or die(mysql_error());
 
		while($rows=mysql_fetch_array($ress2))
	   {
	   $subcourse= $rows['subcourse'];
	    $fee= $rows['fee'];
		 $content= $rows['content'];
 
 
	    ?><br />
 
	<table width="85%" border="1" bordercolor="#CCCCCC">
      <tr >
        <td width="14%" height="40" ><strong>Course:</strong></td>
        <td width="86%"  ><?php echo $subcourse; ?></td>
      </tr>
      <tr>
        <td height="39"><strong>Fee:</strong></td>
        <td><?php echo $fee; ?></td>
      </tr>
      <tr>
        <td height="210"><strong>Discription:</strong></td>
        <td><textarea rows="13" cols="50"><?php echo $content; ?></textarea>
        </td>
      </tr>
    </table>
     <?php } ?>
	<p>&nbsp; </p>
	  </div>
		<div id="title1">
          <h3 class="style5">Courses Offered</h3>
      </div>
		<div id="sidemenu">
 
           <p>
             <?php
          $ress=mysql_query("select  DISTINCT course from course ") or die(mysql_error());	 
 
 
     while ($row = mysql_fetch_array($ress))
	 { 	  
	 $course=  $row['course'];
	 ?>
                   <a href="courses.php?course='<?php echo $course ;?>'" >      
 
                     <?php echo $row['course']; 
	   echo "<br>";
	   }?>                         </a>           </p>
 
 
	  </div>
<div id="footer"><br/>
<div align="center"><span class="links"><a href="index.php">Home</a>
    <a href="aboutus.php">About Us</a>
    <a href="courses.php">Courses</a>
    <a href="demo_registration.php">Demo Class Registration</a>
    <a href="faq.php">FAQ's</a>
    <a href="order.php">How To Order</a>
    <a href="payment.php">Payment Options</a>
    <a href="enquiry.php">Enquiry</a>
    <a href="contact.php">Contact Us</a></span></div>
    </div>
	</div>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title></title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="description" content="Small Corporation" />
	<meta name="keywords" content="small, corporation" />
	<link rel="stylesheet" href="style.css" type="text/css" />
    <style type="text/css">
<!--
.style4 {color: #FFFFFF}

.style5 {color: #2D5181}
-->
    </style>
</head>
<body>

	<div id="contentcourse">
	  <div id="header"></div>
  <ul id="menu">
			<li><a class="current" href="index.php">Home</a></li>
			<li><a href="aboutus.php">About Us</a></li>
			<li><a href="courses.php">Courses</a></li>
			<li><a href="demo_registration.php">Demo Class Registration</a></li>
			<li><a href="faq.php">FAQ's</a></li>
			<li><a href="order.php">How To Order</a></li>
			<li><a href="payment.php">Payment Options</a></li>
			<li><a href="enquiry.php">Enquiry</a></li>
<li><a href="contact.php">Contact Us</a></li>
            
	  </ul>
		
	  <div id="course">
			<div id="title">
			  <h3>Sub Courses</h3>
			</div>
	<br/>
			  
	          <?php 
		include("config.php");
			$course=$_GET['course'];
	  $query=("select course,subcourse from course WHERE course=$course") or die(mysql_error());
	   $ress1=mysql_query($query);	
	  while($rows=mysql_fetch_array($ress1))
	   {
	   $subcourse= $rows['subcourse'];
	    ?>
			     <font color="#666666"> <a href="courses.php?course=<?php echo $course ;?>&subcourse=<?php echo $subcourse ;?>" >    
               <?php 
	   echo $subcourse;
	   echo "<br>"; 
	   ?>
	               </a></font>
			  <?php
	   }?>
		      
          <?php  $course=$_GET['course'];
	   $subcourse= $_GET['subcourse'];
	
	   $ress2=mysql_query("select * from course where  subcourse='$subcourse'") or die(mysql_error());
	    
		while($rows=mysql_fetch_array($ress2))
	   {
	   $subcourse= $rows['subcourse'];
	    $fee= $rows['fee'];
		 $content= $rows['content'];
				 	
		
	    ?><br />
	
	<table width="85%" border="1" bordercolor="#CCCCCC">
      <tr >
        <td width="14%" height="40" ><strong>Course:</strong></td>
        <td width="86%"  ><?php echo $subcourse; ?></td>
      </tr>
      <tr>
        <td height="39"><strong>Fee:</strong></td>
        <td><?php echo $fee; ?></td>
      </tr>
      <tr>
        <td height="210"><strong>Discription:</strong></td>
        <td><textarea rows="13" cols="50"><?php echo $content; ?></textarea>
        </td>
      </tr>
    </table>
     <?php } ?>
	<p>&nbsp; </p>
	  </div>
		<div id="title1">
          <h3 class="style5">Courses Offered</h3>
      </div>
		<div id="sidemenu">
		  
           <p>
             <?php
          $ress=mysql_query("select  DISTINCT course from course ") or die(mysql_error());	 
       
     
     while ($row = mysql_fetch_array($ress))
	 { 	  
	 $course=  $row['course'];
	 ?>
                   <a href="courses.php?course='<?php echo $course ;?>'" >      
                     
                     <?php echo $row['course']; 
	   echo "<br>";
	   }?>                         </a>           </p>
          
          
	  </div>
<div id="footer"><br/>
<div align="center"><span class="links"><a href="index.php">Home</a>
    <a href="aboutus.php">About Us</a>
    <a href="courses.php">Courses</a>
    <a href="demo_registration.php">Demo Class Registration</a>
    <a href="faq.php">FAQ's</a>
    <a href="order.php">How To Order</a>
    <a href="payment.php">Payment Options</a>
    <a href="enquiry.php">Enquiry</a>
    <a href="contact.php">Contact Us</a></span></div>
    </div>
	</div>
</body>
</html>

this is the original code what we did with out making anychanges u asked us to make.
Database has been posted in the first post of the thread..

saikishore

Reputation Points: 10

Solved Threads: 7

Unverified User

Offline

41 posts
since Jul 2008

Page 1
2
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

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: how to php error handling...

Next Thread in PHP Forum Timeline: about e-shopping

DaniWeb Message

Cancel Changes

User Name
Password