[PHP] Re: creating ZIP file from mySQL content?

2001-09-10 Thread BRACK
Like Music? Buy a CD: > http://l-i-e.com/artists.htm Volunteer a little time: > http://chatmusic.com/volunteer.htm - Original Message - From: > Brack <[EMAIL PROTECTED]> Newsgroups: php.general To: > <[EMAIL PROTECTED]> Sent: Saturday, September 08, 2001 6:57 AM

RE: [PHP] mod_rewrite

2001-09-09 Thread BRACK
> > Subdomains are first a DNS issue... The first place you have to go is > your DNS config, since users.body-builders.org wouldn't exist without > an A or CNAME record. My subdomains do not have DNSs =(( and I'm not sure if I can change this issue with .htaccess > > I don't know if mod_rewrit

[PHP] mod_rewrite

2001-09-09 Thread BRACK
I have a website URL www.body-builders.org and users have URLs like www.body-builders.org/user According to the virtual hosting rules I can do any configuration tweaks by .htaccess file. What I want to do is to offer my users URLs like users.body- builders.org Is it possible to do with rewrite

[PHP] creating ZIP file from mySQL content?

2001-09-08 Thread BRACK
I have a site where ppl can upload their text-based ideas in real time, so that I have new records in db every day. When I did uploading by hands and had over 200 files on that site I distributed all site content in downloadable for of zipped win-help formate. Well, I don't think that I can do

Re: [PHP] FULLTEXT search sorting results

2001-09-04 Thread BRACK
category.kat_name like '%$category_search%') and (skits.category like category.cat_id) ORDER by relevance desc limit $limit,10"); Works fine, (I actually changed '&&' with 'and' as you see) Youri > On Mon, 3 Sep 2001 19:33:38 +0200, BRACK ([EMAIL PR

[PHP] FULLTEXT search sorting results

