ninedoors

Try something like this: SELECT bets.name, Register.SNAME FROM Register LEFT JOIN bets ON bets.name = Register.SNAME WHERE bets.name IS NULL You will need a timestamp column in your bets table if you want to restrict it to a time frame.

Make sure that $csv is an array. One way you can check it is: $test = is_array($csv) ? 'yes' : 'no'; echo $test; or you can print_r($csv);

Hey Lake, So I used the code you posted and just cleaned it up a bit and added the part to get your win/loss dynamically. Make you add the style I put at the top of each script in your style you include in each page. Just saves you adding it to each td tag. These "should" get you at least your win/loss column working. The rest on the stuff you mentioned will be a lot more work and will take quite awhile to get it implemented but is definitely attainable. I have all these type stats setup on my mens hockey league website. It is still a work in progress and I have been at it for 5 years now!!! Here's my site. The main thing you should do is sit down and decide exactly what stats you want and might want to capture from your baseball games, now and for future. Even if you are entering something in the database now and aren't using it, it's good to have it there if you eventually decide you would like to track it. I will help you out if you want as I am actually about to start a baseball website for my men's league so it would be good to get the train moving. Nick [attachment deleted by admin]

Do you have your error reporting turned on?

Can you tell us where the image folder is? You have not closed your li tag replace the <br /> with </li>. Why in your img src do you start with "./", it seems odd to me cause I have never seen that before.

I have put everything inside the one loop so there is no reason to collect them in the $file variable. You are also gettign the wrong image reference. Your code will give you <img src="./aircraft/aircraft/'$_GET['reg'].$i.'.jpg.jpg" /> Plus you don't close your li tag, you have a br tag instead.

Look at my above post.

First off you are making $file a variable when I think you want to make it an array. You would need something like: while($i=0 $i < 9 $i++) $file[] = "aircraft/".$_GET['reg'].$i.".jpg"; Then you have a foreach loop. Why not do this inside the while loop? Like this maybe: while($i=0 $i < 9 $i++) echo '<li class="active"><img src="/aircraft/'.$_GET['reg'].$i.'.jpg" alt="Flowing Rock" style="width: auto; height: 70px; margin-left: -28.5px; display: block;" class="thumb" ></li>';

Can you post your table structure?

Hey Lake, I can definitely help you get this setup. So we don't have to do things twice, I just have a couple questions. [*]Do you have any tables setup in your database right now? [*]How are you going to go out entering the scores? Are you going to use an html form? [*]Are you going to be the only one entering the scores or will other people be doing it as well? [*]Do you have a schedule table setup already? If yes, what is it's structure? It take long for you to get this setup after we figure out these questions. Nick

We will need your database structure to be able to help you add the win/loss field you are looking for. Just a note that adding this field breaks relational database law in that you have a column in a table that depends on another columns data. Meaning if a user inserted a score incorrectly say home 7 away 8 it would record a win for the home team. But if you realize your mistake and change the score to say home 7 away 7 you will have to have your program update the win/loss column as well. It doesn't sound like much but unless you are going to have 500, 000 games in the database I would calculate the result as you pull out the scores. I do this with my system that has around 2000 games in it and the query is pretty quick. Just my 2 cents. Nick

After this can you echo $query so you know that $dob is not empty?

If you are just looking to run php applications as standalone apps on any computer PHP Dock does this for you. I have used it and it works great.

You should be getting an error because there is no column 'race' in the table you provided only 'race_id'. The insert shouldn't work at all at this point. Why do you having a closing html tag after the dob input?

What happens when you have a user who has javascript disabled?