List/menu Post question

[NTGre]

Hi....me again 🙂

I m using This.

$result = mysql_query( "SELECT category_id,category_name FROM gallery_category" );
	while( $row = mysql_fetch_array( $result ) )
	{
$photo_category_list .=<<<__HTML_END
	<option value="$row[0]">$row[1]</option>\n
__HTML_END;
	}
	mysql_free_result( $result );	

to receive some values from a table called category_id for my list/menu.
the table got 3 fields
1) category_id=$row[0]
2) category_name=$row[1]
3) Gerne=$row[2]

as far as i understand right im using row[0] as a value in my list/menu
<option value="$row[0]">$row[1]</option>\n
and row[1] as what displayed in my list/menu options

What can i do so every time i use 1 otion from the list/menu
to post both valuesin my table??
and i mean if i use vaue $row[0] to post both $row[1] & $row[2]
in another table in 2 diferent fields???

So far im using...

INSERT INTO another_table(......'".addslashes($_POST['category'])."',
'".addslashes($_POST['category(row[2])'])."',...........

to post the values in my table.But only the 1st part is working,
the 2nd part sends an empty value

What can i DO????

[devinemke]

you could use both fields as the option values separated by a pipe ("|") character and then use [man]explode[/man] to split them back up in the form processing code:

<option value="$row[0]|$row[1]">$row[1]</option>

and then later:

$explode = explode('|', $_POST['category']);
$category_id = explode[0];
$category_name = explode[1];

[NTGre]

thnx..i ll try this NOW !!!! 🙂

[NTGre]

is not working 🙁

i v done
$explode = explode('|', $_POST['category']);
$category_id = explode[0];
$category_name = explode[1];

and later...

INSERT INTO table(.......photo_category,Gerne,.....VALUES ...'".addslashes($POST['explode[0]'])."','".addslashes($POST['explode[1]'])."',

but i m geting
Parse error: parse error, unexpected '[' in /data/www/................./www/vilyl/upload.php on line 31
where line 31 is
$explode = explode('|', $_POST['category']);

i v done something wrong???

[devinemke]

$_POST = array_map('addslashes', $_POST);
$explode = explode('|', $_POST['category']);
$sql = "INSERT INTO table SET category_id = 'explode[0]', category_name = 'explode[1]'";

i don't know what your form looks like but the above code assumes that the form field is named "category".

[NTGre]

the all code goes like...

$result = mysql_query( "SELECT category_id,category_name FROM gallery_category" );
	while( $row = mysql_fetch_array( $result ) )
	{
$photo_category_list .=<<<__HTML_END
	<option value="$row[0]|$row[1]">$row[1]</option>\n
__HTML_END;
	}
	mysql_free_result( $result );	

this is a part of preupload.php and post the values to upload.php that goes like..

// Fetch the photo caption array
	 $_POST = array_map('addslashes', $_POST); 
	   $explode = explode('|', $_POST['photo_category']); 
	   $sql = "INSERT INTO table SET category_id = 'explode[0]', category_name = 'explode[1]'"; 
	$enddate=date ("Y-m-d H:i:s",mktime(date("H"),date("i"),date("s"), date("m"),date("d")+$day_set,date("Y")));
	$First=$_POST['First'];
	$Last=$_POST['Last'];
	$elm1=$_POST['elm1'];
	$photo_caption = $_POST['photo_caption'];

.
.
.
$query = "INSERT INTO gallery_photos(
				`photo_filename`,
				 `photo_caption`,
				  `photo_category`,`Gerne`,
				  `First`,
				  `Last`,
				  `elm1`,
				   `photo_category1`,
				   `enddate`) 
				   VALUES(
				   '0',
				    '".addslashes($photo_caption[$counter])."',
					 '".addslashes($_POST['explode[0]'])."','".addslashes($_POST['explode[1]'])."',
					 '$First',
					 '$Last',
					 '$elm1',
					  '".addslashes($_POST['category1'])."',
					  '$enddate')" ;

including your lines.....

Sorry again that i dont understand but i m newbie and i m trying to learn

[NTGre]

i forgot to mention that the previus code post nothing in

photo_category,Gerne,

[NTGre]

i m trying ti follow your advice to use explode but this
".addslashes($_POST['category'])." is KILING ME..

i v try
$explode = explode('|',".addslashes($_POST['category']).");
$photo_category = explode[0];
$Gerne = explode[1];

but i m geting Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in

I dont know what else to do 😕

[NTGre]

my options in my list menu is now..

<option value="$row[0],$row[1]">$row[1]</option>\n

with this values 1,Italo

in upload.php i v done

$test=array_map('addslashes', $_POST);
$expl = explode(',', $test);
$photo_category = explode(',',$expl[0]);
$Gerne = explode(',',$expl[1]);

and when i submit i m sending....
$photo_category=1,Italo
$Gerne = empty

What im doing Wrong AGAIN !!!!!

😕

[NTGre]

much easyer that i thought :eek:

i just explode the $category in 2 parts !!!!!!

Thnx For your time.........