Re: [PHP] Installing PEAR

2011-01-25 Thread a...@ashleysheridan.co.uk
d into your app directories or in an include path that apache is aware of and things will just work, so that might be a viable solution if the repositories don't work out. Thanks, Ash http://www.ashleysheridan.co.uk - Reply message - From: "Shawn McKenzie" Date: Tue, Jan 25, 2011 1

Re: [PHP] ldap_add - Server is unwilling to peform

2011-01-26 Thread a...@ashleysheridan.co.uk
You could add a line in to your code: include "ldap-blue-pill"; That should fix any performance issues ;) (note, I did try posting earlier with a much funnier reply, but the email was rejected because of a certain 'v' word!) Thanks, Ash http://www.ashleysheridan.co.uk

[PHP] problem with sending AT command in php

2011-11-12 Thread a dehqan
In The Name Of Allah The compassionate merciful Hello ; Am trying to send AT commands to my GSMmodem device , in linux with PHP Am sure it is /dev/ttyusb1 But with [URL="http://pastebin.com/aut4ygXf"]this code[/URL] device respond the same command and code prints that command e.g if we send ATD00

Re: [PHP] problem with sending AT command in php

2011-11-12 Thread a dehqan
dio_write($handle, 'AT') & dio_write($handle, "AT") make firefox times out on Waiting for localhost ... . But dio_write($handle, "AT\n") makes it prints AT exactly the same command or A > A , .. On Sat, Nov 12, 2011 at 10:02 PM, Negin Nickparsa wrote: > are you sure about ATD03518726535\

Re: [PHP] problem with sending AT command in php

