Disregard, MYISAM is the trick
Thank you for your help.....
monion
Last Activity: Oct 13 '09, 04:52 PM
Joined: Sep 21 '09
Location:
-
So, InnoDB allows no more than 1000 columns. This is my problem, Can I choose something else? If so, how do I do it when creating the table from a php script?Leave a comment:
-
From MYSQL I receive the following error message:
error while executing query
mysql error number 1005
cant create table 'inventory.#sql 4c_2b066a'(errn o: 139)
I can add a certain number of entries (1000 total, 125 identical lines as follows with different names):
IPF VARCHAR(20) NOT NULL, IPFDESCRIPTION VARCHAR(90) NOT NULL, IPFSIZE VARCHAR(20) NOT NULL, IPFNOTES VARCHAR(20)...Leave a comment:
-
Maximum # of columns creating a table
I am having a heck of a time creating a table with more than 140 or so columns when using php into mysql. Any known issues after a certain #?
Thanks, -
Form submission
If I have a form with 50-200 input fields, how can I submit them as one PHP/MYSQL insert command?
Ex. Form has input fields of: Lastname, Firstname, SS#, favorite color.
How can I submit all of these/consolidate into a MYSQL table with field name Personalinfo?
Thank you in advance,
MO -
Would I just pack all the values into one array and submit the array as one value?Leave a comment:
-
One last question (Hopefully)
On the form submission, how would I go about submitting multiple items ordered? Would I just keep posting order_id, item_id and quantity over and over until all items off of the form have been submitted? I have only worked a form where a post went to unique fields one time.
ex.: lastname
firstname
not ex:
lastname
firstname
differentlastna me
firstname...Leave a comment:
-
followup
Would I make a seperate table just for the quantities ordered? and make that a FK to what? to display an invoice yielding Site name, vendor, item#, item price and quantity ordered.
Thank you for your patience...
MOLeave a comment:
-
So far...
I used 2 table types
Table type #1 was named after the vendor, it contained the generic column names of: item#, description, cost and a column for each clinic (simple Y/N toggle)
I did a table of type#1 for each vendor.
I then just imported a .csv from excel that had the info and served it up as a basic webpage with one input field for each item so the user could enter a quantity.
Table...Leave a comment:
-
Best layout
I am stumped as to the best layout of a database. It is an inventory database. In it are several (9) vendors each with 2-300 items that we order. Each item has an item#, description and cost. We will have 8 sites that place orders, though not all sites order from all vendors or should have access to order the entire vendor catalog of items.
Suggestions?
Thank you in advance
MO -
Creating a Table
Below is my code. It does not seem to be working. What am I missing? I am trying to create a database table via PHP. It yields a website cannot display the page when run. When I remove the mysql_query portion I get a Error: Query was empty, so I know it is at least doing something.
...Code:<?php include("input_cl.php"); @mysql_connect("localhost","?????","?????"); -
Maybe I'm missing something. The preceding is part of a form. I want to import some values from 1 database table and pass them to a seperate one. The only way I know is to perform an <input...name=. ..> How can I also assign a name to a $variable? I'm new with PHP and mysql so please be patient.
Thanks,
MOLeave a comment:
-
get query values but do not show them
One more question.
How can I get query values assign them to a variable, but not show them?
for example size, $f4 in the following: How can I pass that value $f4 to the form handle page to submit to the database. I can clearly see how to pass $f2 with quantity stuck on the end.
Basically, I need to pass 3 things: 1) item#, 2) item#quantity and 3) size to a new database.
...Code:mysql_select_db("inventory"); -
query
What is the easiest way to format a 1 record query of select * from....
When I have maybe 40 or 50 fields/columns in a row and I want the format to be
col1
col2
col3 col4 col5 col6
col7 col8 col9 col10
col11 col12 col13 col14
so basically col1 (id)
col2 timestamp
col3-col??? data, but I want the data to print 4 per line.
Thanks,
MO -
Add a </tr> <tr> during a php query
All,
One more question (never ending right???)
If I have a list of names to pull from (Mitch, Bob, Randy, Simon, Paul & Will)
in a MYSQL database. How can I query them into a web page using select * from XXXXXX and display them 3 per line?
Ex:
Mitch Bob Randy (on one line)
Simon Paul Will (on the next) and so on and so on?
I can only seem to list them vertically... -
Form input name from a variable
One more question...
I have pulled my query line by line into my php form. Each line/row will have an input field. How can I dynamically assign a variable to the "name" field, for instance if I want the name= to be the value of the item_no.
My updated code:
...Code:<form action="inventorymaster_form.php" method="post" name="inventorymaster_form" align="left"
-
It is, how do I do this?Leave a comment:
-
display multiple rows in a form
Hello, I am trying to retrieve multiple rows from a database, place each row into a form and beside each row add an input field with a variable field name.
So far I can only pull one row.
If it helps to conceptualize, I am pulling an inventory db (vendor, item#, description, etc) I want to return each item line by line and beside each item provide a space to input the quantity the client would like to order...
...
No activity results to display
Leave a comment: