Tag Archives: SQL

XML Public Data Genericization Where Clause Tutorial

Posted on December 24, 2023 by admin

If you’re like me, regarding online data, you work it in your mind to work in with SQL statements, in a relational database sense. In that sense, the first two of the three ways (while the third reminding us more … Continue reading →

Posted in eLearning, Event-Driven Programming, Tutorials | Tagged annotated timeline chart, annotation, calendar, calendar chaer, calendar widget, chart, clause, data, date, date picker, DDL, Google chart, HTML, HTML5, input, interface, interfacing, Javascript, order by, PHP, picker, programming, relational database, sort, sorting, SQL, timeline, timeline chart, tutorial, where, where clause, widget, YUI | Leave a comment

WordPress Blog Post Frontend Error Tutorial

Posted on February 24, 2023 by admin

Running a WordPress.org (self hosted, versus a WordPress.com WordPress hosted) blog you are reading, a few times over several years have seen us stuck with the WordPress TwentyTen theme “Add Post” frontend webpage, to create a blog posting, “shooting ourselves … Continue reading →

Posted in Database, eLearning, Tutorials | Tagged backend, blog, browse, cPanel, database, frontend, MySql, PHP, phpMyAdmin, printf, SQL, textarea, tutorial, TwentyTen, update, Wordpress, wordpress.com, wordpress.org | Leave a comment

PHP MySql Select Query UTF-8 Return Values Tutorial

Posted on February 20, 2023 by admin

Yes, ever since embracing emojis, we’re on the lookout for gobbledegook. And yes, a lot of the strategies we found on the “stumbled upon” Reading UTF-8 Content from MySql Table we were familiar with, but one we weren’t, which was … Continue reading →

Posted in Database, eLearning, Tutorials | Tagged database, dropdown, emoji, gobbledegook, landing page, MySql, PHP, programming, query, select, SQL, tutorial, utf-8 | Leave a comment

CentOS Web Server cPanel Apache Status Tutorial

Posted on November 5, 2022 by admin

Our RJM Programming Linux CentOS Web Server cPanel Apache web server’s suite of software has a very useful report called Apache Status. We use it a bit like another Linux user without this report might use … ps -ef … … Continue reading →

Posted in Database, eLearning, Operating System, Tutorials | Tagged add post, address bar, Adobe, Apache, apache status, backend, blog, blog post, blog posting, browse, buffer, category, CentOS, codex, connection, copy, cPanel, curl, custom fields, database, dropdown, emoji, error, file_get_contents, frontend, hanging, HTML, html validator, issue, lightbulb, link, Linux, local web server, macOS, MAMP, MySql, operating system, paste, PHP, phpMyAdmin, post, problem, process, programming, ps, report, select, single.php, SQL, status, symptom, tag, textarea, top, troubleshoot, troubleshooting, tutorial, TwentyTen, TwentyTen theme, url, validator, web browser, web server, webpage, Wordpress | Leave a comment

Date Range Reporting Primer Tutorial

Posted on October 17, 2022 by admin

Are you always satisfied with Search and/or Advanced Search functionality on websites? We’d say “sometimes”, but understand that some of the access to “Advanced Search” is debatable for webmasters given it can lead to database searches of some complexity, that … Continue reading →

Posted in eLearning, Tutorials | Tagged advanced search, date, date range, file_get_contents, NSW, NSW Government, PHP, programming, range, report, search, SQL, tutorial, url | Leave a comment

MySql Repair Table Diskspace Error Log Consequence Tutorial

Posted on October 7, 2022 by admin

If you are managing a web server, you can run into times when … a total solution to a problem needs more research that will take time … but, perhaps … there is a solution that “eases the pain” of … Continue reading →

Posted in Database, eLearning, Event-Driven Programming, Operating System, Tutorials | Tagged Access, Apache, command, command line, copy, crontab, database, diskspace, error log, find, Linux, log, log file, MySql, operating system, rename, repair, rotation, SQL, ssh, table, tutorial, web server | Leave a comment

MySql Repair Table Failure Diskspace Consequence Tutorial

Posted on September 21, 2022 by admin

The previous MySql Repair Table Primer Tutorial outlined some phpMyAdmin administering of MySql (database) maintenance via SQL like … REPAIR TABLE wps_comments; … but what about if the SQL above fails or times out? Well, there can be implications, as … Continue reading →

Posted in Database, eLearning, Operating System, Tutorials | Tagged Apache, CentOS, command, command line, database, diskspace, error, Linux, MySql, phpMyAdmin, programming, REPAIR TABLE, SQL, ssh, table, timeout, tutorial, web server | Leave a comment

Just Javascript Card Game Cursor Tutorial

Posted on June 1, 2021 by admin

Today we grew the complexity of the logic for non-mobile cursor users of our 500 or bridge card game web application, after yesterday’s Just Javascript Card Game Mid-UX Tutorial. The logic took a while and the presentation took a while … Continue reading →

Posted in Ajax, eLearning, Event-Driven Programming, Games, Tutorials | Tagged alert, arabic, arguments, array, audio, background, background image, background-position, background-repeat, background-size, bid, bidding, body, bookmarklet, bridge, button, card game, cards, cell, click, codepoint, collaboration, colour, colour coding, comma, command line, comment, console.log, content, content management, copy, createElement, CSS, CSS3, cursor, data uri, database, DDL, deal, defence, delay, delimit, delimiter, design, document.createElement, document.querySelectorAll, document.URL, double click, drag, drag and drop, dropdwon, email, emailee, emoji, entity, error, event, exec, fallback, filter, focus, font, form, FormData, game, games, global, global variable, Google, Google Translate, head, hebrew, hover, HTML, html entity, internationalization, ISO, iso 639, ISO 639-1, iso 639-2, iso 639-3, Javascript, joker, JSON, JSON.parse, json_decode, keyframes, kitty, label, language, language code, list, localStorage, logic, macOS, Mail, mailto, MAMP, Mapping, mclick, Memories, MyMemory, name, names, naming, navigation, onions, order, paste, PHP, player, popup, preventDefault, programming, progress, progress bar, prompt, quiz, render, rendering, right to left, row, say, score, scoring, screenLeft, screenTop, select, selector, sessionStorage, setTimeout, share, sharing, SMS, sort, SQL, String.fromCodePoint, style, styling, subject, submit, suit, SVG, table, tabular, tbody, text to audio, Text to Speech, thead, timing, token, touch, translation, trick, tutorial, user experience, UX, validate, variable, web browser, web inspector, webpage, window.opener | Leave a comment

Your Numbers Game
Get clue	Your answer	Your Score
Clue?		Score 0/0

Search for:
Recent Posts
Categories
- Ajax
- Android
- Animation
- Anything You Like
- Code::Blocks
- Coding
- Colour Matching
- Data Integration
- Database
- Delphi
- Eclipse
- eLearning
- ESL
- Event-Driven Programming
- Games
- GIMP
- GUI
- Hardware
- Installers
- iOS
- Land Surveying
- Moodle
- Music Poll
- NetBeans
- Networking
- News
- Not Categorised
- OOP
- Operating System
- Photography
- Projects
- Signage Poll
- Software
- SpectroPhotometer
- Tiki Wiki
- Trips
- Tutorials
- Uncategorized
- Visual Studio
- Xcode
June 2026

S M T W T F S

1 2 3 4 5 6

7 8 9 10 11 12 13

14 15 16 17 18 19 20

21 22 23 24 25 26 27

28 29 30

« May
Meta
Tags
Ajax animation background button canvas command line CSS Did you know DOM dropdown email emoji event form game games Google Google chart hashtag HTML IFRAME image iOS Javascript MAMP media mobile navigation onclick overlay PHP popup programming select share sharing SMS SVG table text textarea tutorial url video web browser
Your Background Image
OnTopList

Tag Archives: SQL

XML Public Data Genericization Where Clause Tutorial

WordPress Blog Post Frontend Error Tutorial

Date Range Reporting Primer Tutorial

MySql Repair Table Diskspace Error Log Consequence Tutorial

MySql Repair Table Failure Diskspace Consequence Tutorial

Numbers Guessing Game

Your Numbers Game

Recent Posts

Categories

Meta

Your Background Image

OnTopList

Recent Comments

Tag Archives: SQL

Numbers Guessing Game

Your Numbers Game

Recent Posts

Categories

Meta

Tags

Your Background Image

OnTopList