Mavzu: MySQL so'rovlar bo'yicha yordam

64. YNWA (1) [off] | TXT | 34| 11 Sep 2017, 02:15 Mehmonlar Iwlamayaoti (Gosti) korinmayapti qande tugrilasa boladi

65. Mc_jas (64) [off] | TXT | 34| 12 Sep 2017, 00:48 Manga reyting kodi kerak saytda utgan kunni xoxlagancha qiliw

66. Tayotabek (1511) [off] | TXT | 34| 10 Dec 2017, 21:10 Savol.
Bita özgaruvchiga 2ta ustuni chiqarish kerak.
$uz = mysql_query("SELECT * FROM `users` where `user_id` = '$user_id' order by `id` ASC limit $start, $kmess);
.
$uzbek = mysql_query("SELECT * FROM `news` where `user_id` = '$user_id' order by `id` ASC limit $start, $kmess);
.
Manashu 2ta mysqlni bita özgaruvchiga yozish kerak yordam .
Bunaqa qildim bömadi
$uza = mysql_query("SELECT * FROM `users`,`news` where `user_id` = '$user_id' order by `id` ASC limit $start, $kmess);

67. MeGaBoY (29) [off] | TXT | 34| 28 Dec 2017, 18:52 Smile ochirish kodini yozib beringlar

68. Tayotabek (1511) [off] | TXT | 34| 2 Jan 2018, 00:34 unsigned qöshilsa nima bölardi malumot auto idga öxshab kirarmidi yo boshqamidi?

69. ChaqMoq (22) [off] | TXT | 34| 9 Feb 2018, 21:37 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `obmennik_files`;
CREATE TABLE IF NOT EXISTS `obmennik_files` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL,
`id_dir` int(11) NOT NULL,
`name` varchar(128) NOT NULL,
`ras` varchar(36) NOT NULL,
`type` varchar(64) NOT NULL,
`time` int(11) NOT NULL,
`time_last` int(11) NOT NULL,
`size` int(11) NOT NULL,
`k_loads` int(11) default '0',
`opis` text NOT NULL,
PRIMARY KEY (`id`)
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `obmennik_dir`;
CREATE TABLE IF NOT EXISTS `obmennik_dir` (
`id` int(11) NOT NULL auto_increment,
`num` int(11) NOT NULL,
`name` varchar(64) NOT NULL,
`ras` varchar(128) NOT NULL,
`maxfilesize` int(11) NOT NULL,
`dir` varchar(512) NOT NULL default '/',
`dir_osn` varchar(512) default '/',
`upload` set('1','0') NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `num` (`num`),
KEY `dir` (`dir`(333))
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Статьи' AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `loads`;
CREATE TABLE IF NOT EXISTS `loads` (
`id` int(11) NOT NULL auto_increment,
`file` varchar(64) NOT NULL,
`size` int(11) NOT NULL,
`loads` int(11) NOT NULL,
`path` varchar(128) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `loads_komm`;
CREATE TABLE IF NOT EXISTS `loads_komm` (
`id` int(11) NOT NULL auto_increment,
`file` varchar(64) NOT NULL,
`size` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(512) NOT NULL,
`id_user` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `file` (`file`),
KEY `size` (`size`)
INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (4, 'Загрузки', '/loads/', 'loads/count.php', 6);

INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (11, 'Файлобменник', '/obmen/', 'obmen/count.php', 9);


DROP TABLE IF EXISTS `obmennik_dir
`;

CREATE TABLE IF NOT EXISTS `obmennik_dir` (
DROP TABLE IF EXISTS `obmennik_files`;

DROP TABLE IF EXISTS `obmennik_files`;


CREATE TABLE IF NOT EXISTS `obmennik_files` (


DROP TABLE IF EXISTS `loads
`;

CREATE TABLE IF NOT EXISTS `loads` (


`loads` int(11) NOT NUL
L,

DROP TABLE IF EXISTS `loads_komm`;


CREATE TABLE IF NOT EXISTS `loads_komm`
(

CREATE TABLE IF NOT EXISTS `loads_komm` (

DROP TABLE IF EXISTS `loads_komm`;

`loads` int(11) NOT NULL,
CREATE TABLE IF NOT EXISTS `loads` (

DROP TABLE IF EXISTS `loads`;

CREATE TABLE IF NOT EXISTS `obmennik_files` (

DROP TABLE IF EXISTS `obmennik_files`;
INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (11, 'Файлобменник', '/obmen/', 'obmen/count.php', 9);

INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (11, 'Файлобменник', '/obmen/', 'obmen/count.php', 9);

INSERT INTO `menu` (`id`, `name`, `url`, `counter`, `pos`) VALUES (4, 'Загрузки', '/loads/', 'loads/count.php', 6);


Do'stlar mana shu sql ni qanday bitta sql zabros qilib bazaga jo'natsam bo'ladi ortiqcha joylarini olib kamchiliklarini to'g'irlab bitta yaxlit sql zabros qilib beringlar biladiganlar bo'lsa iltimos

70. STRaKER (73) [off] | TXT | 34| 10 Feb 2018, 00:15 ChaqMoq, birinchi ikki qatorini olib tashlasez bo'ldikan, yoki boshlanish qisminiyam qo'shsez butun bo'lardi keyin phpmyadmin dan sql degan joyiga vstavit qib jo'natasiz tamom