ded

I need to give a user the ability to put in some dates and have a report generate for them. The query and everything is already completed, but how do I put the results in a word or text document? David

The folder file exists, but something seems wrong with the htaccess files that it shows a 404 error. .htaccess file in public_html # BEGIN WordPress <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / RewriteRule ^index\.php$ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule> # END WordPress .htaccess file in public_html/aa_darts/password/members.htm AuthUserFile "/home/website/.htpasswds/public_html/aa_darts/password/passwd" AuthName "password" AuthType Basic require valid-user

I am about to convert a website into WordPress. However, the current htaccess file has information for directory locks. When that one is in place, the "OFFICIALS LOGIN" page works fine but the WordPress website does not. When I move the WordPress one in place, the WordPress website works fine but the "OFFICIALS LOGIN" page comes up as NOT FOUND. How would I combine the take to make everything work? htacess 1 <Limit GET POST> order deny,allow deny from all allow from all </Limit> <Limit PUT DELETE> order deny,allow deny from all </Limit> RewriteEngine on RewriteCond %{HTTP_HOST} ^.*$ RewriteRule ^aa_darts/forum/?(.*)$ "http\:\/\/www\.website\.com\/forum\/$1" [R=301,L] AuthName dartswdf.com IndexIgnore .htaccess */.??* *~ *# */HEADER* */README* */_vti* php_value memory_limit 32M htaccess 2 # BEGIN WordPress <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / RewriteRule ^index\.php$ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule> # END WordPress

It looks as though the options is null function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } Any thought on how to fix this?

