[PHP] Update involving a list field

[Shiloh Madsen]

Hi,

Im using a form that updates a database entry. In it one of my fields is a drop 
down/list field. Whenever the value in this field is changed, instead of updating it 
to the new item, it is deleted entirely. I have the same field in my entry page that 
inserts just fine, but for some reason the update deletes the info. Is there something 
special about updating a recordset off of a dropdown field that I am missing? if it 
matters, im pulling the initial value of the field from the value in the database 
row.I can send the code for the page to anyone who needs more info.

Shiloh

[PHP] New Question...tables

[Shiloh Madsen]

Thanks to Micah Ive resolved my old problem, but now im working on something new and 
fairly gnarly...i ahve a data entry form and one of the textareas on the form needs to 
have the ability to take a table...from users who dont know html. does anyone know any 
possible solutions to this dilemma? It would be easy if the field would always have a 
table with specific properties, but that is not the case, there may or may not be a 
table and the number of rows and colums used and data input into the table if it does 
exist will vary from record to record. Is there any way to accomplish this tha tyou 
can think of? Im almost certain that there is nothing quick and easy but i was 
wondering if anyone out there had ideas. Just FYI i plan on having a seperat page to 
view data with that will pull the data out of a table, and, ideally format the html 
into a table for display. 

[PHP] Enum table entry

[Shiloh Madsen]

Have a question that im trying to figure out how to resolve. I have a field type in 
mysql that is of the enum type. Unless youre familiar with Dungeons and Dragons, you 
wont get what the values mean, but hopefully youll get the gist anyway. I have a 
column labelled school which holds an enum data type comprised of the values 1 through 
40. From the website front end, where the data is being entered, i want to display, 
ideally a series of checkboxes, otherwise a list which would allow a user to select 
multiple items in that will translate into this enum field. For instance, a series of 
checkboxes with items such as abjuration, conjuration, divination, and others, which 
will all have a numeric value which gets plugged into the enum field. for instance, if 
a user selected abjuration, and divination, it would be plugged into sql as 1, 3 (or 
however enum data is input into its column). That being the case how do i utilize php 
to get this to work? what kind of form elements etc... The problem im seeing with 
checkboxes are that they are discreet and dont group together, so i cant get all the 
data to go into one column in mysql. Hopefully i havent horribly confused the issue 
and some kind soul out there can tell me how to send this data across. As a double 
nice thing...how would you write it to pull the data back out...ie, convert 1, 3 to 
show abjuration, divination? Thanks for the help in advance. 

[PHP] Error: Parse error: parse error, unexpected $ in...

[Shiloh Madsen]

Hi all. Im getting the above mentioned error: *Parse error*: parse 
error, unexpected $ in *c:\program files\apache 
group\apache\htdocs\login.php* on line *38* when I try to view the page 
I just created. As a forewarning, I am very new to PHP, so I may have 
done something stupid, and if it matters, I am also using windows, not 
*nix. Any help with this would be greatly appreciated.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Having more problems

[Shiloh Madsen]

The newbie is still having troubles heh. Maybe some kind soul can tell 
me what im doing wrong this time. This is the code for a page I am 
working on. When I try to bring up the page in a browser, I just get a 
white page, instead of having the HTML display. Anyone able to tell me why?







   Login Page

Unable to connect to the database server at this time.";
   exit();
} else {
mysql_select_db("GameDB",$LoginDB);
if (! @mysql_select_db("GameDB") )
   print "Unable to locate the Game Database.";
   exit();
}
?>

   body { color: white; background: black; }

"


   
   Login: 
   Password: 
   
   









-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php