I am having problems I have a database which I am trying to get data from. I seem to be opening this with the sql database as I am not getting an error message and if i change the sql statement i do. my problem is that is is not reading the data for me and displaying it. The code is:
ok now that you've added the php tags I see a few issues, but they're not query related:
1) your first print() line is not within your while loop
2) you're missing a closing quote and semi-colon on line 20
as for it not finding any rows in the db, I'd suggest you echo out the swimmer's name from the post var and try running your query with phpMyAdmin or from the command line to see if you can return any rows that way. If you do, then perhaps you're query isn't being created correctly within php so try echoing that out to see how it looks.
another thing to note, you need to make sure that your field names are spelled (case sensitive) the same as they are in the db. I noticed you have "where Name = '$name'";. that would probably throw an error if it couldn't find it, but somethign to consider...