Results 1 to 4 of 4
Thread: php
Hybrid View
-
29th October 2010 12:00 #1Registered User
Join Date: Jul:2010
Location: burgas
Posts: 6
php
2
.
<?php
$df="4anta";
// MySQL connect information.
$c_username = "root";
$c_password = "";
$c_host = "localhost";
$c_database = "sait";
// Connect.
$connection = mysql_connect($c_host, $c_username, $c_password)
or die ("It seems this site's database isn't responding.");
mysql_query('set names utf8_general_ci', $connection);
mysql_select_db($c_database)
or die ("It seems this site's database isn't responding.");
$SQL3 = "SELECT * FROM `obiavi,lichni` WHERE `text` LIKE '%$df%' AND `text` LIKE '%$df%' ";
$result3 = mysql_query($SQL3);
while($db_field = mysql_fetch_assoc($result3))
{
echo"
$db_field[text]
";
}
?>
-
29th October 2010 13:03 #2Registered User
Join Date: Dec:2003
Posts: 2,817
UNION Mysql-a - , , ..
Gigabyte DS3P, E4400@9x333, 2x2Gb Super T@1000Mhz, Gigabyte GTX460OC 768Mb
-
29th October 2010 15:52 #3Registered User
Join Date: Jul:2010
Location: burgas
Posts: 6
$SQL3 = "(SELECT `den1`,`text`,`mesec1`,`godina1`,`chas`, `srok`,`goliama`,`malka`,`grad`,`den`,`m esec`,`godina`,`telefon` FROM `obiavi` WHERE `text` LIKE '%$searchDuma%') UNION (SELECT `den1`,`text`,`mesec1`,`godina1`,`chas`, `srok`,`goliama`,`malka`,`grad`,`den`,`m esec`,`godina`,`telefon` FROM `lichni` WHERE `text` LIKE '%$searchDuma%')";
-
30th October 2010 14:40 #4
:
:Code:$SQL3 = " SELECT * FROM `obiavi,lichni` WHERE `text` LIKE '%$df%' AND `text` LIKE '%$df%' ";
- OR AND, .Code:$SQL3 = " SELECT * FROM obiavi, lichni WHERE obiavi.text LIKE '%$df%' AND lichni.text LIKE '%$df%' ";
zlozi, - $df, , .Fujistu Lifebook E756 | Core i7-6500U / 400MHz-3.1GHz | 8 GB DDR4-2133 | Samsung PM871 / 256 GB SSD | 15" 1920x1080 | Manjaro Linux + kernel 4.19




Reply With Quote
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in