Difference between revisions of "Tutorial: PhpRunner 9.8 and Photo Display"
(→Create Photo Project) |
|||
| Line 253: | Line 253: | ||
::* Master - Details relationship | ::* Master - Details relationship | ||
:::* [Master] Reproduced:originalId <===> [Details] Originals:Id | :::* [Master] Reproduced:originalId <===> [Details] Originals:Id | ||
| + | ::* SQL Query | ||
| + | :::* Add CONCAT fields to queries for original and reproduced: | ||
| + | :::<source lang="mysql"> | ||
| + | CONCAT( `widthP`, ' x ', `heightP` ) as wxh_p, | ||
| + | CONCAT( `widthIn`, ' x ', `heightP` ) as wxh_In, | ||
| + | CONCAT( `width`, 'x', `height` ) as wxh, | ||
| + | </source> | ||
<br /> | <br /> | ||
<br /> | <br /> | ||
Revision as of 15:36, 1 June 2018
D. Thiebaut (talk) 10:38, 25 May 2018 (EDT)
Create Photo Project
- Windows 7
- PhpRunner 9.8
- Blank Project
- MySQL 192.168.1.139 (whatever ifconfig returns on Mac)
- Tables
- originals
- reproduced
- Master - Details relationship
- [Master] Reproduced:originalId <===> [Details] Originals:Id
- SQL Query
- Add CONCAT fields to queries for original and reproduced:
CONCAT( `widthP`, ' x ', `heightP` ) as wxh_p, CONCAT( `widthIn`, ' x ', `heightP` ) as wxh_In, CONCAT( `width`, 'x', `height` ) as wxh,
