scaleautostyle Posted July 4, 2010 Share Posted July 4, 2010 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 Link to comment https://forums.phpfreaks.com/topic/206708-small-issue-when-i-upload-my-form/ Share on other sites More sharing options...
kenrbnsn Posted July 4, 2010 Share Posted July 4, 2010 That means your query didn't work correctly. Please post where you do the query. Ken Link to comment https://forums.phpfreaks.com/topic/206708-small-issue-when-i-upload-my-form/#findComment-1081050 Share on other sites More sharing options...
scaleautostyle Posted July 4, 2010 Author Share Posted July 4, 2010 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 Link to comment https://forums.phpfreaks.com/topic/206708-small-issue-when-i-upload-my-form/#findComment-1081053 Share on other sites More sharing options...
scaleautostyle Posted July 4, 2010 Author Share Posted July 4, 2010 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 Link to comment https://forums.phpfreaks.com/topic/206708-small-issue-when-i-upload-my-form/#findComment-1081054 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.