118642 Small PHP work, a few jobs

Hi, I have a few scripts I've worked on that need some small changes. Here's what I need: I've been working on some php scripts and I'm stuck with a small problem. I also need some small changes made to some other scripts. I'm including the scripts and the changes. 1. [login to view URL]: I want it to check if the email entered already exists and if it does not to enter it again, post a message saying "Email already exists." 2. [login to view URL]: I started working on this, but didn't get it to work. You'll see the changes I started on line 74. It starts with: if ($row_innerpage['Category1']!='') { $category1 = $row_innerpage['Category1'] $p = " AND (category = \"$category1\")" I want to be able to change the discount and shipping price according to the entry in the database. The current database looks like this: discount artist category shipping option 37.5 David Yohanan NULL NULL NULL 25 Chaim Peretz NULL NULL NULL 37.5 David Yohanan 3.50 framed The discount is set according to the artist. But, if theres an entry that has the same artist AND a different shipping price and either option OR category, then I want the discount and the shipping price to come from there. I need the same thing for the discount (not the shipping price) on product.php. 3. On [login to view URL], [login to view URL] and [login to view URL] I want the price to be the calculated wholesale price with the discount like on [login to view URL]: For example: Depiction of Mighty Samson Suggested retail price: $49.99 Wholesale price: $24.99 (-50%) Your profit: $25.00 Everything else should stay the same. Thank you, Barak