Re: [PHP-DB] Date Time 90 minutes ago

$date_90_minutes_ago = date('m/d/Y',mktime()-(60*90)); $time_90_minutes_ago = date('h:i:s',mktime()-(60*90)); 60 seconds * 90 minutes. =C= | | Cal Evans | http://www.calevans.com | | We get our best customers from referrals. | We would appreciate you referring any of your | friends or co-workers

Re: [PHP-DB] How can I solve this?

try $x =pathinfo($_SERVER['PHP_SELF']); echo $x['dirname']; =C= | | Cal Evans | http://blog.calevans.com | | Chris Payne wrote: Hi everyone, I am using PHP_SELF in order to get the current path on a dynamically created webpage. This gives me the following: /my_website/index.php

Re: [PHP-DB] problem of transmiting variabl into another page?

problems? =C= | | Cal Evans | http://www.calevans.com | Mohamed Yusuf wrote: I am transmitting variable from one of my pages and I would like to match that variable into mysql data. it won't return data. my code is this. ?php for ($j=A; $j = Z; $j++) { echo | ba href='alpha.php?artist=$j'$j/a/b

Re: [PHP-DB] how to reuse DB results

adodb has a moveFirst() function. You should be able to use it to display x rows then $rs-moveFirst() and then use a while loop to display all of them. HTH, =C= : : Cal Evans : Evans Internet Construction Company : 615-260-3385 : http://www.eicc.com : Building web sites that build your business

Re: [PHP-DB] SQL Statement

may have my story wrong.) Finally, you've already found the greatest tool for debugging MySQL/php, the lists. See ya round. =C= : : Cal Evans : Evans Internet Construction Company : 615-360-3385 : http://www.eicc.com : Building web sites that build your business : Thompson, Jimi wrote: For some

Re: [PHP-DB] Impact of MySQL Queries

will be more available for mysql and your web server. 4: Make sure you have the proper indexes set. If you do need 20 queries, 20 fast queries are better than 20 slow queries. :) HTH. Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So

Re: [PHP-DB] How to print doc

Agreed. It is possible to print things on the server side. I made the (incorrect) assumption that he wanted to control client-side printing from PHP. Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your business

Re: [PHP-DB] How to print doc

Assuming you mean from PHP, you can't directly do that. PHP is server side, Printing is client side. If you are working in a browser environment, you can explore your options within Javascript. Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your

Re: [PHP-DB] Saving arrays to databases?

that route, I would re-exaim your datamodel and see if tere wasn't a way to properly store it. Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your business. * * I think inside the sphere. Jeroen Wasteels wrote

Re: [PHP-DB] Planetside

What is the Planetside database? Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your business. * * I think inside the sphere. Madaleno wrote: Hi, can someone help me on how to access Planetside database to get some

Re: [PHP-DB] mssql and resource handling

the entire recordset and store the records as an array. The array you can save in your session. note if your record set is more than 100 records I would not do this. Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your

Re: [PHP-DB] nested sets?

may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your business. * * I think inside the sphere. ma wrote: hi everybody! i try to make a clickable menu. it should be outputed as XML. i found a solution to make it possible to decend only

Re: [PHP-DB] Read file

I wouldn't run it in a production environment.) Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your business. * * I think inside the sphere. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Read file

to fetch records from the database and return them to the currently running page without refreshing the page. (It can be done. It's ugly and it's a bugger to maintain, but it can be done.) Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you

Re: [PHP-DB] how to connect to access using ado library

checkout http://php.weblogs.com/ They have a database abstraction layer that works like ADO. It may do what you want. Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your business. * * I think inside the sphere

Re: [PHP-DB] Hyperlinking to a new page

$_GET['city'] but I use $_REQUEST because it contains both $_POST and $_GET. The variable names are case sensitive and must be exactly what you put on the URL. $_REQUEST['City'] != $_REQUEST['city'] HTH, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care

Re: [PHP-DB] Problem with php/mysql and ISS on windows XP profeesional

Sounds like you left off a $ when using a variable. I would take a look at line 158, find the variable name and make sure it's $name. Disabling the error will cause the message to go away but not fix the problem. humbly, =C= * Cal Evans * http://www.christianperformer.com * Stay plugged

Re: [PHP-DB] Problem with php/mysql and ISS on windows XPprofeesional

= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience * The measure of a programmer is not the number of lines of code he writes but the number of lines he does not have to write. * - Original Message - From: Adam Voigt [EMAIL PROTECTED] To: Ahmed Abdelaliem

Re: [PHP-DB] Can't Insert more than 1 record

HAR! Ok, seriously though, does your script return an error of any kind? Sounds like you are violating a primary or unique key in the second insert. What database engine are you using? =C= - Original Message - From: Leif K-Brooks [EMAIL PROTECTED] To: Keven Jones [EMAIL PROTECTED] Cc:

RE: [PHP-DB] print new account name on new account page?

to make sure that the select is being executed properly. =C= * * Cal Evans * Stay plugged into your audience. * http://www.christianperformer.com * -Original Message- From: Addison Ellis [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 18, 2003 1:58 PM To: [EMAIL PROTECTED] Subject

RE: [PHP-DB] Drawing chart

check www.zend.com www.freshmeat.net http://www.planetsourcecode.com/vb/default.asp?lngWId=8 to start with. * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Matthias Steiner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 01, 2003 5:28 PM

