Colleen78

That is excellent advice guys! I will definitely do that, it's nice to help out. :)

Ok, that's working now! Thanks so much! What do I owe you guys?!  :-X ;D

Ok, the only problem now is underscores... The link needs to be like this: http://www.domain.com/item/Dragon_Hatchling_Figurine/217/c45 and right now I have it doing this: http://www.domain.com/item/Dragon Hatchling Figurine/217/c45 Any idea how to get the underscores in? Thanks again!

[quote author=ryanlwh link=topic=102398.msg406850#msg406850 date=1154386131] oh i see what you mean.. sorry i misunderstood you. i think it should be something like [code]$SSL_URL/item/$item_name/$item_id/[/code] you'd have to select the item_name from the table. also, i'm not sure what c45 is.. [/quote]Thanks ryanlwh! You guys are so smart here! :) I am not the best at explaining, sorry about that. The cart uses search engine friendly urls so hopefully that doesn't make it too hard to figure out how to get it work, I'll try your code and play around with it a bit and report back. Thanks so much! edit: I just looked in the DB, c45 is the category id! :D

Yes, and the image displays correctly, does that same code somehow tie into the products page link so I can have the visitor click the thumbnail and be taken to the product page?

Hey! I don't know how to link at all. I only put this in the link so far, $SSL_URL which gets the domain root, I need it to add on the rest of the items link. The items link like so: http://www.domain.com/item/Dragon_Hatchling_Figurine/217/c45 I don't know what to put in to get that.

I changed the query line to this: [code=php:0]$query = 'SELECT * FROM `tbl_item` GROUP BY `item_id` ORDER BY `item_id` DESC LIMIT 3';[/code] Now it works, I just need to figure out how to link the images to their pages, if anyone can help, that would be great.

Thanks so much bpops! Ok, I edited the echo part but it's coming up empty, this is my code. [code=php:0] echo "<td>\n"; echo "$item_name\n"; echo "<a href=\"$SSL_URL\"><img src=\"$SSL_URL/item_images/$thumbnail_image\" border=\"0\" /></a>\n"; echo "$short_description"; echo "</td>\n"; [/code] The td's for the table are showing up in the source just empty. I need to call the items name, image and description and link the image to it's page. The variables in the echo's are the row names in the table.

;D

yum milk! add some strawberry mix and you're in heaven, add a bottle of rum and you're on the floor!  ;D

Thanks everyone! Ok about the drinks, but who's having mine? I don't drink.  ;D

[quote author=Crayon Violent link=topic=102399.msg406323#msg406323 date=1154322700] Hi Colleen. Welcome to phpfreaks! It's been my experience that the best way to learn is to just jump into threads, read the problem and solutions, and/or try to solve them yourself.  I've learned so much from working on other people's problems.  [/quote]Thanks! I agree, I do that all the time, I am self-taught. :)

Thanks Crayon! As I stated, I am new to this. I need all the code. I don't know how to put it together to make it work. :D

Would a script like PHPPROBID - http://www.phpprobid.com/ suffice? Or Softbiz Online Auction script. http://www.softbizscripts.com/auctions-script-features.php There's also AJ Auction - http://www.ajsquare.com/products/auction/ There's many here, http://www.hotscripts.com/PHP/Scripts_and_Programs/Auctions/index.html?action=formsubmit&listing_sorting_order=member_rating&listing_sorting_direction=des

I've been dabbling in php/mysql for awhile now, I still have my learner's hat on.  :) I just wanted to say hello! I am hoping I can use this place to help me with the learning curve. :D

I have a shopping cart programmed with php, I am making a custom homepage and want to grab the 3 latest items added and post them on the homepage. I am a beginner so I need the full code to pull it. We don't have a timestamp so the cart company just said to make it pull the three highest ID's. This is the php code for that table in the database: [code=php:0]$sql = 'SELECT COUNT( * ) AS `Rows` , `item_id` FROM `tbl_item` GROUP BY `item_id` ORDER BY `item_id` LIMIT 0, 30'[/code] I'd appreciate any help, thank you.