mysql search/arama

[cem dermen]

veritabanım

Kod:

CREATE TABLE `user` (
`user_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`first_name` VARCHAR( 40 ) NOT NULL ,
`last_name` VARCHAR( 40 ) NOT NULL ,
`email` VARCHAR( 128 ) NOT NULL ,
`country` VARCHAR( 128 ) NOT NULL ,
`university_dep` VARCHAR( 250 ) NOT NULL ,
`university` VARCHAR( 250 ) NOT NULL ,
`phone` VARCHAR( 30 ) NOT NULL
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `editor` (
`editor_id` SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`editor` TEXT
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE `user_editor` (
`user_id` INT NOT NULL ,
`editor_id` SMALLINT NOT NULL ,
PRIMARY KEY ( `user_id` , `editor_id` )
) ENGINE = MYISAM ;

sorgu

Kod:

$data = mysql_query("SELECT * FROM editor WHERE editor LIKE '%ijas%' ORDER BY editor_id ASC LIMIT $baslangic,$limit");
while($info=mysql_fetch_array($data) )
{
Print "<tr>";
Print "<th>Editor:</th> <td>{$info['editor']}</td> ";
Print "<th>Name:</th> <td>{$info['first_name']}</td> ";
Print "<th>Surname:</th> <td>{$info['last_name']}</td> ";
Print "<th>Country:</th> <td>{$info['country']} </td>";
Print "<th>University:</th> <td>{$info['university']} </td>";
Print "<th>University Department:</th> <td>{$info['university_dep']} </td>";
Print"</tr>";
}

bnm yapmak istediğim.. kullanıcının/kullanıcılarının veri tabanında ijas diye kelime varsa, onların isimlerini soy isimleri filan yazdırsın..

ama sorguyu yazamadım...yrdım edebilirmisiniz?

[CoDeDaNCeR]

Kod:

<?php
$data = mysql_query("SELECT * FROM editor,user_editor WHERE editor LIKE '%ijas%' and  editor.editor_id=user_editor.editor_id ORDER BY editor.editor_id ASC LIMIT $baslangic,$limit"); 
while($info=mysql_fetch_array($data) )
{
$user=mysql_query("select * from user where user_id='$info['user_id']'");
while($yaz=mysql_fetch_array($user) )
{
Print "<th>Editor:</th> <td>{$yaz['editor']}</td> ";
Print "<th>Name:</th> <td>{$yaz['first_name']}</td> ";
Print "<th>Surname:</th> <td>{$yaz['last_name']}</td> ";
}
}

/* gibi... */

/* tabii verileri tablolara doğru şekilde girdiğini kabul edersek */


?>