s6xbucks Posted March 31, 2012 Share Posted March 31, 2012 Hello. I run a website that tracks sports in my local high school league. I have used Excel in the past, which works but is a lot of work. So, I am learning quite a bit about PHP and MySQL as I am converting over to a database format for my schedules. I have it working pretty well, but I would like to do something that I am not sure is possible. By the way, I am working within Dreamweaver CS5. So, I have WAMP set up and created my DB with phpMyAdmin, connected to it from within DW, made a recordset, and created a repeating table that shows all of the games. Great. What I want to do is put a blank row between all games played on different dates. For example, there are 5 games on April 7, followed by 4 on April 9, and then 3 on April 11. Is there an easy way to put an empty row between the last game on 4/7 and the first on 4/9, and the last on 4/9 and the first on 4/11? I am not much of a coder, but I have been known to piece things together. If something like this is too difficult I can live without it, but it would be nice to have. Thanks for any help! Quote Link to comment Share on other sites More sharing options...
fenway Posted March 31, 2012 Share Posted March 31, 2012 What's a repeating table? Blank row where? MySQL has no "blank" rows. Quote Link to comment Share on other sites More sharing options...
s6xbucks Posted March 31, 2012 Author Share Posted March 31, 2012 In DW, I set up a 2 row table with a column for each piece of information for each record in my DB: date, time, visiting team, visiting score, home team, home score, comment. The top row is my header, the second row holds the data pulled from the db. I then made the second row a Repeat Region, so it will add a row to the table for each record in the db. What this does is list all 59 games (there will be more added but that is where I am at now) in 59 consecutive rows, as expected. What I would like to have is a blank (empty? devoid of data?) row inserted between any two games that occur on different dates, in order to each date off from the other. So, five games all played on the same date will be listed consecutively in a group, then there would be a blank row before any games played on the next date. I guess I am hoping there is a relatively easy way for the software to add an empty row between games each time it discovers a new date. Quote Link to comment Share on other sites More sharing options...
fenway Posted April 1, 2012 Share Posted April 1, 2012 That's a PHP issue -- you can decide how to format your output as you see fit. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.