RE: [PHP-DB] MySQLnd support for ed25519

2021-09-08 Thread Jonathan Aquilina via php-db
Mysql 8 is already the stable version and has been for a while. I for development use it on windows and its v8 -Original Message- From: Ruprecht Helms Sent: 08 September 2021 16:02 To: php-db@lists.php.net Subject: Re: [PHP-DB] MySQLnd support for ed25519 Hi Dimi, I think mysql 8

Re: [PHP-DB] Debugger

2012-10-24 Thread Jonathan Sundquist
Do you have xdebug installed? - The cold winds are rising On Oct 24, 2012 7:02 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear list - A. Is anyone aware of a debugger that: 1] will step thru the code, 2] will stop at a point that input is requested [eg, form] and

Re: [PHP-DB] Re: php generators

2009-04-29 Thread Jonathan Langevin
maintained? ;-) -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On Wed, Apr 29, 2009 at 4:26 PM, Manuel Lemos mle...@acm.org wrote: Hello, on 04/28/2009 01:40 PM conor mahaney said the following: Hello Everyone, I am a beginner with PHP and Mysql and have dived

Re: [PHP-DB] php generators

2009-04-28 Thread Jonathan Langevin
for more info -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On Tue, Apr 28, 2009 at 12:40 PM, conor mahaney crmahan...@live.com wrote: Hello Everyone, I am a beginner with PHP and Mysql and have dived into a project that may be to much for me right now. I am still

Re: [PHP-DB] Bounty for PHP DB project

2009-03-23 Thread Jonathan Langevin
. -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On Mon, Mar 23, 2009 at 12:12 AM, Jack van Zanen j...@vanzanen.com wrote: Always willing to make a buck, but in all honesty I reckon if you use the adodb libraries it will take you all of 20 minutes to create this yourself

Re: [PHP-DB] MySQLi not closing connections

2008-11-27 Thread Jonathan Langevin
I was thinking the same bug, except that I'm not using real_connect (pass login params when initializing the class), and also the issue only occurs when logging is enabled. I'm really at a loss here :-\ -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On Wed, Nov 26

Re: [PHP-DB] MySQLi not closing connections

2008-11-26 Thread Jonathan Langevin
(',', $activity_log) . ')'; mysql_query($sql); mysql_close(); } exit; } /* /Snippet */ ? -- Jonathan Langevin PHP Site Solutions http://www.phpsitesolutions.com On Tue, Nov 25, 2008 at 3:02 PM, Fergus Gibson

[PHP-DB] MySQLi not closing connections

2008-11-25 Thread Jonathan Langevin
Hoping someone may have some insight. I'm a PHP developer for my current employer. Recently, a coworker and myself started revamping our PHP-based intranet to add more OO functionality and replace some of the repetitive procedural code that was in place. In this revamp, we also converted the

[PHP-DB] Re: Help with JOIN query

2008-03-06 Thread Jonathan Crawford
any. Implicit (or explicit INNER) JOINs will not show you all of the data. Jonathan Crawford [EMAIL PROTECTED] Original message Date: 6 Mar 2008 18:46:18 - From: [EMAIL PROTECTED] Subject: php-db Digest 6 Mar 2008 18:46:18 - Issue 3990 To: php-db@lists.php.net php-db

RE: [PHP-DB] Prevention for multiple submissions from the same form

2007-10-04 Thread Jonathan Gravois
I used the JavaScript method to disable the button after the first click and discovered from irate customers and administration that this resulted in an unsubmittable form on the AOL Browser although it worked perfectly in all others. Just a mention in case your clientele is AOL heavy (like ours).

[PHP-DB] Session Variable from Recordset

2006-04-30 Thread JONATHAN GRAVOIS
What is the syntax for pulling a field out of a query and setting it as a session variable? Thanks, Jon -- Jonathan Gravois Omni Sports Technologies 800.529.6664 X125 http://www.omnisportstech.com Quote: Failure is not the only punishment for laziness; there is also the success of others

[PHP-DB] Dynamic DataBinding in Form

2006-04-30 Thread JONATHAN GRAVOIS
I have an INSERT form with several fields two of which are FName and LName. There is also a field named CUSTOMER which is the concatenation of those two fields separated by a space. Is there a way to fill in customer as the user types in the other two fields. I used to do this in Coldfusion; can I

[PHP-DB] Newly inserted record ID

