In message <[EMAIL PROTECTED]>, Crestland Morgans <[EMAIL PROTECTED]> writes >Hello, > >I am setting up an ecommerce site from scratch using php and mysql >and I am a beginner with php and mysql. I set up my database. I have >come up with the coding for accessing the product, description, price >and a place for the quanity input. What I need to add is a picture of >the product. Right now my coding will list the path of the picture >but not show the picture of the product. What am I missing. I know >that the coding is working some what because when I test out >different pages with products the text changes for the image. >This is the text that comes up instead of where I should see a >picture: >images/catalog/page4/ww-731.gif > >Any suggestions would be most appreciated. >Thanks! >ladycard > > >Here is my coding so far after I have connected my database. > >$mlproducts = $HTTP_GET_VARS["ProdID"]; > > $query_product = "select * from mlproducts where >mlproducts.prodID = '$mlproducts'";
Only select the fields that you need, why get information from the database that you do not need? > $query_prodName= "select from mlproducts where >mlproducts.prodName = '$mlproducts'"; You have your field names missing. > $query_prodPrice = "select from mlproducts where >mlproducts.prodPrice = '$mlproducts'"; You have your field names missing. > $query_prodPrice = "select from mlproducts where >mlproducts.prodImageSmallPath = 'prodImageSmallPath'"; You have set up 4 different query strings, but you only use one in a query. > $itemNo = @mysql_fetch_array($fetch_query); > > > ?> > <?php echo $itemNo["prodImageSmallPath"]; ?> You don't display the image, it should be echo '<img src='.$itemNo["prodImageSmallPath"].' />'; -- Pete Clark Sunny Andalucia http://www.hotcosta.com/comm_1.htm Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/php-list/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
