Jump to content


  • Content Count

  • Joined

  • Last visited

Everything posted by PShannon

  1. You say one folder. I'm accessing two, but not a peer folder -- consistently -- and you mock me. Says a lot about you. If you don't know. Say so. Then there's the other guy. This forum is for children.
  2. I've been doing this since 1966 and I build stuff quick and fast with patterns, components, templates, borrowed code or whatever gets me to where I want to be as fast as possible and I have no problem with tweaking code, but then again, my question had nothing to do with code. You didn't read it and if you did, you certainly didn't understand it. You did not contribute a single word responding to my inquiry. You just decided to lecture a guy you didn't know about what he needed. Now, please go away. You have nothing to contribute.
  3. The W3 code allows the user to define the directory dynamically -- kinda? -- and that is my question. Respectfully, it would be useful to understand the problem statement before responding.
  4. I have used the W3 template to produce a script that uploads image changes to a directory on my server, updates the URL in my database and logs the event. Works beautifully IF the source folder is: \Pictures or \Pictures\Personal But fails if it is any other source folder, even the peer folder \Pictures\BarImages Why?
  5. I can live with this. http://www.database39.com/page.php?id=701 Thank you . . . enjoy the holidays . . .
  6. I really hate to be a pain in the , amigo, but could you show me what that would look like -- please!
  7. Provided a workable solution to a problem I've been wrestling with for weeks in two back-and-forths.

  8. Forgive my omission. I should have identified the source up front. My bad! The target URL is stored in a MySQL database as a VARCHAR field in the "bars" table. The target "bar" is selected via a series of drop-downs -- also sourced from MySQL tables -- that answer the questions: What neighborhood do you want? Do you want a bar or a club/hotel/restaurant bar? Select from list of bars/clubs/hotels/restaurants in "neighborhood." Here's a page that shows a "selected" bar and demonstrates the application (cursor down to below image). http://www.database39.com/page.php?
  9. This works! You're a bloody genius! I have been chasing this for weeks. Thank you! I could use some help cleaning it up a bit. If you look at the resulting webpage -- http://www.database39.com/page.php?id=17 -- the code produces two rows. The first row contains https://www.110grill.com/ The second, "action," row contains the legend "Website" Can the first row be made to "go away?" Again, I am very grateful.
  10. <input type="url" id="homepage" name="homepage" value="https://shakingcrab.com/">&nbsp;&nbsp;<input type="button" onclick="triggerlink()" value="go to url"> This is on the right track, but I do not have the value of the target. The value of the target is in a variable, $website. How does the <input> statement change, given that? You can see what I am trying to do here: http://www.database39.com/page.php?id=13 (cursor down, below image) I appreciate you responding. I've been struggling with this for some time . . .
  11. Can you point me to some G2 on that? Thanks . . .
  12. Because I am vested in: <input type="url" id="website" name="website" value="<?php echo "<a href='$website'>Website</a>"; ?> "> That's just one line of code from that form. There's a bunch of data in the form. Can you help me without suggesting other ways to accomplish this task? Here's how the Edge browser sees the statement at execution: <input type="url" id="website" name="website" value="'http://www.barracudatavern.com/'>Website</a> "> I know I'm close. Any ideas? I appreciate your input . . .
  13. Here's what I have: $website = "https://shakingcrab.com/" (unquoted) <input type="url" id="website" name="website" value="<?php echo "<a href='$website'>Website</a>"; ?> "> This is what the HTML interpreter sees at execution: <input type="url" id="website" name="website" value="'https://shakingcrab.com/'>Website</a> "> Thanks . . .
  14. Thanks . . . Clearly a sop to Internet advertisers who want to force feed us their stuff.
  15. How can I turn video autoplay to off for ALL browsers? I can't believe autoplay is the default in Edge and Chrome.
  16. PShannon

    MySQL recursion

    I have two tables to manage the hierarchical structure of a corporation (does BOM as well). tblOrganization id formal_name short_name etc . . . tblStructure parent_id (tblOrganization.id) child_id (tblOrganization.id relationship Done this a ton in SQL Server and Oracle (even MS Access) by using: tblOrganization ---> tblStructure <--- tblOrganization_1 I can find no equivalency in MySQL???? What does the MySQL SQL SELECT look like to retrieve that corporate structure? Thank you . . .
  17. It's working! I'm good and I am grateful for your help. "A good plan today is better than a perfect plan tomorrow." ~ George Washington
  18. That solution is as fine as wine! You guys are the best and I am very grateful. Do you guys have a tip jar or PayPal account?
  19. Yes. I've been developing in HTML for 20 years, built a dozen sites in HTML, PHP and JAVA, but I've never displayed an URL retrieved from a MYSQL table in an HTML table, and have been unable to find a working solution on the Net -- and I've been looking for a week.. In your example. you know what the URL is. That's ice cream. <td text-align:="" center;="" width:="" 50%;="">https://www.website.com/goodmorning.php</td> In my case, I have no idea what the URL is. It's coming from the database. It now displays in the table as text. My problem is how do I tell the HTML in
  20. Thank you for responding. I appreciate it. Would you kindly show me where the anchor (<a>) is placed, Funce? Placement is everything. while($row = $result->fetch_assoc()) { $the_url = $row["the_url"]; echo "<tr width:100%> <td text-align: left; width: 50%;>" . $row["some_text"] . "</td> <td text-align: center; width: 50%;>" . $row["the_url"] . "</td> </tr>"; } echo "</table>"; } else { echo "0 results"; } echo "The URL--> " . $the_url; You guys h
  21. I am displaying data from a MySQL table in an HTML table. I have one field that I would like to display as an hyperlink (hot link). I have been all over the web for three days looking for a solution to do this. I have placed all of the problem elements on a webpage: 1. MySQL table specs 2. PHP display MySQL table data in HTML table 3. HTML table as seen in website http://www.database39.com/testtableurl.php Thank you for your help . . .
  • Create New...