cmpadmin

Yeah i know its a weird one. I can copy a paragraph of text but not a lot. Is there any issues posting a textarea box to SQL when it has line breaks etc. These are long paragraphs of text which contain () and "" and the like. Should I be posting it a different way than the other fields?

Hi, I have tried both options. Also when I type in it seems ok. When I copy/paste text in it fails. Unless I only copy/paste one paragraph. Then it seems to work. Anyone got any ideas on my little problem?

Hi, I have tried both options. Also when I type in it seems ok. When I copy/paste text in it fails. Unless I only copy/paste one paragraph. Then it seems to work.

OK new question. In my form crazymoonpics.heliohost.org/movieAdd.php I can add things into the fields no problem. However for some reason when I add a lot of text into the plot field it does not seem to save to my database. I beleive it only occurs when I copy and paste. The field in the db is setup as text but it still does not seem to save. Only when i manually type into the field. Any ideas on what I can do to resolve this?

I have been trying to figure out how to do this with AJax but I am struggling as I dont really know the in's and out's of JQuery or Ajax for that matter. Basically I will click the add person button which opens a separate page, add the person, click submit and the page will close. Does the Ajax portion need to go into the add person page or the page with the actual select boxes?

So I have started my new site. So far with a little (lot) of help from you guys I have got quite far. Its not pretty but it is almost funtional. Here is a quick recap: crazymoonpics.heliohost.org on Stevie. Site to be used as a prive IMDB type site where our productions can be listed and search upon. As I am not always around I want users to be able to add their own entries so I have created a form. Now the form works, posts to my database as does the add person button which also posts. I now have two questions I need help on. 1. If I add a person and submit that entry to the database can I make it update the select box automatically so they do not have to reload the page and lose their settings? 2. Not all entries will have 10 cast members. Minimum is 2 and max is 10. Is there a way that I can set these up to either: (a) only show when required ( select a blank option somehow so it does not post to the database If you can help me sort these things out I think all the backend will be complete then for the form and I just have to move onto presenting the data which I think will be markedly easier. Thanks to all that have helped so far, its been a brilliant learning experience. Thanks to all who hopefully help now.

Just for the record it is down again from my side. Appears to be a DNS thing again. I understand DNS can mess up but this is every day and very frequent. Plus happens from 2 different ISP. Any help please?

Yeah I had checked the Down for everyone site and it said it as running. It does not seem to effect everyone. Just seemed strange that I was having DNS issues on two of my ISP's while I know other people could see it. Currently I can see the site though so something fixed.

yeah I am having all kinds of stablity issues at the moment. have a seperate forum post open on that. it seems to be up...for now.

Hi, Just a simple question really. I am new to heliohost and since joining stevie I have found things to be unavailable more than available. Just wondered if this is common or have I just been unlucky in that things have just been worse recently. While my site is by no means going to be used on a coporate level, I will still be expected to provide a site that is stable. If this is common I think I would have to look elsewhere. Any insight you can provide would be of great help. Thanks. JD On looking further I think I may have been premature. It looks like its just not working for my site. I believe there is some kind of DNS issue. I have tried from two different locations (home and work) who both use different ISP's. The site does not seem to resolve from either location hence why I cannot access the site. I have cleared my cache and flushed my DNS. However my corporate work DNS should not experience issues really. Also the fact that it happens from two separate locations suggest a wider issue to me. Is there something I can do that will prevent DNS issues to my site?

New question of the day! So I now have the basic setup of my site. Nothing too fancy just yet. Keen to get things working then I can make it pretty. On the site crazymoonpics.heliohost.org, there is a section that allows you to add a movie into the tbMovies table in SQL. Instead of letting users input their own names which could lead to spelling mistakes and other weirdness I have added a series of dropdowns. What I have also done is crate a tbPerson table in SQL that will hold of the various people that could be selected. What I now need to do is somehow populate my drop downs with the names stored in this tbPerson table. I cannot figure out how to do this. I am sure it involves PHP but the form already calls on my add.php page to submit the form. How to I set something up to also do this population?

please ignore my previous post. I have been able to get the code to work...who knew I would be able to do some of this on my own!

Hi, After following your instructions I think I am pretty close. Thank you for all your help so far. I have created my php code but when I click the submit button i receive a cannot select database! error. My code is below and from what I can see I have not changed anything from what you originally wrote (obviously some of the names have changed in the variables to match mine. Any ideas what I have done wrong? <?php // Connect to the database mysql_connect('localhost', 'cmpadm_xxxx', 'xxxx') or die('<h1>Cannot connect to database!</h1>'); mysql_select_db('cmpadmin_moviesdb') or die('<h1>Cannot select database!</h1>'); // Get the input and assign to variables $movieName = $_POST['movieName']; $genre = $_POST['genre']; $directorName = $_POST['directorName']; $producerName = $_POST['producerName']; $writerName1 = $_POST['writerName1']; $writerName2 = $_POST['writerName2']; $writerName3 = $_POST['writerName3']; $castMember1 = $_POST['castMember1']; $castMember2 = $_POST['castMember2']; $castMember3 = $_POST['castMember3']; $castMember4 = $_POST['castMember4']; $castMember5 = $_POST['castMember5']; $castMember6 = $_POST['castMember6']; $castMember7 = $_POST['castMember7']; $castMember8 = $_POST['castMember8']; $castMember9 = $_POST['castMember9']; $castMember10 = $_POST['castMember10']; $plot = $_POST['plot']; $boxOffice = $_POST['boxOffice']; $netLossGain = $_POST['netLossGain']; $posterURL = $_POST['poster']; // Randomly select an id $id = rand(); // Insert the record into the database mysql_query("INSERT INTO `members` VALUES (".$id.", '".$movieName."', '".$genre."', '".$directorName."', '".$producerName."', '".$writerName1."', '".$writerName2."', '".$writerName3."', '".$castMember1."', '".$castMember2."', '".$castMember3."', '".$castMember4."', '".$castMember5."', '".$castMember6."', '".$castMember7."', '".$castMember8."', '".$castMember9."', '".$castMember10."')"); ?>

Hi, I have been setting up my new site for the last few days and yesterday it was working fine. This morning I have seen that my site now redirects to the default page that states my account is not setup yet please wait 24 hours etc. Is this somethig I have done wrong or something wrong with the heliohost systems? Thank you in advance for any assistance you can give.

Yeah I think baby steps are required for me. I am already learning Dreamweaver, php, html and heliohost. Adding Joomla and/or another service will be too much I think. Plus I think learning it this way is very helpful for me so would prefer to learn the 'traditional' ways. Thank you for the tip though.

OK so far so good. Thank you all for your help. I do have one more question with regards to my form. I want them to be able to fill in the cast of the movie. So I have created a field in my form called cast and made it a multiline text field. So in theory they will input actor 1 actor 2 actor 3 Then when they submit i want that to add those items to the cast column in the SQL table. Later I will want to be able to search for a film and it display all of the info about that film on a page (nicly formatted). Will it be able to get this information and treat each cast member seperately or would it be best to create lots of fields on my form and table e.g. cast member 1 - cast member 2 - etc etc

Wow. Thank you very much. I did not expect so much assistance. I will give this a go as soon as possible and let you know what happens...wish me luck! Thanks alot.

Hi, I am very new to this website creation game and have now hit some roadblocks. Let me tell you what my goal is. I participate in a small group of people who plays an online game creating movies. This has been going on for many years and I am now trying to create a kind of IMDB style site which shows all the movies, actors, directors, writers etc. I have created my main page (although not too pretty yet) at crazymoonpics.heliohost.org/ This is OK and have followed dreamweaver guides on setting this up. However I have several issues. 1. If you view this site in google chrome it is displaying ok with the vertical menubar etc. In IE this does not display correctly which means I have coded something wrong so it is not showing properly. Can you point me in the right direction? 2. Now I have this page the idea is to create a form that allows the players to add their movies into a table. Then I want to create pages that take the information from that table to create pages for movis, directors (basically everything in the CMP Movie Database section). I have created a form within dreamweaver but how can I tell it to populate the SQL table i have created in cPanel? I cannot find a good guide on this so far. I am sure I will have many more questions once I have this working but for now I think this will be a very helpful starting point if someone can help. Thank you very much in advance for any help you can offer. CMPAdmin