2001-09-03 Thread BRACK
Hi, I asked recently to help with the selection for FULLTEXT search and now with your help I found how to do that but I still have problem with advansed search. This is what I have right now: $result = mysql_query("SELECT skits.*,category.* from skits,category where (skits.title like '%$tit

[PHP] detection of relevance

2001-09-03 Thread BRACK
I have made a detetor of relevance in found results in form of colored ine od length depended on relevance. I did it this way: In query I inserted match (...,...,...) against ('%$var%') as relevance in while loop I inserted $relevance = $row["relevance"]; $rel = round($relevance); print "\n";

Re: [PHP] FULLTEXT search sorting results

2001-09-02 Thread BRACK
Works fine, thank you Youri > On Sat, 1 Sep 2001 14:01:57 +0200, BRACK ([EMAIL PROTECTED]) wrote: >I > have query - > >$res = mysql_query("SELECT > >skits.*,category.cat_id,category.cat_name FROM skits,category WHERE > >MATCH (title,descr,skits) AGAINST ('%$

[PHP] FULLTEXT search sorting results

2001-09-01 Thread BRACK
I have query - $res = mysql_query("SELECT skits.*,category.cat_id,category.cat_name FROM skits,category WHERE MATCH (title,descr,skits) AGAINST ('%$search_idea%') and skits.lang like 'English' and skits.category like category.cat_id limit $limit,10 "); I expect to get results sorted by relev

Re: [PHP] Re: how to sort search results by relevance? thanks

2001-08-30 Thread BRACK
Oh yeah! I just had old MySQL manual but I have upgraded MySQL and this function is working in my version, just was not described in docs Okay, thank you for help, I managed to do it. > On Wed, 29 Aug 2001 13:58:34 +0200, BRACK ([EMAIL PROTECTED]) wrote: >> > In article <3B8A

Re: [PHP] Re: how to sort search results by relevance?

2001-08-29 Thread BRACK
On 29 Aug 2001, at 9:18, Mark Maggelet wrote: > On Wed, 29 Aug 2001 13:58:34 +0200, BRACK ([EMAIL PROTECTED]) wrote: > >> In article <3B8A1D6A.4295.2947D@localhost>, [EMAIL PROTECTED] > >> (Yura) wrote: > >> > >> > How to sort search results of

[PHP] Re: how to sort search results by relevance?

2001-08-29 Thread BRACK
> In article <3B8A1D6A.4295.2947D@localhost>, [EMAIL PROTECTED] > (Yura) wrote: > > > How to sort search results of php-mysql site by relevance? > > See the mysql manual's chapter on FULLTEXT indexes. I indexed column 'text' and tried to add "ORDER BY text DESC" in query and deleted wildcards

[PHP] $i % 2 ? 0:

2001-08-25 Thread BRACK
Hi Can someone explain to me what "$i % 2 ? 0:" means or what it does step by step? I was looking in PHP docs for "?" and ":" and didn't find it there. I use this line in my script to assign different value for $bgcolor variable to color rows in result, but I want to understand what does it m

[PHP] Re: HELP!!!

2001-08-25 Thread BRACK
ith > http://php.net/mysql_error like sending it to http://php.net/error_log or > something. > > -- > WARNING [EMAIL PROTECTED] address is an endangered species -- Use > [EMAIL PROTECTED] > Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm > Volunteer a little

[PHP] HELP!!!

2001-08-24 Thread BRACK
I have a script with combination: $ins_u = @mysql_query("INSERT INTO users (name,email) VALUES ('$u_name','$u_email')"); $userid = @mysql_insert_id($ins_u); It's working fine on local server but now I put it on the web and it sais: Warning: Supplied argument is not a valid MySQL-Link res

[PHP] Re: strange error

2001-08-23 Thread BRACK
if you have structure like then you need to insert "}" before " or if you use syntax you have to insert "endif;" If you think you did it but still have an error, try to count your "if" statements and "endif;" maybe something is missing. Youri -- PHP General Mailing List (http://www.php

Re: [PHP] Errors

2001-08-21 Thread BRACK
d it. > > Two ways around this - either set the variable $page to something first, or > fix the php.ini file to stop being so fussy... try setting error_reporting > to 7. > > (Newbie advice only, so take with a pinch of salt) > > - Original Message - > From:

[PHP] Re: sendmail

2001-08-21 Thread BRACK
Thank you for advise, I think I'll use .htaccess and that would be fine. But why do I need to include ""? I'm using in on my local Apache win32 without "" even though I understand what is "string" Youri On 19 Aug 2001, at 16:01, Richard Lynch wrote: > > I'm on virtual hosting that lets me con

[PHP] Errors

2001-08-19 Thread BRACK
Hi I'm getting strange errors if I add "LoadModule php4_module ../php/sapi/php4apache.dll" to http.conf If I don't load it everything is working with php.exe without any errors but as I load it as a modul I get for example - Warning: Undefined variable: page in d:\abria sql\apache\htdocs\inc\

[PHP] sendmail

2001-08-19 Thread BRACK
Hi, I'm on virtual hosting that lets me configure anything with .htaccess file. I was recomended by provider to specify location of sendmail in case I want to use php mail() function I know that I may do it in .htaccess file by adding php_value sendmail_path /usr/sbin/sendmail The qwestion is

[PHP] qwestion about %E6%E2%E0%F7%EA%E0

2001-08-14 Thread BRACK
Hi thanx to everyone I solved the problem by updating my php and inserting upper() in queries. Now I can insert whatever case in search field and get case insensitive result. Youri -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional com

Re: [PHP] qwestion about %E6%E2%E0%F7%EA%E0

2001-08-14 Thread BRACK
tin2', `sjis', `swe7', `tis620', `ujis', `usa7', or > `win1251ukr'. *Note Character sets::. > > -- > Canaan Surfing Ltd. > Internet Service Providers > Ben-Nes Michael - Manager > Tel: 972-4-6991122 > http://si

[PHP] qwestion about %E6%E2%E0%F7%EA%E0

2001-08-14 Thread BRACK
Hi I'm doing the script for searching the mySQL db in Russian language. but output of textform http://localhost/indexr.php3?search_idea=%E6%E2%E0%F7%EA %E0 is not the same as http://localhost/indexr.php3?search_idea=%C6%C2%C0%D7%CA %C0 (this is the same word but first is lower case and second

Re: [PHP] charset win1251

2001-08-13 Thread BRACK
Hi Maxim, You are probably only one in this mailing list with experiance of work with russian language in PHP, I have another qwestion concerning Opera and textarea - I can't make Opera to accept cyrillic text in textareas, I mean I can type in Russian but can't insert russian text (tried var

RE: [PHP] MySQL connection

2001-08-09 Thread BRACK
27;t be made. > > No code is shown, just a line number. If, in your > > case, PHP dumps the > > source code to the browser window when the db > > connection won't work, > > then something has to be wrong. :) > > > > --Matt > > > > > &g

[PHP] charset win1251

2001-08-09 Thread BRACK
I'm tired... I finished English version of my site and wanted to start Russian part but realized that MySQL server returnes all data in koi-8r charset which is not very comfortable for some of the users, specially I know that A LOT of russians using Opera brawser older versions of which do no

Re: [PHP] MySQL connection

2001-08-09 Thread BRACK
oing to get: > > > > Warning: Unknown MySQL Server Host... > > Warning: MySQL Connection Failed... > > > > No usernames/passwords. I have to say however that I > > always include my connect.php file. Maybe that's a > > secure way to connect without

[PHP] last modification time

2001-08-08 Thread BRACK
Is there any function that can fetch a time of last modification of the remote document. For example I have a links based on the MySQL database, and I want to know what linked site was most resently renewed. Thank you Youri -- PHP General Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP] MySQL connection

2001-08-08 Thread BRACK
Hi, > > > I think BRACK a.k.a. Jouri means that the connection > string (from the PHP pages) would be visible in the > client's browser once the SQL server stops running. > However, I am not so sure about this as all commands > are processed on the server - it will, howev

RE: [PHP] MySQL connection

2001-08-08 Thread BRACK
to how the "hacker" would see all this information (the > username.. password, etc..) just by going to a site where the SQL backend > was down? > > Ryan > > > -Original Message- > > From: BRACK [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, August

Re: [PHP] MySQL connection

2001-08-08 Thread BRACK
xist. > > Tyler Longren > Captain Jack Communications > [EMAIL PROTECTED] > www.captainjack.com > > > On Tue, 7 Aug 2001 21:35:58 +0200 > "BRACK" <[EMAIL PROTECTED]> wrote: > > > I just wanned to bring the issue of security of MySQL connection:

[PHP] MySQL connection

2001-08-07 Thread BRACK
I just wanned to bring the issue of security of MySQL connection: Let us imagine that SQL server was down for some hours (of course without us knowing it) and at the same hours our SQL site was visited by some kind of hacker, he can see on his screen all our SQL connection info like username,

[PHP] Syntax

2001-08-03 Thread BRACK
Thank you everyone who replied on my treat "Syntax" There was just a typo and problem is solved Youri <>< <>< <>< <>< God is our provider ><> ><> ><> ><> http://www.body-builders.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional com

[PHP] Syntax

2001-08-02 Thread BRACK
Hi, I'm in a process of doing site with MySQL database, and most of the code I plased in index.php3 (in one file) but I've got some problems with statements: I have: if (isset(...)) { ... } elseif (isset(...)) { ... } elseif (isset(...)) { ... } else { ... } IT DOESNT WORK! but when I do: i

[PHP] Re: PHP EDITOR 4 WINDOWS?

2001-08-01 Thread BRACK
AceHTML4 Pro http://www.visicommedia.com/ On 1 Aug 2001, at 12:08, Kyle Smith wrote: > --=_NextPart_000_0018_01C11A82.B809B880 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Does it really exist? If so could someone post some URL

Re: [PHP] Re: What tools do you use to develop PHP?

2001-08-01 Thread BRACK
I tried PHPEd and PHP Coder but still came back to my favorite AceHTML4 Pro from visicom.com They have quite good customizable PHP wizard so you should try this one it's not expencive but MUCH more featured then HomeSite. BRACK -- PHP General Mailing List (http://www.php.net

[PHP] How to split results on multiply pages?

2001-07-29 Thread BRACK
Hi, I've made a nice working skript for managing MySQL database of about 300 records (this is my first PHP script). But I don't know how to split search results on pages? Does anyone have an example of such script for me to work on it and understand how it works? My script is done as if: el