This URL works fine: http://www.adodarts.com/calendarandresults/ This URL works fine: http://www.adodarts.com/calendarandresults/?year=2010&region=&state= If I select 2009, it does not work: http://www.adodarts.com/calendarandresults/?year=2009&region=&state= Here is the code: <script type="text/JavaScript"> <!-- function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } function poptastic(url) { newwindow=window.open(url,'name','height=400,width=525,scrollbars=yes,resizable=yes'); if (window.focus) {newwindow.focus()} } function poptastic1(url) { newwindow=window.open(url,'name','height=550,width=650,scrollbars=yes,resizable=yes'); if (window.focus) {newwindow.focus()} } //--> </script> <div align=center style="background-color:#66CCFF; font-size:18px; font-weight:bolder;"><a href="http://www.adodarts.com/files/ADOPlayoffInformation2010.pdf" target="_blank">Click here for 2010 ADO Playoff Information</a></div> <br> <div align=center style="background-color:#FFCC66; font-size:18px; font-weight:bolder;">Click below for 2010 ADO Regional Results</div> <div align=center style="background-color:#FFCC66; font-size:14px; font-weight:bolder;"><a href="2010-masters">MASTERS</a> - <a href="2010-all-stars">ALL-STARS</a> - <a href="2010-us-team"">US Team</a> - <a href="2010-cricket">Cricket</a></div> <table height=30> <tr><td> </td></td> </table> <form name="form1"> <table align=center> <tr> <td><select name="year" > <option value="">Year</option> <option value="2011">2011</option> <option value="2010">2010</option> <option value="2009">2009</option> </select> </td><td><select name="region"> <option value="">Region</option> <option value="">All Regions</option> <option value="1-1">Region 1-1</option> <option value="1-2">Region 1-2</option> <option value="1-3">Region 1-3</option> <option value="1-4">Region 1-4</option> <option value="1-5">Region 1-5</option> <option value="2-1">Region 2-1</option> <option value="2-2">Region 2-2</option> <option value="2-3">Region 2-3</option> <option value="2-4">Region 2-4</option> <option value="2-5">Region 2-5</option> <option value="3-1">Region 3-1</option> <option value="3-2">Region 3-2</option> <option value="3-3">Region 3-3</option> <option value="3-4">Region 3-4</option> <option value="3-5">Region 3-5</option> <option value="4-1">Region 4-1</option> <option value="4-2">Region 4-2</option> <option value="4-3">Region 4-3</option> <option value="4-4">Region 4-4</option> <option value="4-5">Region 4-5</option> <option value="4-6">Region 4-6</option> <option value="5-1">Region 5-1</option> <option value="5-2">Region 5-2</option> <option value="5-3">Region 5-3</option> <option value="5-4">Region 5-4</option> <option value="5-5">Region 5-5</option> <option value="6-1">Region 6-1</option> <option value="6-2">Region 6-2</option> <option value="6-3">Region 6-3</option> <option value="6-4">Region 6-4</option> <option value="6-5">Region 6-5</option> </select> </td><td><select name="state"> <option value="">State</option> <option value="">All States</option> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> <option value="CA">California</option> <option value="CO">Colorado</option> <option value="CT">Connectictut</option> <option value="DE">Delaware</option> <option value="FL">Florida</option> <option value="GA">Georgia</option> <option value="HI">Hawaii</option> <option value="ID">Idaho</option> <option value="IL">Illinois</option> <option value="IN">Indiana</option> <option value="IA">Iowa</option> <option value="KS">Kansas</option> <option value="KY">Ketucky</option> <option value="LA">Louisiana</option> <option value="ME">Maine</option> <option value="MD">Maryland</option> <option value="MA">Massachusetts</option> <option value="MI">Michigan</option> <option value="MN">Minnesota</option> <option value="MS">Mississippi</option> <option value="MO">Missouri</option> <option value="MT">Montana</option> <option value="NE">Nebraska</option> <option value="NV">Nevada</option> <option value="NH">New Hampshire</option> <option value="NJ">New Jersey</option> <option value="NM">New Mexico</option> <option value="NY">New York</option> <option value="NC">North Carolina</option> <option value="ND">North Dakota</option> <option value="OH">Ohio</option> <option value="OK">Oklahoma</option> <option value="OR">Oregon</option> <option value="PA">Pennsylvania</option> <option value="RI">Rhode Island</option> <option value="SC">South Carolina</option> <option value="SD">South Dakota</option> <option value="TN">Tennessee</option> <option value="TX">Texas</option> <option value="UT">Utah</option> <option value="VT">Vermont</option> <option value="VA">Virginia</option> <option value="WA">Washington</option> <option value="WV">West virginia</option> <option value="WI">Wisconsin</option> <option value="WY">Wyoming</option> </select> </td><td> <input type="submit" value="Filter" onClick="MM_jumpMenu('parent',this,0)"> </td></tr> </table> <strong><em>*Note: Unsanctioned tournaments will not have links</em></strong> </form> <?php $year = $_GET['year']; $region = $_GET['region']; $state = $_GET['state']; if($year == 0) { $year = '2010'; } $dbh=mysql_connect ("localhost", "database", "password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("adodarts_TournamentCalendar"); $y = "`sdate` >= '2010-01-01' AND `sdate` <= '2010-12-31'"; $r = ""; $s = ""; if($year == 2009) { $y = "`sdate` >= '2009-01-01' AND `sdate` <= '2009-12-31'"; } if($region != "") { $r = " and `region` = '" . $region . "'"; } if($state != "") { $s = " and `state` = '" . $state . "'"; } $query = "SELECT * FROM `ADOSanctionedTournaments` WHERE " . $y . $r . $s . " ORDER BY `sdate`"; $result = mysql_query($query,$dbh) or die(mysql_error()); ?> <table width=100% align=center> <?php while($row = mysql_fetch_array($result)) { $rrn = $row[rrn]; if(substr($row['sdate'],5,2) == 1) { $alphamonth = 'January'; } elseif(substr($row['sdate'],5,2) == 2) { $alphamonth = 'February'; } elseif(substr($row['sdate'],5,2) == 3) { $alphamonth = 'March'; } elseif(substr($row['sdate'],5,2) == 4) { $alphamonth = 'April'; } elseif(substr($row['sdate'],5,2) == 5) { $alphamonth = 'May'; } elseif(substr($row['sdate'],5,2) == 6) { $alphamonth = 'June'; } elseif(substr($row['sdate'],5,2) == 7) { $alphamonth = 'July'; } elseif(substr($row['sdate'],5,2) == { $alphamonth = 'August'; } elseif(substr($row['sdate'],5,2) == 9) { $alphamonth = 'September'; } elseif(substr($row['sdate'],5,2) == 10) { $alphamonth = 'October'; } elseif(substr($row['sdate'],5,2) == 11) { $alphamonth = 'November'; } elseif(substr($row['sdate'],5,2) == 12) { $alphamonth = 'December'; } if($alphamonth != $alphamonthhold) { echo "<tr><td colspan=5 align=center bgcolor=#CCCCCC>"; echo '<div style="color:#0000CC; font-size:14px; font-weight:bold">' . $alphamonth . '</div>'; echo "</td></tr>"; } echo "<tr><td align=center>"; echo substr($row['sdate'],8,2); if(substr($row['sdate'],8,2) != substr($row['edate'],8,2)) { echo "-" . substr($row['edate'],8,2) . " "; } echo "</td><td>"; if($row['filename'] != "" & $row['tournamentdirector'] == ""){ echo "<a href=\"javascript:poptastic1('http://www.adodarts.com/calendar/tournament.php?rrn=$rrn');\">"; echo $row['tournament']; echo "</a>"; } elseif($row['filename'] != "" & $row['tournamentdirector'] != "" & $row['paymentreceived'] == "Y" & $row['adoapproved'] == "Y"){ echo "<a href=\"javascript:poptastic1('http://www.adodarts.com/calendar/tournament.php?rrn=$rrn');\">"; echo $row['tournament']; echo "</a>"; } elseif($row['filename'] == "" & $row['tournamentdirector'] == "" & $row['paymentreceived'] == "Y" & $row['adoapproved'] == "Y"){ echo "<a href=\"javascript:poptastic1('http://www.adodarts.com/calendar/tournament.php?rrn=$rrn');\">"; echo $row['tournament']; echo "</a>"; } else { echo $row['tournament']; } echo "<font color=white>" . $row[rrn] . "</font>"; echo "</td><td align=right>"; echo "$" . number_format($row['purse']); echo "</td><td>"; echo $row['state']; echo "</td><td>"; if($row['results'] != "Y") { echo " "; } else { echo "<a href=\"javascript:poptastic1('http://www.adodarts.com/calendar/results.php?rrn=$rrn&year=$year');\">results</a>"; } echo "</td>"; $alphamonthhold = $alphamonth; } echo "</tr></table>"; ?> </td> </tr> </table>

