Submitting to appropriate database field.

Radon3k

What I'm trying to do is depending on what selection a user picks, it will go into the appropriate field in the database. Example:

Database:
ID
A
B
C
D
E
etc...

The user types in his name as "Charley" and submits it. I want that to go into field C. Another user types her name in as Amanda and submits it. I want that entry to go into field A. How do I go about doing this? Thanks. 🙂

drawmack

Why have you set your database up this way?

Radon3k

Let me explain what I'm actually trying to do, that may make it easier and I may even get a more efficient way of doing this.

I'm trying to create a review system. It could be for anything, let's just say it's for movies. A user types in the movie name and submits it. Instead of this going live, it goes into a queue system so that I can approve it or delete it. Once approved, it then goes live. I already have that part created.

So when I'm reviewing it there is a drop down list in which I can select which category it goes into based on the movie name. Say the name is "The Village", I want that to go into "V", and not "T". I'll have a drop down box with letters A-Z and a # for numbers. Based on which letter I select, it will go into the database field with the appropriate letter.

This is what I'm trying to at the moment though if you know of a better way then I'm all ears. Thanks.

pnoeric

hmmmmm

why not just have two fields, one for the name of the movie, and the other for the review?

then when you query the databse, if you want all reivews for movies that start with 'A', you say "SELECT * FROM movie_reviews WHERE name LIKE 'a%';

now, separate issue: to change "The Village" into "Village, The" (for internal purposes-- you can display it as either one to the user) it's just a matter of looking for 'The' at the front of a string and moving it to the end as appropriate. something like this would do it:

$t = 'The Village';
if(strtolower(substr($t, 0, 4)) == 'the ') {
$t = substr($t, 4).', '.substr($t, 0, 4);
}
echo $t;

best
Eric