[Resolved] Need guidance on translating plain-english into numbers (details inside..)

Kinsbane

Okay, so on this website I'm working on I'm setting it up similar to PHPnuke. If anyone's worked with phpNuke before, you know that it sets up tables specifically for categories, and topics, etc, complete with an ID for each entry.

I'm doing something similar.

I have a genres table, which is uniqued by having a gid (genre id). I also have sub-genres, which are uniqued by having a sid (sub id). But, when somone in the admin section adds a new sub-genre to the system, they also pick which main genre it goes into.

So, I'm wondering if there's an easy way to take the values from the genres table, load up a select box to pick which genre a sub-genre goes into with id's translated into its title, then when the new query gets sent into the sub-genre table, the value that goes into the gid for its row is the corresponding id number from the genre table (whew).

It's kinda hard to spit out, but right now I'm trying to visualize how I would program this and all I see are line after line after line after line after line of code. I'm hoping to avoid that, and hoping you guys understand what I mean. 😕

LordShryku

A couple of guys here have done the reverse of this. You may be able to use their code as a basis....

Kinsbane

Originally posted by LordShryku
A couple of guys here have done the reverse of this. You may be able to use their code as a basis....

Actually.. I guess I wasn't too clear with what I wanted to do.

But thanks for the reply, youve been, at least, attempting to assist me (even if I dont pick up everything :o ).

But actually, I found out what I wanna do.

Say I wanna add an image, and it goes into both a main genre and a sub-genre. Well, on the add an image page, I have two select boxes showing the current genres & sub-genres. User picks where the image goes, and when it gets submitted, here's some sample code of how the whole query goes down:

$sql_translate = "SELECT * FROM tbl_genres WHERE title='".$_POST['sgnr_maingenre']."'";
$sql_xlate_query = mysql_query($sql_translate);
$sql_xlate_array = mysql_fetch_array($sql_xlate_query);
$gnrid = $sql_xlate_array['gid'];
$sql_subgenre = "INSERT INTO tbl_subgenres VALUES ('', '".$gnrid."', '".$_POST['sgnr_title']."', '".$_POST['sgnr_desc']."')";