scottwhittaker

Ha ye! When you put it like that it sounds stupid but if theres a lot of inputs and therefore subsequent variables, something like this would have saved a lot of this.... $variable = $_GET['input_name'];

Hi thanks for the response but thats not what I was meaning although I see how u thought that. What you replied with was how to put a POST or GET value into a variable BUT what if I do not know the name of the input field which would mean I cannot type the code you supplied because I do not know the name of the bit in red...here... ( $_GET['surname']; ). I want the variable name to be the name of the input field (almost like a dynamically created variable name) and the value of the variable to be the value entered on the form. I could swear I had read about this somewhere previously but its looking like I havent!

Hi Is it posible to use form field names as variable names like so... <form name="test" method="GET"....> <input name="surname">.... when submitted creates URL like form_handler.php?surname=value_entered Can I somehow set a variable with the name of each form input and set it to the value entered so that when I type "print $surname;" It prints the name name they entered? I know this sounds strange but I want to create a script for use on many different forms which I wont know all of the input names for. Hope that makes sense, kinda hard to explain though. I've had a look but nothing came up. Cheers Scott

So far I have done the following... 1) Pulled out the problematic description column into a new excel spreadsheet. 2) Find and Replace all (") speech marks with something similar or just with blanks (reason for this will become clear later) 3) Exported it as a csv file. 4) It seems that when cells with new lines within them are exported to csv they are enclosed within ("...") speech marks which means I can now read the file into a string variable and "explode" the string into an array at every speech mark. Theoretically each odd numbered element of the array should contain the description data of a row from the original database. This seems to work but doesnt keep the new lines intact and simply outputs everything into one long paragraph. Not very pretty at the minute but getting closer. Scott

Hi I have an old MS Access property database which I have opened in Excel just to view it. There is approx 500 rows. Basically most of the columns are filled in with normal simple data such as a basic address or a post code or a price. However the description column is a full on description with line breaks etc. In Excel these show up as boxes with a question mark in them. Is there a good way of getting this data into a mySQL database? Without the description column its simple and ideally I'd rather these long descriptions were stored in text files or html files and pulled in when required. I attempted this but when I exported it to a csv file the line breaks seem to mess it all up. Is there a way of doing this or is it a no hoper? Cheers Scott

Hi I just came across CushyCMS which seems like a nice simple CMS for basic sites and for those who havent seen it, it basically allows web masters to define editable parts of a web page by assigning a class="cushyCMS" attribute to any specific <P> or <DIV> tag. Assigned editors can then login and change the content. I like it because its so simple. Most other CMS I come across are so involved and complicated its unreal. Basically I was just wondering how it pulls the content of a page out and rewrites it back to the page? I thought of a way of doing it myself but it involves creating a template with a content area and then allowing them to edit a simple content page and then create a HTML page by combining the two but obviously CushyCMS doesnt work this way as it edits the pages from any server its provided with FTP details of. Another way I thought of was to somehow read the entire page and find any element with a cushyCMS class assigned to it and display it for editing purposes then re write the page back to the server overwiting the original but I'm not sure on how to best do the middles part of this (searching for and pulling out full <DIV>'s and <P>'s etc with a relevant class value) whilst remembering where to insert them back into the page. Anyone got any thoughts as to what the best way of doing this is or how I can do the second idea above? Thanks for any input! Scott