2011-11-15 Thread a dehqan
\n is for Linux \r is for Windows On 11/14/11, Richard Quadling wrote: > On 12 November 2011 20:02, a dehqan wrote: >> dio_write($handle, 'AT') & dio_write($handle, "AT") make firefox times out >> on Waiting for localhost ... . >> But dio_write($h

Re: [PHP] problem with sending AT command in php

2011-11-18 Thread a dehqan
Quadling wrote: > On 15 November 2011 15:12, Mike Mackintosh > wrote: > > > > > > On Nov 15, 2011, at 8:25, Richard Quadling wrote: > > > >> On 15 November 2011 11:50, a dehqan wrote: > >>> \n is for Linux > >>> \r is for Windows

Re: [PHP] Dynamic PHP links

2005-02-13 Thread Ryan A
Hey, The reason your pal warned you against that approach is, someone could screw with your url with something like this: index.php?content=/etc/httpd/.dbmpasswd which would include that file if it exists...its a security problem, be careful and know EXACTLY what you are including/requiring

[PHP] Catalog or cart

2005-03-01 Thread Ryan A
Hey all, I have a client who has a computer store, now he wants to put all his stuff in one site. He does not want to do any selling from his site, but just list all his items. After looking via google and the the usual script sites, agora cart looks pretty good and easy to maintain, other

RE: [PHP] Catalog or cart

2005-03-02 Thread Ryan A
Hey all, Thanks guys, I'm checking the ones you recommended and taking most of your advise ;-) Feel free to write in if you missed anything in your old reply or have new recommendations. Cheers, Ryan > Hey all, > I have a client who has a computer store, now he wants to put al

[PHP] software catalog

2005-03-08 Thread Ryan A
Hey! Anybody know of a "software catalog" (or cart preferably) that is free? A site i am working for sells software, now they want to have a cart feature so people can put the packages in a cart and get discounts etc if they purchase more than 1 product...they are using 2checkout for

RE: [PHP] software catalog

2005-03-09 Thread Ryan A
Hey, Thanks for replying. Searching for shopping cart php gives me hundreds of results, mostly carts for tangible items. I was hoping someone could recommend a solution that they have used as since nearly all of us work for other people or make software to sell...this must be pretty common. Drop

Re: [PHP] software catalog

2005-03-09 Thread Ryan A
Hey! Thanks for replying. Hot scripts and script search ware the two places which i checked out first before writing to the list, then google, because I dont need a jackass who has been on the list for 2 days telling me to f***ing google for it, just coz it would make him feel happy with himself

Re: [PHP] a new it company

2005-03-09 Thread Ryan A
> here here - I thought It was kind of humourous, I also bare in mind > > that these guys in the far east are just trying to make their way in the > > world too, they are at a disadvantage with the language also. besides > > which there is a quite a culture gap - I noti

[PHP] Ad software

2005-03-15 Thread Ryan A
Hey, I am looking for a software that just lists adverts... eg: Like ebay but without the bidding Requirements are simple, so simple that i am sure something like this exists and i dont have to write it myself: 0.They must register first then... 1.offer the person to put in his ad details, a few

Re: [PHP] New Website for PHP Coders.. www,lifenit.com

2005-03-18 Thread Ryan A
Stupid damn sites dont even open, get yourself some decient hosting...and after you do that DONT SPAM THIS LIST,DUMBASS. On 3/17/2005 8:22:17 PM, freshersworld .com ([EMAIL PROTECTED]) wrote: > Hi All, > > > > This is a very interesting website. > > > > Visit www.lif

[PHP] multiple words search query advise

2005-03-20 Thread Ryan A
Hi, We have an a auction like site, now we have to add a search feature to the site, the searching will be done for 2 fields: subject and description (ad_sub, ad_text). Since i have never done this before, I would appreciate some advise on how to do it. I was thinking of getting the search

Re: [PHP] multiple words search query advise

2005-03-21 Thread Ryan A
Hey! Thanks! I'll look it up. -Ryan On 3/21/2005 5:53:38 AM, Brent Baisley ([EMAIL PROTECTED]) wrote: > You want to use a full text index spanning the two fields. You > wouldn't > want to do a "LIKE" search because that wouldn't be able to use > > > in

[PHP] Full-text searches sucks?

2005-03-21 Thread Ryan A
Hey all, I just put in a search function for a site using mySql full text, i am running it on my local server for now. I am running it on two fields: ad_sub and ad_text The results i getting are really quite bad, this is how i am testing it out: 1. I wrote an insert statement and looped it 700

Re: [PHP] Full-text searches sucks?

2005-03-21 Thread Ryan A
only mysql 4.1+ compatable, I presently DO have a 4.1 setupbut if we shift hosts...i dont want it to "break" my code. Thanks, Ryan On 3/21/2005 8:03:39 PM, [EMAIL PROTECTED] wrote: > > which means because I i getting a match for well over 50% of the > > > records..

Re: [PHP] Full-text searches sucks?

2005-03-22 Thread Ryan A
Hey, > > I dont want to do that as its only mysql 4.1+ compatable, > > IN BOOLEAN MODE was added in version 4.0.1 not 4.1, for what it's > worth. Oops, thats what i meant. The problem is a LOT of hosts are still on 3.23.xx so I dont want to do the BOOLEAN MODE thing. -Ryan

[PHP] count with match probelm

2005-03-22 Thread Ryan A
Hi, I am running this kind of a statement: $q=mysql_query("select cno,date_and_time,MATCH(ad_sub, ad_text) AGAINST('$words') AS score from ".$tcname."ads WHERE MATCH(ad_sub, ad_text) AGAINST('$words') AND is_confirmed=1 LIMIT $limit1, $limit2"); which is r

[PHP] GIF instead of JPG..

2005-03-22 Thread Ryan A
Hi, I found this beautiful piece of code on the php site which make a proportional thumbnail, problem is its only working with JPEG files...and not with GIFs, can someone please help me convert it to GIF too? I tried but got a bit confused as there are no functions that are equal to

Re: [PHP] GIF instead of JPG..

2005-03-23 Thread Ryan A
Hey! Thanks for sharing mate! I'll run it and get back to you if I have any problems. Cheers, Ryan On 3/22/2005 10:49:42 PM, Andras Kende ([EMAIL PROTECTED]) wrote: > > Hi, > > > I found this beautiful piece of code on the php site which make a > > > proportio

RE: [PHP] GIF instead of JPG..

2005-03-23 Thread Ryan A
Hey! Thanks for replying. I started out to do exactly that: changeing everything from JPEG to GIF, but I also wanted to know what exactly i was doing so i started to read the manual for each function that i was using and i got a bit stumped when i came to "imagecreatetruecolor" as it

Re: [PHP] GIF instead of JPG..

2005-03-23 Thread Ryan A
Hey, Thanks for replying. The best part of your reply was: "Or, you could even use http://php.net/imagegetsize and IGNORE the filename, and base your decision on what's actually *IN* the file, so when some idiot renames a jpeg to ".gif" because they think that will make

Re: [PHP] Borrowed code- how to give credit

2005-03-23 Thread Ryan A
Well, if your code is open source or you are distributing the code add a comment right on top of the file like this /* This line's : code here original author was, and I am very greatful to this person for writing this beautiful piece of code that i am useing */ maybe? :-) Cheers, Ryan On

