Results 1 to 17 of 17
Thread: MySQL
Hybrid View
-
10th April 2008 23:19 #1
MySQL
. MySQL. , , . , "12", , , 12, 1 2. MySQL 12 , , 1,2,12 3.
.
-
11th April 2008 00:01 #2
-, . , 1 2 , 12?
, , , . .
- , , , :
1 1
1 2
1 12
2 4
join , (, , , ). "1" "1" . -, , ( ), . ( , . ) . .
- , - . , , -, , .
.. "" "". ' .Last edited by Bombera; 11th April 2008 at 00:08.
EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|
-
11th April 2008 00:08 #3, ., 1 2 , 12?
, 1 -. - . :
-> VitalPHP Code:$grabProducts = @mysql_query("SELECT DISTINCT p.* FROM Vital_products AS p, Vital_categories AS c, Vital_series AS s WHERE p.Active = '1' AND s.Active = '1' AND p.Cid REGEXP '$catId' AND TitleEn IS NOT NULL AND TextEn IS NOT NULL ORDER BY p.Id DESC LIMIT ".$paging -> _offset.", ".$perpage."") or die(mysql_error());
Id -
Bid -
Sid -
Cid -
...
-
11th April 2008 00:08 #4Registered User
Join Date: Jul:2001
Location: Redmond, USA
Posts: 1,699

http://thedailywtf.com/ ? / - ?Soltek 75FRN2-RL bred "B" 1700+ : 1466@2300(11.5x200) 1.85V 512 MB DDR333 TwinMOS: 11-3-3-2@2.8V Leadtek Geforce4Ti 4200 128 MB : 300/600 80GB Seagate 7200.7 CDROM 48x BenQ Enermax EG365P-VE/FCA 350W Creative DT2200 5.1 Middle Tower Water Cooling
-
11th April 2008 00:22 #5
-
11th April 2008 00:32 #6
. , . , REGEXP : (- ), , . - , , , . , , , 9 19, 295 .. , , .
, ,
"no, no"
, , . (- ) , , . sid e , cid . .
?Last edited by Bombera; 11th April 2008 at 00:38.
EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|
-
11th April 2008 00:35 #7
.
.
.. . - "-, | " .. .
:
PHP Code:$catId => (int)$_GET["category"];
( )PHP Code:$product_group = @implode(",", $_POST["product_group"]);
( multiple field)Code:<option value="<?php echo $c["Id"];?>"<?php echo ((ereg($c["Id"], $r["Cid"])) ? " selected" : "");?>><?php echo $c["NameBg"]; ?></option>
-
11th April 2008 00:50 #8Code:
... p.Cid REGEXP '$catId' ...
FIND_IN_SET , :Code:... FIND_IN_SET('$catId', p.Cid) > 0 ...
Code:mysql> SELECT FIND_IN_SET('2', '1,2,3'), FIND_IN_SET('2', '1,22,3')\G *************************** 1. row *************************** FIND_IN_SET('2', '1,2,3'): 2 FIND_IN_SET('2', '1,22,3'): 0 1 row in set (0.00 sec)Internet - it doesn't make you stupid, it just makes your stupidity more accessible to others
-
11th April 2008 00:55 #9
:
(^[0-9]*$)|(,[0-9]*,)|(,[0-9]*$)EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|
-
11th April 2008 09:48 #10
. , '9' '1,91,5,6,9' - ',9,' ',1,91,5,6,9,'
i7-3930K@4.7(47x100, 1.41v), EK Supreme HF, Phobya G-Changer 420, XSPC Laing DDC Dual + Pump, Asus Rampage IV Formula, 4x2G RipjawsZ 2133MHz, GTX980Ti EVGA w/ EK-FC Titan, CM ATCS 840, Corsair AX1200, Corsair Force 3 120GB, HP ZR2740w
-
11th April 2008 12:35 #11
- , ..
- .. , .
, icaci. ! * *PHP Code:$grabProducts = @mysql_query("SELECT DISTINCT p.* FROM Vital_products AS p, Vital_categories AS c, Vital_series AS s WHERE p.Active = '1' AND s.Active = '1' AND FIND_IN_SET('$catId', p.Cid) AND TitleEn IS NOT NULL AND TextEn IS NOT NULL ORDER BY p.Id DESC LIMIT ".$paging -> _offset.", ".$perpage."") or die(mysql_error());
-
11th April 2008 14:35 #12
, - :
( ) , "12", "1" "2", :
Code:$string = "1,2,12,21,111,222,12121212121212,bla bla bla"; $regexp = "[12]{2}"; $string =~ /$regexp/isg;
-
11th April 2008 14:42 #13
-
11th April 2008 14:52 #14
, , .
EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|
-
11th April 2008 15:04 #15$catId p.Cid ? .(^[0-9]*$)|(,[0-9]*,)|(,[0-9]*$)
-
11th April 2008 15:56 #16. ( $ regexp):Code:
'(^'.$catId.'$)|(,'.$catId.',)|(,'.$catId.'$)'
"SELECT DISTINCT p.* FROM Vital_products AS p, Vital_categories AS c, Vital_series AS s WHERE p.Active = '1' AND s.Active = '1' AND p.Cid REGEXP '".'(^'.$catId.'$)|(,'.$catId.',)|(,'.$catI d.'$)'."' AND TitleEn IS NOT NULL AND TextEn IS NOT NULL ORDER BY p.Id DESC LIMIT ".$paging -> _offset.", ".$perpage.""
$catId, .
, . .EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|
-
11th April 2008 16:10 #17




Reply With Quote

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