DevelopPHP
home gear home donate
Search Results For
in:

Libraries book

HTML Library CSS Library JavaScript Library PHP Library

Videosbook

PHP and MySQL JavaScript HTML and CSS Vector and 3D Flash Actionscript Android Dev Miscellaneous

Resourcesbook

Website Hosting Developer Q+A
Sprite Programming Mastery
Show Alternate Field if Target Field is Empty
There may be times when you have empty values in some fields. If that is the case you can run conditional if and else statements on the returned data to see if there are empty values, matches, or whatever the logic needs to be. In this example we are going to display alternate data from another field if the target field has an empty value.

In the example below we have a member table that holds member information. If the website field is empty for that member, I am going to display their name field's data instead. Both fields used must be defined in the SQL command to return in the while loop.

Show alternate field if a field's value is empty:
Learn HTML
<?php 
// connect to your MySQL database here
require_once "connect_to_mysql.php";
// Build sql command
$sqlCommand "SELECT id, username, website FROM members";
// Execute the query here now 
$query mysql_query($sqlCommand) or die (mysql_error()); 
// Output the data using a while loop
$siteDisplay "";
while (
$row mysql_fetch_array($query)) {
    
// Gather all $row values into local variables
    
$uid $row["id"]; 
    
$username $row["username"]; 
    
$website $row["website"]; 
    
// Run conditional to see if the desired field is empty
    // If it is we display alternate content from another field in their row
    
if (!$website) {
        
$siteDisplay "$username";
    } else {
        
$siteDisplay "$website";
    }
    
    
// echo the output to browser
    
echo "User ID: $uid &bull; $siteDisplay<hr />";
}
// Free the results 
mysql_free_result($query);  
// close mysql connection 
mysql_close(); 
?>

Develop PHP browser display window
User ID: 1 • www.flashbuilding.com
User ID: 2 • www.joecool.com
User ID: 3 • Sally
User ID: 4 • www.williamawesome.com
User ID: 6 • www.webintersect.com
User ID: 5 • Tara
User ID: 7 • www.weheardyoufart.com
User ID: 8 • Adam



Home   •   Terms of Use   •   T-Shirts   •   RSS   •   Testimonials   •   Subscribe   •   Classroom Chalkboard   •   Developer Q+A   •   Donate   •   Top ↑
Popular In PHP / MySQL E-Commerce Store Production
Social Network Website Building
Image Upload / Photo Processing
CMS Software Programming
Mass Email Systems
Magic XML Data
Search Programming
Popular In JavaScript JSON Programming
Ajax Programming
Animating Elements
WYSIWYG Programming
Date/Time Programming
DOM Scripting
Object Reference
Popular In HTML Canvas Element
New Form Elements
Audio Element
Video Element
Drag and Drop
Event Handling
Element Grouping
Popular In CSS Custom Font Embedding
Dynamic Fit Backgrounds
Theatre Mode
Box Overlays
CSS Level 1 Properties
CSS Level 2 Properties
CSS Level 3 Properties
DevelopPHP.com is a growing educational system packed with video and written material that you can access 24/7 100% free. The focus here in 2014 is spread between five technologies: HTML, CSS, JavaScript, PHP and MySQL. Learn programming theory, database interaction, web design, animation, graphics editing, vector art, 3D modeling, and much more. The educational experience here is a hybrid one offering both high quality video tutorials and code libraries that grow more robust every day. The code libraries are being assembled so that developers can discover all of the building blocks of their favorite languages. The libraries coupled with high quality video tutorials will take you deep down the rabbit hole very quickly. You can also ask questions and get free advice at WebIntersect.com.
HTML5