[PHP-DB] Time Question

2002-03-05 Thread Lerp
Hi there, I have a field in my db called expires and it holds a value for the last time somebody visited my site such as 1015354119 . How would I add 15 minutes onto this? Would I use the mktime() and do it that way, or there a better way to do this? Thx Joe :) -- PHP Database Mailing List (

[PHP-DB] Re: multiple select statements

2002-03-05 Thread Lerp
Hi there :) You could construct seperate queries for every possible combination of search provided you don't have a huge number of search criteria (form elements for your search) . I did this just recently for a friend finder site. In the search the user has four fields that are automatically inc

[PHP-DB] Re: Advantage Database Server

2002-02-27 Thread Lerp
Hi there :) I believe you can connect to an Advantage Db through unified odbc functions. Check the manual at www.php.net Cheers, Joe :) "Stewart Gateley" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Has anybody had any luck or tried connecting to ADS from

[PHP-DB] Re: forced page links...

2002-02-27 Thread Lerp
Hi there :) I use session variables to do this, once the user has logged in and you know they are who they say they are, set a session variable using session_register("isloggedin"); $isloggedin = "yes"; And at the top of every page you want protected simply do a check to see if it is set or not

[PHP-DB] Re: PHP advice

2002-02-25 Thread Lerp
Hi there :) What happens when you change this line ($query = "select * from auth where password = ".$password.""; ) to this: (no periods) $query = "select * from auth where password = '$password'"; Cheers, Joe :) "Greg Lobring" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[E

[PHP-DB] Re: Errors Deleting...

2002-02-22 Thread Lerp
Hi there :) When using checkboxes you'll have to name them as an array... > value=\"".$myrow[id]."\">remove I'm pretty sure it would be like: remove Hope this points you right direction ;) Cheers, Joe:) "Jas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...

[PHP-DB] Re: slow result

2002-02-22 Thread Lerp
Post some code up :) "Sommai Fongnamthip" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > When I select data from table with mysql prompt or mysql-front-end, it > display result fast. But when I put this sql into php, it used more time > to display the

Re: [PHP-DB] Re: Parse error (a bit OT)

2002-02-21 Thread Lerp
Glad you figured it out :) Cheers, Joe :) "Markus Lervik" <[EMAIL PROTECTED]> wrote in message 1014295168.26036.27.camel@hal9000">news:1014295168.26036.27.camel@hal9000... > On Thu, 2002-02-21 at 14:36, Lerp wrote: > > > Hi there :) I think you just mig

[PHP-DB] Re: Parse error (a bit OT)

2002-02-21 Thread Lerp
Hi there :) I think you just might be missing two curly braces. Like below. if ($prev_week) { while(date("W",mktime(0,0,0,$m,$d,$Y))==$week) { ...blababla... } } if ($next_week) { while(date("W",mktime(0,0,0,$m,$d,$Y))==$week) { ...blablabla... } } Hope this helps, Joe :) "Markus Lervik" <

[PHP-DB] Re: A good tutorial

2002-02-20 Thread Lerp
You're welcome Jen :) Cheers, Joe :) "Jennifer Downey" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Thanks Joe! > > This is exactly what I was looking for. Little tweaking and I was off and > running. > > T

[PHP-DB] Re: A good tutorial

2002-02-19 Thread Lerp
Ammendment: Make sure you test for the proper file extension before you actually upload it. The last thing you want is someone uploading a text file instead of the type of file you are looking for! I forgot to add that in the code. Grab the last 4 characters off of the end of the filename and det

[PHP-DB] Re: A good tutorial

2002-02-19 Thread Lerp
Hi Jen, here's some code I posted up in the general ng for storing in db and retrieving images from db for display on your page. It's recommended that you stay away from storing actual images in the db. If you are storing a path the code below might help you out. It select a firstname, and an imag

Re: [PHP-DB] Time Difference

