Jump to content

nomadsoul

Members
 View Profile  See their activity

  • Posts

    70

  • Joined

  • Last visited

 Content Type 

Everything posted by nomadsoul

  1. nomadsoul
    I just got a warning saying "I have been given a warning, no porn links" However, I have never put up a porn link. What's up? I haven't even been logged in for over a year. I'm upset
  2. nomadsoul
    Sassa's fix worked thanks! Echoing the query was the first thing I did. But thanks for the great advice. Jaques1: You also can't just drop GET parameters into your query string. Never heard of escaping? -Thank You. You are correct, I'm getting back to coding after a long layoff.
  3. nomadsoul
    I tried the suggestions and still get the same error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR keywords LIKE 'web' keywords LIKE 'yahoo'' at line 1" yahoo is one of multiple keywords in the keywords column When I run the query SELECT * FROM searchengine WHERE keywords LIKE 'yahoo' directly through phpmyadmin it returns an empty set: MySQL returned an empty result set (i.e. zero rows). (Query took 0.0000 seconds.) It will only return a results set (in phpmyadmin) only when yahoo is the only keyword in the keywords column. But the keywords column is supposed to be able to process multiple keywords within a cell as long as they are space delimited. I was hoping someone might paste this code into htdocs and dump the sql into phpmyadmin or the mysql shell to see if the same errors arise.
  4. nomadsoul
    Barand: Thanks The error out put is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR keywords LIKE 'search' OR keywords LIKE 'term'' at line 1 And the output should return all the rows based on keywords from the keywords column that match the '$k' input. and the other columns are the id, title, description, and link fields. (I think that is what you are asking)? sass: Thanks will try that maxxd;Thanks Ok will try that. I think you mean something like: $query .= "OR keywords LIKE %$each% ";?
  5. nomadsoul
    Hi and thank you for reading my topic. I'm building a search engine from a tutorial and I'm getting the famous "Warning: mysql_num_rows() expects parameter 1" boolean etc.. I know mysql_num_rows() is depricated and I promise not to use it in the future but for now I'm using it in other projects on the same server and all's ok. I'm quite sure it's a problem with the SQL syntax because when I paste SELECT * FROM searchengine WHERE keywords LIKE 'any_keyword_from_the_column' -into Phpmyadmin it won't return results, however a simple SELECT * FROM searchengine returns results. So, without using mysql_error() I get: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\research2\search.php on line 42 But after I applyin mysql_error() to everything I narrowed it down to this: $query = mysql_query($query) or die (mysql_error());: I get the error msg: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR keywords LIKE 'search' OR keywords LIKE 'term'' at line 1 I've checked multiple times to see if I've left out any columns in the db or mismatched them in while loop. Below I have included the code which you can paste into a file called search.php along with the mysql dump file to pase into phpmyadmin query box. I'm using xampp. In the code the WHERE clause is extended into the if statement and concatenated into the $query variable. This is done to break the words in the text box so they can be searched as an array. As I said, I really think it is the SQL syntax and not the mysql_* functions but I could be wrong. I'd really like to get this code working and mess with it. It looks like it could be very useful as a private website search engine. Thanks for your time and mental energy. <html> <head> <title></title> <meta http-equiv="content-type" content="text/html;charset=utf-8" /> </head> <body> <h2>Search Engine</h2> <form action = './search.php ' method = 'get'> <input type = 'text' name = 'k' size = '50' value = '<?php echo $_GET['k']; ?>' /> <input type = 'submit' value = 'Search'> </form> <hr /> results <br> <?php $k = $_GET['k']; $terms = explode(" ", $k); $query = "SELECT * FROM searchengine WHERE "; foreach ($terms as $each) { $i = 0; if ($i == 1) $query .= "keywords LIKE '$each' "; else $query .= "OR keywords LIKE '$each' "; } mysql_connect("localhost", "root", "") or die (mysql_error()); mysql_select_db("search2") or die (mysql_error()); $query = mysql_query($query) or die (mysql_error()); $numrows = mysql_num_rows($query) ; if ($numrows > 0) { while ($row = mysql_fetch_assoc($query)) { $id = $row['id']; $title = $row['title']; $description = $row['description']; $keywords = $row['keywords']; $link = $row['link']; echo "<h2><a href='$link'>$title</a></h2> $description<br /><br />"; } } else echo $k ; ?> </body> </html> and here is the SQL dump (I called my db search2 and my table searchengine -- phpMyAdmin SQL Dump -- version 4.2.7.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Nov 27, 2014 at 11:54 AM -- Server version: 5.6.20 -- PHP Version: 5.5.15 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `search2` -- CREATE DATABASE IF NOT EXISTS `search2` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `search2`; -- -------------------------------------------------------- -- -- Table structure for table `searchengine` -- CREATE TABLE IF NOT EXISTS `searchengine` ( `id` int(11) NOT NULL, `title` varchar(250) NOT NULL, `description` varchar(250) NOT NULL, `keywords` text NOT NULL, `link` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `searchengine` -- INSERT INTO `searchengine` (`id`, `title`, `description`, `keywords`, `link`) VALUES (1, 'Nick Frosty''s Official Web Site', 'Welcome to Nick''s', 'Nickfrosty Website tutorials videos web design', 'http://www.nickfrosty.com'), (2, 'Google search engine', 'The best search engine', 'google web site search ', 'http://www.google.oom'), (3, 'The Yahoo Search Engine', 'Not as good as Google', 'Yahoo search engine website', 'http://www.google.com'), (4, 'This is a test', 'This is a test website', 'Google', 'http://www.google.com'); -- -- Indexes for dumped tables -- -- -- Indexes for table `searchengine` -- ALTER TABLE `searchengine` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `searchengine` -- ALTER TABLE `searchengine` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; If you have any questions about any details of this code please ask me. Thanks for your time
  6. nomadsoul
    Thanks fenway, I suspected it would be this complex
  7. nomadsoul
    I'm tasked with a hypothetical challenge and I'd like to know if it can be done. And if it can, I'd love some ideas (pseudo code is ok) of different ways I could do this maybe the solution could benefit others as well: Imagine that there are 3 companies selling produce: Company 1 Company 2 Company 3 Each of these companies are tracking the price and types of products they are selling. Prices change each day so our website is asking each company to upload the type and price of product each day -so buyers can compare prices. So, imagine the seller will be greatly inconvenienced to try to log into the website and update the prices manually (they may have thousands of products). If they are using their own automated spread sheet, then they could simply upload the excel sheet, and the website will parse through the existing list, compare with the old list (already in the website) and sync the prices and products that the seller has in their own BI software. In this method, the website uses 1 name to describe each product.. and forces whatever name each of the various sellers use as a description, be mapped to the website common name (in the Mysql table or a master list?). The buyer will be trying to compare a produce item, and if all the names are different, then it wouldn't work. Company 1 sells Granny Smith medium apples for .99 cents a pound Company 2 Medium Green Granny apples for 1.05 a pound Company 3 sells Green Granny apples for .85 cents a pound Now.. the website lists that product as Granny Smith Medium Apples ...but they are the same apples. Buyers will look at the site and find Granny Smith Medium Apples and want to see the pricing, but since each seller uses a different name.. we need each of those names to be mapped to our common name (Granny Smith Medium Apples). Logging in and updating with a php form is not an option because the update has already been done for the company on the spreadsheet, we don't want to ask the customer to update everything again on the website because the customer may have thousands of products. I think I might be overanalyzing the situation and there is probably a simple solution. I also thought of providing a spreadsheet template for each company with names matching the Mysql table but as I mentioned these companies may have thousands of products. Names can be added and dropped or changed. Maybe I could join 3 tables: MasterList, ImportedList, and UpdatedList, using diff, REPALCE or some regular expressions? Like I say if you have some ideas, pseudocode is ok but if you know of any scripts related to this task let me know.
  8. nomadsoul
    Sorry I am a complete dumbass, I forgot the tablename. SELECT DATEDIFF(ShippedDate,RequiredDate) AS DiffDate FROM Orders
  9. nomadsoul
    #1054 - Unknown column 'ShippedDate' in 'field list' But there is a ShippedDate column
  10. nomadsoul
    Hi all, I've found many explanations on how to calculate the difference between two individual dates i.e: DATEDIFF (day, ‘7/8/2009’, ‘8/14/2009’) AS Result ] But nothing on how to calculate the difference between two date fields i.e: SELECT DATEDIFF(ShippedDate,RequiredDate) AS NewCalculatedField I tried but won't work, can it be done? -tried with and without parenthesis
  11. nomadsoul
    I'm doing a project from an ecommerce book and it says "the non_coffee_products table has a many to one relationship with the non_coffee_categories table" I have listed them both below but I see no fk-references syntax. I see absolutely no connection between these two tables. Does the Key Index link these tables? I guess I need a tutorial on Indexes CREATE TABLE `non_coffee_products` ( `id` mediumint( unsigned NOT NULL AUTO_INCREMENT, `non_coffee_category_id` tinyint(3) unsigned NOT NULL, `name` varchar(60) NOT NULL, `description` tinytext, `image` varchar(45) NOT NULL, `price` decimal(5,2) unsigned NOT NULL, `stock` mediumint( unsigned NOT NULL DEFAULT '0', `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `non_coffee_category_id` (`non_coffee_category_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `non_coffee_categories` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `category` varchar(40) NOT NULL, `description` tinytext NOT NULL, `image` varchar(45) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  12. nomadsoul
    Hi all, I am using kplaylist (a huge php file) paired with xspf_player (a flash player) to serve mp3 files on a site I'm building. My problem is : I can't figure out how customize the appearance of the flash player. Specifically I'd like to remove the album cover jpg area. Here is the xspf_player website :http://www.xspf-player.com/customize.html#skin I am not sure what to do with the code provided on the website. Do I insert the code into the php file or do I make an html file to link to the player? I'm clueless. If anyone is familiar with this I hope you can assist me.
  13. nomadsoul
    Yes, I was using a session that was already set and users name is echoed no problem. It's not imperative but I thought i'd be nice to let the user see hisher name uc. I tried your code and it didn't work. I've wrapped the variable in {}brackets because it is inside html, that's how I learned it but if there is another way I will try. I will keep trying variations on your code. Thanks
  14. nomadsoul
    Hi, gday, how can I use the ucfirst variable on the posted variable after to form has been submitted to welcome my member? "<p>Welcome: ucfirst{$_SESSION['first_name']};" This is not working. Should I use it in the form instead?
  15. nomadsoul
    A blank screen should mean your db connection is working. Do you have a deadline on your website or is it your own project? Sorry that you've had so much trouble. Your book certainly arrived fast. Which book and which forum did you join?
  16. nomadsoul
    I am also a member of Larry's forum as "nomadsoul"
  17. nomadsoul
    Oh crap, my oversight; Rename the script: mysql_insert.php It should be the same name as in the action = "script name' part.
  18. nomadsoul
    Ok, let me check out the error. I think you'll like Larry's book(s). He even answers questions personally on his forum.
  19. nomadsoul
    I don't think there is such a thing as a simple shopping cart. And I'd be surprised if it can be done without many many posted replies but I think this website has excellent tutorials and "Effortless e-commerce" by Larry Ullman is probably the best way to go if you want to DIY.
  20. nomadsoul
    Vince, I don't know how much you are interested in php mysql coding or if your just passing through but I always recommend books by Larry Ullman He is known for "Translating geek into English" Personally, I won't touch a php book that doesn't have his name on it.
  21. nomadsoul
    No problem, I know what it's like to be busy.
  22. nomadsoul
    Hi V, Here's some good news for you, This script below works, just create the table with this: CREATE TABLE IF NOT EXISTS `data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(20) NOT NULL, `airfieldname` varchar(20) NOT NULL, `heightabovesealevel` int(5) NOT NULL, `generallocation` varchar(100) NOT NULL, `co_ordinates` varchar(20) NOT NULL, `ppr` varchar(3) NOT NULL, `alternate` text NOT NULL, `airground` varchar(3) NOT NULL, `radiofrequency` double NOT NULL, `runway` varchar(30) NOT NULL, `circuit` varchar(200) NOT NULL, `status` varchar(10) NOT NULL, `remarks` text NOT NULL, `warnings` text NOT NULL, `ophours` varchar(50) NOT NULL, `contacts` text NOT NULL, `landingfee` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=83 ; Then run the below script. I've put everything into one file this time. I've tested it and it works. -adjust the mysql_connect part to fit your parameters. you should be able to plug it right in. then check your db to see if data has been inserted. If so, then you can start making it look more symetrical and colorful (I'll let you do that). You should also check to see if your display page is showing the data that has been entered. You can also change the datatypes of the table since I'm not sure and just gave everything text or varchar. Once you are satisfied with that it'll be time for form validation (making sure everyone behaves when they enter data). you can call it insert.php if you'd like <?php $connect = mysql_connect("yourhost","yourusername","yourpassword") or die ("mysql_error"); mysql_select_db("yourdbname") or die(mysql_error()); echo "connected to your database!"; ?> <html> <body> <form action="mysql_insert.php" method="POST"> Status: <input type="text" name="status" /><br> Username: <input type="text" name="username" /><br> Airfield Name: <input type="text" name="airfieldname" /><br> Height Above Sea Level <input type="text" name="heightabovesealevel" /><br> General Location <input type="text" name="generallocation" /><br> Co-ordinates <input type="text" name="co_ordinates" /><br> <!--Prior Permission Required <input type="text" name="ppr" /> --> Prior Permission Required<select name='ppr' class='text_select' > <option value="yes" >yes</option> <option value="no" >no</option> </select><br> Alternate Airfield<input type="text" name="alternate" /> <!-- Air to Ground Radio<input type="text" name="airground" /> --> Air To Ground Radio <select name='airground' class='text_select'width = 20pt> <option value="Yes" >Yes</option> <option value="No" >No</option> </select><br> Radio Frequency<input type="text" name="radiofrequency" /><br> Runway<input type="text" name="runway" /><br> Circuit<input type="text" name="circuit" /><br> Remarks<input type="text" name="remarks" /><br> Warnings<input type="text" name="warnings" /><br> Operating Hours<input type="text" name="ophours" /><br> Contacts<input type="text" name="contacts" /><br> Landing Fee<input type="text" name="landingfee" /><br> <input type="submit" /> </form> <?php $status = $_POST['status']; $username = $_POST['username']; $airfieldname = $_POST['airfieldname']; $heightabovesealevel = $_POST['heightabovesealevel']; $generallocation = $_POST['generallocation']; $co_ordinates = $_POST['co_ordinates']; $ppr = $_POST['ppr']; $alternate = $_POST['alternate']; $airground = $_POST['airground']; $radiofrequency= $_POST['radiofrequency']; $runway= $_POST['runway']; $circuits = $_POST['circuit']; $remarks = $_POST['remarks']; $warnings = $_POST['warnings']; $ophours = $_POST['ophours']; $contacts = $_POST['contacts']; $landingfee = $_POST['landingfee']; $sql=mysql_query("INSERT INTO data(status, username, airfieldname, heightabovesealevel,generallocation,co_ordinates,ppr,alternate,airground,radiofrequency,runway,circuit,remarks,warnings,ophours,contacts,landingfee) VALUES ('".$_POST['status']."','".$_POST['username']."','".$_POST['airfieldname']."','".$_POST['heightabovesealevel']."','".$_POST['generallocation']."','".$_POST['co_ordinates']."','".$_POST['ppr']."','".$_POST['alternate']."','".$_POST['airground']."','".$_POST['radiofrequency']."','".$_POST['runway']."','".$_POST['circuit']."','".$_POST['remarks']."','".$_POST['warnings']."','".$_POST['ophours']."','".$_POST['contacts']."','".$_POST['landingfee']."')"); ?>
  23. nomadsoul
    I see you've added a new field. I'll have to alter the form I just sent you. May take some time.
  24. nomadsoul
    I've taken an old insert script of mine and altered it to suit your form. It is connecting but not inserting. Right now I don't have time to debug it or create any conditionals for insert or error check so, I'm hoping someone else can check it, modify or alter it, i won't object I've also included the table information. I should have copied the CREATE TABLE statement when I had the chance but didn't. Sorry. I'll check back in a day or so. I'm busy but not for too long. So, below are 3 files to work with, and make sure they are in separate files in the same folder: connect.php -you'll need to modify for your host, password etc.. process.php -the insert script which is linked to connect.php form.htm -your form slightly edited user_input.doc I always like to make sure the script is inserting in the table before moving on to form validation whereas others like to do validation as they go. connect.php: <?php $connect = mysql_connect("yourhost","yourusername","yourpassword") or die ("mysql_error"); mysql_select_db("airfield_data") or die(mysql_error()); echo "connected!"; ?> process.php: <?php require ("connect.php"); $status = $_POST['status']; $username = $_POST['username']; $airfieldname = $_POST['airfieldname']; $heightabovesealevel = $_POST['heightabovesealevel']; $generallocation = $_POST['generallocation']; $co_ordinates = $_POST['co_ordinates']; $ppr = $_POST['ppr']; $alternate = $_POST['alternate']; $airground = $_POST['airground']; $radiofrequency= $_POST['radiofrequency']; $runways = $_POST['runways']; $circuits = $_POST['circuits']; $remarks = $_POST['remarks']; $warnings = $_POST['warnings']; $ophours = $_POST['ophours']; $contacts = $_POST['contacts']; $landingfee = $_POST['landingfee']; $sql=mysql_query("INSERT INTO user_input(status, username,airfieldname, heightabovesealevel,generallocation, co_ordinates,ppr,alternate,airground,radiofrequency,runways,circuits,remarks,warnings,ophours, contacts, landingfee) VALUES ('".$_POST['status']."','".$_POST['username']."','".$_POST['airfieldname']."','".$_POST['heightabovesealevel']."','".$_POST['generallocation']."','".$_POST['co_ordinates']."','".$_POST['ppr']."','".$_POST['alternate']."','".$_POST['airground']."','".$_POST['radiofrequency']."','".$_POST['runways']."','".$_POST['circuits']."','".$_POST['remarks']."','".$_POST['warnings']."','".$_POST['ophours']."',".$_POST['contacts'].",'".$_POST['landingfee']."')"); ?> form.html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> <style type='text/css'> body{ margin-left: 18px; margin-top: 18px; } body{ font-family : Verdana, Arial, Helvetica, sans-serif; font-size : 13px; color : #474747; background-color: transparent; } select, option{ font-size:13px; } ol.phpfmg_form{ list-style-type:none; padding:0px; margin:0px; } ol.phpfmg_form li{ margin-bottom:5px; clear:both; display:block; overflow:hidden; width: 100% } .form_field, .form_required{ font-weight : bold; } .form_required{ color:red; margin-right:8px; } .field_block_over{ } .form_submit_block{ padding-top: 3px; } .text_box, .text_area, .text_select { width:300px; } .text_area{ height:80px; } .form_error_title{ font-weight: bold; color: red; } .form_error{ background-color: #F4F6E5; border: 1px dashed #ff0000; padding: 10px; margin-bottom: 10px; } .form_error_highlight{ background-color: #F4F6E5; border-bottom: 1px dashed #ff0000; } div.instruction_error{ color: red; font-weight:bold; } hr.sectionbreak{ height:1px; color: #ccc; } #one_entry_msg{ background-color: #F4F6E5; border: 1px dashed #ff0000; padding: 10px; margin-bottom: 10px; } </style> <div class='form_description'> </div> <form name="flying" action='process.php' method='post' enctype='multipart/form-data' > <ol class='phpfmg_form' > <li class='field_block' id='field_1_div'><div class='col_label'> <label class='form_field'>status</label> <label class='form_required' > </label> </div> <div class='col_field'> <input type="text" name="status" class='text_box'> <div id='field_1_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_2_div'><div class='col_label'> <label class='form_field'>username</label> <label class='form_required' > </label> </div> <div class='col_field'> <input type="text" name="username" id="field_2" value="" class='text_box'> <div id='field_2_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_2_div'><div class='col_label'> <label class='form_field'>Airfield Name</label> <label class='form_required' > </label> </div> <div class='col_field'> <input type="text" name="airfieldname" class='text_box'> <div id='field_2_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_3_div'><div class='col_label'> <label class='form_field'>Height Above Sea Level</label> <label class='form_required' > </label> </div> <div class='col_field'> <input type="text" name="heightabovesealevel" class='text_box'> <div id='field_3_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_4_div'><div class='col_label'> <label class='form_field'>General Location</label> <label class='form_required' > </label> </div> <div class='col_field'> <textarea name="generallocation" id="generallocation" rows=4 cols=25 class='text_area'></textarea> <div id='field_4_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_5_div'><div class='col_label'> <label class='form_field'>Co-ordinates</label> <label class='form_required' > </label> </div> <div class='col_field'> <input type="text" name="co_ordinates" class='text_box'> <div id='field_5_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_6_div'><div class='col_label'> <label class='form_field'>Prior Permission Required</label> <label class='form_required' > </label> </div> <div class='col_field'> <select name="ppr" class='text_select' > <option value="yes" >yes</option> <option value="no" >no</option> </select> <div id='field_6_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_7_div'><div class='col_label'> <label class='form_field'>Alternative Field</label> <label class='form_required' > </label> </div> <div class='col_field'> <input type="text" name="alternate" id="field_7" value="" class='text_box'> <div id='field_7_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_8_div'><div class='col_label'> <label class='form_field'>Air Ground Radio</label> <label class='form_required' > </label> </div> <div class='col_field'> <select name="airground" class='text_select'width = 20pt> <option value="Yes" >Yes</option> <option value="No" >No</option> </select> <div id='field_8_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_9_div'><div class='col_label'> <label class='form_field'>Radio Frequency</label> <label class='form_required' > </label> </div> <div class='col_field'> <input type="text" name="radiofrequency" class='text_box'> <div id='field_9_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_10_div'><div class='col_label'> <label class='form_field'>Runways</label> <label class='form_required' > </label> </div> <div class='col_field'> <textarea name="runways" rows=4 cols=25 class='text_area'></textarea> <div id='field_10_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_11_div'><div class='col_label'> <label class='form_field'>Circuits</label> <label class='form_required' > </label> </div> <div class='col_field'> <textarea name="circuits" rows=4 cols=25 class='text_area'></textarea> <div id='field_11_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_12_div'><div class='col_label'> <label class='form_field'>Remarks</label> <label class='form_required' > </label> </div> <div class='col_field'> <textarea name="remarks" rows=4 cols=25 class='text_area'></textarea> <div id='field_12_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_13_div'><div class='col_label'> <label class='form_field'>Warnings</label> <label class='form_required' > </label> </div> <div class='col_field'> <textarea name="warnings" id="field_13" rows=4 cols=25 class='text_area'></textarea> <div id='field_13_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_14_div'><div class='col_label'> <label class='form_field'>Operating Hours</label> <label class='form_required' > </label> </div> <div class='col_field'> <input type="text" name="ophours" value="" class='text_box'> <div id='field_14_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_15_div'><div class='col_label'> <label class='form_field'>Contacts</label> <label class='form_required' > </label> </div> <div class='col_field'> <textarea name="contacts" rows=4 cols=25 class='text_area'></textarea> <div id='field_15_tip' class='instruction'></div> </div> </li> <li class='field_block' id='field_16_div'><div class='col_label'> <label class='form_field'>Landing Fee</label> <label class='form_required' > </label> </div> <div class='col_field'> <input type="text" name="landingfee" id="field_16" value="" class='text_box'> <div id='field_16_tip' class='instruction'></div> </div> </li> <br><input type="submit" value="Submit"> </form> </body> </html> user_input.doc: Field Type Null Default id int(11) No status varchar(20) No username varchar(50) No heightabovesealevel text No genderallocation text No co_ordinates varchar(20) No ppr varchar(2) No alternate varchar(50) No airground varchar(3) No radiofrequency varchar(10) No runways varchar(20) No circuits varchar(20) No remarks text No warnings text No ophours varchar(50) No contacts varchar(200) No landingfee varchar(20) No airfieldname text No
  25. nomadsoul
    Yes the id input can be cut. Sorry , forgot about that. Hang on and I'll change that in a bit
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.