Re: [PHP] Borrowed code- how to give credit

2005-03-23 Thread Ryan A
> And if you make money from it, send them some money for the effort. > yep, money would really tell the author you appreciate his contribution / what he thought of. :-) -Ryan -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 -

[PHP] Avoiding SQL injections: htmlentities() ?

2005-03-26 Thread Ryan A
Hi, Just a quick question, I have been reading a lot about SQL injection doing a s**tload of damage to many sites, I myself use a pagentation class which sends the page number from page to page in a $_GET['page'] request which gets used in a LIMIT parameter. >From what i have

Re: [PHP] Avoiding SQL injections: htmlentities() ?

2005-03-26 Thread Ryan A
Hey! Thanks for replying. I was just going to write to you (after your last reply to my questions) that someone recommended your site and after i made a quick visit...if you could direct me to the exact page/section...guess you read my mind :-D Thanks, Ryan On 3/26/2005 7:47:36 PM, Chris

[PHP] live records

2005-03-26 Thread Ryan A
Hey all, Been working on this nearly the whole night so i dont really know if this is all that hard or am just braindead. Heres what i am doing: I am reading off an array from the users cookie called "user_cookie" the array is a bunch of numbers like this: 254 7785 5899 540055 etc the n

Re: [PHP] Password expiration script

2005-03-31 Thread Ryan A
Theres instant2c pro at securecents.com, but that might be like using a tank to kill a fly :-D On 3/31/2005 11:18:31 AM, Bosky, Dave ([EMAIL PROTECTED]) wrote: > --_=_NextPart_001_01C53626.6CCF76C0 > > Content-Type: text/plain > > > > I'm looking for a script th

[PHP] Recommendation for a MySql wrapper class

2005-04-01 Thread Ryan A
Hi, After spending a long time reading about SQL injection on the Google,PHP.net site and on Shifflet.org (very good article, links, feedback - and I'm really happy that knowledgeable people like Chris take the time to help actively on the list) I have some mixed views on how easy it

Re: [PHP] Recommendation for a MySql wrapper class

2005-04-02 Thread Ryan A
Hey Dan, Even if you did have something to do with these companies/softwares/classes I would still take your advise as you have given me some real helpful advise in the past, and a lot of others too, you're one of the helpful guys on the list. Thanks, I'll chech these out, the thing

Re: [PHP] Recommendation for a MySql wrapper class

2005-04-02 Thread Ryan A
On 4/2/2005 3:08:30 AM, Marek Kilimajer ([EMAIL PROTECTED]) wrote: > > > You can pack PEAR classes with your project and set up include_path > > accordingly. Hey, Thanks for replying. Good idea, have never done it but that should be a reason to start anyway :-) Cheers, Ryan

[PHP] users online

2005-04-03 Thread Ryan A
Hi, I have been searching the archives with little luck so I need a reminder here, I remember a little while ago someone asked how to implement the "users online" functionality that some sites have...now i have been asked to do exactly that but with a small twist: instead of displaying

Re: [PHP] HUMAN CHECK without url/session cookie/hidden input, etc.

2005-04-03 Thread Ryan A
check up on CAPTCHA on google or your favourite search engine -Ryan On 4/3/2005 11:35:03 PM, nime ([EMAIL PROTECTED]) wrote: > A kind of :-) > > > > https://nokiags.wdsglobal. > com/bookmarkmanual?contractId=191&phoneId=408&captchaEnabled=true&step=det

Re: [PHP] Test

