Re: [PHP-DB] Skipping a row

2003-12-19 Thread Robby Russell
John Greco wrote: $sql2 = select * from product where whseNum = '.$whseNumber.' order by prodNum; What does your PHP code look like after that? What is your index starting with? are you starting with 0? or 1? $sql = SELECT id FROM product WHERE something = this; $rs = pg_query($sql); $i = 0;

[PHP-DB] plPHP and php mail() example

2004-01-30 Thread Robby Russell
body. Testing email. Test! -Robby Feel free to join the plPHP mailing list as well. http://mail.commandprompt.com/mailman/listinfo/plphp Cheers, Robby Russell -- #--- # Robby Russell, | Sr. Administrator / Lead Programmer # Command Prompt

Re: [PHP-DB] counting a value

2004-01-30 Thread Robby Russell
and favorite numbers. # SELECT fav_num as Favorite Number, count(*) FROM student_number GROUP BY fav_num; Favorite Number | count -+--- 1 | 1 2 | 3 3 | 1 5 | 3 7 | 1 Cheers, Robby Russell

Re: [PHP-DB] counting a value REVISED pt2

2004-01-30 Thread Robby Russell
in that column, then i want it to say 2 is listed 43 times. how do i do this? thank you for your help with my beginner newbie questions. -james Did you really review your question much? Do you have a php script that has connected to the database already? -Robby -- Robby Russell, | Sr. Administrator

RE: [PHP-DB] Intellectual property rights

2004-08-09 Thread Robby Russell
. They will not install PHP ( too many hacker problems they say). Did I just screw myself? Do I have any protection of my design? Can I do anything? Thanks, Vinny -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland

Re: [PHP-DB] PHP and mysql script error in webhosting

2004-08-09 Thread Robby Russell
-- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development / -- PHP Database Mailing List

Re: [PHP-DB] Lock Record on Postgresql

2004-08-13 Thread Robby Russell
people misusing LOCKS. -Robby -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development

Re: [PHP-DB] How to create a new Table in prostgresql from a Webinterface

