Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

8,840 profile views

IndianaGuy's Achievements


Newbie (1/7)



  1. Found a typo. When I used fetch_row, I did change them to echo $row4[1] etc etc. I did find a typo and it works now. However, the fetch_assoc is still giving me the "r" for the results. I wish I can understand why so I can learn something. Thank you .When I did use fetch_assoc, I did change the values to $row4['School']; etc etc
  2. I am hear you buddy. I have tried mysqli_fetch_assoc($result4), mysqli_fetch_array($result4), mysqli_fetch_row($result4). Only so I can at least see a different results to figure out the problem is. They all give me the same exact answer. For testing. The IMDid is 35;Team:rCoach:rTeam Color:rSchool:r
  3. print_r is giving me the right results!! Array ( [0] => 19 [1] => 35 [2] => YES [3] => YES [4] => NO [5] => NO [6] => NO ) Not sure how the heck I got Echo instead of echo!! LOL
  4. This keeps returning odd results. I can't find much information online when I researched it. The results are, For testing. The IMDid is 35; Team:r Coach:r Team Color:r School:r echo "For testing. The IMDid is " .$IMDid; $sql4 = "SELECT * FROM reminders WHERE userFK = '$IMDid'"; $result4 = mysqli_query($conn, $sql4); if (mysqli_num_rows($result4) > 0) { while ($row4=mysqli_fetch_row($result4)) { Echo "Selections:"; Echo "Team: " . row4['TeamName']; echo "<br>"; Echo "Coach: " . row4['Coach']; echo "<br>"; Echo "Color: " . row4['TeamColor']; echo "<br>"; Echo "School " . row4['School']; echo "<br>"; } mysqli_free_result($result4); }else{ echo "No record found"; }
  5. This sounded easier to do that I had thought. I am trying to wrap my mind around the loop but it is not working out for me. I think "Create an empty-string variable outside the loop that produces each row." is what is confusing me. How is this done? Thank you
  6. Excellent. Thank you so much. I thought of a similar solution, but thought maybe I should do some research before I reinvent the wheel.
  7. Hello folks, I am afraid i may not be using the correct wording with the "Title", but I hope I can clarify. I have a table with three columns column 1: FileName column 2: FinishDate column 3: FinishTime When I do a fetch the rows and display them I get FileName, FinishDate, FinishTime FileName, FinishDate, FinishTime FileName, FinishDate, FinishTime etc etc What I am trying to do is to group the same FileName to display FileName FinishDate, FinishTime FinishDate, FinishTime etc FileName FinishDate, FinishTime FinishDate, FinishTime etc Is this possible? and can you lead me to the correct tutorial or link with explanations. Thank you so much
  8. wow!! I thought my issue was syntax related. This is going to be a disaster for me to figure out. lol
  9. How do I turn off a password protected workbook. Obviously I have the password. I am trying to make a copy of the protected workbook and make the new copy unprotected. Thank you very much set xlApp = CreateObject("Excel.Application") Set objWorkbook = xlApp.Workbooks.Open("C:\mypath\..\..\protected.xlsx") xlApp.Visible=TRUE Set targetSchedule = xlApp.Workbooks(1) targetSchedule.SaveAs ("C:\mypath\..\..\..\uprotected_copy.xlsx") Dim myPass myPass = "12345678" targetSchedule.Unprotect password:=myPass
  10. If I understand you correctly, YES. I sent myself an email to xxxxxxxxxx@att.txt.net from my gmail account and it came to the phone as a text message just as expected. Thank you for the help
  11. IndianaGuy

    email at text

    This use to work but not anymore. Any ideas why? when I replace $to with a real email address. it works just fine! //xx.. is a 10 digit phone number. ATT says this should work! $to = xxxxxxxxxx@att.txt.net"; $subject = "My subject"; $txt = "Hello world!"; mail($to,$subject,$txt);
  12. Looking for a recommendation for a audio/video player that will work on mobile devices. I don't care if I pay a few bucks for it but free is good as well. I need something that will be easily modified. I will need to add some eventlistener and record the users play/stop actions etc. Thank you
  13. I appreciate your help. Still trying to figure out your response and how to use it on a function, or if that is even a good idea. this $stmt is going to be ran several times in a row. I figure prepared statement is the best way to go. Also, column opener_Ask is a integer. it's just a counter keeping track of how many times it was triggered. The following works but I would rather keep it the old way so I can learn more on how it works lol.Also $colName is the one that will change everytime more so than the $sesID $stmt = $conn->prepare("UPDATE tbl_calls SET $colName = $colName + 1 WHERE memberid_fk = ?");
  14. My very first prepared statement :-). I am sure its wrong, but not sure why . I get error "Call to a member function bind_param() on boolean". Thank you for your advice. <?php function updateCallStats($colName,$sesID){ $servername = "localhost"; $username = "root"; $password = ""; $database = "abc"; $conn = new mysqli($servername,$username,$password,$database); $stmt = $conn->prepare("UPDATE tbl_calls SET ? = ? + 1 WHERE memberid_fk = ?"); $stmt->bind_param("ssi", $colName, $colName, $sesID); $stmt->execute(); echo "Wooohoo. I did it"; } $colName = "opener_Ask"; $sesID = "10"; updateCallStats($colName, $sesID); ?>
  15. The developer tools in Chrome is not showing that there are nay errors! Any other place I can go that may identified errors? Thank you
  • Create New...