search 001011 where $a[2]=1

[hayato1]

6months ago i posted similar question but it never been answered, so i deleted that thread, i thought i could learn as time goes by.... but now 6 months later, i still couldn't find my solution to it. i cound't manage to know the way to write this correctly. I hope you can help me out.

i using mysql, php, apache
+---------+------------+------------+
| t_index | t_audio_ja | t_audio_ca |
+---------+------------+------------+
| 5 | 000101 | |
| 43 | 0001001 | |
| 15 | 0000011 | 0000001 |
+---------+------------+------------+

1. how to correctly display as a string? when each [1] represents something.
   example webphp display:
   index(43) | ja-51dts, ja-20dbd
   index(15) | ja-51dbd, ja-20dbd, ca-20dbd

2. using 2 dropdown box <country> | <sound> to search values to display search result only?
   WHERE t_audio_'$country'!=NULL AND ...............[$sound]...?

^{^^^^^^^^^^}
my values are
[0] = 00
[1] = 01
[2] = 61dts
[3] = 51dts
[4] = 51dbdS
[5] = 51dbd
[6] = 20dbd
[7] = LPCM
[8] = Stereo
[9] = mono

or is there a better way to pouplate the database with different structure? i have 6 country with 10 bin each, i thought of using array but i don't know how to write correctly.
thanks for reading

[laserlight]

Um, you need to explain what you are working with, and what you are trying to do. The question doesnt make sense to me.

[hayato1]

Thanks for trying to help,
1)
I trying to display mysql values of 4 columns "t_audio_ja | t_audio_ca | t_audio_ch | t_audi_en" to string if they have t_audio_[*]==1 without the last comma.
if t_audio_en=1111111111 stands for a DVD which have this sound =
?, ?, EN[6.1 dts-ES], EN[5.1 dts], EN[5.1 dolby S. EX], EN[5.1 dolby digital], EN[2.0 dolby digital], EN[LPCM], EN[stereo], EN[mono],
http://anime.vaxva.com:8080/~data/d15.html
my data structure

INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (1, '00000001', '0000001', '', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (2, '', '', '000000001', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (5, '000101', '', '', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (7, '00101', '', '', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (8, '00000001', '', '', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (9, '0000001', '', '', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (10, '', '0000000001', '0000000001', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (11, '000001', '', '', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (12, '00000001', '', '', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (15, '0000011', '', '0000001', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (43, '0001001', '', '', '');
INSERT INTO `title` (`t_index`, `t_audio_ja`, `t_audio_ch`, `t_audio_ca`, `t_audio_en`) VALUES (64, '0000001', '0000001', '', '');

^{^^^^^^^}

2)
i trying to make a dropdown box which enable to conduct search as <lang=4types> AND <sound_effect=10types>, currently i only able to have messup search box because i wrote my code wrongly
as i having <lang option=4types> OR <sound_effect=40types>

thanks if you read again...

[laserlight]

function genAudioStr($prefix, $flags) {
	//array of audio values
	$array = array("00", "01", "61dts",
		"51dts", "51dbdS", "51dbd",
		"20dbd", "LPCM", "Stereo", "mono");
	//check that number of audio values match number of flags 
	if (($count = count($array)) == strlen($flags)) {
		$ret = '';
		for ($i = 0; $i < $count; $i++) {
			if ($flags{$i} == 1) {
				$ret .= $prefix . '-' . $array[$i] . ', ';
			}
		}
		return $ret;
	} else {
		return false;
	}
}

//sample use
$str = genAudioStr('ca', '1111111111');

[hayato1]

hmm thanks for the function but how do i apply to 4 columns? and conduct a search? if wants data contains "en" with mono OR "all" with stereo
//sample use
$ja=$row[t_audio_ja];
$ch=$row[t_audio_ch];
$ca=$row[t_audio_ca];
$en=$row[t_audio_en];
$str = genAudioStr('?', '?');
echo $str;

[laserlight]

how do i apply to 4 columns

Okay, I think that you are trying to tackle something that is really beyond you at this point if you need help to solve so simple a problem 🙁

Anyway, let's start with a simple question: what query would you write to select the required data from your database?

[hayato1]

SELECT * FROM data_base WHERE 1 $arg_s;

edited: i using this for the lang search (let '$s' be sound_lang, '$a' be audio_effect)
if ( $GET!=NULL) { $passthrough_s="&s=$s"; }// i use this for paging
if ( $GET==1) { $arg_s="AND t_audio_ja !=0"; }
elseif ( $GET==2) { $arg_s="AND t_audio_ch !=0"; }
elseif ( $GET==3) { $arg_s="AND t_audio_ca !=0"; }
elseif ( $_GET==4) { $arg_s="AND t_audio_en !=0"; }
else { $arg_s=""; }

[laserlight]

i using this for the lang search
if ( $_GET!=NULL) { $passthrough_s="&s=$s"; }// i use this for paging

You havent even solved your first problem yet, and you want to talk about lang search and paging.

[hayato1]

ok you dun want me to skip ........
Q1 "what query would you write to select the required data from your database?

ANS:
SELECT column1, column2FROM my_database1 WHERE column1 = 'required_data1'
AND column2 = 'required_data2';