2005-04-04 Thread Ryan A
Good test! On 4/4/2005 2:46:14 PM, [EMAIL PROTECTED] wrote: > Test > > > > -- > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. > > MailScanner thanks transtec Computers for their support. > -- No virus found in thi

[PHP] Slightly 0T - database (adodb)

2005-04-05 Thread Ryan A
Hey all, After my old thread of "SQL-Injection" I have been checking out the PEAR db classes and ADODB as a database wrapper. PEAR is quite large and has a LOT of stuff which I prolly will never use (but very useful stuff if you know how to use it) so I thought i'll go with adodb.

Re: [PHP] Slightly 0T - database (adodb) SOLVED

2005-04-05 Thread Ryan A
4/5/2005 9:13:27 PM, Ryan A ([EMAIL PROTECTED]) wrote: > Hey all, > > After my old thread of "SQL-Injection" I have been checking out the PEAR > db > > classes and ADODB as a database wrapper. > > > > PEAR is quite large and has a LOT of stuff which I pr

[PHP] plug-in forum

2005-04-05 Thread Ryan A
Hi, a client wants me to add a forum to his existing site...which is not a problem, the problem is he wants it to work off his existing site eg: once someone logs in to the main site they dont have to relogin or create new accounts in the forum section a one login gets you total site access

RE: [PHP] plug-in forum

2005-04-05 Thread Ryan A
m or their "computer skills" Cheers, -Ryan On 4/6/2005 12:50:31 AM, Chris W. Parker ([EMAIL PROTECTED]) wrote: > Ryan A <mailto:[EMAIL PROTECTED]> > > on Tuesday, April 05, 2005 3:07 PM said: > > > > > a client wants me to add a forum to his existing site...whi

Re: [PHP] plug-in forum

2005-04-06 Thread Ryan A
Hey Davy, Thanks for replying. I checked out punbb before, a fantastic forum coz its real simple, and if you want more complex stuff it supports it via "mods"...problem is the mods can be a pain in the @ss when upgrading and I need something a little more powerful (private messageing,

[PHP] Simple array question, array delete

2005-04-06 Thread Ryan A
Hey, I have a $data_recs array like this: 12 445 45655 4 343 etc when the user gives me a number, i have to check if its in the array and delete that entry...how do i do that? I have looked at the manual but have gotten confused with array pop,splice,array_key_exists etc Thanks, Ryan

[PHP] Simple array question, part 2

2005-04-06 Thread Ryan A
Hey, I have a $data array like this: [0] => 158 [1] => 169926 [2] => 169931 [3] => 169932 [4] => 169933 then when i delete the first one ([0] => 158) it becomes like this: [1] => 169926 [2] => 169931 [3] => 169932 [4] => 169933

Re: [PHP] Simple array question, part 2

2005-04-06 Thread Ryan A
PERFECT! Thanks mate. -Ryan On 8/6/2005 6:47:22 PM, Josip Dzolonga ([EMAIL PROTECTED]) wrote: > Ryan A wrote: > > > > >what function should i lookup/use? > > > > > >Thanks, > > >Ryan > > > > > This will do the job : &g

RE: [PHP] Simple array question, part 2

2005-04-06 Thread Ryan A
y, it is improper > handling.... > Thats right, it's > not array_pop(), its array_shift()... > musta' had a > brain fart and you didn't see the other array functions -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Data

Re: [PHP] plug-in forum

2005-04-06 Thread Ryan A
> Hey Ryan... I am actually coding a forum that meets all of you're > > > requirements, however it isn't done yet and I currently have another > project which takes priority. I should have an alpha out by the end of > april or may at the latest. When do you need th

[PHP] language files

2005-04-06 Thread Ryan A
Hey, I was just wondering which is the best/most efficient way of having language files for a site? eg: if $lang=english then it should include lang.en.inc.php if $lang=swedish then it should include lang.se.inc.php etc One way I did it before was to have an array like so: $lang_en[0]="

Re: [PHP] language files

2005-04-06 Thread Ryan A
Hey, Glad that you replied coz you would have had more experience with this than the average php joe being the author of a forum. Isnt your approach a lot like this one: > $get_user="Enter your username:"; > $get_pass="Enter your password:"; except that you are us

Re: [PHP] Simple array question, array delete

2005-04-06 Thread Ryan A
On 4/7/2005 5:19:24 AM, [EMAIL PROTECTED] wrote: > On Wed, April 6, 2005 6:09 am, Ryan A said: > > > when the user gives me a number, i have to check if its in the array > and > > > delete that entry...how do i do that? > > > I have looked at the manual bu

Re: [PHP] switch question

2005-04-07 Thread Ryan A
Hey, > Can I jump to html and back to php in the middle on switch yes, you can. Question: I know this might sound silly but why didnt you try it before writing to the list? you would have gotten your answer much quicker. Cheers, Ryan -- No virus found in this outgoing message. Checked by AV

RE: [PHP] language files

2005-04-07 Thread Ryan A
Hej Kim, > Hi there > > have you ever double entered the same words? > Well, if You do that, the later is the overwriting the previous ;) Exactly what I want to avoid. That was a pretty good example of using language files...and I really liked the text in that file...funny ;-)

