tet3828
-
Posts
107 -
Joined
-
Last visited
Never
Everything posted by tet3828
-
To the contributers so far... You guys rock, thanks again and again. Quick coding question... I wonderful and helpfull script posted by Orio but Im having trouble getting the image to show I have commented the problem area. The link to my image is in a mySQL table and instead of showing the image its showing the code. What the deal here? <?php if(!isset($_POST['submit'])) { die("<html><body><form action=\"".$_SERVER['PHP_SELF']."\" method=\"POST\"> <select name=\"cat\"> <option value=\"Holiday\">Holiday</option> <option value=\"Animals\">Animals</option> </select> <input type=\"submit\" name=\"submit\" value=\"Search!\"> </form> </body> </html>"); } $qry = "SELECT itemName,itemPrice,itemSmall FROM `products` WHERE itemCat='".$_POST['cat']."'"; $result = mysql_query($qry) or die(mysql_error()); echo "<table border=\"1\"><tr><td>Name</td><td>Price</td><td>Thumbnail</td></tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>".$row['itemName']."</td>"; echo "<td>".$row['itemPrice']."</td>"; echo "<td><img src=\"".$row['itemSmall']." /></td>"; \\\itemSmall is the location of my thumbnail on the server echo "</tr>"; } echo "</table>";
-
Thanks for the responses so far people. I appreacieate you all bearing with me as I reduce the broad nature of my questions by grasping the mysql/PHP concept. Ill admit the last response made very little sense to me prior to my recent trip to the library and some practice coding....Moving right along. here goes: I have a table in mySQL it contains roughly 20 rows or "items" with the following values as columns: NAMEs, CATAGORYs, DESCRIPTIONs , PRICEs and HTTP:// reference to a thumbnail how should I approach displaying the NAME PRICE AND THUMBNAIL in a borderless table when an item's catagory is selected from a dropdown?
-
I must not have posed this question properly last post....22 reads to 1 response ::). Allow me to simplify... I have a database. Each Item in the database will have the following values: CATAGORY SUB-CATAGORY STORE ITEM NUMBER NAME DESCRIPTION PRICW PRICE SMALL PICTURE PICTURE what script should I start with if I need all items in a selected catagory to be displayed in a table including an itme Name, Thumbnail, and price? Thanks again! ;D
-
I must not have posed this question properly last post....22 reads to 1 response ::). Allow me to simplify... I have a database. Each Item in the database will have the following values: CATAGORY SUB-CATAGORY STORE ITEM NUMBER NAME DESCRIPTION PRICW PRICE SMALL PICTURE PICTURE what script should I start with if I need all items in a selected catagory to be displayed in a table including an itme Name, Thumbnail, and price? Thanks again! ;D
-
no clue where to start on this one folks hope I am in the right place. I posted the same topic in the mySql fourm because I don't know which fourm this post should be directed toward. possibly both. I have completed the basic layout of my site http://claireart.net/shell/mermaid.htm in the open area I am looking to list catagorized thumbs of the items in the display any overflow I want to result with the display of scroolbars or an additionol page. I have a mysql account on godaddy. For each item I want to be able to put the following online folder ( mysql folder) and have is displayed in the open area 1.an item description and price 2.a thumbnail 3.full size picture of item what is the best way to approach this task. is their scripts anyone can recommend...or even one that does it all? Programs I have: Ms Access Dreamweaver Photoshop Fireworks Flash Ms Excell Ms word Evoia 3d thats all I can think of for now
-
no clue where to start on this one folks hope I am in the right place. I have completed the basic layout of my site http://claireart.net/shell/mermaid.htm in the open area I am looking to list catagorized thumbs of the items in the display any overflow I want to result with the display of scroolbars or an additionol page. I have a mysql account on godaddy. For each item I want to be able to put the following online folder (??? mysql folder) and have is displayed in the open area 1.an item description and price 2.a thumbnail 3.full size picture of item what is the best way to approach this task. is their scripts anyone can recommend...or even one that does it all? ??? Programs I have: Ms Access Dreamweaver Photoshop Fireworks Flash Ms Excell Ms word Evoia 3d thats all I can think of for now