RSprinkel

Hi All, I have a online membership website and when a member sends me a payment via money order, check, etc. I go to an admin form and enter the data into the form saying it was paid. When I click the submit button it processes the information into the database (MySQL) and what I would like is to be able to have that process actually email that specific member a notice to let them know payment has been received. Here is the process code that I am currently using: <?php include 'db.php'; $username = $_POST['username']; $date = $_POST['date']; $amount = $_POST['amount']; $paidby = $_POST['paidby']; $next = $_POST['next']; $comments = $_POST['comments']; $username = stripslashes($username); $date = stripslashes($date); $amount = stripslashes($amount); $paidby = stripslashes($paidby); $comments = stripslashes($comments); //insert info into dues table $sql = mysql_query ("INSERT INTO dues (username, date, amount, paidby, next, comments) VALUES('$username','$date','$amount','$paidby','$next','$comments')") or die (mysql_error()); if(!$sql){ echo 'There has been an error processing your Payment Received. Please contact the webmaster.'; } mysql_close($connection); //show user decision page include 'dues_filed.php'; ?> Thanks much in advance. RSprinkel

Thanks Andy. Aprreciate the help.

Hi All, Was wondering if there was a way to NOT have directory/pages shown in the address bar when users browse site.  As well as not display the directory/page at the bottom? For instance www.mysite.com/pages/mypage.htx I would like for it to only show www.mysite.com period. Thanks Much in advance. RSprinkel

