Adevy

Thank you for your answer.
I’m sure that $post_id is available because it’s not use one time.

This is the function :

function send_mail_publication($post_id) {
	$options = get_post_meta($post_id, '_ait-dir-item', true);
	$emailemis = $options[emailemission];

	if ( $emailemis == 1) {
		return;
	}
	else {

		if ( empty($options[email]) OR empty( $options[gpsLatitude] ) OR  empty( $options[gpsLongitude]) ) {
			return;
		}

		$name = get_the_title($post_id);
		$email = $options[email];
		$profession = $options[prof];
		$lien_url = get_permalink($post_id);

		$message = "Dear" . $name . "...";

	$check_mail = wp_mail( "gab.davy@gmail.com", $message);
			if(1) {
				$val = get_post_meta($post_id, '_ait-dir-item', true);
				$val[emailemission] = '1';
				$updat = update_post_meta($post_id, '_ait-dir-item', $val);

				wp_mail( "test@gmail.com", "emailemission okk");
			}

	}
}

add_action('publish_ait-dir-item', 'send_mail_publication');

Thank you

Thank you very much for your answer.

I understand what you say but I don’t understand how i Can, fisrtly, display a table in order to show results of the database ?

Even if visitors can’t touch the sql database, how can them see it ?

Thank you. Actually my aim is very simple.

I want to list a lot of book.
Every book must have a title, a description, a category (tragedy, comedy,…). And I want that people can mark a book with several mark.
In a page of my website I will show a ranking for the best book.

To do this, I have created a custom post type called BOOK, with a TITLE and an EXCERPT. With a plugin, I have added some custom fields, category, average mark, and several marks.

Now, can I change the value of this mark directly with the answers of internet users ?

It’s my first site with wordpress and I think my problem is that I reflect with database because with a table in PHPMyAdmin it’s simple but I want to do this with wordpress.

Thank you very very much.

But i dont understand how to use the data in new tables in my website.

I want use the datas in the new table.