[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

[PHP-DB] A challenge

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

[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

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

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

[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] 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] 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] Problem with LONG TEXT fields (ODBC-MS SQL 7)

2001-01-12 Thread Jonathan Kazmierczak
Hi! I've problem with print long texts. I have DB on MS SQL 7 and I use ODBC to connect with DB. I have one row, in which long text field takes about 5100 bytes. PHP can't print page with this text, but don't give me any error messages (other texts, 4096, are printed correctly). Printing this

[PHP-DB] RE: [PHP] connection id

2001-03-24 Thread Jonathan Sharp
will drop the connection when the script ends. Cheers, -Jonathan Sharp js_AT_imprev.com -Original Message- From: andrie [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 3:38 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP] connection id Hello php mania, i

[PHP-DB] PHP MySql

2001-04-08 Thread Jonathan Underfoot
even that dosen't work. Ideas? Thanx, -Jonathan Underfoot -- 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 PROTECTED]

RE: [PHP-DB] Advice On Building Dynamic MySQL Queries

2001-04-20 Thread Jonathan Hilgeman
I actually created an array of different conditions like: $ConditionsArray = array("Var1 500","Var2 1800","ID=43"); and then: $Conditions = join(" AND ", $ConditionsArray); This constructs: $Conditions = "Var1 500 AND Var2 1800 AND ID=43&qu

RE: [PHP-DB] Variable passing

2001-04-24 Thread Jonathan Hilgeman
(print PassHidden...) before each of your /FORM tags, and it should work fine. -- Jonathan Hilgeman -Original Message- From: Brinzoi Constantin Aurelian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 5:49 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Variable passing Hi ! Here

RE: [PHP-DB] Querying 2 databases...???

2001-04-24 Thread Jonathan Hilgeman
Why not just JOIN the tables using new columns in the sportDB? For instance, if your user names in the sportDB database and the user names in the mysql database match up, just do a JOIN ... ON sportdb.table_name.username_field = mysql.user.User You don't need two connections. Jonathan

[PHP-DB] PHP5 is NOT out yet, but 4.0.5 IS!

2001-05-01 Thread Jonathan Hilgeman
1) Check out the new 4.0.5 version of PHP. 2) Some of the functions in the documentation now say Feature added in 4.0.6 but I don't see that version available yet, since 4.0.5 was just released. Does that just mean they are enticing us or something? -Original Message- From: B. van

RE: [PHP-DB] web to access/excel

2001-05-22 Thread Jonathan Hilgeman
Hi Russ, Try this package: http://phpclasses.upperdesign.com/browse.html/package/237 You need to register for free to gain access, but this package is supposed to write Excel binary files. Jonathan -Original Message- From: Russ Michell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22

Re: [PHP-DB] PHP accessing MySQL

2001-05-22 Thread Jonathan Duncan
That is what I thought, so I set $db_num to another number and still came up with the same error. jkd Darren [EMAIL PROTECTED] wrote in message 9e42lj$s7b$[EMAIL PROTECTED]">news:9e42lj$s7b$[EMAIL PROTECTED]... I think the 0 is referring to your $db_num Jonathan Duncan [EMAIL P

Re: [PHP-DB] PHP accessing MySQL

2001-05-22 Thread Jonathan Duncan
Miles Thompson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Jonathan .. see below. At 08:38 PM 5/18/01 +, Jonathan Duncan wrote: Miles Thank you for the response. I did some debugging and the value of $dbs is 2. I am not sure of what exa

Re: [PHP-DB] PHP accessing MySQL

2001-05-22 Thread Jonathan Duncan
YES!! I just had a feeling the book was wrong. That did get rid of the error. However, it did not completely solve my issue. Now when I run the script I just get the message Couldn't list databases. This just happens to be the die message for the same line of code that I have been looking

RE: [PHP-DB] security in PHP under Apache

2001-05-23 Thread Jonathan Hilgeman
PHP runs via Apache, so it adopts the user that Apache uses, essentially. You can use a program like sudo to allow them to run certain commands on the server. Jonathan -Original Message- From: Simon R Jones [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 23, 2001 10:31 AM To: [EMAIL

RE: [PHP-DB] Connecting to MySQL

2001-06-21 Thread Jonathan Hilgeman
that is being sent. It simply appends the @localhost so you can see where you're connecting to. I would check the users table in the mysql database. - Jonathan -Original Message- From: Keith Whyman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 7:52 AM To: [EMAIL PROTECTED] Subject

RE: [PHP-DB] How do I backup my MySQL database? asks a Newbie.

2001-06-22 Thread Jonathan Hilgeman
servers, as well. That might help you. It's all in a single function library I called dbUtils. Just open up the file in a text editor, define as many servers as you want, and run the function you need. You can get it by going to http://www.hotscripts.com/Detailed/10533.html - Jonathan -Original

RE: [PHP-DB] MySQL Error???

2001-06-29 Thread Jonathan Hilgeman
I CC-ed the mailing list by accident. Below is my original reply to Brian. -Original Message- From: Jonathan Hilgeman Sent: Thursday, June 28, 2001 8:14 AM To: 'Brian Grayless' Cc: PHP-DB (E-mail) Subject: RE: [PHP-DB] MySQL Error??? Hi Brian, Sounds like you have a tinyint field

[PHP-DB] Re: MySQL Error

2001-07-10 Thread Jonathan Hilgeman
Are you running as the admin setting it up or are you a user on the system getting the error? Vivek Misra [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Dear Experts When ever i try to run MySQL under linux it gives me following error ERROR 2002 : can't

[PHP-DB] Re: Warning: Page has Expired

2001-07-11 Thread Jonathan Hilgeman
transient sid support if enabled ; by compiling with --enable-trans-sid - END SNIPPET - Hope this helps. - Jonathan Keith Spiller [EMAIL PROTECTED] wrote in message 003401c10a0f$6bd7da60$3083140a@aristotle">news:003401c10a0f$6bd7da60$3083140a@a

[PHP-DB] Re: Warning: Page has Expired

2001-07-11 Thread Jonathan Hilgeman
You can also change your form to use the GET method instead. That works without changing your php.ini file. But don't use GET methods for logging in or passing secure information. It's much more insecure than POSTing (not that POSTing variables is a 100% secure method, either)... Keith Spiller

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

2001-07-13 Thread Jonathan Hilgeman
post the upload to the same file if you want (so File 1 AND File 2 are whateverform.php). I just split them up for this example. I don't take credit for the fix_php_rh7_upload_bug function. That was posted by someone else on the PHP documentation. - Jonathan -Original Message- From

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

2001-07-16 Thread Jonathan Hilgeman
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have implemented the code even as one file but the php file just run without uploading the file to the server, though i have chmod the uploadfolder tmp as 777,, Any help.Thanks ... Jonathan Hilgeman [EMAIL PROTECTED] wrote in message

[PHP-DB] Re: mysql_fetch_array

2001-07-30 Thread Jonathan Hilgeman
try just changing mysql_fetch_array to mysql_fetch_assoc Bryan [EMAIL PROTECTED] wrote in message 006801c1192c$649f6e30$272478cc@bryanspc">news:006801c1192c$649f6e30$272478cc@bryanspc... mysql_fetch_array places 2 records for each one returned (example) Array ( [0] = 56

[PHP-DB] Re: Warning Page Expired

2001-07-31 Thread Jonathan Hilgeman
feature to keep people from seeing private, posted information. The GET method puts all the information in the query string, so there's nothing to hide, so caching doesn't become a problem. - Jonathan Olinux O [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]

[PHP-DB] Windows+GD-ed Images

2001-08-13 Thread Jonathan Hilgeman
have plenty of hard drive space left. - Jonathan -- 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 PROTECTED]

[PHP-DB] Resource Consumption

2001-08-13 Thread Jonathan Hilgeman
there. It seems that it cannot open the file or something - as if another process were using the file. The only explanation I can think of is that Apache never let go of the file after using it. Is this a possibility? Remember, I am using a Windows 2k platform. - Jonathan -- PHP Database Mailing List

[PHP-DB] Re: (OT) SQL query repeats

2001-08-15 Thread Jonathan Hilgeman
If you use GROUP BY lesson.l_id after your ORDER BY lesson.l_id, you will not get any records with the same lesson.l_id value. - Jonathan Adv. Systems Design [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... hello: I have 2 tables...lesson and lesson_gl

[PHP-DB] Re: (OT) SQL query repeats

2001-08-15 Thread Jonathan Hilgeman
Try one of the following: 1) Move the GROUP BY between WHERE and HAVING -OR- 2)SELECT l.*,lg.* FROM lesson l LEFT JOIN lesson_gle lg ON lg.l_id=l.l_id WHERE lg.glenum LIKE 'MA%' GROUP BY l.l_id ORDER BY l.l_id - Jonathan Adv. Systems Design [EMAIL PROTECTED] wrote in message [EMAIL

[PHP-DB] Re: query returned Resource id #2 (quick php/mysql tutorial)

2001-08-17 Thread Jonathan Hilgeman
will write the following to your screen: // George owns a Ferrari // Raymond owns a Honda // Betsy owns a Porsche Hope this helps. - Jonathan Default [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, I'm using PHP 4 and mysql. I'm trying to do just

Re: [PHP-DB] Photo Album Schema

2001-08-21 Thread Jonathan Hilgeman
Well said, Justin. I still would have to go with the scheme of: /photos/$UserID/$Category (?)/$FileName - Jonathan Hilgeman www.SiteCreative.com Justin Buist [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED].. . I'm going to play Devil's advocate a little

[PHP-DB] FreeBSD connecting to Access database on NT/2k

2001-08-22 Thread Jonathan Hilgeman
suggestions, but I will not mention them because they seemed to be confusing, and if anyone else suggests the solutions, the person might try to offer their own, better explanation of how it all works. I want something that's free, preferably. :) - Jonathan, www.SiteCreative.com -- PHP Database

[PHP-DB] Re: FreeBSD connecting to Access database on NT/2k

2001-08-22 Thread Jonathan Hilgeman
Also, I should mention that I have glanced at two methods: iODBC and OpenRDA, but I'd like to know if I can use PHP's dl() function to simply load them when needed, instead of having to recompile... - Jonathan Jonathan Hilgeman [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">new

[PHP-DB] Re: can you help to beginner?

2001-08-23 Thread Jonathan Hilgeman
)) { $company_name = $Row[companyname]; $service_name = $Row[servicename]; $Companies[$company_name][] = $service_name; } foreach($Companies as $Company = $ArrayOfServices) { print Company: $CompanyBR\n; foreach($ArrayofServices as $Service) { print $ServiceBR\n; } } -- Jonathan Andrius

Re: [PHP-DB] can you help to beginner?

2001-08-23 Thread Jonathan Hilgeman
Actually, He should be using three. While one company could use many services, you might also have other companies that offer the same service. So there should be 3 tables to allow a many-to-many relationship. See my e-mail response to him. - Jonathan Chris Hobbs [EMAIL PROTECTED] wrote

[PHP-DB] Re: Troubles in ODBC Land

2001-08-28 Thread Jonathan Hilgeman
; foreach($EnvVars as $Key = $Val) { putenv($Key=$Val); $HTTP_ENV_VARS[$Key] = $Val; } I can see via phpinfo() that they are getting set. Any more ideas? - Jonathan Jonathan Hilgeman [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm on a FreeBSD

[PHP-DB] ODBC Woes

2001-08-28 Thread Jonathan Hilgeman
(I'm on PHP 4.0.3), but not hte first, although I need to use the first example. Is there some sort of switch that lets you decide what format you can follow? - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

Re: [PHP-DB] ODBC Woes

2001-08-28 Thread Jonathan Hilgeman
I am attempting to use oPAYc (www.opayc.com) as a central method of payment processing. In order to pass information like different store configs or certificates at runtime, I need to pass them in the DSN string area. I'm using iODBC right now. - Jonathan Andrew Hill [EMAIL PROTECTED] wrote

Re: [PHP-DB] ODBC Woes

2001-08-28 Thread Jonathan Hilgeman
sor_type]) } else { $do_this='http://php.net/download-docs.php'; } On Tuesday 28 August 2001 22:05, Jonathan Hilgeman wrote: Okay, all I need to know is this: Some people say that they can only connect with: odbc_connect(DSN=Datasource;UID=username;PWD=password,,); Others say that does

[PHP-DB] Re: store an array in a mysqldb

2001-08-31 Thread Jonathan Hilgeman
in a mySQL database and then unserialize()-ed later. Here's the manual reference for some examples: http://www.php.net/manual/en/function.serialize.php - Jonathan Jeroen Van Bussel [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I would like

[PHP-DB] Re: resizing image in php

2001-08-31 Thread Jonathan Hilgeman
Any specific type of image? Look at the function and user comments on this PHP manual page. They have some good examples of resizing. http://www.php.net/manual/en/function.imagecopyresized.php - Jonathan Andrius Jakutis [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">new

Re: [PHP-DB] Password Question

2001-08-31 Thread Jonathan Hilgeman
to them? You also might try the Answer your secret question routine, where you type in a question that only you know the answer to, and you answer it to get the e-mail sent off... - Jonathan Jeff Oien [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I like

Re: [PHP-DB] Weird Problem In mysql_connect();

2001-08-31 Thread Jonathan Hilgeman
($host,$user,$pass); } -OR- function dbConnect ($host,$user,$pass) { $link = mysql_connect($host,$user,$pass); } - Jonathan Dave Watkinson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... yeah - everything's fine! All the variables are being stored, but

Re: [PHP-DB] Warning: Page has Expired

2001-09-04 Thread Jonathan Hilgeman
will get a cached page if you use your back button - but its extremely seldom. - Jonathan Dave Watkinson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... look in php.ini (or whatever the Linux equivalent is) for session.cache_limiter