2006-04-30 Thread JONATHAN GRAVOIS
Thanks to the help of this list, I am making great progress. Now this -- I have a multi-part submission form for a support application for us, the manufacturer - the reseller's information is submitted, the customer's information is submitted, then the warranty support information needs to be

[PHP-DB] Compiling PHP with IMAP and OpenSSL

2005-12-24 Thread Jonathan Chong
/memcache' -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] passing DOMDocument Object to another function

2005-09-28 Thread jonathan
I am accessing information in my database. If the format is set to be html, I echo out the variables just fine. If the format is set to be xml, I create a DOMDocument. The problem is that in processing the result set, it calls several other functions. How do I pass the DOMDocument Object to

[PHP-DB] format of mysqli returned array

2005-09-23 Thread jonathan
Is there any documentation about how mysqli returns a result set? i use fetch_assoc on it and would like to write a result to a text file in the same format so that it could be opened at a later point and run through a while phrase. thanks, jonathan -- PHP Database Mailing List (http

[PHP-DB] what is the value of session_register

2005-09-22 Thread jonathan
Is there any values to this function? I'm looking over some code where this is a done a bunch of time and I don't see any value to it. Maybe I'm naive about the internals but... -jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] reg expressions- please help!!!!!1

2005-03-08 Thread Jonathan Trepczyk
is a flight from London Gatwick to Manchester. etc can some help with some ideas or sql queries i can use to query my database and then provide an appropriate answer or response to eaach query Thank you in davance for your help -- Jonathan Trepczyk -- PHP Database Mailing List (http://www.php.net

[PHP-DB] NLP to SQL queries

2005-02-07 Thread Jonathan Trepczyk
hiya guys, just trying to find the best way of translating natural language queries to sql queries to put in a website, i will be glad if you can help or point me towards the right direction Thanks for your help Jonathan -- Jonathan Trepczyk -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] database connectivity problem

2005-02-02 Thread Adams, Jonathan K. [C]
' Subject: Re: [PHP-DB] database connectivity problem Adams, Jonathan K. [C] wrote: Here is the error: Warning: sybase_connect() [function.sybase-connect]: Sybase: Unable to allocate connection record My configuration - The database is Sybase ASE 12.0 running on Solaris 8 The webserver

[PHP-DB] php database connectivity issues

2005-02-01 Thread Adams, Jonathan K. [C]
Here is the error: Warning: sybase_connect() [function.sybase-connect]: Sybase: Unable to allocate connection record My configuration - The database is Sybase ASE 12.0 running on Solaris 8 The webserver is Apache 1.3.33 with PHP 5 running Solaris 9 The sybase libraries are shared via NFS, which

[PHP-DB] database connectivity problem

2005-02-01 Thread Adams, Jonathan K. [C]
Here is the error: Warning: sybase_connect() [function.sybase-connect]: Sybase: Unable to allocate connection record My configuration - The database is Sybase ASE 12.0 running on Solaris 8 The webserver is Apache 1.3.33 with PHP 5 running Solaris 9 The sybase libraries are shared via NFS, which

[PHP-DB] Cannot load module php_mysql.dl!!

2004-11-11 Thread Jonathan Charette
I've got php5, apache2 and mysql4 installed. I've got some stardocks products installed and some registry tweaks too. My php.ini in C:\windows\ is I think correctly configured and I removed the ; before the mysql extension. I configured Apache2 httpd.conf for php5, from some forum on the net.

[PHP-DB] Cannot load module php_mysql.dll!!

2004-11-11 Thread Jonathan Charette
I've got php5, apache2 and mysql4 installed. I've got some stardocks products installed and some registry tweaks too. My php.ini in C:\windows\ is I think correctly configured and I removed the ; before the mysql extension. I configured Apache2 httpd.conf for php5, from some forum on the net. It

[PHP-DB] super define...

2004-11-01 Thread Jonathan Haddad
Is there a way to use define so it replaces the constant even if it's inside quotes? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] HTML stored in a text field

2004-10-06 Thread Jonathan Haddad
Gabe Covert wrote: I have a database which has a BLOB field storing text... It should probably be in a text field, but I don't think that's the problem... The field has HTML control codes, such as b, /b, and p. When I echo them from the database, a la: echo td . $row['textfield'] . /td I get the

Re: [PHP-DB] Space requirements (with respect to foriegn languages)

2004-08-26 Thread Jonathan Haddad
On Aug 26, 2004, at 12:27 PM, Gerard Samuel wrote: My site/code/database is developed primarily for the english language. I've had people from "The Far East" add content to my site using their native language, and it is displaying properly in the site. But Im a bit concerned

Re: [PHP-DB] Inserting a ' into mySQL

2004-08-23 Thread Jonathan Haddad
use mysql_escape_string. http://us3.php.net/manual/en/function.mysql-escape-string.php Jon Ron Piggott wrote: I have begun to create a Christian Ministry Directory. It is on the ministry web site I am building at http://www.actsministries.org/ministrydirectory/ . One of the problems I am now

Re: [PHP-DB] Timeout problem

2004-08-06 Thread Jonathan Haddad
can you just use a cron job and mysqlbackup instead? it does what you want and is already written. Jon Mauro Chojrin wrote: Hi: I'm developing a db application with php and I have this problem: I have a script for backup making which is very simple, it just goes through the entire database

Re: [PHP-DB] Begining PHP...Have Questions

2004-07-19 Thread Jonathan Haddad
if you have shell access, please do the following describe users; select * from users; also, why are you using LIKE instead of =? use this instead: $query = SELECT * FROM users WHERE email = '.$username.'; i would also suggest turning off register globals and using $_POST['username'] and not

Re: [PHP-DB] Begining PHP...Have Questions

2004-07-19 Thread Jonathan Haddad
what you mean at the end of your reply about register globals. Are you saying that everywhere I use $username to refer to the users inputed username I should use $_POST['username'] instead? Or are you suggesting to use this in one location. Thanks again for the reply, Aaron Jonathan Haddad [EMAIL

Re: [PHP-DB] mysql auto increment

2004-07-13 Thread Jonathan Haddad
There might be some system that requires a 4 digit number and the PK is being used directly. Also, this same system might need to be exported to Excel, which trims leading zeros and is generally a pain in the ass. Peter Westergaard wrote: I've done exactly this for a really cheap-and-dirty

[PHP-DB] Security Issues

2004-07-13 Thread Jonathan Haddad
writing to that folder? Jonathan Haddad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] problem....

2004-06-23 Thread Jonathan Haddad
Please post the table definition to the mailing list so we can help you more quickly. Also, is there a table called RuneRunner_1 or are you meaning to use RuneRunner_1 as an alias? Odds are, your problem is not PHP related, it's an error in your SQL syntax. Jon water_foul wrote: i fixed those

Re: [PHP-DB] Re: datetime update

2004-06-10 Thread Jonathan Haddad
[EMAIL PROTECTED] wrote: Hi all, i have a datetime field in a mysql database and it's defined with a default of '-00-00 00:00:00:' now, when i add a record to the database, i want to fill that field with the date and current time. can anyone point me ? Via PHP: $dateTime = date('Y-m-d

Re: [PHP-DB] Combining 2 queries into 1?

2004-05-30 Thread Jonathan Hadddad
How about select count(*) from online Jon On May 30, 2004, at 1:23 PM, Kim Steinhaug wrote: I have theese two queries : select count(*) as online from online where uid=''; select count(*) as online from online where uid!=''; Each online user has a uid (UserID), so if their logged inn this field

[PHP-DB] PG and error handling

2003-10-31 Thread Jonathan Scott
I have been looking for a resource on how to do proper error handling with PostgreSQL connections and queries. In one specific case, I have a referential integrity constraint on a table. When I try to delete from that table, it fails, as it should, when there is something referring to the

[PHP-DB] Excel file into MySQL

2003-09-30 Thread Jonathan Villa
Is it possible to transfer information from an excel file (33,000 rows) into MySQL using phpMyAdmin or MySQL CC? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Excel file into MySQL

2003-09-30 Thread Jonathan Villa
On Tue, 2003-09-30 at 10:31, Jonathan Villa wrote: Is it possible to transfer information from an excel file (33,000 rows) into MySQL using phpMyAdmin or MySQL CC? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Excel file into MySQL

2003-09-30 Thread Jonathan Villa
right... I was just looking for a quick answer without having to look for it myself... (I tend to be a little self-centered sometimes, sorry) On Tue, 2003-09-30 at 13:29, Jason Wong wrote: On Wednesday 01 October 2003 02:23, Jonathan Villa wrote: On Tue, 2003-09-30 at 10:31, Jonathan Villa

Re: [PHP-DB] Working query not able to run with PHP script.

2003-09-18 Thread Jonathan Villa
Sorry, I meant referenced in another table not database On Thu, 2003-09-18 at 16:09, Jonathan Villa wrote: I have several tables I want to delete as well as their reference in another database The query produced

[PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which is a 2 part script. First thing I do is pull

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
at 14:49, CPT John W. Holmes wrote: From: Jonathan Villa [EMAIL PROTECTED] I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how

RE: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread Jonathan Villa
a thought, Ryan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:28 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Need to Run a PHP script using CRON or ? Interesting... how does this fair concerning security? So I'll have

RE: [PHP-DB] Define()

2003-03-18 Thread Jonathan Villa
Edwin, There is no $ in front of the vars because it's a constant. $ signifies a variable. A variable's value can change, a constant's value cannot. --- Jonathan -Original Message- From: Edwin Boersma [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:43 AM To: [EMAIL

RE: [PHP-DB] Easy array question...

2003-03-12 Thread Jonathan Villa
$array_copy = array(); array_push($array_copy, $_SESSION['original_array']); echo $array_copy[0];//or whatever to test --- Jonathan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 10:43 AM To: 'Hutchins, Richard'; '[EMAIL

RE: [PHP-DB] Easy array question...

2003-03-12 Thread Jonathan Villa
Sorry, I just reread your post $array_copy = array(); array_push($array_copy, $original_array); echo $array_copy[0];//or whatever to test --- Jonathan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 10:56 AM To: 'NIPP, SCOTT V

RE: [PHP-DB] Easy array question...

2003-03-12 Thread Jonathan Villa
Try it with the original array first, just for testing --- Jonathan -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 11:10 AM To: '[EMAIL PROTECTED]'; 'Hutchins, Richard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Easy array

[PHP-DB] Define()

2003-03-12 Thread Jonathan Villa
I am developing an app which needs 3 constants. The value of these constants comes from a database result. This works fine. My problem is that they do not work very well. I am developing on both windows/Linux (depending what I boot into). This is the effect I want $doc_dir = the string of

RE: [PHP-DB] Define()

2003-03-12 Thread Jonathan Villa
(IMG_HOME_ROOT, /client_name/web/images/); and it didn't work What would be the difference between using that and $img_dir = /client_name/web/images/; --- Jonathan -Original Message- From: Jim Hunter [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 12:58 PM To: [EMAIL PROTECTED

RE: [PHP-DB] Define()

2003-03-12 Thread Jonathan Villa
that my image directory changes or a directory changes from login to register, then I don't want to have to go into EVERY SINGLE page and line of code to change it. --- Jonathan

RE: [PHP-DB] Define()

2003-03-12 Thread Jonathan Villa
Jim, I don't think that matters. One can escape into PHP in several ways (depending on the php.ini config of course) 1. ?php 2. ? 3. script language=php 4. % 5. ?= (to echo something right away) Anyway, I tried that and it still doesn't work. --- Jonathan

RE: [PHP-DB] Searchform to results.php

2003-03-07 Thread Jonathan Villa
SELECT .. FROM .$_POST['searchtype']; I'm not to sure if this is just for easy ready, but I haven't too many instances where the query is in all caps. Anyone, does case matter in a query? --- Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

[PHP-DB] Help with a query

2003-03-03 Thread Jonathan Villa
= $customer_id; -Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Help with a query

2003-03-03 Thread Jonathan Villa
is what I wanted to avoid, but I guess there's no other way Thanks for the quick reply. --- Jonathan -Original Message- From: Paul Burney [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:06 AM To: [EMAIL PROTECTED]; PHP Database List Subject: Re: [PHP-DB] Help with a query

RE: [PHP-DB] How to access a MS Access DB

2003-03-03 Thread Jonathan Villa
I believe I posted that thread. Try odbc_exec instead of odbc_prepare Let me know if have more problems --- Jonathan -Original Message- From: Beverly Steiner [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 3:11 PM To: [EMAIL PROTECTED] Cc: Beverly Steiner Subject: RE

[PHP-DB] Storing an array in the database

2003-02-28 Thread Jonathan Villa
How would I store an array in the database? I want to store 2 things. One array of shirt sizes and one array of which holds other arrays. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Storing an array in the database

2003-02-28 Thread Jonathan Villa
Thanks! I checked out the php docs, serialize() returns a string containing a byte-stream representation of value that can be stored anywhere. Perfect! --- Jonathan -Original Message- From: Chris Boget [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 10:43 AM

[PHP-DB] phpMyAdmin

2003-02-28 Thread Jonathan Villa
Ok, maybe this is strictly a phpMyAdmin Q, but I'm sure many of use it =) I have a server at home which runs phpMyAdmin. I also run it locally on my laptop. The cfg_uri for both is http://localhost/phpMyAdmin/ When I open a web browser (IE), I go to http://mydomainonmyserverathome/phpMyAdmin

RE: [PHP-DB] Customer id

2003-02-28 Thread Jonathan Villa
Create a customer_id field in the database, make it primary, int, and autoincrement --- Jonathan -Original Message- From: Dan Kelly [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 6:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Customer id How do I write a script

Re: [PHP-DB] php-dbase on RedHat 8.0

2003-02-27 Thread Jonathan Villa
That's odd. I haven't tried 4.3.1, but I do have 4.3.0 running on apache 2.0.44. I'll try 4.3.1 today and see if I come across anything. At Thursday, 27 February 2003, Roger Boily [EMAIL PROTECTED] wrote: Hi, I have upgrated to RedHat 8.0 that unfortunatly downgrade my working php 4.3.1 to

RE: [PHP-DB] Get MySQL table schema for a dump

2003-02-27 Thread Jonathan Villa
I never thought of mysql_fetch_row. What I ended up using was $row = mysql_fetch_array($result_id); echo $row[1]; I'll probably use fetch_row as it makes more sense. Thanks. --- Jonathan -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday

RE: [PHP-DB] Processing Page

2003-02-27 Thread Jonathan Villa
--- Jonathan -Original Message- From: Aspire Something [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 1:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Processing Page Hi all, Permit me to recive your valuable knowledge , We are working on a project where the backend churns

RE: [PHP-DB] Processing Page

2003-02-27 Thread Jonathan Villa
META HTTP-EQUIV=refresh CONTENT=5;url=http://yourpagehere; 5 = time to wait --- Jonathan -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:10 PM To: 'Aspire Something'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Processing Page

RE: [PHP-DB] Processing Page

2003-02-27 Thread Jonathan Villa
META HTTP-EQUIV=refresh CONTENT=5;url=http://yourpagehere; 5 = time to wait --- Jonathan -Original Message- From: John A DAVIS [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:23 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Processing Page What are the correct

RE: [PHP-DB] Re: Processing Page

2003-02-27 Thread Jonathan Villa
I guess I was thinking of a success only scenario. If the backend never failed, then an easy Meta redirect would work, (if given enough time to process). However, in the real world, assuming success is a foolish mistake. --- Jonathan -Original Message- From: [EMAIL PROTECTED

RE: [PHP-DB] Re: Processing Page

2003-02-27 Thread Jonathan Villa
that, I know it involved 3 pages 1. please hold page 2. page to verify the status of the process, then redirect to #1 or else #2 3. final result --- Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fredrik de Vibe Sent: Thursday, February 27

RE: [PHP-DB] Processing Page

2003-02-27 Thread Jonathan Villa
work if you could set the field being used as a point of a reference when the other process is running. ??? --- Jonathan -Original Message- From: Aspire Something [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:56 PM To: php-db Subject: Re: [PHP-DB] Processing Page

RE: [PHP-DB] Re: Get MySQL table schema for a dump

2003-02-26 Thread Jonathan Villa
Sorry, I should have explained that I want to do this via PHP. --- Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fredrik de Vibe Sent: Wednesday, February 26, 2003 5:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Get MySQL table

RE: [PHP-DB] Get MySQL table schema for a dump

2003-02-26 Thread Jonathan Villa
...)) ??? or while ($rows = mysql_fetch_array()...) --- Jonathan -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9:49 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Get MySQL table schema

[PHP-DB] Issue with this particular SQL query construction

2003-02-18 Thread Jonathan Chum
I have two tables. Table_1 contact_id (INT 5) Table_2 contact_id (INT 5) type (enum '1','2') data (TEXT) In table_2, there is a possible of two records that can be associated to an entry in table in the form of the record type can be an either 1 or 2. There will always be a type 1, but not

RE: [PHP-DB] How to access a MS Access DB

2003-02-14 Thread Jonathan Villa
this error. Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in D:\is\clients\eki\killer_spin\new_web\test_connect.php on line 3 Failed. I'm not to sure how to set this up to work with PHP --- Jonathan

[PHP-DB] RE: your odbc problem can be solved

2003-02-14 Thread Jonathan Villa
hard pressed for time and have not found the right info on the web which is why I am asking what I am asking. Thanks in advance. --- Jonathan -Original Message- From: John A DAVIS [mailto:[EMAIL PROTECTED]] Sent: Friday, February 14, 2003 10:45 AM To: [EMAIL PROTECTED] Subject

RE: [PHP-DB] passing variables

2002-12-09 Thread Jonathan
One of many possible things. Dependent on the version of PHP you are using, you might have register_globals set to off in your php.ini file, which is preferable. In which case you'll have to use If($_REQUEST['variable']) Or If(isset($_REQUEST['variable'])) Second possible is: I've never

RE: [PHP-DB] CREATE TABLE QUERY PHP/MySQL

2002-12-06 Thread Jonathan
- Original Message - From: Jonathan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 06, 2002 10:00 PM Subject: [PHP-DB] CREATE TABLE QUERY PHP/MySQL This is the first time I am trying to create a table in MySQL based on user input. Here is the scenario

[PHP-DB] regarding multiple joins

2002-11-22 Thread Jonathan Narong
this is a problem i've been struggling with for a little while. any attempt to find help online has not produced any useful information. this is regarding joins, which i'm not an expert in, but hopefully one of you can help me out. i have an table 'articles' which has multiple fields, such as

[PHP-DB] RE: inserting html into mysql tables

2002-11-22 Thread Jonathan Narong
5k of data is way too much for varchar, so i would use a field of type TEXT. i do this as well (storing html data in mysql) and it works great. some say to use addslashes() although, on my setup (3.23/4.1) it seems to addslashes automatically - not sure exactly why that is though. -Original

RE: [PHP-DB] RE: regarding multiple joins

2002-11-22 Thread Jonathan Narong
that worked perfectly! thank you so much! -jon -Original Message- From: Rick Widmer [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 6:08 PM To: Jonathan Narong; David Elliott; Jonathan Narong on PHP-DB Subject: Re: [PHP-DB] RE: regarding multiple joins At 05:26 PM 11/22/02

[PHP-DB] creating a new mysql automatically every day?

2002-11-18 Thread Jonathan Narong
i'm currently building a traffic analysis application for a website. it is my first time working on such a project, so i'm not even sure if this would be the best way to do it all, but here it goes. what i would like to do is count the number of hits that go to different sections of the site. i

RE: [PHP-DB] creating a new mysql automatically every day?

2002-11-18 Thread Jonathan Narong
John, That is good advice. I wasn't aware of indexes/keys slowing down inserts. Whats the best way to copy a table over to another table though? -jon -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 5:36 PM To: 'Jonathan Narong'; [EMAIL

[PHP-DB] RE: Displaying a single picture...

2002-11-12 Thread Jonathan Narong
not sure i understand why you would need to use a php script for this? why not just use a static html img tag, if all you're doing is opening the picture in a new window? -jon -Original Message- From: Brett Lathrope [mailto:brett;lathrope.com] Sent: Tuesday, November 12, 2002 1:44 PM To:

[PHP-DB] RE: date questions in mySql

2002-11-12 Thread Jonathan Narong
yes, you need to insert the date as -mm-dd. you can go around this and still have the user see a form field with mm/dd/ but you need to break each part down, and play with the string functions so the final mysql query is in -mm-dd. -jon -Original Message- From: Paul Ihrig

[PHP-DB] Re: Multi-Dimensional Arrays

2002-10-10 Thread Jonathan Duncan
tArray[1][ItemNumber] = $itemnumber; $cartArray[1][Brand] = $brand; $cartArray[1][Quantity] = $itemqty; $cartArray[1][ItemName] = $itemname; Note that $cartArray[] = $val is just a short hand way of doing array_push($cartArray, $val); Cheers, Owen Prime http://www.noggin.com.au Jonatha

[PHP-DB] Multi-Dimensional Arrays

2002-10-09 Thread Jonathan Duncan
($itemnumber=$brand, $itemqty, $itemname)); print_r($cartArray).BRBR; echo $cartArray[0][0].BRBR; Thank you, Jonathan Duncan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Are running sessions using a MySQL handler faster?

2002-08-21 Thread Jonathan Thomas
Good afternoon! Quick performance question - I'm currently preparing the release of a new website running on a Linux box written in PHP and MySQL with sessions throughout. I've read a bit about changing the PHP session handler to use a database vs. the flat file method. Does anyone have

[PHP-DB] resource ID #3

2002-07-11 Thread Jonathan
to the mysql que. Then, I have a second database which matches each abbreviation with the proper name. When I try to run any query on the second database, the only output I recieve is resource id #3 Any suggestions? Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] A challenge

2002-07-03 Thread jonathan
suggestions?? Deeply appreciated. Thanks. [EMAIL PROTECTED] -- Jonathan

[PHP-DB] retrieving all information from a single table

2002-06-21 Thread Jonathan
;$a4;$a++) { for($i=0;$i4;$i++) { $row = mysql_fetch_array($result); echo $row[i][organization].br; echo $row[i[location].br; echo $row[i][charge]; } } ? /body /html -- Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

RE: [PHP-DB] appending new entry to old entries

2002-04-18 Thread Jonathan Hilgeman
Text to the end of MyField without a query to get the previous values. For numeric fields, you can also increment them like this: UPDATE table SET MyNumericField = MyNumericField + 1; That would update all rows in table, incrementing every row's MyNumericField value by 1. - Jonathan

RE: [PHP-DB] page expires

2002-04-18 Thread Jonathan Hilgeman
http://php.sitecreative.com/faq.php -Original Message- From: Natividad Castro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 6:12 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] page expires Hi to all, I have form that users fill out and submit. What I'm trying to do is not to

[PHP-DB] PHP to Fax

2002-04-16 Thread Jonathan Hilgeman
with scripting? #2 Does anyone know about fax servers or how to obtain one? - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL to Email and Line Breaks

2002-04-14 Thread Jonathan David Edwin Wright
Hiya, If I remember correctly, you much send both \r and \n to terminate a line on an e-mail, regardless of the platform. This should include the header aswell. At 12:00 14/04/2002 +0100, DL Neil wrote: Jeff, I have a form where someone enters the body of an email message into a textarea

RE: [PHP-DB] Saving DB Resuts to a file

2002-04-12 Thread Jonathan Hilgeman
or not, and if there are other people that could get on the server). Then try running the script again. - Jonathan -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 1:52 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Saving DB Resuts to a file Hi

RE: [PHP-DB] How to avoid: Warning: Page has Expired

2002-04-09 Thread Jonathan Hilgeman
I've addressed this problem here: http://php.sitecreative.com/faq.php - Jonathan -Original Message- From: John Hughes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 12:30 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] How to avoid: Warning: Page has Expired I have the first

RE: [PHP-DB] grouping by category

2002-04-04 Thread Jonathan Hilgeman
arrays are a little hard to grasp at first, but they can make things a lot easier to read/understand, which is what I strive for in my coding (over speed). You never know who will one day read your code... - Jonathan -Original Message- From: Alex Behrens [mailto:[EMAIL PROTECTED]] Sent

RE: [PHP-DB] Editing/Updating Data with Forms

2002-04-04 Thread Jonathan Hilgeman
Just look at your basic PHP tutorials like Devshed's PHP 101: http://www.devshed.com/Server_Side/PHP/PHP101 - Jonathan -Original Message- From: Evans, Josh [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 7:31 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Editing/Updating Data

RE: [PHP-DB] need some help...

2002-04-02 Thread Jonathan Hilgeman
Thank you. Someone else exists who has the sense of mind to use single quotes. I hate looking at other people's code that has tons of \s in it. - Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 5:00 PM To: [EMAIL PROTECTED

RE: [PHP-DB] int or tinyint

2002-04-01 Thread Jonathan Hilgeman
... - Jonathan -Original Message- From: Jennifer Downey [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 31, 2002 10:06 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] int or tinyint Hi all, Just a simple question (I think). When should I use tinyint over int. and what is the difference

RE: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Jonathan Hilgeman
. - Jonathan -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 12:45 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Pop up are you sure... On Monday 01 April 2002 16:44, Dave Carrera wrote: Hi All How do you do this? Use javascript

RE: [PHP-DB] Pop up are you sure...

2002-04-01 Thread Jonathan Hilgeman
shrug I was close. :) -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Monday, April 01, 2002 10:53 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Pop up are you sure... On Tuesday 02 April 2002 01:30, Jonathan Hilgeman wrote: You're so negative, Jason. :) No, my

  1   2   3   >