Re: [PHP] language files

2005-04-07 Thread Ryan A
> > I was just wondering which is the best/most efficient way of having > > language > > files for a site? > > > > I can't really speak to this, as I've never gotten around to > > multi-language support, but this always looked like a winner to me: &

Re: [PHP] Simple Alert Message then Redirect?

2005-04-07 Thread Ryan A
On 4/7/2005 7:55:29 PM, Josip Dzolonga ([EMAIL PROTECTED]) wrote: > PartyPosters wrote: > > > > >Hello I want to display an alert message then after users click ok I want > to automatically goto a URL > > > > > >if ($var_stock_count == 0){ >

[PHP] Str_replace?

2005-04-07 Thread Ryan A
Hey, I am making a site primary for the Swedish audiance, Swedish alphabets are pretty much the same as our English ones except for three extras, which are: (lowercase) åäö (and uppercase) ÅÄÖ While using dreamweaver to format some of the pages I noticed that DW converts those letters to: å=å ö

Re: [PHP] Simple Alert Message then Redirect?

2005-04-07 Thread Ryan A
On 4/7/2005 9:24:31 PM, Josip Dzolonga ([EMAIL PROTECTED]) wrote: > Ryan A wrote: > > > > >Meta refresh too would do the job quite nicely > > > > > >Cheers, > > >Ryan > > > > > Yes it will, but he will still have to use JavaScrip

[PHP] using rand()

2005-04-07 Thread Ryan A
Hey, need some advise on what would be the best way to do this: I have a table with these fields: cno (just a auto_increment field), username, sex (2 values: man, woman), has_pic (0=no,1=yes), pic_name I need to randomly get 3 womens pictures and one guys picture from the above table... I know I

Re: [PHP] using rand()

2005-04-07 Thread Ryan A
female' order > by rand() limit 3;"); > > the second: > > $result2 = > mysql_query("select * from {table} where sex='male' order > by rand() limit 1;"); > > > > where {table} is the name of your table... > > > > drew Thanks Drew, Simpl

Re: [PHP] Re: using rand()

2005-04-08 Thread Ryan A
I guess so, but I dont think the difference would be all that great using rand() in php or "order by rand" in mysql.. worth checking up for "programmer show off" rights anyway :-) Cheers, Ryan > i guess a good question would be which one of these methods has more &g

Re: [PHP] Storing password in cookie

2005-04-09 Thread Ryan A
On 4/9/2005 3:33:50 PM, [EMAIL PROTECTED] wrote: > On 9 Apr 2005 John Nichel wrote: > > > > > While it is not absolute that you > can't store passwords in a cookie, it > > is an absolute that you _shouldn't_ > > > > Sorry, I > don

[PHP] Date time simplicity gotten out of hand

2005-04-09 Thread Ryan A
Hey, I thought this would be simple and just a few mins of programming but along the way...i have managed to confuse myself ;-D I have 2 field in my table users_online: present_date_time datetime expires_in datetime for present_date_time I am using now() to insert but for expires_in I need to

Re: [PHP] Date time simplicity gotten out of hand