2004-08-14 Thread Robby Russell
is the type of sql command that you would issue. You can do $query = CREATE TABLE foo (id SERIAL PRIMARY KEY, name TEXT);; Then run this query through your php command of choice (pg_query, PEAR, etc) -Robby -- /*** * Robby Russell | Owner.Developer.Geek

Re: [PHP-DB] How to forward a POSTed form to another server and catch the return for further processing

2004-08-14 Thread Robby Russell
should be returned or captured by the first server. Obviously my brain is not working. Thanks for your help. Curl can do this for you. -Robby -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL

Re: [PHP-DB] PHP versions - Development server live server...

2004-10-13 Thread Robby Russell
version, but most bugs are not so easy to produce. -Robby -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development

RE: [PHP-DB] PHP versions - Development server live server...

2004-10-13 Thread Robby Russell
it will not work on 4.x hosting servers...especially object oriented programming. As a rule of thumb, keep your development and live environments as close as possible. :-) Cheers -Robby -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON

Re: [PHP-DB] Logging Into A MySQL (Web) Database

2004-10-21 Thread Robby Russell
-- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development / signature.asc Description

Re: [PHP-DB] sending e-mails

2004-10-21 Thread Robby Russell
-- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development / signature.asc Description

Re: [PHP-DB] Logging Into A MySQL (Web) Database

2004-10-21 Thread Robby Russell
should stay in it. You started a new thread and can't assume that we know where your train of thought is coming from. -Robby -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730

Re: [PHP-DB] Implementing search in a database driven website

2004-10-26 Thread Robby Russell
Vinayak You're going to have replace all the css tags when you pull the data out...or rethink how you handle this sort of stuff in your CMS. (html/css inside the content isn't fun to deal with) -Robby -- /*** * Robby Russell | Owner.Developer.Geek

Re: [PHP-DB] Implementing search in a database driven website

2004-10-26 Thread Robby Russell
On Tue, 2004-10-26 at 16:57 -0700, Robby Russell wrote: On Wed, 2004-10-27 at 00:33 +0530, Vinayakam Murugan wrote: Hi I have a PHP-mysql website in which I want to implement search functionality. Through the content management section, the user can enter data into the database

Re: [PHP-DB] Finding the highest number in a column?

2004-10-27 Thread Robby Russell
-- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development * --- Now supporting PHP5 and PHP4 --- / signature.asc

Re: [PHP-DB] Finding the highest number in a column?

2004-10-27 Thread Robby Russell
On Wed, 2004-10-27 at 20:46 -0700, Robby Russell wrote: On Wed, 2004-10-27 at 23:33 -0400, Chris Payne wrote: Hi there everyone, I am working with a very complex system where not all numbers are assigned 1, 2, 3 etc so there could be a row with the number 1 and then the next

Re: [PHP-DB] I can't seem to get Max() to work

2004-10-28 Thread Robby Russell
, but it doesnt return anything unless I change the MAX() to a * and I dont want that I need it to be the MAX() number as it isnt an auto-increment field. Is this an integer field? -Robby -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON

Re: [PHP-DB] printer dialouge box

2004-10-30 Thread Robby Russell
On Sat, 2004-10-30 at 18:03 +0530, balwantsingh wrote: how i can open the printer dialouge box of browser in PHP. pls. help. with best wishes balwant by using javascript. PHP doesn't do client-side stuff. -- /*** * Robby Russell

Re: [PHP-DB] can i display an image _directly_ from postgres db storage?

2004-11-02 Thread Robby Russell
? is this possible? This example uses large objects, you can try to use the same logic and use the bytea field. http://blog.planetargon.com/index.php?/archives/27_Displaying_image_from_PostgreSQL_large_object_with_PHP.html -- /*** * Robby Russell | Owner.Developer.Geek

Re: [PHP-DB] Problem with script

2004-11-02 Thread Robby Russell
) hth, Robby -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development *--- Now supporting PHP5

Re: [PHP-DB] Please point me in the right direction.......

2004-11-11 Thread Robby Russell
? If that is the case, I would have them fill out a contract that says that anything that isn't generic (like some libraries) would be under your ownership, not theirs..as per 'work for hire' -Robby -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON

Re: [PHP-DB] PHP vs ASP

2004-11-15 Thread Robby Russell
PHP = tons of open source libraries..free to download -Robby -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development

Re: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread Robby Russell
On Wed, 2004-12-01 at 12:50 +, PHPDiscuss - PHP Newsgroups and mailing lists wrote: Hi, what can i do, where users can't select and copy my text from web-page. Thanks render the text to an image. -- /*** * Robby Russell | Owner.Developer.Geek

Re: [PHP-DB] MySQL PHP hosting

2005-02-09 Thread Robby Russell
thought maybe someone here might have a good solution. jzf http://www.planetargon.com/hosting/ -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730

Re: [PHP-DB] php/other language (perl)

2005-02-23 Thread Robby Russell
/package/perl -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development * --- Now hosting Ruby on Rails Apps

Re: [PHP-DB] boolean values in postgresql

2005-02-23 Thread Robby Russell
while I am reading. Bret -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development * --- Now hosting Ruby on Rails Apps

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-25 Thread Robby Russell
and changed the login functions. ..but if someone can see your password in MD5 format..could they then not login with the same privileges as with your plain text? -Robby -- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com

Re: [PHP-DB] MySQLPHP decrypt(password)

2005-02-25 Thread Robby Russell
-- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting Development * --- Now hosting Ruby on Rails Apps

Re: [PHP-DB] big data base

2005-03-09 Thread Robby Russell
-- /*** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | [EMAIL PROTECTED] * 503.351.4730 | blog.planetargon.com * PHP-PostgreSQL Hosting Development * open source solutions - web hosting / -- PHP Database Mailing List

Re: [PHP-DB] postgresql and php

2005-04-24 Thread Robby Russell
if my other coding is correct. In my form, I have radio buttons. Any and all help is appreciated. Might you consider showing us some code and/or trying it out yourself and coming to us when you hit a problem? -Robby -- /** * Robby