sws

Hi, I have created a form that my clients fill out and then it's supposed to email the data to me once they click submit and then redirect them to the thank you page.  I have tested the form and his submit. When I hit submit it redirects me to the thankyou page and everything seems fine but I am not receiving the email. Here's the page with the form on it: [code]<form action="thanks.php"                 method="POST">                       <input type="hidden" name="recipient"                     value="admin@mysellium.com">                       <input type="hidden"                     name="subject"                     value="Home-Deliver-Ease.com - Order" />                                       <table width="475" border="0" cellspacing="0" cellpadding="4">                   <tr bgcolor="#E1EFCE">                     <td colspan="2"><div align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Fill                         out your Grocery List</strong></font></div></td>                   </tr>                   <tr>                     <td width="250" valign="top"><div align="left">                         <p align="center"><font size="2" face="Arial, Helvetica, sans-serif"><br>                           <br>                           <br>                           <br>                           Write your grocery list here &gt;&gt;</font><font face="Arial, Helvetica, sans-serif"><br>                           <font size="1">Please include<font face="Arial, Helvetica, sans-serif">                           Brand Name <br>                           or Size </font> where applicable:<br>                           <br>                           <br>                           <a href="ideas.html"><img src="images/shopping_cart_small.jpg" width="50" height="67" border="0"></a><br>                           </font><font size="2"><a href="list_ideas.html" target="_blank">Click                           Here for Grocery Ideas</a><br>                           </font></font></p>                       </div></td>                     <td width="245"><div align="right">                         <textarea name="Grocery List" cols="35" rows="15" id="Grocery List">I would like....</textarea>                       </div></td>                   </tr>                   <tr bgcolor="#E1EFCE">                     <td colspan="2"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Contact                       &amp; Delivery Information</strong></font> <div align="left"></div></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Name:</font></div></td>                     <td><input name="Name" type="text" id="Name"></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Address:                         </font></div></td>                     <td><input name="Address" type="text" id="Address"></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">City:</font></div></td>                     <td><input name="City" type="text" id="City"></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Province:</font></div></td>                     <td><input name="Province" type="text" id="Province"></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Postal Code:</font></div></td>                     <td><input name="Postal Code" type="text" id="Postal Code"></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Phone:</font></div></td>                     <td><input name="Phone" type="text" id="Phone"></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Email:</font></div></td>                     <td><input name="Email" type="text" id="Email"></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Requested                         Delivery Date:</font></div></td>                     <td><font size="2" face="Arial, Helvetica, sans-serif">                       <input name="Delivery_Date" type="text" id="Delivery_Times3" size="12">                       (ex - mm/dd/yyyy )</font></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Requested                         Delivery Time:</font></div></td>                     <td><font size="2" face="Arial, Helvetica, sans-serif">                       <input name="Delivery_Times2" type="text" id="Delivery_Times2" size="12">                       (ex - 1:00 pm)</font></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">Special                         Deilvery Instructions:</font></div></td>                     <td><textarea name="Special Deilvery Instructions:" cols="35" rows="5" id="Special Deilvery Instructions:"></textarea></td>                   </tr>                   <tr>                     <td colspan="2">&nbsp;</td>                   </tr>                   <tr bgcolor="#E1EFCE">                     <td colspan="2"><div align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong>Method                         of Payment</strong></font></div></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">                         Cheque:</font></div></td>                     <td><font size="2" face="Arial, Helvetica, sans-serif">                       <input type="radio" name="cheque" value="cheque">                       </font></td>                   </tr>                   <tr>                     <td><div align="right"><font size="2" face="Arial, Helvetica, sans-serif">                         Cash:</font></div></td>                     <td><font size="2" face="Arial, Helvetica, sans-serif">                       <input type="radio" name="cash" value="cash">                       </font></td>                   </tr>                   <tr>                     <td colspan="2"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">All                         orders are payable at time of delivery.</font><font size="2" face="Arial, Helvetica, sans-serif">                         </font></div></td>                   </tr>                   <tr>                     <td colspan="2"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif">I                         agree:                         <input name="I Agree" type="checkbox" id="I Agree" value="yes">                         </font></div></td>                   </tr>                   <tr>                     <td colspan="2"><div align="center"><br>                         <input type="submit" name="Submit" value="Place Order Now">                         &nbsp;&nbsp;                                             </div></td>                   </tr>                   <tr>                     <td>&nbsp;</td>                     <td>&nbsp;</td>                   </tr>                 </table>               </form>[/code] Here's the script that is supposed to email the form data to me: [code]<?   $email = $_POST['email'] ;   $recipient = $_POST['recipient'];   $subject = $_POST['subject'];   $list = $_POST['Grocery List'];   $name = $_POST['name'];   $address = $_POST['address'];   $city = $_POST['city'];   $province = $_POST['province'];   $postal_code = $_POST['Postal Code'];   $phone = $_POST['phone'];   $delivery_date = $_POST['Delivery_Date'];   $delivery_time = $_POST['Delivery_Times2'];   $special_instructions = $_POST['Special Delivery Instructions'];   $cheque = $_POST['cheque'];   $cash = $_POST['cash'];   $agree = $_POST['I Agree'];     mail( "admin@mysellium.com", "$subject",     $email, $subject, $list, $name, $address, $city, $province, $postal_code, $phone, $delivery_date, $delivery_time, $special_instructions, $cheque, $cash, $agree,  "From: $email" );   header( "Location: http://www.solsticewebsolutions.com/home_d/thankyou.html" ); ?> [/code] Can anybody please tell me what I've done wrong ?