2005-04-09 Thread Ryan A
On 4/9/2005 7:28:34 PM, Greg Donald ([EMAIL PROTECTED]) wrote: > On Apr 9, 2005 12:35 PM, Ryan A <[EMAIL PROTECTED]> wrote: > > > Hey, > > > I thought this would be simple and just a few mins of programming but > along > > > the way...i have managed to

[PHP] Alternate to timediff() (might be slightly 0T)

2005-04-09 Thread Ryan A
Hey, Reading the time and date functions of MySql I see that to compare my two timedates I would need to go with TIMEDIFF, but theres a "note" there that states: TIMEDIFF() was added in MySQL 4.1.1. and our host is running 4.0 and another 3.23.x So how can I compare 2 timedates which

Re: [PHP] Alternate to timediff() (might be slightly 0T)

2005-04-09 Thread Ryan A
Hmmm. we have a new sql guru on the list eh? welcome master... :-) Thanks mate. -Ryan On 4/9/2005 8:18:10 PM, Greg Donald ([EMAIL PROTECTED]) wrote: > On Apr 9, 2005 1:09 PM, Ryan A <[EMAIL PROTECTED]> wrote: > > > So how can I compare 2 timedates which are: > >

Re: [PHP] deleting $_SESSION

2005-04-11 Thread Ryan A
use unset() -Ryan On 4/11/2005 4:43:06 PM, AndreaD ([EMAIL PROTECTED]) wrote: > I have a session variable called > > > > $_SESSION['total'] the problem is I > can't delete/reset it. I have tried > > $_SESSION['total']= 0; > > $_SESSIO

[PHP] Dump client, nice concept...but how to do it via php?

2005-04-11 Thread Ryan A
Hey, A client asked me if I could do this, i told him i'll check around...so naturally I am asking you guys :-D He has an account with a sms gateway and has a website with come crappy profiles of his users. He wants the functionality that any of his users can send him an MMS message contain

Re: [PHP] Dump client, nice concept...but how to do it via php?

2005-04-11 Thread Ryan A
Hey, Thanks for replying. > > some other way of uploading a pic from the users mobile to the profile... > > email, but be aware of the security. Users should input some token in > the subject. How with email? other than sending email using mail() i have never worked with any ema

[PHP] image calculation problem

