Re: [PHP-DB] Link for next db record

2002-05-12 Thread Jennifer Downey
This line sets $row["rv_space"] echo"Search Record by Space Number  "; "Beau Lebens" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > How are you setting the value for $row["rv_space"] ? > > // -Original Message- > // From: Jennifer Downey [mailto:[EMA

RE: [PHP-DB] Link for next db record

2002-05-12 Thread Beau Lebens
How are you setting the value for $row["rv_space"] ? // -Original Message- // From: Jennifer Downey [mailto:[EMAIL PROTECTED]] // Sent: Monday, 13 May 2002 2:01 PM // To: [EMAIL PROTECTED] // Subject: Re: [PHP-DB] Link for next db record // // // Hi Beau, // // I have a form that selec

Re: [PHP-DB] Link for next db record

2002-05-12 Thread Jennifer Downey
Hi Beau, I have a form that selects an rv electric record here is a snip and if you need more tell me. This just returns a blank page. $current_date = date("M"); $pkwh =.064; $get_electric = "SELECT * FROM electric WHERE rv_space = $row[rv_space]"; $result = mysql_query($get_electric) or die(mys

RE: [PHP-DB] Link for next db record

2002-05-12 Thread Beau Lebens
jen, assuming you are "currently" looking at a page which is something like php.php?record=3, then you should be able to just do Previous recordNext record and then on the php.php page, you would obviously being grabbing something from the database using a unique identifier or similar. one "got

[PHP-DB] Link for next db record

2002-05-12 Thread Jennifer Downey
Hi all, Wondering if you could help or point me to a tut where I can use a link to get the next record in the db? Like Previous recordNext record How do I go about doing this. Thanks Jennifer -- The sleeper has awaken --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus sys

[PHP-DB] Re: Upcoming event script

2002-05-12 Thread Adam Royle
Should be something like so... "SELECT text FROM events WHERE date < now() SORT BY date DESC LIMIT 1" That should work. Adam

RE: [PHP-DB] Word Count, rounding and missing zeros

2002-05-12 Thread Gurhan Ozen
$formattedquote=sprintf("%.2f", $thequote); See: http://www.php.net/manual/en/function.sprintf.php Gurhan -Original Message- From: Kim Kohen [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 9:59 PM To: PHP Subject: [PHP-DB] Word Count, rounding and missing zeros G'day All, I'm u

RE: [PHP-DB] Upcoming event script

2002-05-12 Thread Beau Lebens
assuming you are using a date format field, you can do something like (not tested, please check syntax!) $SQL = "SELECT text FROM events WHERE date < " . date("Y-m-d") . " SORT BY date DESC LIMIT 1"; good luck Beau // -Original Message- // From: Andrew [mailto:[EMAIL PROTECTED]] // Sen

[PHP-DB] Word Count, rounding and missing zeros

2002-05-12 Thread Kim Kohen
G'day All, I'm using php to query a mysql db and I need to display a word count from one of the columns and multiply it to get a quote. So far I have this: $thewords = count(split (" ","$adtext")); $thequote = round(($thewords * .78),2); In an example with 35 words it returns 27.3 but I'd like

[PHP-DB] Re: Upcoming event script

2002-05-12 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > I'm sorta new at php, as most of my experience is in ASP...so I need a > little help. > > I am making a "next upcoming event" script. Basically, I want to be able to > put into mysql a description of the even and a date where the postin

RE: [PHP-DB] Date problem

2002-05-12 Thread Pierre-Alain Joye
> i get $postdate from my mysql database,the problem is that i want > to increase that date by 6 months?? > its stored in mysql as date field http://www.mysql.com/doc/D/a/Date_and_time_functions.html check DATE_ADD :) hth pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] Date problem

2002-05-12 Thread its me
i get $postdate from my mysql database,the problem is that i want to increase that date by 6 months?? its stored in mysql as date field

Re: [PHP-DB] Client IP

2002-05-12 Thread Sebastian Tschiatschek
Take a look at the following page: http://www.cgsa.net/php/identifierShow.php The script for getting the original ip-address is quite good. hth Sebastian -- Tschiatschek Sebastian, [EMAIL PROTECTED] | System Consulting Graz, AUSTRIA / High Availability/Cluster Mobile: +

Re: [PHP-DB] Syncing two tables in mysql

2002-05-12 Thread Jason Wong
On Sunday 12 May 2002 13:37, Thomas \"omega\" Henning wrote: > And how can i use it? I suppose the manual will have full details. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Develo

Re: [PHP-DB] Client IP

2002-05-12 Thread Jason Wong
On Sunday 12 May 2002 21:49, Hayan AL Mamoun wrote: > Dear all, > I'm using the $REMOTE_ADD variable to get the visitor IP address, but when > a visitor access my website throught a proxy server I get always the same > ip of that proxy server. > Is there a way to get the unique IP of each users???

[PHP-DB] Upcoming event script

2002-05-12 Thread Andrew
I'm sorta new at php, as most of my experience is in ASP...so I need a little help. I am making a "next upcoming event" script. Basically, I want to be able to put into mysql a description of the even and a date where the posting should start, and I want to be able to make it show the most recent

[PHP-DB] Client IP

2002-05-12 Thread Hayan AL Mamoun
Dear all, I'm using the $REMOTE_ADD variable to get the visitor IP address, but when a visitor access my website throught a proxy server I get always the same ip of that proxy server. Is there a way to get the unique IP of each users??? bst rgds Hayan -- PHP Database Mailing List (http://www.p

RE: [PHP-DB] Open file dialog box to save static file

2002-05-12 Thread Howard Picken
No that wouldn't work because the formatted page looks quite different from the page she uses for admin. I've been looking for some samples for fopen() coding, cause I'm relatively new to this PHP game, I think I've found an example that might be useful though so I'll play around a bit and see wh

[PHP-DB] Re: Easy one for you guru's :-)

2002-05-12 Thread Jason Morehouse
Here is a simple cart, but should give you the idea. Cheers! -J $name,'price'=>$price,'qty'=>$qty); break; # Remove from cart case 'remove': # Remove item unset($_SESSION['cart'][$id]); break; } # Show cart contents if any if (count($_SESSION[cart]) > 0) { prin

RE: [PHP-DB] Open file dialog box to save static file

2002-05-12 Thread Peter Lovatt
Hi you can use php to write the html to a file, rather than having to do it all manually. Look at fopen() Not sure if this is exactly what's needed, but it might be. HTH Peter --- Excellence in internet and open source software --

[PHP-DB] Open file dialog box to save static file

2002-05-12 Thread Howard Picken
I'm looking for a way to do the following I've created a php/mysql site for my wife for various database lists she has. She uses PHP locally on our on web server to add/manage entries but a lot of the pages need to be static and uploaded to a specific site (no PHP/MySQL). So I've give her a li