Hi all, I have a situation and the details are listed below. I have a scoring database that keeps track of scores for a racing league.  The tables that I need to query to put on a standings page are Division, Drivers, and Score(which tracks all the races for all divisions and drivers.  What I need is to be able to query these tables broken down into divisions and list each driver per division with their total standings.  As it stands the Score table only list the drivers by their driver ID which is a number.  So it would basically have to cross reference the ID in the Score table with the Driver table to get the drivers name.  Then the points from each race has to be totalled for all drivers per division.  Then the information queried goes into a standings table. For example: Pro Division Driver Name     Total Points John Doe             1180 Any help with this would be MUCH APPRECIATED. Thanks Much in Advance.

Yes I am using Windows XP SP2.  When I imported the dump, I went directly to the database  via phpmyadmin and clicked on Import.  Yes I have a ODBC Connection set up, but even with that I get this error.  Access Denied for User:username.  Would this be a hosting issue from where I am hosting my space or like you said previously "Well the default in the last couple installations (on Linux) was to only have mysql only running locally and not exposed to the network"?

Well this is gonna be a stupid question on my part as MySQL is all new to me, but how and where would I enter that command to check? Again sorry, LOL.

Well I have my IP listed as a Access host if that is what you mean.  If thats not what you are asking, I don't know how to check.  This is all new to me.

Hi All, Ok any help here would be greatly appreciated. I currently have a MS Access db that I update weekly and would like to convert it to an MySQL db.  I am using a utility called MS Access to MySQL and when I try to connect to my MySQL db with the set permissions it runs for awhile (not doing anything) and then gives me this error: "Error: -2147467259 Reason: [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server during query Hint: Please try to change the Connection Database when asked for the Connection Options. The one you specified was not found." Now I know the db is there cause I did an actual dump of the access db and then imported in via MySQL.  I have tried numerous utilities including SQLyog and I get the same error about Lost connection or to MySQL during server query or I get timed out errors. Again Any help would be greatly appreciated. Thanks much in advance.

OK I found a way to get the MS Access db into MySQL but I have errors and will post the info in the MySQL Area. Thanks All for your help.  Much Appreciated.

Hi all, I am wondering if there is a utility or a way to extract data in HTML files into php/MySQL? My scenario: I currently am a League Owner for an online N2K3 Racing League and the files that the Sim puts out is in HTML format.  I would like to be able to process this information into an MySQL database and calculate the standings and stuff.  I am currently using a League utility which all the data is stored in an Access Database that puts out the race statistics and stuff into other HTML pages and having to upload it onto the site and linking to specific HTML pages .  I would rather it go into a MySQL Database if at all possible. Thanks very much in Advance. RSprinkel

Thanks for all the help guys.  I got all those little nasty bugs worked out.  Now I am gonna try to do some sorting or something and hope I don't mess this all up after all of this, LOL. Again Thanks for the Help and I am sure I will have some more questions regarding some other help on soon.

AndyB, Thanks again very much for your expertise.  I did something dumb and changed the <select name="sierra"> to <select users="sierra">.  That is strictly my fault.  What a DUMB thing for me to do, LOL. Again Thank You very much.  Working like a charm now.

Thanks for the info.

Ok I got this script working now without any errors.  Now when I go to post the info into the database it posts everything but the sierra name into the db.  Man this PHP stuff is tuff, LOL. Here is the process script. [code]<?php include 'db.php'; $sierra = $_POST['sierra']; $date = $_POST['date']; $series = $_POST['series']; $nmod = $_POST['nmod']; $track = $_POST['track']; $sierra = stripslashes($sierra); $date = stripslashes($date); $series = stripslashes($series); $nmod = stripslashes($nmod); $track = stripslashes($track); //insert info into win table $sql = mysql_query ("INSERT INTO win (sierra, date, series, nmod, track) VALUES('$sierra','$date','$series','$nmod','$track')") or die (mysql_error()); if(!$sql){ echo 'There has been an error processing your pirep. Please contact the webmaster.'; } mysql_close($connection); //show user decision page include 'test_filed.php'; ?>[/code] All table fields are correct in the db and coincide with the script. Again Thanks much for tolerating me and my NON PHP knowledge, LOL.

Hi all, I am getting this error when I try to enter data into a database via a form. Here is the error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod, track) VALUES('PA_LowRider'','09/14/2006','Cup','Cup','Richmond')' at line 1 Here is the code trying to process the data into the database. [code]<?php include 'db.php'; $sierra = $_POST['sierra']; $date = $_POST['date']; $series = $_POST['series']; $mod = $_POST['mod']; $track = $_POST['track']; $sierra = stripslashes($sierra); $date = stripslashes($date); $series = stripslashes($series); $mod = stripslashes($mod); $track = stripslashes($track); //insert info into win table $sql = mysql_query ("INSERT INTO win (sierra, date, series, mod, track) VALUES('$sierra','$date','$series','$mod','$track')") or die (mysql_error()); if(!$sql){ echo 'There has been an error processing this win. Please contact the webmaster.'; } mysql_close($connection); //show user decision page include 'win_filed.php'; ?> [/code]

[quote author=redarrow link=topic=108379.msg436037#msg436037 date=1158504691] what line is 75 then sorry my cristal ball not working. [/quote] LOL sorry I didn't post that and when I re-read what I wrote I was about to post it. But no need to now.  It WORKS GREAT thank you very much for the update. Again Thanks.

Hi AndyB, I am getting this error now when I inserted this code. Parse error: syntax error, unexpected $end in /home/../../../../test.php on line 75

AndyB - Thanks very much for the help.  Worked great redarrow - Didn't know that.  I will remember that.  The scripts I am running was written for me for other prior uses.

Sorry for being such a noob at this.  But here is my issue. I have a page that displays data coming out of a table that places the data in row format.  I would like to have it displayed in column format.  I don't want the data to be editable though. Here is the code that spits it out in Row format: [code]<table border="0" cellpadding="5" cellspacing="0" align="center" style="font-size: 9pt; border: solid 1px">     <tr bgcolor="#b5d0e5"> <th align="center">Sierra Name</th> <th align="center">Location</th> <th align="center">Date Joined</th> <th align="center">Status</th>     <th align="center">Open</th> <th align="center">Member Bio</th>     </tr> <? $sql = "SELECT * FROM users WHERE username = '$username'"; $result = mysql_query($sql); while ($row = mysql_fetch_array($result)) { ?>     <tr style="color: #111111"> <td align="center"> <?echo $row["sierra"];?> </td> <td align="center"><?echo $row["location"];?></td> <td align="center"><?echo $row["signup_date"];?></td> <td align="center"><?echo $row["status"];?></td>     <td align="center"><?echo $row[""];?></td> <td align="center"><?echo $row["bio"];?></td>     </tr>[/code] That spits the data out like this: Sierra          Location          Signup Date          Status        Open          Bio Data            Data                Data                  Data          Data          Data [b]I like to have it displayed as this:[/b] Sierra: data Location:  data Signup Date: data Status:  data Open: Data Bio: data (but the data needs to be in a scrollable text box) I have tried this and modified it many times and still nothing appears: [code]<table border="0" cellpadding="5" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="17%" id="AutoNumber1">     <tr>       <td width="99%" align="center">Sierra Name</td>       <td width="3%"><?echo $row["sierra"];?></td>     </tr>     <tr>       <td width="99%" align="center">Location</td>       <td width="3%"><?echo $row["location"];?></td>     </tr>     <tr>       <td width="99%" align="center">Date Joined</td>       <td width="3%"><?echo $row["signup_date"];?></td>     </tr>     <tr>       <td width="99%" align="center">Status</td>       <td width="3%"><?echo $row["status"];?></td>     </tr>     <tr>       <td width="99%" align="center">&nbsp;</td>       <td width="3%">&nbsp;</td>     </tr>     <tr>       <td width="99%" align="center">Member's Bio</td>       <td width="3%"><?echo $row["bio"];?></td>     </tr>   </table>[/code] [color=blue][b]Thanks very much in advance[/b][/color] :(

Hi all, I need some help here on a few things I am trying to do. 1) I am trying to create a form that I want data pulled out of a MySQL table called users from a column named sierra and then placed in a Drop Down box in the form.  I have searched here and tried many of the ideas here and apparently I am not grabbing the concept. 2) I want to have a form that pulls data from 3 different databases.  It is a profile form for my league.  When someone clicks on a members name the profile page will pull up displaying 3 different things.  1)Basic info on the member coming from the users table, Accomplishments within the league - Coming from the accomplishments table, and 3) Winnings - which would come from a win table.  All of these tables are in the same database.  Thank you all very much in advance.

