scaleautostyle
-
Posts
58 -
Joined
-
Last visited
Never
Everything posted by scaleautostyle
-
Why the picture doesn't appear???
scaleautostyle replied to scaleautostyle's topic in PHP Coding Help
the thing that I can see it's.. the h came from the path put in the field. I just change one for the dirct link and now it's mark a t because the file name is tam2401.jpg #%$%#% now how can I get the full name instead of just the frst letter thanks in advance yours sebastien -
Why the picture doesn't appear???
scaleautostyle replied to scaleautostyle's topic in PHP Coding Help
because Image_id is one of my field in my database where my image are stock. thanks for any advice sebastien -
Why the picture doesn't appear???
scaleautostyle replied to scaleautostyle's topic in PHP Coding Help
the thing is... I don't know where come the h I don't have any images starting with an h ?????? yours sebastien -
now the search function is working good. but the image show is blank with an X at the top left corner... WHY??? this is my code <?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); //-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_kit=$row['year_prod_kit']; $scale=$row['scale']; $image_id=$row['image_id']; //-display the result of the array echo "<ul>\n"; echo "<li>" .$kit_number . " " . $manufacturer_kit . " " . $kit_name . " " . $description . " " . $year_prod_kit . " " . $engine_detail . " " . $scale . " </li>\n"; echo "<img src='picture/".$image_id['imgage_id']."' width='150' height='100'/>"; echo "</ul>"; } } else{ echo "<p>Please enter a search query</p>"; } } } ?> if I made a property on the blank image this is what it return me as path.... .............../picture/h where the h come from???? thanks for your help sebastien
-
OK PROBLEM SOLVE... now a new one... see other post.
-
thanks but now I have an other problem. when I submit the search form I got a BLANK page.... ?????? what's going on here ??? the form page does'nt change just the search.php page. ( VERY MINOR ) and I got the same result if I put back the old one. ???? <?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, description, manufacturer_kit FROM Contacts WHERE description LIKE '%" . $name . "%' OR manufacturer_kit LIKE '%" . $name ."%'"; //-run the query against the mysql query function $result=mysql_query($sql); //-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']; //-display the result of the array echo "<ul>\n"; echo "<li>" . "<a href=\"search.php?id=$kit_id\">" .$description . " " . $manufacturer_kit . "</a></li>\n"; echo "</ul>"; } } else{ echo "<p>Please enter a search query</p>"; } } } ?> did my coding is good ???
-
Hi guy's!! I try several option but always get the same result.. doesn't work and receive this message Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\...........\SEARCH.php on line 15 this is my form <?php include_once("db_connection.php"); ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Search engine</title> </head> <p><body> <h3>Model kit database</h3> <p>You may search either by reel car or kit manufacturer</p> <form method="post" action="search.php?go" id="searchform"> <input type="text" name="name"> <input type="submit" name="submit" value="Search"> </form> </body> </html> </h2> <p> </p> <p> </p> <br> <br> </body> </html> and this is my search code <?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, description, manufacturer_kit FROM Contacts WHERE description LIKE '%" . $name . "%' OR manufacturer_kit LIKE '%" . $name ."%'"; //-run the query against the mysql query function $result=mysql_query($sql); //-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']; //-display the result of the array echo "<ul>\n"; echo "<li>" . "<a href=\"search.php?id=$kit_id\">" .$description . " " . $manufacturer_kit . "</a></li>\n"; echo "</ul>"; } } else{ echo "<p>Please enter a search query</p>"; } } } ?> what is wrong??? thanks for your help sebastien