RE: [PHP-DB] Next/Prev 10 lines

check out php.weblogs.com ADODB does this for you. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Steve Dodkins [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 9:16 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Next/Prev 10 lines Has

RE: [PHP-DB] trees in MySQL

of the suggestions I read here, this system doesn't like holes in the numbers. But he gives code for adding and subtracting nodes. By combining the two, I actually made it so the client could move entire branches. HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original

RE: [PHP-DB] Catalog

, and don't forget Paul Dubois book on MySQL. I've not yet purchased a copy (sorry Paul) but the parts I've leafed through at the bookstore looked very good. Also, join the MySQL mailing list. (Paul actually hangs out over there) =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com

RE: [PHP-DB] Email Encryption?

Instead of emailing them the login and password info, setup a fax gateway and fax it to them. I used this in a situation that needed to be HIPA compliant. (If security is still an issue, fold the fax before sending it.) :) HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com

RE: [PHP-DB] Separating content from style

= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Dave Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 10:27 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Separating content from style Folks, I've just learned a bit about Java Beans and how

RE: [PHP-DB] search question

. HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Meltem Demirkus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:20 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] search question Hi, Is there any other efficient way (--except using

RE: [PHP-DB] Form question.......

will see a small window pop-up. Other than that, it is possible to use a Java Applet to do it as well. HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Rodrigo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 7:30 PM To: PHP Subject

RE: [PHP-DB] Indepth Tutorial... need help.

I must concur, Chapters 28 29 are worth the price of the book! =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 9:49 AM To: [EMAIL PROTECTED]; Matt Zur Subject: Re

RE: [PHP-DB] SQL query prob

!= $row['contactType']) When contactType changes again, you'll display it again and reset the flag again. HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Russ [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 8:44 PM To: PHP DB

RE: [PHP-DB] Re: Unified DB Query function

Casy, try php.weblogs.com ADODB. It is a database abstraction layer that supports Sybase. (Among other db backends.) HTH, =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Casey Allen Shobe [mailto:[EMAIL PROTECTED]] Sent

RE: [PHP-DB] how to create a graph from a db?

never done it myself but look into the png/jpg routines built into PHP. You can use them to dynamically create an image. What you DO with the image is up to you. :) Seriously, there are some tutorials out there about this very topic. hit phpbuilder.com or google.com to find them. =C= * * Cal

RE: [PHP-DB] Check Boxes

= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 10:33 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Check Boxes Hi-- Does anyone have any

RE: [PHP-DB] Keeping autoincrement ID 2 digits. Possible?

Not within the construct of auto_increment. You could , however write your own Serial Assigned Key (SAK) routine in PHP to enforce these business rules. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: Andy [mailto:[EMAIL

RE: [PHP-DB] classes and sessions

Yes. You can create your class, instantiate it and store it in the session like any other variable. However. before you issue a Session_start() you MUST have already included the class definition in your page. If you start the session and have not, it will throw an error because it will not

RE: [PHP-DB] reading a URL...

Try: $sqlStatement = "Select * from newStories where id = ".$GLOBALS['HTTP_GET_VARS']['id']. " order by whateverValue"; Then execute that statement. The value ID that you passed in on the URL is stored in the associative array $HTTP_GET_VARS. Check the manual at www.php.net, there's a section

RE: [PHP-DB] MySQL for Billng Question

Jeff, Check www.freshmeat.net There are a couple of packages out there that already do this. Some of them use MySQL. If nothing else, you can borrow their database schema. Cal http://www.calevans.com -Original Message- From: Jeff Oien [mailto:[EMAIL PROTECTED]] Sent: Monday, March

RE: [PHP-DB] table 1 to table 2

insert into table2 Select * from table1 where myConditionIsMet; Cal http://www.calevans.com -Original Message- From: Tobe Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 1:41 PM To: PHP-DB Subject: [PHP-DB] table 1 to table 2 Using PHP, I need to run a query against

RE: [PHP-DB] delete registers..

Depends on what registers are. If they are people then I would just shoot then and get it over with. :) Seriously, if you mean how do you delete records form a table that are more than a month old (let's say 30 days to make it simply) then you need to have a timestamp field in your table. Then

RE: [PHP-DB] MySQL connection problem - need help from expert

Greetings and Salutations Ian, Somewhere in your code you are going to have a line similar to this: $currentConnection = mysql_connect ($server, $userName,$password) $server is going to be either the name or the IP address of your server $userName is going to be the MySQL user name you use to

RE: [PHP-DB] help on modifications / subscribe / unsubscribe script

I'll take the easy one... #3: instead of: input type="TEXT" name="password" use input type="PASSWORD" name="password" Cal http://www.calevans.com -Original Message- From: Marc Bragg [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 10, 2001 11:46 AM To: [EMAIL PROTECTED] Subject:

RE: [PHP-DB] my sql text query

Nope, you change the field to not null then it won't allow null values in the database. Since the data already has null values, the Alter Table would probably fail. I'm still trying to figure out what any of this has to do with an index? Do you have an index on this description field? Cal

RE: [PHP-DB] using ID

Ohh, Ohh, OOHH! [waving hand wildly in the air] :) Because primary key should always be system generated and not a value that the user ever sees, can modify, or that means anything to anyone other than the system. usernames can change. PK's should never change. In this case, if