2002-02-15 Thread Lerp
r, $minute, $second, $month, $day, $year?? > > -Original Message- > From: Lerp [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 15, 2002 8:46 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Time Difference > > > Hi again. I have a date field in my mssql 7.0 db format :

[PHP-DB] Time Difference

2002-02-15 Thread Lerp
Hi again. I have a date field in my mssql 7.0 db format : 2/14/2002 12:21:28 PM . I would like to know how to calculate the difference in seconds between 2 such timestamps. $starttime = mktime($hour, $minute, $second, $month, $day, $year); returns :1013776613 endtime = mktime($hour, $minute, $s

Re: [PHP-DB] Time Question

2002-02-14 Thread Lerp
Thx Rick :) Appreciate your help :) Cheers, Joe "Rick Emery" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > $t = date("m/d/Y h:i:s A", gettimeofday()); > print $t; > ?> > -Original Message- > Fr

[PHP-DB] Time Question

2002-02-14 Thread Lerp
Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a mssql7.0 backend. The snag is this, I have a 'starttime' field in my db using the 'datetime' format ... looks like this 2/14/2002 12:21:28 PM. Unfortuanely, I'm unable to convert this field to type integer at the present tim

[PHP-DB] Re: MS SQL Server 7

2002-02-13 Thread Lerp
Hi there. Have you tried it with the odbc functions? Same prob? Cheers, Joe :) "Todd Williamsen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am trying to get PHP to work with MS SQL Server 7, but its not liking > something > > when I do a mssql_connect()

[PHP-DB] Re: Need to delete charcters from a string

2002-02-08 Thread Lerp
Oops, I totally misunderstood what you were trying to accomplish :) heh Sorry for any confusion Joe :) "Renaldo De Silva" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I need to delete the last 3 character of a string, what command can i use o > do this.

Re: [PHP-DB] addslashes()

2002-02-08 Thread Lerp
It shouldn't. It will affect any " or ' coming out. For example, for going in to db: $mystring = "Hi there Mr O'Neil."; $mystring = addslashes($mystring); echo $mystring; would result in "Hi there Mr O\'Neil." When coming out of db make sure you use the stripslashes function to return the orig

[PHP-DB] Re: Simple Search Function

2002-02-06 Thread Lerp
Hi there, you might want to take a look at the eregi function for case-insensitive pattern matching. Joe :) "Mike De Libero" <[EMAIL PROTECTED]> wrote in message 001f01c1af1c$4d7dce00$6901a8c0@slugo">news:001f01c1af1c$4d7dce00$6901a8c0@slugo... Hi guys, I was wondering what the best way wou

[PHP-DB] Re: Another dynamic sql.

2002-01-28 Thread Lerp
Your select options have no values associated with them! Not sure if you did this on purpose or not, but no value will be sent to next page. Joe :) "Raymond Lilleodegard" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi all! > > I have this form with some c

[PHP-DB] Re: [PHP]please help

2002-01-28 Thread Lerp
Hi there, here's an upload form that might be what u are looking for: Hope his helps you out :) Joe php page 1 Upload Photo: php page 2 -- receiving/upload processing page "; print $userfile_name . ""; // copy the file being posted if(copy($userfile, "/ez/codesnipits/temprotatingimages/"

[PHP-DB] Iterate through Multi-Dimensional Arrays

2002-01-11 Thread Lerp
Hi all, I have a multidimesional array that holds consultants and their details. I've tried this a number of ways but to no avail. Could someone help me out iterating through the first and then the second array and display those results on my webpage. I messed it up pretty badly :( heh Here's my

[PHP-DB] Record Page Through sqlServer Woes

2002-01-10 Thread Lerp
Hi all, I have a small php app where I'd like to incorporate page throughs of records, say 10 at a time. I'm using sqlServer and have run into a problem using the LIMIT statement within my query. Code: $sqls = "SELECT consultantid, firstname, lastname, city, country, category, yearsexp FROM CONS