LOL yup you are right, it is at the end of the latter part right before the "or die".  I also found I Was missing the ) there as well and then I found the ownmbr,) which I had to remove the ",".  Now it works fine. Thanks for pointing out the missing " that pointed me in the right direction to fix and find the other 2 little issues. Again Thank you

Hi all, I am trying to create a file to enter some info into a db.  When I try to submit the data I am getting this error" Parse error: syntax error, unexpected T_STRING in /home/blah/blah/blah/create_profile_process.php on line 69 Here is some of the code above and below line 69: [code]//insert info into profile table $comments2 = htmlspecialchars($comments); $sql = mysql_query ("INSERT INTO profile (username, work, married, children, fdriver, ftrack, fmod, hobbies, hear, say, team, bman, bnmbr, cman, cnmbr, trman, trnmbr, tpman, tpnmbr, lmman, lmnmbr, aman, anmbr, gnman, gnnmbr, owman, ownmbr,) VALUES('$username','$work','$married','$children','$fdriver','$ftrack','$fmod','$hobbies','$hear','$say','$team','$bman','$bnmbr','$cman','$cnmbr','$trman','$trnmbr','$tpman','$tpnmbr','$lmman','$lmnmbr','$aman','$anmbr','$gnman','$gnnmbr','$owman','$ownmbr') or die (mysql_error()); if(!$sql){ echo 'There has been an error creating your profile. Please contact the webmaster.'; } $sql = "SELECT * FROM users WHERE username = '$username'"; $result = mysql_query($sql); $user_array = mysql_fetch_array($result);[/code] Now Line 69 is: [code]$sql = "SELECT * FROM users WHERE username = '$username'";[/code] Now I know it has got to be something I am overlooking and probably a simple fix, but I can't find it. Thanks much in advance. RSprinkel

Thanks for the help.  I did just find the error. The info it was to be placed into the db I didn't have a comma in between 2 of the data and threw it off. Again, Thanks much for your help. RSprinkel

Hi all, I am trying to figure out a code to pull the newest member out my user database. I am using a MySQL db. Any help would be greatly appreciated. Thanks much in advance.

Hi All, I am having an issue with one of my databases. I am trying to enter data from a temp database into a permanent database via a form. When I hit the submit form I am getting this error. "Column count doesn't match value count at row 1" Can someone please give me some ideas as to what is causing this? I have checked all the data fields that this is trying to go in and the data count matches the column count I have 15 data fields and 15 columns in this database. Thanks in advance.