Hi, I am creating a fantasy sports pool and I have the standings displayed on the home page. It shows a table with the user_id and their point totals. I want to change it so that each user id is an <a href> link to a url that will show a detailed view of their roster. so if there user id is "whatever"  They can click the link that says whatever and it will take them to ultimatepoolies.com?user_id=whatever How do I do this and more impoetantly how do I ensure that that file exists on my webserver ? here is what I have now: [code]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Ultimate Poolies - Compete against the world's ULTIMATE SPORTS POOLIES</title> </head> <body background="images/bg.gif"> <?php include ("config.php"); # Include the config.php file here error_reporting (E_ALL & ~ E_NOTICE); # Don't show notices. echo '<table align="center" border="0" cellpadding="0" cellspacing="0" width="850"> <tr>     <td height="22" background="images/nav_bar_02.jpg"><font color="#FFFFFF"><p>Welcome to ULTIMATE POOLIES.com We are pleased to announce that our HOCKEY Contests are now in progress!!!</p></font></td>   </tr>   <tr>     <td bgcolor="#FFFFFF"><font face="SerpentineDBol" size="+3" color="#FF0000">Ultimate Poolies.com </font>'; if(!empty($online['id'])) {   print'Welcome <b>'.stripslashes($online['username']). '</b>- <a href="logout.php">Logout</a><br />'; } else {   print'<a href="login.php">Login | </a><a href="register.php">Register</a><br />'; } ?>   </td>   </tr>   <tr>     <td height="22" background="images/nav_bar_02.jpg"></td>   </tr>   <tr><td>     <table border="1" cellpadding="2" cellspacing="0">       <tr>         <td width="150" bgcolor="#003399" align="center" valign="top"> <table bgcolor="#CCCCCC" width="148"> <tr>   <td align="left"><a href="index.php">Home  </a></td> </tr> <tr>   <td align="left"><a href="hockey_contests.php">Hockey Pools </a></td> </tr> <tr>   <td align="left"><a href="#">Football Pools </a></td> </tr> <tr>   <td align="left"><a href="#">Basketball Pools </a></td> </tr> <tr>   <td align="left"><a href="#">Baseball Pools </a></td> </tr> <tr>   <td align="left"><a href="upforums/index.php" target="_blank">Message Boards  </a></td> </tr> <tr>   <td align="left"><a href="mailto:admin@ultimatepoolies.com">Contact U.P.</a></td> </tr> </table>  </td> <td width="530" bgcolor="#FFFFFF" valign="top"><br /> <table border="0" align="center" width="520"> <tr> <td valign="top" align="center"><font color="#003366"><h2> Welcome to Ultimate Poolies.com</h2></font> </td> </tr> </table> <table border="1" align="center"> <tr>   <td colspan="3" align="center"><img src="images/hockey_stars.gif" /></td> </tr> <tr>   <td colspan="2">   <table border="1" bordercolor="#3366FF" width="100%" cellspacing="0" cellpadding="0">   <tr><td colspan="2" bgcolor="#003399" align="center"> <p><font color="#FFFFFF"><b>Standings</b></font></p></td> </tr> <tr>   <td width="100" align="center"><b>Manager </b></td><td align="center">  <b>Points</b></td> </tr> <?php   $standings_sql = "SELECT b.handle AS manager, SUM(a.points) AS total FROM nhl_managers AS b LEFT JOIN nhl_players AS a ON(b.lw1 = a.id OR b.lw2 = a.id OR b.lw3 = a.id OR b.lw4 = a.id OR b.lw5 = a.id OR b.rw1 = a.id OR b.rw2 = a.id OR b.rw3 = a.id OR b.rw4 = a.id OR b.rw5 = a.id OR b.c1 = a.id OR b.c2 = a.id OR b.c3 = a.id OR b.c4 = a.id OR b.c5 = a.id OR b.d1 = a.id OR b.d2 = a.id OR b.d3 = a.id OR b.d4 = a.id OR b.d5 = a.id OR b.d6 = a.id OR b.d7 = a.id OR b.d8 = a.id OR b.d9 = a.id OR b.d10 = a.id OR b.g1 = a.id OR b.g2 = a.id OR b.g3 = a.id) GROUP BY manager ORDER BY total DESC"; $standings_query = mysql_query($standings_sql); if (!$standings_query) {   echo 'SQL error: ', mysql_error();   exit; // error handling } while ($table_row = mysql_fetch_array($standings_query)) {   ?> <tr>   <td><font face="Verdana, Times New Roman, Times, serif" size="-2" color="#990000">   <?=$table_row['manager']?>   </font>   </td>   <td><font face="Verdana, Times New Roman, Times, serif" size="-2" color="#990000">   <?=$table_row['total']?>   </font>   </td>   </tr> <? } ?> </table> </td> <td valign="middle" align="center"><a href="hockey_pickem_roster.php">Enter Today !</a><br /><a href="#">Rules</a></td> </tr> </table> </td> <td width="232" bgcolor="#CCCCCC" align="left" valign="top"><br /javascript news headlines here</td>       </tr>     </table> </td>   </tr> </table> </body> </html> [/code]

Hi, most of you will have seen my posts before. I'm trying to put up several different fantasy sports pool concepts on mywebsite. I have very basic php knowledge but am finding it all overwhelming. I was wondering if any of you would like to partner up with me to get it done. It has the potential to make big money if done right. I have no budget but would be willing to partner with the right individual. Anybody interested ? I'd put this in the freelance forum but not sure if I'm allowed to post unpaid positions there.

Thanks guys ! I really appreciate the help

Thanks Jocka. I'll implement this. Once I have this working, how would I then enter the picks into the database ?  I'll need to createa table containing the user's id and all of the pick values each day. Any advice on how I should set that up ?

I have a mysql table that contains the entire nhl schedule in it. Fields in the table are as follows: ID Home Team Visiting Team Date I'm trying to create a form that lists every game being played on that particular date (always today) with radio buttons beside each team name. Basically what I'm trying to accomplish is to display a form that shows every game for that day and to let the user pick a winner for each game.  How to I populate the form with JUST the games for the present day ? Also,  How do I write the picks to the database.

Thanks. Sounds like a good solution. I am using a user id and a pick id (which is basically the player id for each player... tied back to the players table). I'm plugging this all into just one managers table right now though. Then on the page that displays the standings I pull the data from the managers and players table and display it. I'll break it up into two tables: a picktrack table and a picktrackitems table. Does this mean that my managers table will just contain the username and the unique id ?  So essentially I'll have 3 tables ? I have to plan ahead for when I add other pools. The manager will be allowed to enter several different pools but can only enter each pool once.

Hi, I have no experience using phpMyAdmin. I have never seen any sign of it through my host company. Is it something I have to install or do I have to ask them for access to it ? It sounds like it will take A LOT of hassle out of creating forms ? I use sql front to access my mysql databases. Does it compare at all to phpMyAdmin ?

Hi, I have created a sports pool in which the user uses a form to make a bunch of player selections. When they submit the form their picks are entered into my database.  I'm now trying to take it to the next step. Currently, the form can be filled out over and over again but I want it so that the user must submit picks each week by Sunday night 11:59 pm (Pacific time). Once they've submitted their picks for the week, they can not change their picks for the week. After 11:59 pm each Sunday night, I want the form to be disabled. The form will then be enabled again each Saturday from 11:59 PST to Sunday night 11:59 pst for user's to enter their picks for the upcoming week. Any suggestions on how to accomplish this ?

Your double quote after the last NULL  has to go OUTSIDE the close bracket and before the semi-colon [code]<?php //LINE 37 $sql = "INSERT INTO my_search_table where uID = '". $uID ."' VALUES('NULL', '$brideFname', '$brideLname', '$groomFname', '$groomLname', '$event_month', '$event_day', '$event_year', 'NULL', 'NULL', 'NULL', 'NULL'"); ?> [/code] should be [code]]<?php //LINE 37 $sql = "INSERT INTO my_search_table where uID = '". $uID ."' VALUES('NULL', '$brideFname', '$brideLname', '$groomFname', '$groomLname', '$event_month', '$event_day', '$event_year', 'NULL', 'NULL', 'NULL', 'NULL')"; ?> [/code]

That META thing.... I've never seen that.  I have been trying to think about how I'm going to make a webpage for the ncaa basketball tournament in march. I'll have the bracket with all the first round games where the user can pick the winner from each game.... based on their picks for each game I need the page to refresh so that the second round games are populated with the winners they selected. So on for the third, fourth rounds, etc... Would that META thing work ?

Yeah, I use paypal now. And it's great but I find that a lot of customers don't want to use it. I don't know why (probably because it's an extra step, setting up the paypal account) I wasn't suggesting I create something myself.  I was wondering if there are any companies out there that offer something like paypal web payments PRO (U.S. residents only) This lets them pay with their credit card without having to set up a paypal account (I think) I would use that solution but I live in Canada so they wont let me.

OK businessman.  That sounds like something I would like to do. Somehow go through the data on ESPN, capture it and put it into my database each night. Problem is, I have no idea how to do it. Can anybody point me in the right direction ? Tutorials, anything ??

Hi, I've got a question regarding accepting credit card payments online. I am wondering if anybody knows a way of doing this without having to go through one of the big banks for a gateway. I know paypal offers it but it is only for US residents. I live in Canada. Does anybody know how I can accept credit cards without having to have my credit approved and paying all kinds of heavy set up fees like the banks charge. I do currently accept paypal as my only method of payment but a lot of my clientelle is elderly and very hesitant to use paypal. Any advice would be appreciated.

Does anybody know of an effectiveway to obtain sports player stats on a nightly basis other than paying 10's of thousands of dollars for a nightly xml feed from a stats service company or manually updating my table ? Sites like espn and such have player stats on their site. Is there an effective way of taking that info and plugging it into my database ?  I'm thinking xml or something.  And the other thing. I'm assuming I'd need permission from them ? Any input would be great because manually updating 1000 + players each night is a royal pain in me butt hehe.