small issue when I upload my form

[scaleautostyle]

Hi!!. I just upload my form into my production server and .. SURPRISe  got an error message. everything work OK on my local server... WHY is it showing this.

 

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /...../search.php on line 31

 

 

this is what start my line 31 and so on... 32, 33 etc..

 

 

  while($row=mysql_fetch_array($result)){   
         $description  =$row['description'];   
         $manufacturer_kit=$row['manufacturer_kit'];   
         $kit_id=$row['kit_id']; 
         $kit_number=$row['kit_number'];
         $kit_name=$row['kit_name'];
         $engine_detail=$row['engine_detail'];
         $year_prod_reel=$row['year_prod_reel'];
         $scale=$row['scale'];
         $image_id=$row['image_id'];

 

any advice will be welcome

 

yours

 

sebastien

[kenrbnsn]

That means your query didn't work correctly. Please post where you do the query.

 

Ken

[scaleautostyle]

thanks.. this is the complete code.. hope this help

 

<?php

include_once("db_connection.php");
   if(isset($_POST['submit'])){   
   if(isset($_GET['go'])){   
   if(preg_match("/^[  a-zA-Z]+/", $_POST['name'])){   
   $name=$_POST['name'];   
      
     //-query  the database table   
   $sql="SELECT  kit_id, kit_number, kit_name, description, manufacturer_kit, manufacturer_reel, engine_detail, year_prod_kit, year_prod_reel, scale, image_id  FROM kit WHERE kit_name LIKE '%" . $name ."%' OR description LIKE '%" . $name .  "%' OR manufacturer_kit LIKE '%" . $name ."%'";  


  //-run  the query against the mysql query function   
   $result=mysql_query($sql);  
   
  //-make the header of the table   
   
   echo "  <table align=center width=\"100%\" border=\"\">\n";
   echo "    <tr>\n";
   echo"  <td nowrap align=center width='95'>  kit manufacturer  \n";		
   echo"  <td nowrap align=center width='55'>	scale \n";		
   echo"  <td nowrap align=center width='90'>	kit number \n";		
   echo"  <td nowrap align=center width='290'>	kit name \n";		
   echo"  <td nowrap align=center width='400'>	description \n";		
   echo"  <td nowrap align=center width='70'>	year of reel production of car \n";		
   echo"  <td nowrap align=center width='70'>	complete engine detail\n";		
   echo"  <td nowrap align=center width='75'>	Select Picture to get bigger\n";
   echo "    <tr>\n";

   //-create  while loop and loop through result set   
   while($row=mysql_fetch_array($result)){   
         $description  =$row['description'];   
         $manufacturer_kit=$row['manufacturer_kit'];   
         $kit_id=$row['kit_id']; 
	 $kit_number=$row['kit_number'];
	 $kit_name=$row['kit_name'];
	 $engine_detail=$row['engine_detail'];
	 $year_prod_reel=$row['year_prod_reel'];
	 $scale=$row['scale'];
	 $image_id=$row['image_id'];
	   
   //-create  table of item during he while loop
   
echo "  <table align=center width=\"100%\" border=\"\">\n";		   
echo"  <td nowrap align=center width='95'>  $manufacturer_kit  \n";		
echo"  <td nowrap align=center width='55'>	$scale \n";		
echo"  <td nowrap align=center width='90'>	$kit_number \n";		
echo"  <td nowrap align=center width='290'>	$kit_name \n";		
echo"  <td nowrap width='400'>	$description \n";		
echo"  <td nowrap align=center width='70'>	$year_prod_reel \n";		
echo"  <td nowrap align=center width='70'>	$engine_detail \n";		
echo"  <td nowrap width='75'> <a href=".$image_id.">   <img src='".$image_id."' width='75' height='50'/>";		
echo "    </tr>\n";
echo "    </table>\n"; 
echo "    </tr>\n";
echo "    </table>\n"; 

   }   
   }  
   else{   
   echo  "<p>Please enter a search query</p>";   
   }   
   }   
   }
?>  

 

yours

 

sebastien

[scaleautostyle]

Solve... thanks... NEWBY error  I forgot to update my database 

 

yours

 

sebastien

 

 

only one problem to solve for today... how to shoe multiple image... see the appropriate thread for this one.

 

thanks

 

sebastien