Re: [PHP-DB] array fill/sort question
hi,
you can add the ip2long() function into your SELECT statement and have
an ORDER BY clause at the end like this...
SELECT s_id, subnet_name, ip2long('subnetaddr'), subnetmask,dnsdomain,
location, contact, ccn FROM subnets ORDER BY subnetaddrr;
hope it helps.
KD
On Tue, 10 Jun 2003, Snijders, Mark wrote:
> hi,
>
> I'm working on a ipaddres/subnet programm
>
> now i have a talbe with a lot of information about ip-addresses
>
> i'm having this query:
>
> SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain, location, contact,
> ccn FROM subnets
>
> the subnetaddr field looks like this : 100.20.20.1 and is ofcourse a
> varchar field
>
> BUT before displaying it on the screen i have to sort it by subnetaddr and
> then show it
>
> but i have to sort it as integer, so i use the php-function ip2long();
>
> so you get a decimal...
>
> so what i have to do:
>
> do the query> make a decimal field of the 'subnetaddr' put it in an array,
> sort it and display it
>
>
> BUT how can i put ALL of the fields in the query in an array, sort it, and
> then display it?
>
> please help me, I can't work it out :(
>
> thanks, Mark
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ideas for Affiliate Program.....
Hello all, I am working on an Affiliate Program and need ideas or suggestions... please email me if you have any suggestion for now my program will keep track of an affiliate_id and the client_ip address for future reward... (i.e if the client buys anything, the affiliate_id gets a credit...) but this system won't reward an affiliate if for example, many clients use the same computer (same ip address) to buy products... then the affiliate_id is only credited once Have anyone ever done anything similar and have other suggestions? I am working on it, but is still looking for better ways of doing it... thanks in advance.. KD -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ideas for Affiliate Program.....
Thanks Mike, I downloaded and implemented that program to see how it works, but my Affiliate Program will do so much more than that... and is more complicated i know what to do... just have a little concern about not paying Affiliates what they deserve... I don't want to under pay or over pay them... just thought that i can't really think as good as many of you... so if you think there is a better way of tracking who gets what credit, please let me know as of right now, i am tracking them the way i told you Aff_id and Client_ip. Thanks anyway.. KD On Tue, 24 Jun 2003, mike karthauser wrote: > on 24/6/03 4:59 pm, Kieu D. Trang at [EMAIL PROTECTED] wrote: > > > Have anyone ever done anything similar and have other suggestions? I am > > working on it, but is still looking for better ways of doing it... thanks > > in advance.. > > You want to look on sourceforge for a project called php affiliate. I think > that should save you some time ;-) > > -- > Mike Karthauser > Managing Director - Brightstorm Ltd > > Email >> [EMAIL PROTECTED] > Web >> http://www.brightstorm.co.uk > Tel >> 0117 9426653 (office) >07939 252144 (mobile) > > Snailmail >> Unit 8, 14 King Square, >Bristol BS2 8JJ > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql_fetch_array issues.
this error only means that your msql_query($result) was correct, but did
not have any result... meaning, there was nothing to select, there for
there is nothing to fetch... hence you can not do a msql_fetch_array() on
an empty result set.
KD
On Wed, 9 Jul 2003, Greg Hetrick wrote:
> Yup, I have all permissions -- it appears that I can access mysql but not
> the database itself.
>
> "Gary Every" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> .
> > Do you have select permissions on that DB/table?
> >
> > If you have GRANT permissions, try
> > GRANS SELECT, INSERT, UPDATE, DELETE ON db.tablename to
> > 'youruser'@'your.ip.address' IDENTIFIED BY 'yourpassword';
> >
> > your.ip.address can be substituted with localhost if you're on the same
> box.
> >
> >
> > Gary Every
> > Sr. UNIX Administrator
> > Ingram Entertainment
> > (615) 287-4876
> > "Pay It Forward"
> > mailto:[EMAIL PROTECTED]
> > http://accessingram.com
> >
> >
> > > -Original Message-
> > > From: Greg Hetrick [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, July 09, 2003 12:31 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: [PHP-DB] mysql_fetch_array issues.
> > >
> > >
> > > I do not have the die statment -- the DB is the same except
> > > the name and I
> > > have double checked that I just did a back up of the previous
> > > db and moved
> > > it to the new server. I have done some more digging, my query
> > > appears to
> > > work, but I almost appears that I have a problem with selecting the
> > > database --
> > > if I comment out the mysql_select -- statment I get the same
> > > error, perhaps
> > > I just can't get to that DB.
> > > intresting.
> > >
> > > I guess I can assume at this point there is something flaky with my DB
> > >
> > >
> > > "Jeffrey N Dyke" <[EMAIL PROTECTED]> wrote in message
> > > news:[EMAIL PROTECTED]
> > > >
> > > > Do you have an 'or die(mysql_error())' statement following your
> > > > mysql_query($result) line. 99% of the time, this error
> > > means your query
> > > > failed. if it works on another serverare the fields
> > > the same, the
> > > > dbname, the tablename?
> > > >
> > > > hth
> > > > jeff
> > > >
> > > >
> > > >
> > > > "Greg Hetrick"
> > > > <[EMAIL PROTECTED]To:
> > > [EMAIL PROTECTED]
> > > > net> cc:
> > > >Subject: [PHP-DB]
> > > mysql_fetch_array issues.
> > > > 07/09/2003 12:04
> > > > PM
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > I am getting the following error when attempting to pull
> > > data out of a
> > > > mysql
> > > > DB
> > > >
> > > > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL
> > > result
> > > > resource in
> > > /home/pffl/public_html/pffl/webpage/html/dataentry.php on line
> > > > 125
> > > >
> > > > I can take this same code to a different web server and it
> > > is pulling
> > > > correctly!
> > > >
> > > > I am currently running Apache 2.0.46 with PHP 4.3.2 I was
> > > running Apache
> > > > 1.3.x with PHP 4.3.1 and getting the same thing, any ideas?
> > > here is the
> > > > chunk of code where I use the function.
> > > >
> > > > while ($myrow=mysql_fetch_array($result))
> > > > {
> > > > ?>
> > > >
> > > > > > > }
> > > >
> > > > Any Ideas.
> > > >
> > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] weird php error
try
if (isset($_GET['login']) AND $_GET['login'] == 'forgot')
KD
On Fri, 29 Aug 2003, Tiberiu Ardeleanu wrote:
> Try:
>
> if ($_GET['login'] == 'forgot')
>
>
> - Original Message -
> From: "OpenSource" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, August 29, 2003 7:38 AM
> Subject: [PHP-DB] weird php error
>
>
> > Hi guys,
> >
> > This is weird to me..
> > I got this script
> > ---
> > >
> > if ($_GET[login] == 'forgot')
> > {
> > echo "Sorry I forgot my password";
> > }
> > else { echo "you are good to go"; }
> >
> > ?>
> > -
> > when ran, it gives me this error
> >
> >
> > Notice: Use of undefined constant login - assumed 'login' in
> > G:\Inetpub\wwwroot\test\index.php on line 3
> >
> > Notice: Undefined index: login in G:\Inetpub\wwwroot\test\index.php on
> > line 3 good to go
> >
> > What is this all about?
> > The script look fine to me.
> >
> > Thanks in advance for your support
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
