I'm trying to implement some PHP code you shared to calculate someone's age from their date of birth.  Below is the code;

$bday = new DateTime($text); $today = new DateTime(); $diff = $today->diff($bday); return $diff->y;

I have a field for the date of birth {jr_dateofbirth}.  Do I need to create a banner field like {jr_age} to display the results?

How do I format the code to make it work for the fields I am using?

I hope I made sense in what I'm trying to acheive.

Thanks

Law

<?php if (empty($listing['Listing']['text']): echo "No summary has been added just yet"; else: ?>
 // Continue

Except it doesn't. What am I doing wrong? 

maybe you know, that I am using Amazon Product Advertising API in Banner fields to show price, title and other product details regarding to the ASIN number of a book (different field). This works great.

Code which I am using to get the author of a book (In Banner field / PHP Based Formatting):

require_once PATH_ROOT."amazon.php";
$asin = $CustomFields->fieldValue('jr_amazonasinoderisbn10',$entry);
// Region code and Product ASIN
$response = getAmazonPrice("de", $asin);

if ($response) {
 
return  $response['author'];

}


return false;

I was thinking about, if it would be possible to make these banner  fields searchable like a text field? In this way we don't have to fill out every detail about a book for a book review.

Example:

For my listings "Book reviews" I have to fill out: ASIN Number, author, title of the book, and so on..

But with the ASIN Number and the Product Advertising API I could get all the other details automatically. So the fields author, title, price could be filled out automatically.

Is this possible?

Best regards,

Daniel

just a quick one, i am getting a syntax error on the following where.. (its a guess).

I have a custom field that lists all accessibility tags of a list and all i want to do is create a button of 'similar listings' based on geolocation to current listing and also to its already selected accessibility tags.

Ideally the tags would come from the user selected tags rather than the listed tags (user may select 1 tag however list may have 5 so i would prefer to use the 1 tag).

Am i right in thinking the where is simply  Field.jr_accessibility = {user_jr_accessibility}    

Error message is ----- but works when i remove the WHERE clause

1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} ) ) ORDER BY Totals.user_rating DESC, Totals.listing_id DESC LIMIT 10' at line 79

The page you are looking for does not exist or an other error occurred.

Intro: I have custom lists for many tag urls, e.g. /year/2019 for Click2Search's /alias/tag/year/2019. 

Task: change displayed Click2Search urls for shorter custom list ones.

Done: for single select fileds (PHP Based Formatting):

$url .='<a href="/year/'.$value.'">'.$value.'</a>';
return $url;

Problem: multiple select fields. The code above is not working because of an array instead of a string.

Help: Can you please hint me how to modify an array output for Click2Search urls the same way as with a string output?

$price = $CustomFields->fieldValue('jr_price',$entry);
$volume = $CustomFields->fieldValue('jr_volume',$entry);
$total = $price * $volume;
return $total;

How can I put in the currency format like this:

1200,- €

instead of

1200

And additional:

How can I devide? In this way?

$total = $price / $volume;