Questions tagged as "sql"
Best approach for working with joins and echoing out information
Hi,
I’m new here so apologies if this question’s answer is simple. If I have a list of questions in a questions table and each row of data has aREAD MORE
By Yiibie in Active Record · Asked 110 days 23 hours 24 mins ago
Questions: 1 Accepted: 0 ( 0% ) | Reputation: 0
Many-Many CRUD Generation
I’m really struggling trying to find a tool that does CRUD generation on my database that has some many-many relationships.
For example, I have a table A which has a many-manyREAD MORE
By sarink in Active Record · Asked 518 days 3 hours 13 mins ago
Questions: 1 Accepted: 0 ( 0% ) | Reputation: 0
Complex SQL
What is a good way to incorporate the following complex SQL into a Yii application?
- select * from (
- SELECT * FROM (
- SELECT * FROM tbl_extradata ORDER BY field1 DESC) AS s
- GROUPREAD MORE
By mminnie in Active Record · Asked 524 days 7 hours 8 mins ago
Questions: 1 Accepted: 0 ( 0% ) | Reputation: 0
CActiveDataProvider SELECT only some fields
cactivedataprovidercactiverecordjoinsql
How to make CActiveDataProvider to SELECT only some fields from the query. For example :
- new CActiveDataProvider($model, array(
- 'criteria'=>array(
- 'select'=>array(
- 't.field1',
- 't.field2',
By phreak in Active Record · Asked 596 days 10 hours 54 mins ago
Questions: 1 Accepted: 0 ( 0% ) | Reputation: 0