2005-04-13 Thread Ryan A
Hi, I copied this from the php site, but trying to modify it is driving me nuts coz its not working. Basically I am trying to make a thumb where the width is 87px...I dont care what the height is, heres the code: function prop_thumb_height() { // The file $filename = 'cat.jpg'; // Set

Re: [PHP] image calculation problem

2005-04-13 Thread Ryan A
Thanks mate, it works perfectly. -Ryan On 4/13/2005 11:35:23 PM, Philip Hallstrom ([EMAIL PROTECTED]) wrote: > see below... > > > > > Basically I am trying to make a thumb where the width is 87px...I dont > > > care what the height is, heres the code: > > &

[PHP] Dedicated server (0T)

2005-04-13 Thread Ryan A
Hey, Can anyone recommend a host for dedicated hosting? Hopefully one that you have used. Please reply offlist so as not to disturb anyone else. Thanks, Ryan -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.9 - Release Date: 4/13

[PHP] Re: Dedicated server (0T)

2005-04-14 Thread Ryan A
ont mind; Anybody have any idea about http://www.fastservers.net/ ? Reason I am asking is they have no setup fee and have a public forum, and on the forum there is a lot of praise with very little flack, prices are not too bad either...which is kind of strange for a dedicated hosting provider. I

[PHP] Getting a contract

2005-04-14 Thread Ryan A
Hey, There was some discussion before this on how much to charge to make a site / set of scripts, which also turned into advise from the more experienced members of this list...good advise I might add. Note: This thread is not directly a php thread but related in a big way to what most of us do

[PHP] Font color

2005-04-15 Thread Ryan A
Hey, On our profiles page we are allowing the person to pick their own font color and background image, the font color is picked by a DHTML popup and displays "swatches" of color, when the user picks the color she wants its html RRGGBB value is automatically inserted... Heres the prob

[PHP] Two tables (Slightly 0T)

2005-04-16 Thread Ryan A
want to run a query on every record returned from users_online as that would be really "expensive". Thanks, Ryan -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.13 - Release Date: 4/16/2005 -- PHP General Mailing

Re: [PHP] Two tables (Slightly 0T)

2005-04-16 Thread Ryan A
Hey, Thanks for replying. Will look up "join". > BTW this is a question for the [MySQL General] list at [EMAIL PROTECTED] I know its largly a MySql question, but I am using it via PHP...and thats why I wrote the OT in the subject...didnt want to tick anyone off. Cheers, Ryan O

Re: [PHP] Re: Two tables (Slightly 0T)

2005-04-16 Thread Ryan A
Hey, Thanks for replying. I know, I need to start brushing up on my Sql, problem is I rarely need to use much other than a simple select,update,insert. Sorry I didnt write my where query before...this is what i am using: SELECT last_online from `members_online` WHERE last_online > DATE_sub(

Re: [PHP] Streaming video BLOBs from MySQL

2005-04-16 Thread Ryan A
, flash player? > > > Thanks for any ideas! > > > > Look into flush(); yeah... you gotto ...or it starts to pile up after a few days :-) -Ryan -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.13 - Relea

Re: [PHP] Need help with file permissions for PHP files

2005-04-17 Thread Ryan A
PLEASE lets not start on the. > > 2. "Because it reads out of order." > > >"Why?" > > >"Top posting is bad." > > > III. Trimming is good, because it gets right to the point. .top posting / bottom posting thing again. -Ryan -- No virus found in this outgoing message. Chec

[PHP] Last visitors

2005-04-19 Thread Ryan A
Hey, Am a bit puzzled as to how to do this, I am modifying a profiles/dating site, the site works like this: if you are a "guest" you can see only limited details of a profile, if you have logged in, you see many more details. On the profile page there should be "last 10 visitor

Re: [PHP] Last visitors

2005-04-19 Thread Ryan A
>> the site works like this: > > if you are a "guest" you can see only limited details of a profile, if > you > > have logged in, you see many more details. > > On the profile page there should be "last 10 visitors", it will not > register > &

Re: [PHP] Last visitors

2005-04-19 Thread Ryan A
sorry for misunderstanding you. No problem, I guess i didnt explain it well enough, and you dont have to help me but you are trying, so thank you. > As for cleaning up... that's the bit that I can't figure out myself :(. exactly, I came to the same part as youbut then i would h

RE: [PHP] Last visitors

2005-04-19 Thread Ryan A
Hey, > As to exactly how you decide which are the most recent 10 records to do > > this deletion, that is a little more complex. Yep, for sure > Something like > > DELETE FROM profile_visits > > WHERE user='billy' > > AND time_of_visit NO

RE: [PHP] Last visitors

2005-04-19 Thread Ryan A
Hey, > Couple of options: a CRON job/scheduled job which invokes a SQL command > deleting all but the 10 most recent records, **I dont think this would be very effective, as there might be thousands of profiles and each gets their last 10 visitors, some would be more popular than others

Re: [PHP] Last visitors

2005-04-19 Thread Ryan A
> what if you have something like 1000 users on your system. > > you'd have 1000 txt files! :( > the DB seems to be a better idea as it's > probably more expandable... > > you can do other queries to it and stuff... whereas 1000 txt files > > will be a pai

Re: [PHP] Last visitors (SOLVED?)

2005-04-19 Thread Ryan A
Hey! I think I solved this: select 11 latest visitors count to see if it returned 11 records, if (count == 11){ get the oldest (of the 11) visitors time delete everything from that record and older than that } else{} Pros: max 2 queries If i am missing anything or you see any problem in my logi

Re: [PHP] Last visitors (SOLVED?)

2005-04-19 Thread Ryan A
Hey, Thanks for replying. > Check my reply. I did, the problem is the client is on a box with mySql 3.23.x or 4.0.x, he is deciding to upgrade to a dedicated box but then the host he is looking at says they will charge him if they are to upgrade to mysql 4.1 (hence i cant even use sub-sele

Re: [PHP] Last visitors

2005-04-19 Thread Ryan A
> > >> Table: profile_log Create Table: CREATE TABLE `profile_log` ( > > >> `profile_id` int(10) default NULL, > > >> `user_id` int(10) default NULL, > > >> `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update > > &g

RE: [PHP] Last visitors

2005-04-20 Thread Ryan A
g ENGINE to TYPE will fix that error, and > you can leave off the charset. I believe utf8 was added in 4.1. If you > leave off charset=xxx it will just default to whatever the server's > default-character-set is set to, probably latin1. Hey, Thanks for replying. Theres something wrong

RE: [PHP] Last visitors

2005-04-20 Thread Ryan A
> Theres something wrong coz its not working as expected... > I followed instructions and created a table like this: > > > CREATE TABLE test_last_visitors ( > profile_id int(10) default NULL, > user_id int(10) default NULL, > ttimestamp timestamp(14) NOT NULL) TYP

Re: [PHP] Last visitors

2005-04-20 Thread Ryan A
Hey, > Why are you setting the profile_id equal to a value when you also have > that in your WHERE clause? I may have missed something here, but I > though the purpose of this was to track the last ten visitors to a > certain page, and if this is the case, why increment the

Re: [PHP] Post shorter code

2005-04-21 Thread Ryan A
> You're far more likely to get someone to look at your problem code if > you can narrow it down to a block of code. Hell, you didn't > even state a problem!!! > > Sorry, but if you come back with a well defined problem then maybe > someone can help you. It also helps

Re: [PHP] Post shorter code

2005-04-21 Thread Ryan A
> > It also helps if you quote a bit from the original post so new people > to > > > the thread > > > will know what you are talking about... > > > for example: I have no idea about which thread Jason(above) is talking > > > about > > > &g

Re: [PHP] reverse MD5 ???

2005-04-21 Thread Ryan A
I am not really interested in reversing MD5 and I sure as hell hope its not easy to do for a LONG time to come as we use it in some of our licensing, for software we sell.BUT the below text was some good reading none the less. I'm gonna copy and save the below text for the next client who

Re: [PHP] Post shorter code

2005-04-21 Thread Ryan A
> Chris W. Parker wrote: > > What? ;) HAHAHAHA -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.10.1 - Release Date: 4/20/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: reverse MD5 ???

2005-04-21 Thread Ryan A
Interesting reading, even though most of it went over my head :-) There ar'nt any tools freely available to the average joe to decypher a md5 hash though...right? Cheers, -Ryan On 4/21/2005 6:34:45 PM, Greg Donald ([EMAIL PROTECTED]) wrote: > On 4/21/05, Satyam <[EMAIL PROTEC

[PHP] formatting logic

2005-04-21 Thread Ryan A
Hi, Am having a bit of logic problem figuring this outI just think the easy solution would cost me in having too many sql queries from my script so there has to be a easier way. I am allowing our members to upload pictures and they can choose which category the pictures go under, the first

[PHP] Count totals (might be 0T)

2005-04-21 Thread Ryan A
Hi again, Am faced with a new problem (either that or working straight 10 hours is catching up!) Heres my table (easy to figure out so i wont waste your time explaining the fields): cno, date_added, pic_name, pic_size_kb, pic_desc_text, pic_category the way i am displaying the data is like this

Re: [PHP] Count totals (might be 0T)

2005-04-21 Thread Ryan A
Hey, Thanks for replying. That means I will have to run a query per categorywhich I would like to avoid if possible as they could be a high amount of categories as they are user created and not defined by us. Thanks, Ryan On 4/22/2005 12:08:31 AM, Drewcore ([EMAIL PROTECTED]) wrote: >

Re: [PHP] Re: reverse MD5 ???

2005-04-22 Thread Ryan A
Hey, > I really > wouldn't sweat this in terms of your day-to-day life/programming, > other than to keep your code modular enough to replace "md5" with > something else in the year 2020 or whatever. Thats fine by me, by 2020 the spaceship would have landed and I will be declared sub ruler of plan

RE: [PHP] Re: Php defense

2005-04-22 Thread Ryan A
On 4/22/2005 6:04:49 PM, Chris W. Parker ([EMAIL PROTECTED]) wrote: > Matthew Weier > O'Phinney <mailto:[EMAIL PROTECTED]> > on Friday, April 22, 2005 7:39 AM said: > > > I'm > not allowed to say what company > it's for, but we just finished > >

<    2   3   4   5   6   7   8   9   10   11   >