Search results for query: *

hi i've got two tables Localization (Localization_Id,Localization_Left,Localization_Right) - indexes on Localization_Id PRI and on (Localization_Left,Localization_Right) Company (Company_Id,Localization_Id) - indexes on Company_Id PRI and another one for Localization_Id I use this query to...

i've got many tables but to describe my problem i think that will be enough. CREATE TABLE Elementy ( Elementy_Id varchar(20) NOT NULL default '', Elementy_Dane text, PRIMARY KEY (Elementy_Id) ); CREATE TABLE Linki ( Linki_Id mediumint(10) unsigned NOT NULL auto_increment...

hello :) I've query which use 2 inner joins i've thought that i use proper indexes but EXPLAIN showed that i'm wrong my tables: CREATE TABLE `telefony_Cechy` ( `Cechy_Id` int(10) unsigned NOT NULL auto_increment, `Cechy_Nazwa` varchar(255) collate utf8_polish_ci NOT NULL default ''...

Hi i've got database for site which has a data of many companies (1 milion rows in main table): CREATE TABLE `firmy_Firmy` ( `Firmy_Id` int(11) unsigned NOT NULL auto_increment, `Firmy_Nazwa` varchar(255) collate utf8_polish_ci NOT NULL default '', `Firmy_Opis` text collate...

i've got a a domain which runs over port 80, now i'd like move it to 443 on ssl. On this machine i 've many virt host running on 80. i can delegate another ip for ssl. <VirtualHost xx.xx.xx.xxx:80> ServerAdmin admin@example.com DocumentRoot /home/klienci/mia/strony_www/example.com...

How can i modify this query to make it work ? SELECT a.Zamowienia_Id ,DAYOFMONTH(a.Zamowienia_DataZamowienia) ,b.Uzytkownicy_Imie ,b.Uzytkownicy_Nazwisko ,c.SposobZaplaty_Nazwa ,d.RodzajPrzesylki_Nazwa ,a.Zamowienia_DataZamowienia ,a.Zamowienia_DataRealizacji...

Hi i've got a lot of old data which is encoded as latin2 and stored in tables with latin1 enc. How can i convert it and styrore in utf-8 table with utf-8 encoding? Any ideas ? Via-Net - web directory

Does flash can read variable from url? Let's say that movie is located on age http://www.example.com/index.php?var1=x&var2=y Can i access values from var1 and var2 ? Via-Net - web directory

helo i've got 2 tables Gallery Gallery_Id,Gallery_Name Images Images_Id,Gallery_Id,Images_Filename,Images_Width,Images_Height I'd like to select all galeries from Gallery and join Images to each gallery but i'd like to limit 3 images per gallery this code list all images from all galleries...

Hi i've got cisco 1601 as my router. It's been setup to work with support of frame relay protocol. So i have 2 interfaces: one ethernet, second Serial 0 and subinterface Serial 0.1 Now i've got a new set of ip addresses and i'd like to change it, but i can't change ii all at once - my old ip's...

Hi I've written program which spiders my site and save words to database (mysql). I used data as search engine data. My pages are coded in iso-8859-2 and i store it in db as utf-8 I was using Unicode::Lite to convert data. Now i moved on another server and there's no possibility to install...

Hi i'm including few files in php let's say that main program is in /var/www/tsest/index.php it's include 2 files include('/var/www/tsest/dir1/dir2/name1.php'); include('/var/www/tsest/dir1/dir2/name2.php'); how can i check inside name1.php path to this included file ? in name1.php code...

Hi http://katalog.robart.pl/Katalog/ Page looks different in IE and firefox I setup it for firefox by now i must to rearange divs. What make them look bad in IE ? Why tables inside div #tresc has moved down below end of #prawakol (which has float: right) tx in advance gry online

Is there any posibility to write perl script which itself doesn't request more resources thn 10% of system ? gry online

I have mysql server 4.1.2 I created tables without assigning any charset neither collation. I inserted data through perl to this table. Data was encoded in utf-8 and in this format i select it and show on the web. But i've ended tests and i must move whole database on another server with mysql...

CREATE TABLE `katglowny_Katalog` ( `Katalog_Id` int(11) unsigned NOT NULL auto_increment, `Katalog_Adres` varchar(255) NOT NULL default '', PRIMARY KEY (`Katalog_Id`), UNIQUE KEY `IX_Adres` (`Katalog_Adres`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `katglowny_Kategorie` (...

On http://test.motyl.no-ip.org/dlamechanika/ there is document with styles On firefox 1.0 it looks but on IE6 it looks bad. I'm trying to achieve efect |--------------------|---------| |#banner | | |--------------------| #obraz | |#napis | |...

Hi i've got a table Id,Name,Status,DateAdded,Rate So i'd like to select 5 newest records with status = 1 SELECT * FROM Table WHERE Status = 1 ORDER BY DateAdded DESC LIMIT 5 so i need here index on (Status,DateAdded) later i query for 100 top rated SELECT * FROM Table WHERE Status = 1...

Hi In this code after click, it should redirect here http://processaddress but it moves me http://addressforgoogle.pl is this possible to halt the original adres <a href="http://addressforgoogle.pl" onclick="window.location='http://processaddress';">some text</a> Webdesign

Hi i must sort this way ORDER BY IF((Katalog_NowaOcena > 0 && Katalog_OcenaIlosc > 0),(Katalog_NowaOcena*Katalog_OcenaWartosc/Katalog_OcenaIlosc),IF(Katalog_NowaOcena > 0,Katalog_NowaOcena,(Katalog_OcenaWartosc/Katalog_OcenaIlosc))) DESC where i should put indexes to reach max preformance...