[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

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_rewrite can

[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

Re: [PHP] FULLTEXT search sorting results

2001-09-04 Thread BRACK
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 PROTECTED]) wrote: $result = mysql_query(SELECT skits.*,category.*,match (skits.title,skits.descr,skits.skits) against ('$relev') as from oops, should

[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 img

[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

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 ('%$search_idea%') and skits.lang like 'English

[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

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 3B8A1D6A.4295.2947D

[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 in front

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-mysql site by relevance? See the mysql manual's chapter

[PHP] Re: HELP!!!

2001-08-25 Thread BRACK
. -- 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 time: http://chatmusic.com/volunteer.htm - Original Message - From: Brack [EMAIL PROTECTED] Newsgroups

[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 mean.

[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

[PHP] Re: strange error

2001-08-23 Thread BRACK
if you have structure like html ?php if (isset(...)){ ...; } elseif (isset()){ } else { ... ? /html then you need to insert } before /html or if you use syntax html ?php if (isset()): ...; elseif (isset()): ...; else: ...; ? /html you have to insert endif; If you think you did it but still have

[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 configure

Re: [PHP] Errors

2001-08-21 Thread BRACK
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: BRACK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

[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

[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

[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] qwestion about %E6%E2%E0%F7%EA%E0

2001-08-14 Thread BRACK
Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http://sites.canaan.co.il -- - Original Message - From: BRACK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 11:28 AM Subject: [PHP] qwestion about %E6%E2%E0%F7%EA%E0 Hi

[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

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

Re: [PHP] MySQL connection

2001-08-09 Thread BRACK
way to connect without anyone seeing your password in case of sqlserver problems. Greetz, Bjorn Van Simaeys www.bvsenterprises.com --- BRACK [EMAIL PROTECTED] wrote: If you have Apache and MySQL servers make this experiment - start Apache but forget to start SQL

[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

RE: [PHP] MySQL connection

2001-08-09 Thread BRACK
to the browser window when the db connection won't work, then something has to be wrong. :) --Matt -Original Message- From: BRACK [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 5:57 AM To: Attila Strauss Cc: [EMAIL PROTECTED] Subject: Re: [PHP] MySQL connection

Re: [PHP] MySQL connection

2001-08-08 Thread BRACK
, 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, however display an error message that the SQL

Re: [PHP] MySQL connection

2001-08-08 Thread BRACK
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: Let us imagine that SQL server was down for some hours (of course without us

RE: [PHP] MySQL connection

2001-08-08 Thread BRACK
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 07, 2001 12:36 PM To: [EMAIL PROTECTED] Subject: [PHP] MySQL connection

[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,

[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 commands, e-mail: [EMAIL

[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:

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: