答复: [PHP-DB] Values in a date field

2007-03-17 Thread Jacob
$date=Getdate($subsciption_begins); $month=$date[mon] -邮件原件- 发件人: Ron Piggott [mailto:[EMAIL PROTECTED] 发送时间: 2007年3月17日 21:45 收件人: PHP DB 主题: [PHP-DB] Values in a date field I have a $subscription_begins variable. It the date type. -MM-DD How may I find out the month value (1

答复: [PHP-DB] Urgent! Installing PHP 4 on 6 4-bit machines

2007-03-08 Thread Jacob
Congratulations !!! -邮件原件- 发件人: Ng Hwee Hwee [mailto:[EMAIL PROTECTED] 发送时间: 2007年3月8日 16:23 收件人: php-db@lists.php.net 主题: Re: [PHP-DB] Urgent! Installing PHP 4 on 64-bit machines Hi all, Just to close this thread in case someone encounters the same problem as me. The issue is solved

答复: [PHP-DB] Urgent! Installing PHP 4 on 6 4-bit machines

2007-03-07 Thread Jacob
Check if phpmyadmin has the same problem. -邮件原件- 发件人: Niel Archer [mailto:Niel Archer] 代表 Niel Archer 发送时间: 2007年3月7日 19:58 收件人: php-db@lists.php.net 主题: Re: [PHP-DB] Urgent! Installing PHP 4 on 64-bit machines Hi I've only had MySQL 4.1 running on 64 bit windows and PHP 5.x, without

答复: [PHP-DB] Urgent! Installing PHP 4 on 6 4-bit machines

2007-03-06 Thread Jacob
Hello all: Maybe, you should ask M$ ,in M$DN to give help. -邮件原件- 发件人: Chris [mailto:[EMAIL PROTECTED] 发送时间: 2007年3月7日 9:30 收件人: Ng Hwee Hwee 抄送: php-db@lists.php.net 主题: Re: [PHP-DB] Urgent! Installing PHP 4 on 64-bit machines Ng Hwee Hwee wrote: Hi Niel, The problem is my

答复: 答复: [PHP-DB] Urgent! Installing PHP 4 on 64-bit machines

2007-03-06 Thread Jacob
Because we don't know ,but if it is a uncommon thing, M$ should give some information about it , if not , we meet a new problem , we should ask M$ or intel for help. -邮件原件- 发件人: Chris [mailto:[EMAIL PROTECTED] 发送时间: 2007年3月7日 9:56 收件人: Jacob 抄送: 'Ng Hwee Hwee'; php-db@lists.php.net 主题

[PHP-DB] Splitting Arrays in Half

2004-12-09 Thread Jacob Hackamack
will be here for any questions you have. Thanks Again, Jacob $total_count = 0; $display_count = 0; //Do for each item foreach ($item as $sched) { /*$total_count++; $sched[] = array( 'teama' = $item[teama], 'teamb

[PHP-DB] Correction: [PHP-DB] Splitting Arrays in Half

2004-12-09 Thread Jacob Hackamack
. Hopefully it clairifies some things On 12/9/04 1:28 PM, You, Jacob Hackamack, with the internet address: [EMAIL PROTECTED] wrote: Hello all, I have the following code and here is my goal: I have an array and right now, as the code stands, I have one column of data on a page. I want it to have

[PHP-DB] Question

2004-11-08 Thread Jacob Hackamack
on their work pnRedirect(pnModURL('Standings', 'admin', 'viewteams', array('lid' = $lid))); // Return return true; } The only problem is that the image upload does not seem to work. Any help that you might provide or guidance would be greatly appreciated. Thank you in advance. Jacob L

[PHP-DB] Session Values Change

2004-07-27 Thread Jacob Hackamack
tried a couple of options (a hrefs) but they didn¹t seem to work and was wondering if anybody had any suggestions. Thank You In Advance Jacob ?php session_start(); if (! isset($_SESSION['view'])) { $_SESSION['view'] = Jacob; } ? #FORMATTING CODE HERE $dbuser='php

[PHP-DB] Quick Question: Line Breaks

2004-01-08 Thread Jacob Hackamack
suggestions please help out. Thanks for advance. Jacob

RE: [PHP-DB] Re: send email

2003-11-27 Thread Jacob A. van Zanen
Hi This is PHP code and will be parsed by the webserver before being send out to the browser. All that is displayed in the browser is the non PHP stuff. So the email address is in the source code of the php page but when you click 'view source' in your browser you won't see it. Jack

RE: [PHP-DB] send email

2003-11-25 Thread Jacob A. van Zanen
Hi, Here a bit of code that I use in a members list (this is the update bit) CODE SNIPPET if (isset ($_GET['update']) OR isset ($_POST['update'])) { $db = @mysql_connect(localhost, username,password); mysql_select_db(walvis,$db); if(isset($_POST['enter'])) {

RE: [PHP-DB] using code for multiple sites

2003-11-13 Thread Jacob A. van Zanen
Hi You could create an alias in every virtual host pointing to the same directory for all sites, or I believe apache will use anything outside the virtual host tags as being default for all sites. Jack -Original Message- From: mike [mailto:[EMAIL PROTECTED] Sent: Thursday, November

[PHP-DB] BBEdit

2003-11-06 Thread Jacob Hackamack
of the site is up at http://www.filmcanister.com/Education/Physics/ If anybody wants to take a look at it (don't be afraid to put in a fake name and period, the table is backed up and won't go live for some time) :). Thank you one and all. Jacob -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Problem Solved

2003-11-05 Thread Jacob Hackamack
Thanks for your help, I was able to go through line by line and fix what was wrong, I guess a simple rewriting of some code solved it because now its better and faster then before. Thank You all. Jacob

RE: [PHP-DB] Selecting two names from a table

2003-10-06 Thread Jacob A. van Zanen
Hi, Try something like this: SELECT U1.User_Name , U2.User_Name , B.Booking_Date FROMUSER U1 , USER U2 , BOOKING B WHERE B.Booking_Creator = U1.User_ID AND B.Booked_User = U2.User_ID' Jack -Original

RE: [PHP-DB] Need help with a OpenLink ODBC driver error again

2003-10-06 Thread Jacob A. van Zanen
Hi Does the query return data when executed not through a browser but directly on the database? If yes, how much time does it take to return the data. I believe default time out for apache is 30 seconds. So maybe it's a webserver setting that needs to be increased. Jack -Original

RE: [PHP-DB] UPDATE part of a column

2003-09-23 Thread Jacob A. van Zanen
As a separate issue, I would consider seperating the address field into it's individual parts Street,area,city etc.. All different fields -Original Message- From: Shaun [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 2:03 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] UPDATE

RE: [PHP-DB] Databases and PHP?

2003-09-22 Thread Jacob A. van Zanen
PHP can be used with many different databases (MySql support is just built in, others you have to compile in). I do not know about DB2 but ODBC is always possible Jack -Original Message- From: IN [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 11:31 AM To: [EMAIL

RE: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

2003-09-22 Thread Jacob A. van Zanen
Hi, I think this is what you are trying to do. You get a record back that has seveal fields and you want to reference those fields indiviually. This is what I do in this example (which shows people information) and present in HTML table

RE: [PHP-DB] Email Form

2003-09-16 Thread Jacob A. van Zanen
Hi, Combine the two scripts Begin script Accept the post variables Insert them into the database Mail them End script jack -Original Message- From: Philip O'Rourke [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Email

RE: [PHP-DB] Whios request record in database

2003-09-12 Thread Jacob A. van Zanen
In order to insert data into database you'll need an insert statement I only see select * from $table Jack -Original Message- From: IS [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 1:32 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Whios request record in database I want

RE: [PHP-DB] include_path problem

2003-09-03 Thread Jacob A. van Zanen
I have not really followed this thread so if it is mentioned already. Is the include_path directive twice in the file? -Original Message- From: Ford, Mike [LSS] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 3:42 PM To: 'Bruce Levick' Cc: [EMAIL PROTECTED] Subject:

RE: [PHP-DB] another PHP Sql question...

2003-08-29 Thread Jacob A. van Zanen
One question: Do you mean that a b are from the same column but are row 1 2 from your query result.? If so, you can possibly write a loop like so Dump all your records in an array; Start loop for as long you find records in array { Take the first record from your array and dump it

RE: [PHP-DB] SELECT Part of a Field

2003-08-29 Thread Jacob A. van Zanen
Depending on the database you are using Substring() Substr() Functions do what you want jack -Original Message- From: Shaun [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 11:58 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] SELECT Part of a Field Hi, How can I SELECT a

RE: [PHP-DB] Simple field replace...?

2003-08-28 Thread Jacob A. van Zanen
Try using the substring function in your sql statement Substring('String',32); Jack -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 11:35 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Simple field replace...? Hi there, I need to

RE: [PHP-DB] Database backup

2003-08-27 Thread Jacob A. van Zanen
How'bout backing up your data directory (ies) Otherwise you can maybe use mysql_dump in a batch?? Jack -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 11:46 PM To: php Subject: [PHP-DB] Database backup Hi there everyone, Is there a

RE: [PHP-DB] MYSQL 4.1 derived tables and PHP

2003-08-22 Thread Jacob A. van Zanen
Hi THX I added mysql_error() to get the error message. I got the message that the user did not have rights on table /tmp/dbla.bla I figured that I must give some more global read rights to this user (not just DB read rights). After that it worked. THX Jack -Original Message-

Re: [PHP-DB] It\'s wierd when I\'ve used forms...

2003-08-22 Thread Jacob A. van Zanen
You'll have to look into stripslashes function (of the top of my head) PHP automatically puts slashes around variables Jack On Fri, 2003-08-22 at 23:35, Joe Walker wrote: I've got a form (for sending mail to a user) and the user input is in an html form using the post method to pass:

Re: [PHP-DB] It\'s wierd when I\'ve used forms...

2003-08-22 Thread Jacob A. van Zanen
I mean in front of special characters off course :-) Jack On Fri, 2003-08-22 at 23:40, Jacob A. van Zanen wrote: You'll have to look into stripslashes function (of the top of my head) PHP automatically puts slashes around variables Jack On Fri, 2003-08-22 at 23:35, Joe Walker wrote

[PHP-DB] PEAR DB

2003-07-28 Thread Jacob Marble
Hey all- Before I ask my question, is there a more appropriate NG for PEAR::DB related questions? It always bugs to have off-topic posts... Thanks, Jake LandEZ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PEAR DB getAssoc()

2003-07-10 Thread Jacob Marble
); And here's the output: array(1) { [1]= array(16) { [0]= string(5) Jacob [1]= string(6) Marble [2]= NULL etc... As I understand it, an associative array should return something more like: array(1) { [1]= array(16) { ['firstname']= string(5) Jacob

[PHP-DB] Re: Problem with 4.3.2

2003-06-13 Thread Jacob Marble
Interesting. They say the ISAPI module isn't production quality yet... we use it, though, w/o problems. We're running IIS on Win2000 and php 4.3.2. Does it work besides the phpinfo() problem? Jake LandEZ Ryan Jameson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] More info... I

[PHP-DB] Client API version is wrong or am I?

2002-11-20 Thread Jacob Larsen
I have installed the MySQL 4.0.4 client, but when I look at phpinfo() I see that it says: Client API version: 4.0.2-alpha Why? Regards, Jacob -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] previous and next links with php postgresql

2002-09-12 Thread Chandler, Jacob R
http://www.webmasterbase.com/article/662 -Original Message- From: Angelo Marcos Rigo [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] previous and next links with php postgresql Hi I am trying to have previous and next

RE: [PHP-DB] Time Question

2002-02-14 Thread Jacob Wyke
Use: date(n/j/Y g:i:s A); If you need any more help on what the letters mean, or you need to change the layout visit: http://www.php.net/manual/en/function.date.php keTTle_drum. Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a mssql7.0 backend. The

[PHP-DB] Web Poll Using sql

2002-01-17 Thread Jacob Wyke
Hi, I know this must sound like a really easy question, but im trying to create a simple web poll, where you choose your answer from a radio button and then click submit. On submitting I would like to update a sql table depending on what box the user clicked. How can I make it so it increments

RE: [PHP-DB] Windows, MSSQL varchar255 caracters?

2001-11-12 Thread Jacob Anderson
The VARCHAR(255) bug is actually a limitation imposed by ODBC - so I suspect the MSSQL library uses ODBC for communication with a SQLServer installation. I've experienced the same problem using Java JDBC and some older SQL Server drivers. Recent type-4 MS SQL Server drivers for JDBC have fixed

[PHP-DB] Abstraction layers

2001-10-24 Thread Jacob Singh
What is everyone's favorite abstraction layer? -- Jacob Singh, [EMAIL PROTECTED] on 10/24/2001 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

Re[2]: [PHP-DB] Selecting twice from the same table

2001-09-13 Thread Jacob Singh
Hello Justin, Thursday, September 13, 2001, 11:07:26 AM, you wrote: JB On Thu, 13 Sep 2001, Jacob Singh wrote: Hello, main -- ID autonumber content_ID enum('artist','song','album',user function','genre', etc.) name char img char des char etc. etc. songs

[PHP-DB] Backups, best practices

2001-09-06 Thread Jacob Singh
Hello, I'm just wondering how everyone manages their MySQL backups, I'm looking for a better solution than manual. any scripts or example would be especially appreciated. tnks -- Best regards, Jacob Singh Pajama Design (413)582-9342 2 Belanger Pl. Northampton, MA 01060