Does anyone have any coding examples that would show me how to create a simple webpage with an upload option that will allow the user to upload the records of a csv or excel sheet directly into a file on the as400? Regards, DED

figured it out

Multiple Items....paypal showing empty cart message <form action='https://www.sandbox.paypal.com/cgi-bin/webscr' METHOD='POST'> <input type="hidden" name="cmd" value="_cart"> <input type="hidden" name="upload" value="1"> <input type="hidden" name="business" value="[email protected]"> <input type="hidden" name="no_shipping" value="2"> <input type="hidden" name="return" value="http://www.website.com/beta/ordercomplete.php?sid=<?php echo $sid; ?>"> <input type="hidden" name="rm" value="2"> <input type="hidden" name="cbt" value="Click Here To Complete Order!"> <?php $query5 = "SELECT * FROM shoppingcart WHERE `sid` = '$sid' ORDER BY `product`"; $result5 = mysql_query($query5,$dbh) or die(mysql_error()); while($row = mysql_fetch_array($result5)) { $count = 0; $rrn = $row['rrn']; $description = $row['sizedesc'] . " " . $row['name']; $product = $row['product']; $query6 = "SELECT * FROM product WHERE `id` = '$product'"; $result6 = mysql_query($query6,$dbh) or die(mysql_error()); while($row = mysql_fetch_array($result6)) { $count = $count + 1; $item_name = "item_name_" . $count; $item_number = "item_number_" . $count; $quantity = "quantity_" . $count; $amount = "amount_" . $count; $shipping = "shipping_" . $count; $price = number_format($row['price']); ?> <input type="hidden" name="<?php echo $item_name; ?>" value="<?php echo $description; ?>"> <input type="hidden" name="<?php echo $item_number; ?>" value="<?php echo $product; ?>"> <input type="hidden" name="<?php echo $quantity; ?>" value="1"> <input type="hidden" name="<?php echo $amount; ?>" value="<?php echo $price; ?>"> <input type="hidden" name="<?php echo $shipping; ?>" value="<?php echo '12.00'; ?>"> <?php } } ?> <input type="hidden" name="currency_code" value="USD"> <input type="submit" value="Checkout"> </form>

Shipping Costs: $12.00 for the first item. $6 for each additional item. For orders over $150, shipping is free! How do I eliminate shipping costs if over $150? <form action='https://www.sandbox.paypal.com/cgi-bin/webscr' METHOD='POST'> <input type="hidden" name="cmd" value="_cart"> <input type="hidden" name="upload" value="1"> <input type="hidden" name="business" value="[email protected]"> <input type="hidden" name="no_shipping" value="2"> <input type="hidden" name="return" value="http://www.website.com/beta/ordercomplete.php?sid=<?php echo $sid; ?>"> <input type="hidden" name="rm" value="2"> <input type="hidden" name="cbt" value="Click Here To Complete Order!"> <input type="hidden" name="item_name_1" value="German Shepherd"> <input type="hidden" name="item_number_1" value="ZZZ10055"> <input type="hidden" name="quantity_1" value="1"> <input type="hidden" name="amount_1" value="65.00"> <input type="hidden" name="shipping_1" value="12.00"> <input type="hidden" name="item_name_2" value="Plush 16 inch"> <input type="hidden" name="item_number_2" value="ZZZ10400"> <input type="hidden" name="quantity_2" value="1"> <input type="hidden" name="amount_2" value="55.00"> <input type="hidden" name="shipping_2" value="6.00"> <input type="hidden" name="item_name_3" value="Yorkie"> <input type="hidden" name="item_number_3" value="ZZZ17400"> <input type="hidden" name="quantity_3" value="1"> <input type="hidden" name="amount_3" value="60.00"> <input type="hidden" name="currency_code" value="USD"> <input type="submit" value="Checkout"> </form>

add another underscore. change item_number1 to item_number_1

OK, added the following and brings over the correct URL, But still buyer must click button instead of automatically loading the webpage. <input type="hidden" name="rm" value="2">

This works ok if the buyer presses the "Return to Merchant" button. Is there something that does an auto return? I need to be able to update the database to show payment confirmed. Actually, even if you click the button, the url reads http://www.Website.com/ordercomplete.php?merchant_return_link=Return+to+Merchant

I know how to send paypal the item information, pricing, quantity, etc etc etc. How do I send paypal a session ID that they will return to me once the payment has been processed? Regards, DED

aleX_hill, That is basically what I did. Except i created the session id at the time the user first enters the website. Is this a good idea? session_start(); if ($_SESSION['sid'] == ""){ $_SESSION['sid'] = rand() . rand() . rand(); } I have everything working perfect. The add product, delete product. What I need to do now is give the summary information to paypal. Basically, even if they order 5 items, just send a total price to paypal. Once payment is complete, return to my website with the correct session id. I would then have a order processed screen show all the detailed information and shoot out an email to the buyer. Where can I get information on how to do this? Seems everywhere I look on paypal, I would have to create paypal buttons. Any help is much appreciated. Regards, DED

First time doing a shopping cart. I figure I have to hold the information within the shopping cart in a database. How do I link the records to the "session"? Do I use the session_start();? Not sure exactly how to do this. The owner of the site does not require the buyer to create an account. Regards, DED