adding new fields to a tabel and then getting them after ad such

jediman

Hi everyone! Right now, I can create a php script that adds fields to a table, but how do i do it like dynamically? Ive coded myself in circles and need a good direction. Could someone post and example? Also, I am having trouble getting data into the fields, since ill get a message saying something like the # of fields or something isnt equal any longer. Any hints?

Shrike

Paste some code.

jediman

require("system/config.php");   

	mysql_connect("127.0.0.1","",""); 
	@mysql_select_db($database) or die( "Unable to select database"); 
	$fieldname = $_POST['newfield'];
	$secondfield = $fieldname."additional";
	$testrun = "ALTER TABLE mytable ADD $fieldname TEXT"; 
	$testruntwo = "ALTER TABLE mytable ADD $secondfield TEXT AFTER $fieldname"; 
	$result = mysql_query($testrun);
	$result = mysql_query($testruntwo);

Thats all i really got thus far, i want to add it dynamically, like clcik a button called add, it adds one more to the table one more on the form and retains the vlaues i just added in. Is this doable?

batman

You have some weird mysql layout here. Try changing the "ALTER TABLE" to "INSERT INTO"...

jediman

Uhhh did you not read the first part? I need to dynamically ADD FIELDS into the table first! And I really need to do this dynamically. Inserting into is different!

batman

Yes I know. And no I didnt read the first part that closely. Sorry for confusion.

jediman

S'ok 🙂 Its late, well here anyways lol. Any insight would be appreciatated though. I really would like to do it dynamically versus reloading and constantly displaiyng whatever i just entered, etc etc as its planned on going on now. Any hints? Im sure someone out there must have done something similar.

Shrike

Theres's nothing obviously wrong with your code. Echo out the SQL statements and ensure you have valid SQL. A minor point, theres probably no need to set the second field to be AFTER the first one, as both will be added to the end of the table unless specified elsewhere.

jediman

Hmm true. What I need to know how to do though, is do this dynamically. I wasnt able to produce any code in which I could actually do this. Has anyone done something similar? Ie; hit a button called add, and then just add the field, and keep it displayed? I tried creating a custom function for it, but I think i am limited by my knowledge at this time. Any help is very much appreciated.

Also, what would it be that after the fields are added to the table, I have it set to like insert data into the fields that were there. I did have the mysql_close() statement before hand, so I am not sure what is doing it. It tells me that the number of entries or something to that effect isnt equal to the table. Do i need to do like a two part thing, two pages maybe? I should be able to do it all from one page in theory, and thusly hopefully in practice.

jediman

Bump

jediman

Hmm, nobody has any clue? Im beginning to think about using flash to dynamically add "new fields" by placing them one after another every time you hit an add button or such. Would this work?

I mean, if someone has a clue please let me know, i'd really like to know. It would save me a buttload of time coding in circles and such. HELP!?