SQL query Problem..

[thara]

hi.. every one.

 

I have a problem with a logic. this is it.....

I need select an one row from the database. when retrieving data sql query need to check some image type. That mean, I have these values 'Director, Manager, Principal etc.' and those value I used as image type in my database. Actually I need to get a image from db after matching its type.

 

I try to do it like this...

 

	$q = "SELECT image_id FROM institute_images 
		 WHERE institute_id = $instituteId AND image_type = " . 

	// Make the designaton array for check Image Type:
	$desig = array ( 'Managing Director', 'Manager', 'Director', 'The Principal', 'Deputy Principal', 'Proprietor', 'Assistant Manager', 'Head Master');	 

	$imageType = false;	 

	// check that file is of an permitted MIME type
	foreach ($desig as $type) {
		if ($type ) {
			$imageType = true;
			break;
		}
	}	 

	$r = mysqli_query ( $dbc, $q );			
	$numRows = mysqli_num_rows($r);

	if ( $numRows == 0) { 

 

 

it is little bit confusing me.. can anybody help me to fix this problem...

 

thank you

[SurrealScripts]

Hey thara,

Can you show us a structure of the database and an example of what you want to achieve? It should make it easier for me to understand what you want.

[thara]

Actually I need get a image from database and its type should be one of a value from my $designation array. The query should check $designation array's value with database table and if its match with one of a value in database then query can retrieve one row.