Jump to content

IndianaGuy

Members
  • Content Count

    91
  • Joined

  • Last visited

Community Reputation

0 Neutral

About IndianaGuy

  • Rank
    Newbie

Recent Profile Visitors

7,940 profile views
  1. IndianaGuy

    fetch returning "r" for results

    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. IndianaGuy

    fetch returning "r" for results

    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. IndianaGuy

    fetch returning "r" for results

    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. IndianaGuy

    fetch returning "r" for results

    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. IndianaGuy

    fetch statement with grouping

    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. IndianaGuy

    fetch statement with grouping

    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. IndianaGuy

    fetch statement with grouping

    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. IndianaGuy

    Uprotect a Workbook

    wow!! I thought my issue was syntax related. This is going to be a disaster for me to figure out. lol
  9. IndianaGuy

    Uprotect a Workbook

    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. IndianaGuy

    email at text

    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. IndianaGuy

    Media Player

    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. IndianaGuy

    Prepared statement with UPDATE

    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. IndianaGuy

    Prepared statement with UPDATE

    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. IndianaGuy

    touchstart and click on refresh only

    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
×