Search the Community
Showing results for tags 'fields'.
-
I created a recipe site that displays various dishes, and I'm tickled pink that I got it to work (first time doing this!) But I'd like to have pages that displays dishes by its category. The column that houses this is called "category" which has 7 total: Appetizers & Beverages, Soups & Salads, Side Items, Main Dishes, Baked Goods, Desserts, and Cookies & Candy. I have this page connected to a "connection.php" page, but here's the code in question: <!-- Page Title--> <div class="row"> <div class="col-lg-12"> <h1 class="page-header">Appetizers & Beverages</h1> </div> </div> <!-- /Page Title --> <!-- Displayed Data--> <?php $sql = "SELECT id, category, bilde, title FROM oppskrift_table ORDER BY title "; $result = mysqli_query($con, $sql); if(mysqli_num_rows($result) > 0 ){ while($row = mysqli_fetch_assoc($result)){ ?> <div align="center" class="col-md-3"> <a href="#"> <img class="img-responsive img-cat" src="bilder/rBilder/<?=$row['bilde']?>" width="250" alt=""> </a> <h4 style="max-width:250px;"> <a href="#" class="dishes"> <?=$row['title']?> </a> </h4> </div> <?php } } ?> <!-- END Displayed Data--> </div> How can I tweak this so that only the category Appetizers & Beverages shows up on the page?
-
Been trying to figure out...how can I delete the first input field box in a series? Under Presentations Requested, I want the delete the first short box. http://myiwma.org/wordpress1/reservation-form/ Lauren
-
Hello. I want to show in my website all entries from a table, but I only want to show some values in one of the DB columns: Copyright Imagem: <?php echo $row["copyright"]; ?></p> Whati I want is to show all entries for $row["copyright"], except the ones in what the value is "null". The remaining columns, I want to show all of them.
-
I am in need of assistance. I'm learning and advancing in php, although I've come across a problem. I'm working on a project and I want to to show the time of something and then another part to show just the date. In my database I have a field called date_played and it has a format like this: 2012-11-23 23:27:06 What I want to do is have php look for the 2012-11-23 for the date and then 23:27:06 for the time and then go even further with the date feature have it echo the time like 11:27 PM ( I think I know that part). Can you please help? Your help would be greatly appreciated!