[PHP-DB] Re: DB design question (so maybe a little OT)

2001-09-07 Thread Jonathan Hilgeman
I'm thinking that you should get all the common fields among the different types of people: F. Name, L. Name, Address, CC Number And then create a different table containing additional information that only pertains to certain types of people. Then join them using an id. - Jonathan Alexander

[PHP-DB] Re: NEWBIE - Needs Assistance with Joins

2001-09-17 Thread Jonathan Hilgeman
PHP code... - Jonathan Cecily Walker Kidd [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Hello, I have two tables, one that contains an item id, album title name, and artist ID number. The second table is a list of artists, with an auto-increment artist ID. I want to join

[PHP-DB] Exporting Access - MySQL with a macro

2001-09-18 Thread Jonathan Hilgeman
something about not finding an installable ISAM, and the help files seem to indicate that I need to specify a ODBC connection string in the field for Database Name. Can someone help me out here? - Jonathan (The mySQL database is used in my PHP application, so it's not totally off-topic

[PHP-DB] Re: Renaming a database name...

2001-09-19 Thread Jonathan Hilgeman
There is an excellent set of functions called dbUtils that takes care of this type of thing. You can get it from www.SiteCreative.com - Jonathan Arief Fajar Nursyamsu [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Dear All... Can I rename a datab

RE: [PHP-DB] Creating a file using php

2001-10-22 Thread Jonathan Hilgeman
by asking questions here. Bottom Line: Read, read, read, read, READ the manual. Rinse and repeat. - Jonathan -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 10:27 AM To: 'DL Neil'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Creating a file using php

RE: [PHP-DB] executing system commands

2001-10-25 Thread Jonathan Hilgeman
not defining the path to a command, i.e. system(mycommand); instead of system(/usr/bin/mycommand); Hope this helps if you're having problems. - Jonathan -Original Message- From: Ric Manalac [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 3:46 AM To: [EMAIL PROTECTED] Subject

[PHP-DB] SSL and IE

2001-10-26 Thread Jonathan Hilgeman
connect. I'm not what the difference is in the versions - any thoughts or known issues on this? - Jonathan ___ Mensa Torture: Drinking a 64 oz. Icee in 8 seconds. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] sending bulk emails

2001-11-02 Thread Jonathan Hilgeman
or received in that time. Anyone know beforehand whether I will get a timeout with sending these e-mails, and if so, how to work around it? - Jonathan -Original Message- From: Russ Michell [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 4:20 AM To: Cami Cc: PHP DB list Subject: Re

[PHP-DB] No Caching (Reloading Fresh Content)

2001-11-13 Thread Jonathan Hilgeman
uses their Back button to get to the page. Any thoughts on how to do this? - Jonathan -- 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 PROTECTED]

Re: [PHP-DB] No Caching (Reloading Fresh Content)

2001-11-13 Thread Jonathan Hilgeman
with this new LIMIT 100 query and return Number of Users: 100 - 2 So at this point I have either the option of forcing the user to see the IE page and have them reload it, which works, or by allowing caching to go on. Any more thoughts? - Jonathan Chris Boget [EMAIL PROTECTED] wrote in message [EMAIL

RE: [PHP-DB] Upload

2001-11-16 Thread Jonathan Hilgeman
); ? --- - Jonathan -Original Message- From: Lilian Salazar [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 8:09 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Upload Hi, Exists some component that allows to do upload from archives to the Web server? Where

[PHP-DB] MySQL Restarting A LOT

2001-11-20 Thread Jonathan Hilgeman
of the blue, and there's no patterns that I can follow. I have binary logging set up. Help... - Jonathan -- 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: [PHP-DB] MySQL Restarting A LOT

2001-11-20 Thread Jonathan Hilgeman
Nope - I've already tried there. Nobody answers the door. Now I'm trying here because it's a PHP application, there may be a possibility of someone else experiencing or that has experienced the problem and fixed it. Thanks for the link, anyway. I'm already a subscriber. :) - Jonathan

RE: [PHP-DB] No Caching (Reloading Fresh Content)

2001-11-20 Thread Jonathan Hilgeman
Thanks, but I think you already sent me that link. Or maybe it was a different Chris. Either way, I couldn't get any viable answers from there. - Jonathan -Original Message- From: Boget, Chris [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 1:30 PM To: 'Jonathan Hilgeman

[PHP-DB] MySQL Can't Create UNIX socket (55)

2001-11-26 Thread Jonathan Hilgeman
I occasionally receive an error message saying that PHP was unable to create a UNIX socket (55). Anyone else have this error or know what it is? - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [PHP-DB] PHP accessing MySQL

2001-11-27 Thread Jonathan Duncan
. Any ideas anyone? Julie? Miles? Could this have anything to do with mysql user permission? Thanks, jkd Jonathan Duncan [EMAIL PROTECTED] wrote in message 9eekpb$s41$[EMAIL PROTECTED]">news:9eekpb$s41$[EMAIL PROTECTED]... YES!! I just had a feeling the book was wrong. That did

RE: [PHP-DB] inserting mysql data using php array???

2001-11-27 Thread Jonathan Hilgeman
I actually have an easy way to do INSERTs like this. First I create the array: $MyArray[field] = value; $MyArray[name] = Jonathan; $MyArray[age] = 123; $MyArray[email] = $email_address; and then I define this function somewhere in a function library: function Array2Query($dbArray

[PHP-DB] Re: session.save_path

2001-11-29 Thread Jonathan Duncan
Thank you for the info Fred. As for the php.ini, I have been successful in adding options to my httpd.conf file and having them work. Jonathan Fred [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... PHP as an apache module requires the php.ini file. Loo

RE: [PHP-DB] Connecting to MySQL Database

2001-12-13 Thread Jonathan Hilgeman
, it won't be the same, because it won't match the encrypted password. - Jonathan -Original Message- From: Michael Elliott [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 5:54 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Connecting to MySQL Database I am trying to create

RE: [PHP-DB] Connecting to MySQL Database

2001-12-13 Thread Jonathan Hilgeman
would be to put all the session information at the very top of the script. - Jonathan -Original Message- From: Michael Elliott [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 8:40 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Connecting to MySQL Database Alright here goes

[PHP-DB] cURL not returning anything

2001-12-14 Thread Jonathan Hilgeman
the sample HTML page, but nothing came back. It's like the fetching process works, but there's a problem returning the contents to either a file or a variable. But there are no errors reported by PHP. Help! - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

RE: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jonathan Hilgeman
be empty/non-existent. - Jonathan -Original Message- From: SpyProductions Support Team [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 8:40 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Checkboxes, PHP, and MySQL I've looked around in a few of the PHP lists for an answer

RE: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jonathan Hilgeman
Or a better, more-visual way might be: ? if($result[32] == 1) $Checked = CHECKED; else $Checked = ; print INPUT TYPE='Checkbox' NAME='firstvalue' VALUE='1' $Checked; ? - Jonathan -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 8:45

RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Jonathan Hilgeman
I usually just create a cron job for this. Create your PHP script that will delete the matching records once. Then go into cron and have it run every 10 minutes. - Jonathan -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 11:21 AM To: [EMAIL

[PHP-DB] RE: [mysql-support] RE: [PHP-DB] Run php page automatically

2001-12-20 Thread Jonathan Hilgeman
to a log file: system('echo A new message MyLogFile'); I used to think that PHP was only for the purpose of viewing through web pages, but I've since found that it really can make a handy system tool sometimes when Perl is a hassle. - Jonathan -Original Message- From: NiteHaqr [mailto

RE: [PHP-DB] How to speed up querries in a humangous db?

2001-12-26 Thread Jonathan Hilgeman
the database, use your PHP or Perl code or whatever you use in order to specify which table to use. - Jonathan -Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 26, 2001 12:41 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] How to speed up querries in a humangous

RE: [PHP-DB] finding records wiht non-null columns

2002-01-03 Thread Jonathan Hilgeman
...WHERE some_column IS NOT NULL; - Jonathan -Original Message- From: bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 8:19 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] finding records wiht non-null columns Is there a better query than SELECT * FROM some_database WHERE

RE: [PHP-DB] How to querry two db in a single statement?

2002-01-04 Thread Jonathan Hilgeman
: --- | db1Name | db2Name | --- | George | Bill | | Mark | Henry| | Harry| Ford | --- Hope this helps. - Jonathan -Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 5:50 AM

RE: [PHP-DB] How to querry two db in a single statement?

2002-01-04 Thread Jonathan Hilgeman
if you want to sort the results alphabetically. - Jonathan -Original Message- From: Andreas Pucko [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 9:40 AM To: Jonathan Hilgeman Subject: AW: [PHP-DB] How to querry two db in a single statement? I wrote them

[PHP-DB] Fixed Quote Marks in Inputs

2002-01-04 Thread Jonathan Hilgeman
this helps someone else. - Jonathan -- 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 PROTECTED]

RE: [PHP-DB] Fixed Quote Marks in Inputs

2002-01-04 Thread Jonathan Hilgeman
to use slashes unless you're dealing with regexes. And not everybody does it that way. - Jonathan -Original Message- From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 1:41 PM To: Jonathan Hilgeman Cc: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] Fixed Quote

RE: [PHP-DB] Fixed Quote Marks in Inputs

2002-01-04 Thread Jonathan Hilgeman
for a lot of us. - Jonathan -Original Message- From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 2:39 PM To: Jonathan Hilgeman Cc: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] Fixed Quote Marks in Inputs Oh, one more thing - maybe you don't understand what

RE: [PHP-DB] Fixed Quote Marks in Inputs

2002-01-04 Thread Jonathan Hilgeman
and apparently experienced method that I only used because I listened to programmers like you (mind you, I said LIKE you, not YOU) who believe in standard procedure in all cases without considering more efficient options. - Jonathan -Original Message- From: Bogdan Stancescu [mailto:[EMAIL PROTECTED

RE: [PHP-DB] Fixed Quote Marks in Inputs

2002-01-04 Thread Jonathan Hilgeman
And I apologize if I came off as ultra-defensive/rude. I had a bad day, a bright idea, and then felt like someone was tearing it to pieces. This is like the PHP soap opera. - Jonathan -Original Message- From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 3

RE: [PHP-DB] Fixed Quote Marks in Inputs

2002-01-07 Thread Jonathan Hilgeman
... - Jonathan -Original Message- From: Boaz Yahav [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 12:07 AM To: Bogdan Stancescu; Jonathan Hilgeman Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Fixed Quote Marks in Inputs I just read your thread and I have to say that I was intrigued

RE: [PHP-DB] Similar Articles or Customers also bought...

2002-01-21 Thread Jonathan Hilgeman
, maybe, but it works. - Jonathan -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 3:25 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Similar Articles or Customers also bought... I am trying to figure a simple way of creating a script for a news site

RE: [PHP-DB] Query with numbers like 1, 3, 5..........

2002-02-07 Thread Jonathan Hilgeman
Yes, Even Numbers: SELECT * FROM table WHERE MOD(id,2) = 0; Odd Numbers: SELECT * FROM table WHERE MOD(id,2) != 0; - Jonathan -Original Message- From: Jeremy Peterson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:59 AM To: Raymond Lilleodegard; [EMAIL PROTECTED

Re: [PHP-DB] MySQL / PHP Database Help

2002-02-08 Thread Jonathan Underfoot
What does bool(false) mean? Thats off the vardump -J - Original Message - From: Jeroen Timmers [EMAIL PROTECTED] To: Jonathan Underfoot [EMAIL PROTECTED] Cc: [PHP-DB] [EMAIL PROTECTED] Sent: Friday, February 08, 2002 8:58 AM Subject: Re: [PHP-DB] MySQL / PHP Database Help Hello

[PHP-DB] Re: How To Upload

2002-02-08 Thread Jonathan Underfoot
with it (resize and edit images etc etc) but thats the basic layout... -Jonathan

Re: [PHP-DB] Re: [PHP] help - to get client IP

2002-02-11 Thread Jonathan Underfoot
[HTTP_X_FORWARDED_FOR]);} else {$IP = $HTTP_SERVER_VARS[REMOTE_ADDR]; $host = @gethostbyaddr($HTTP_SERVER_VARS[REMOTE_ADDR]);} -Jonathan - Original Message - From: Jeroen Timmers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [PHP-DB] [EMAIL PROTECTED] Sent: Monday, February 11, 2002 7:43 AM

Re: [PHP-DB] mySQL dB copy

2002-02-11 Thread Jonathan Underfoot
with this. -Jonathan PS: I use this utility to run daily backups. - Original Message - From: mike [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 11, 2002 7:50 PM Subject: [PHP-DB] mySQL dB copy Hello all, I am a relatively new php/mysql developer, I would like to take an entire

Re: [PHP-DB] Re: multiple forms, one submit button

2002-02-12 Thread Jonathan Underfoot
that made sense and worked out for you. This is simmilar to somethign I do where when someone submits a date and activity it is automatically checked for duplicity and accuracy before posting to the database (3 scripts.) -Jonathan - Original Message - From: Alecs [EMAIL PROTECTED] To: [EMAIL

Re: [PHP-DB] Required pages...

2002-02-12 Thread Jonathan Underfoot
the javascript commands on the netscape site, I don't know them offhand. If theres a PHP way to do it, I'm unsure of it. Regards, -Jonathan - Original Message - From: jas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 12, 2002 5:22 AM Subject: [PHP-DB] Required pages... I am

[PHP-DB] Re: How To Upload

2002-02-14 Thread Jonathan Underfoot
the forum has another idea? (Returned copy.) -Jonathan - Original Message - From: Luke Thomas [EMAIL PROTECTED] To: Jonathan Underfoot [EMAIL PROTECTED] Sent: Sunday, October 14, 2001 5:10 AM Subject: Re: How To Upload Hi, This Mail interested me very much, I am currently trying

[PHP-DB] SQL

2002-02-19 Thread Jonathan Underfoot
in the where clause? Thanx -Jonathan

Re: [PHP-DB] SQL

2002-02-19 Thread Jonathan Underfoot
be completely off base here..) Thanx, -Jonathan - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Jonathan Underfoot' [EMAIL PROTECTED]; [PHP-DB] [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 4:06 PM Subject: RE: [PHP-DB] SQL How could you possibly have

Re: [PHP-DB] SQL

2002-02-20 Thread Jonathan Underfoot
Actually, I'm running MS SQL which should allow me to sub-select Usually I work in MySQL -J - Original Message - From: Frank Flynn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 11:59 PM Subject: Re: [PHP-DB] SQL Jonathan, You

[PHP-DB] Secure Encrypt/Decrypt Functions

2002-02-21 Thread Jonathan Hilgeman
Does anyone know of a fairly simple, but secure technique for encrypting and decrypting text? - Jonathan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] The Debacle

2002-02-24 Thread Jonathan Underfoot
every time I list them (seems more difficult.) Either way, does anyone have the propper PHP function I should use? Thanks much... -Jonathan

Re: [PHP-DB] Problem with symbol

2002-02-25 Thread Jonathan Underfoot
In my experience PHPMyAdmin DOES NOT change anything. It never changes for me, and it dosen't addslashes(), which makes it a complete pain in the ass to use, but better than changing things without your knowledge I suppose. Maybe I'm using an old version? -Jonathan - Original Message

RE: [PHP-DB] Tutorial?

2002-03-04 Thread Jonathan Hilgeman
and to be patient, and if something goes wrong, here's how to contact us. - Jonathan -Original Message- From: Jennifer Downey [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 02, 2002 10:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Tutorial? Hi all, Can anyone point me to a good tutorial on how

  1   2   3   >