I want to use an if statement that when it matches a string in the database, it prints out a message. But, in the database, if there is more than one count of the string then it prints it out multiple times. Does anyone know how to make sure it only prints once? Many thanks. My code is:
if ($value == 'America')
{
echo "Welcome";
}
Based on the information you have given one solution would be:
welcome_displayed = false;
if (welcome_displayed and $value == 'America')
{
echo "Welcome";
welcome_displayed = true;
}
I assume you're in a loop. If so, I would use the break construct:
<?php
$array = array('red', 'blue', 'yellow');
foreach ($array as $color) {
if ($color == 'blue') {
print "We found a match.";
break;
}
}
If you're simply trying to write a query that only gets 1 match, use the DISTINCT keyword or LIMIT the number of results, or something like that. If you update your question I can update my answer accordingly.
You can also combine any matches into an array and then use 'array_unique' to only get the distinct items.
// DEFAULTS
$matched_items = array();
$values = array('Denver', 'ABQ', '1234', 'asdfa', 'America', 'osproqr', 'America', 'iowrenvoiw', 'America');
// LOOP THROUGH EACH VALUE AND COMPARE IT AGAINST THE NEEDLE
foreach ($values AS $value) {
if ($value == 'America') {
$matched_items[] = $value;
}
}
// PRINT OUT ONLY THE UNIQUE ITEMS
print_r(array_unique($matched_items));
Use SELECT DISTINCT on the columns you want to select.
sql="SELECT DISTINCT /*table column*/ FROM /*TABLE NAME*/ WHERE /*column name*/ = America "
This will select only one row WHERE a column = America.
break;be suffice?