select Examples and Free Source Code

How to fetch multiple values from a database using multiple ids with CodeIgniter...

php codeigniter select codeigniter-3 query-builder

HTML Select tag show vertical scroll with 10 option...

html jquery css select vertical-scrolling

Passing multiple values from HTML form select box with PHP to SQL statement...

php html select

How to prevent unwanted backticks in a SELECT clause with CodeIgniter's query builder methods...

php codeigniter select query-builder quoting

How to use FIND_IN_SET() on column values separated by semicolons...

mysql sql select inner-join find-in-set

codeigniter differentiate field names in JOINed tables...

php codeigniter select query-builder name-collision

Displaying Data from a Join in Codeigniter 2.2.1...

php codeigniter select query-builder codeigniter-2

Codeigniter database query bug - does not return expected results...

php codeigniter select prepared-statement sql-injection

SELECT MySQL rows where today's date is between two DATE columns...

mysql select

Why doesn't CodeIgniter's order_by() affect query()?...

php codeigniter select sql-order-by query-builder

How to access two databases in a single SELECT query with CodeIgniter's query builder...

php codeigniter select query-builder multiple-databases

How to add an ORDER BY clause using CodeIgniter's query builder...

php codeigniter select sql-order-by query-builder

Complex MySQL SORT based on time...

mysql sorting select

Selective query...

mysql select

I want to modify this SQL statement to return only distinct rows of a column...

sql mysql select distinct

MySQL SELECT query WHERE timestamp falls on the current date...

mysql date select timestamp where-clause

SELECT rows for user where column value is in the future with CodeIgniter...

php datetime codeigniter select quoting

Is there an equivalent to SELECT t1.* when there is a USING() clause?...

sql oracle-database join select

Why does my single-table SELECT query using CodeIgniter's query builder have an error before the...

php mysql codeigniter select query-builder

Codeigniter: Select from multiple tables...

php codeigniter join select query-builder

Query to show records with 3 date criterias...

mysql date select

Why does my CodeIgniter model method return no results?...

php mysql codeigniter select query-builder

Why does my Left Join subquery only work with * instead of specifying the fields I need?...

sql mysql select subquery left-join

How to count the number of rows with a date from a certain year in CodeIgniter?...

php date codeigniter select counting

How to execute a SELECT SUM() query using CodeIgniter's query builder methods...

php codeigniter select sum query-builder

How to get only the number from a string in MySQL?...

mysql sql string select numbers

Query fails when Distinct is used...

php mysql sql select distinct

Writing a SUBSTRING() call in CodeIgniter's select() method renders SQL with corrupted quotes...

php codeigniter select query-builder quoting

MySQL SELECT only not null values...

mysql sql select notnull

SELECT rows from one table where the same pair of columns are not found in another table using CodeI...

php mysql codeigniter select not-exists