This is the code i have implemented. Of course it is wrong because it is a multivalue field... 

I have two tables: cms_player and cms_matches

in cms_matches i have a multivalue  field  called players 

Now i want in my website i would create a list o player and count the number of matches played for each player. 

PLAYERS | MATCHES PLAYED 

Any suggestions about that?

Orazio

<?php $matchesPlayed = mysql_count("matches", "players LIKE '%\t".$playersRecord['num']."\t%'") ;?><?php echo $matches_played;?>

<?php $matchesPlayed = mysql_count("matches", "players_matches = " . intval($playersRecord['num']) ) ;?><?php echo $matchesPlayed;?>

I have two tables cms_players and cms_matches

in cms_matches i have a pillbox list field ‘yellow_card’ in which i select players that receive yellow card for each match (SELECT num, CONCAT(surname," ",name) FROM `<?php echo $TABLE_PREFIX ?>players` ORDER BY surname ASC) 

Now, i have a page for each player and i would "count” number of yellow cards received from this player.

Could you help me?

i think that m problem is the same discussed here https://www.interactivetools.com/forum/forum-posts.php?Local-time-vs-Mysql-time-causing-publishDate-issue-82356

There is a different between local zone time and mysql time

I've upgraded to 3.54 version but i have a strange problem. 

I can see on my website the old articles but if i create a new article i see only on backend... and not on website!

Could someone help me?

Orazio

I have two sections combined in one main page with this code... but i would put them in a date order... and i don't know how. Any suggestion?

// load records
list($approfondimentiRecords, $approfondimentiMetaData) = getRecords(array(
'tableName' => 'approfondimenti',
'perPage' => '15',
'leftJoin' => array(
// foreign table => local field (that matches num in foreign table)
'autori' => 'autori',
),
));

list($attualitaRecords, $attualitaMetaData) = getRecords(array(
'tableName' => 'attualita',
'limit' => '5',
'leftJoin' => array(
// foreign table => local field (that matches num in foreign table)
'autori' => 'autori',
),
));

$allRecords = array_merge(
$attualitaRecords,
$approfondimentiRecords

);

?>

when i try to access to cmsAdmin i receive this error:

Notice: MySQL Error: Got error 28 from storage engine - in schema_functions.php on line 37 by getMySqlColsAndType() in /home/calciocatania/cmsAdmin/lib/common.php on line 278

????

I have a url like this http://www.blabla/list.php?city=taormina 

I would have something like "There are 13 results in TAORMINA" recalling the field city (Taormina in this case) from url. Is it possible?

Orazio

Https://www.*******.com/comprasiciliano/prodotto.php?2

or 

Https://www.*******.com/comprasiciliano/prodotto.php?Salsa-di-pomodoro-ciliegino-6

I have this code  but every page give me always the last item ... 

// load record from 'locali'
list($prodottiRecords, $prodottiMetaData) = getRecords(array(
'tableName' => 'prodotti',
'where' =>getNumberFromEndOfUrl(), 
'loadUploads' => true,
'leftJoin' => array( 
// foreign table => local field (that matches num in foreign table) 
'azienda' => 'azienda', 
),
));
$prodottiRecord = @$prodottiRecords[0]; // get first record

I have this code 

list($reviewRecords, $reviewMetaData) = getRecords(array(
'tableName' => 'review',
'where' => 'restaurant = ' . getNumberFromEndOfUrl(),
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$reviewRecord = @$reviewRecords[0]; // get first record

So i would like to have "no records found" 'where' => 'restaurant = ' . getNumberFromEndOfUrl(), 

Any suggestions about this?

Thank you in advance for your help

Orazio 

Does it need some change on code?

Thank you in advance

Orazio 

Is it the same if i use this code?

// load record from 'restaurants'
  list($restaurantsRecords, $restaurantsMetaData) = getRecords(array(
    'tableName'   => 'restaurants',
    'where'       => whereRecordNumberInUrl(0),
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $localiRecord = @$restaurantsRecords[0]; // get first record


 list($reviewRecords, $reviewMetaData) = getRecords(array(
    'tableName'   => 'review',
	'where' => 'restaurant = ' . getNumberFromEndOfUrl(), 
	  'loadUploads' => false,
    'allowSearch' => false,
	 'limit'       => '1',
  ));
  $reviewRecord = @$reviewRecords[0]; // get first record

REstaurants.num = Review.restaurant

Of course i have many restaurant, and non for only restaurants there is a review.

I would have a Restaurant page, and, in this page i would show a vote for service from review table. 

I know that i need a leftjoin (i suppose) but i'm a little confused

Thank you in advance for some help :-)