Judul

No changes

Permalink

No changes

Konten

Old		New
19	### Database Query	19	### Database Query
20		20
21	```php	21	```php
22	$query = database::query(	22	$category = database::query(
23	"select c.id, ci.name from ". DB_TABLE_PREFIX ."categories c	23	"select c.id, ci.name from ". DB_TABLE_PREFIX ."categories c
24	left join ". DB_TABLE_PREFIX ."categories_info ci on (ci.category_id = c.id and ci.language_code = 'en')	24	left join ". DB_TABLE_PREFIX ."categories_info ci on (ci.category_id = c.id and ci.language_code = 'en')
25	where c.id = ". (int)$category_id ."	25	where c.id = ". (int)$category_id ."
26	limit 1;"	26	limit 1;"
27	);	27	)->fetch();
28
29	$category = database::fetch($query);
30	```	28	```

Edited by tim on 7 Apr 2025 at 15:59