select child.cat_name, child.cat_desc, parent.cat_name from mytable child, mytable parent where child.pk_cat_id = parent.fk_cat_id
Thanks to all
Solved my problem :)
I've developed an app that takes the data in a text file and moves it to specific columns in an Excel file. My computer has the Excel 2010 installed. So the application works fine with no issues. However we've begun to upgrade computers and software in the office ...
This is just a reminder. When setting environment variables through .htaccess, CLI or dotenv use
filter_var() to evaluate a boolean. For example, start the built-in PHP server with these variables:
DEBUG=FALSE LOG=TRUE SMS=1 SMTP=0 CONNECT=yes BACKUP=no php -d variables_order=EGPCS -S localhost:8000
And then test through
boolval(): if you ...
This class is intended as a small and simple alternative to java.util.Scanner for people in the early stages of learning Java. Unlike Scanner it has built-in error handling and retry, it throws no checked exceptions, is as tolerant as possible of variations in the format of user input, and avoids ...