lemke411

If you have the option to do some new work try using JQuery. I skimmed through and they have a time and date picker available. This is quite new and there is only one book out there now but this would be worth learning. I use drop down boxes for time input and a textbox for date with a javascript date picker go to dynamic drive for free javascript help code.

You will find your self asking the question at least 100 times a day especially if you are a web designer. Firefox follows the book on html and css rendering and IE does not. What this means you will have a headache from IE being non-compliant. Try putting the <div id='sidebar'></div> above the main div tag. I am not much of a designer since I am a programmer, but what you are working on may become a major pain. I recommend working with tables it is a lot easier work with and to debug. I hope this helps you out.

You have a lot of code everywhere, I have a couple tips that might help you out. 1st Create a connect.php file that handles the database connetion 2nd Do most of you coding on top above the doctype when you can and do forget to use functions when you can 3rd When doing a query and looping through to generate HTML keep the select and result with the while loop it will be easier to read 4th Use sessions to maintain login information and create a file that checks the login and keep that on top of the page. I hope this helped you out.

What I have noticed that MySQL and PHP that blank is null so there would be no result for the length. I don't even think that a 0 will be displayed for the length.

Try using this: ORDER BY RAND()

I have created many e-commerce sites and worked on some theory and what I did was go to the sites and list out the types of information. Once you collected all of the information that you figured that you needed, start creating your database and normalize your tables. This process may take some time depending on the information that you want to display to the user. Another approach you might consider would be asking your friends or co-workers that shop online on what sites they like and dislike so you know a possible angle you may want to pursue. What your main concern is to break down the site as far as possible because the database is the foundation of any dynamic site and you want that to be very strong so any add ons to a site wont cripple it and the work-a-rounds wont be a hassle. I hope this helped you out.

I would recommend writing out you queries like this: $select = "SELECT s.id, s.show_name, c.cat_name FROM tv_shows AS s INNER JOIN tv_episodes AS e ON s.id=e.show_id INNER JOIN tv_cats AS c ON s.cat_id=c.id ORDER BY s.show_name ASC"; $result = mysql_query($select); if (mysql_num_rows($results){ while($row = mysql_fetch_row($result)){ } } I used INNER JOINs but if the tables under the FROM may not have a record associated to the SELECT you may have to use a LEFT JOIN. If were you I would read up on JOINs because you will use them a lot. Good luck and have fun.

I have a couple tips that you could use to make you coding a little easier. 1st: Create a connect.php file and include it (it just looks nicer and less cluttered and changes happen in one place) 2nd Do a header("location: page.php"); instead of an include 3rd Don't use html or htm extensions because later on you may want to do some php in those pages and then you will have to change them.

I guess it depends on how you have every thing set up. If you have a set amount of images (img1 - img7) and the audio records relate and reuse the images. Like audio1 uses img1, img3, and img4 and audio2 uses img2, img5, and img1 then I would create another table that holds that relation between the two tables.