Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 5 years ago. Improve this question Let's say that I have a database with this data stored: How can I select all of this value with a PDO query excluding those

Select from database only values not seen before [closed]

Let’s say that I have a database with this data stored:

Email-Link-Link2
1E@231-Example1-Example2
1E@231-Example3-Example4

JavaScript
​x
 
Email-Link-Link21E@231-Example1-Example21E@231-Example3-Example4​

How can I select all of this value with a PDO query excluding those seen before, so in this case 1E@231,will select only one time.

Answer

If understand what you said, this is your answer:
Connexion to data base with PDO

<?php 
//CONNEXION TO DATA BASE WITH PDO...
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$base = new PDO('mysql:host=localhost;dbname=your_data_base', 'the_user', 'Your_password', $pdo_options);
//end of connexion to data_base
;?>

JavaScript
 
<?php //CONNEXION TO DATA BASE WITH PDO...$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;$base = new PDO('mysql:host=localhost;dbname=your_data_base', 'the_user', 'Your_password', $pdo_options);//end of connexion to data_base;?>​

NOW getting data from data base with not duplication(you can use sql function DISTINCT

<?php
$sc=$base->query("SELECT DISTINCT Email FROM table_where_data_stored");
while($data_distinct =$sc->fetch()){
//your data will be displayed here

;}
;?>

JavaScript
 
<?php$sc=$base->query("SELECT DISTINCT Email FROM table_where_data_stored");while($data_distinct =$sc->fetch()){//your data will be displayed here​;};?>​

May this help you!!

Advertisement

Answer