Jump to content

vet911

Members
  • Posts

    100
  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

vet911's Achievements

Member

Member (2/5)

0

Reputation

2

Community Answers

  1. Thanks for the comment. I finally figured it out. try { echo "<br>"; foreach($dbh->query("SELECT * FROM test_shot WHERE testshot=1 ORDER BY year ASC") as $row) { echo "<div class='image-holder'><img src ='".$row['picture']."' width=300px /><br><a> ".$row['year']." ".$row['description']." </a>"; if($row['sold'] == 1) { echo "<img src='images/sold1.png'></div>"; } elseif ($row['sold'] == 0) { echo "</div>"; } } } catch (PDOException $e) { print $e->getMessage(); }
  2. try { echo "<br>"; foreach($dbh->query("SELECT * FROM test_shot WHERE sold=1 ORDER BY year ASC") as $row) { if($row['picture'] != "" && $row['picture'] != null) { echo "<div class='image-holder'><img src ='".$row['picture']."' width=300px /><br>"; } if($row['year'] != "" && $row['year'] != null) { echo $row['year']; } if($row['description'] != "" && $row['description'] != null) { echo $row['description']; } if($row['sold'] == 1) { echo "<img src='images/sold1.png'><br>";//Add your image code here } elseif ($row['sold'] == 0) { echo "</div><br>"; } } } catch (PDOException $e) { print $e->getMessage(); } ?>
  3. That is what I figured out because when I took it back out of the code it was working as before. I haven't been able to figure it out sense. I'll continue to work at it some more. Thanks
  4. I did get an error message: 500 Internal Server Error. I removed the important info from the paypal hidden stuff. What I tried to do was check the $row['sold'] value to see if it was sold. 1= sold, 0 = not sold. It works, but not the way I would like. I was trying some different things that's why the commented out stuff.
  5. $result = $dbh->query($sql); if($result) { $i = 0; $max_columns = 3; foreach ($result as $row) { // open row if counter is zero if($i == 0) { echo "<tr VALIGN='top'>"; } // if ($row['avail'] != "0") //{ // make sure we have a valid product ALIGN='CENTER' if($row['image'] != "" && $row['image'] != null) { echo "<td><div class=box><a href=$row[image] rel=lightbox title=$row[image]><img class=border src=$row[image]>"; if($row['itemno'] != "" && $row['itemno'] != null) { echo "<a>Item No: </a>$row[itemno]<br />"; } if($row['description'] != "" && $row['description'] != null) { echo "<a>Description: </a>$row[description]<br /> "; } //if($row['sold'] !=1) //{ if($row['price'] != "" && $row['price'] != null) { echo "<a>Price: $</a>$row[price]<br />"; echo "<form target='paypal' action='' method='post'>"; echo "<input type='hidden' name='cmd' value='_cart'>"; echo "<input type='hidden' name='add' value='1'>"; echo "<input type='hidden' name='business' value=''>"; echo "<input type='hidden' name='item_name' value='$row[description]'>"; echo "<input type='hidden' name='item_number' value='$row[itemno]'>"; echo "<input type='hidden' name='amount' value='$row[price]'>"; echo "<input type='hidden' name='shipping' value='7.00'>"; echo "<input type='hidden' name='shipping2' value='0.50'>"; echo "<input type='hidden' name='handling' value='2.00'>"; echo "<input type='hidden' name='currency_code' value='USD'>"; echo "<input type='hidden' name='return' value=''>"; echo "<input type='hidden' name='undefined_quantity' value='1'>"; echo "<input type='image' src='' height='21' border='0' name='submit' alt=''>"; echo "</form>"; } //else($row['sold'] !=0) //{ //echo "<img src='images/sold.png'>"; //} //} //echo "</form>"; } echo "</div></td>"; // } // increment counter - if counter = max columns, reset counter and close row if(++$i == $max_columns) { echo "</tr>"; $i=0; } // end if } // end while } // end if results // clean up table - makes your code valid! if($i < $max_columns) { for($j=$i; $j<$max_columns;$j++) { echo "<td>&nbsp;</td>"; } } } My website shows items listed from the database with a picture and associated information including a icon to make the purchase. I want to show the item as sold after the purchase and not the hidden info that is sent to aPayapl to make the purchase. I would like show the item as sold and attach a sold icon but eliminate the paypal hidden info. I tried but when I run the program it breaks. I tried to comment out the stuff i tried. I need some help please. Thanks in advance for any help.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.