Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-28 Thread Jason Wong
this file owned and readable only by root. Set the program owned by root, executable by everyone and suid. If you don't need the flexibility of the custom program and would rather make use of existing infrastructure: http://marc.theaimsgroup.com/?l=php-generalm=110137778213700w=2 -- Jason Wong

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-28 Thread Jason Wong
as. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-26 Thread Jason Wong
server. Now if someone somehow had access to your key then it's game over for you. Unless you password protected your key which -- would be extremely impractical. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-25 Thread Jason Wong
: if I have access to your key then I can connect. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post

Re: [PHP-DB] accessing mysql on non default port - windows

2005-02-05 Thread Jason Wong
. If mysql.default_port is not defined *then* it will start loking at other places (as detailed in the comments). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] accessing mysql on non default port - windows

2005-02-05 Thread Jason Wong
/mysql client to a mysql server running on 330[not 6] All the time! -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list

Re: [PHP-DB] Storing JPEGS in MySQL

2005-02-02 Thread Jason Wong
. Yep, because you haven't stored anything resembling an image in the DB! -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list

Re: [PHP-DB] Table from an array?

2005-02-02 Thread Jason Wong
SQL statement to create table? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http

Re: [PHP-DB] Auto Responses?

2005-01-23 Thread Jason Wong
from getting a auto response. Or if they own their own server they can do the same. More specifically, smart autoresponders will not respond to mailing lists, bounces, etc. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] Auto Responses?

2005-01-23 Thread Jason Wong
On Monday 24 January 2005 02:13, Samar wrote: On Mon, 24 Jan 2005 01:56:03 +0800, Jason Wong [EMAIL PROTECTED] wrote: More specifically, smart autoresponders will not respond to mailing lists, bounces, etc. If they are some kind of extensions or plug-ins to email clients, I guess you could

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Jason Wong
() should never be used on data retrieved from the DB (that is assuming your data was inserted correctly in the first place). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Jason Wong
need to use stripslashes() on data retrieved from the database depends on the setting of magic_quotes_runtime. The recommended setting is to have it disabled which means you do not need stripslashes(). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] ssh tunneling with phpmyadmin

2005-01-10 Thread Jason Wong
and port 13306. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Wong
. If you do the above and use mysql_error() you'll get a more precise error message. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search

Re: [PHP-DB] MySQL Auto PK

2005-01-06 Thread Jason Wong
that number on the end of the string you've created to insert into a varchar field. It's an extra query per insert, but it'd do the job. Don't forget to WRITE lock the table before counting, and only unlock after inserting the new id. -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Wong
and your, and just to annoy the Americans, it's ensure and not insure! -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list

Re: [PHP-DB] $_GET of array variables

2005-01-05 Thread Jason Wong
On Thursday 06 January 2005 07:02, Jochem Maas wrote: now lets sing together: If in doubt print it out! :-) Hey, you're using my trademark without my permission :) google If in doubt print it out -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators

Re: [PHP-DB] str_replace question

2005-01-05 Thread Jason Wong
SQL query and its a difficult one, and I have a solution that works perfectly but I need this to work in order to do it. I'm pretty sure a simple if-clause somewhere would prevent the extraneous AND from appearing in $additionalsql. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open

Re: [PHP-DB] Removing first word from a string?

2005-01-03 Thread Jason Wong
(), but the better solution would be to revise your logic so that you produce correctly formed SQL in the first place. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] semi-newbie | php, mysql RH Enterprise

2005-01-01 Thread Jason Wong
for the mysql.soc file, or (2) tell mySQL to put the mysql.sock file somewhere else (like, presumably, /tmp, so PHP can find it)? Did you actually look in your php.ini? Because there is an entry there just for this purpose. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] semi-newbie | php, mysql RH Enterprise

2005-01-01 Thread Jason Wong
implementation of MySQL. Do a locate/find mysqld.sock. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post

Re: [PHP-DB] semi-newbie | php, mysql RH Enterprise

2005-01-01 Thread Jason Wong
On Sunday 02 January 2005 05:44, Evan Cooch wrote: Jason Wong made several helpful suggestions to my earlier query - alas, non of them have panned out. That's because you have more problems than you know. Basically it mostly boils down to RH putting things in non-default places. As per his

Re: [PHP-DB] semi-newbie | php, mysql RH Enterprise

2005-01-01 Thread Jason Wong
the PHP-bundled one or the MySQL one) it will have no bearing on your socket problem. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search

Re: [PHP-DB] how to connect new html page in PHP.

2004-12-25 Thread Jason Wong
On Saturday 25 December 2004 16:32, Zareef Ahmed wrote: $header=from:[EMAIL PROTECTED] \n\r\n\r; The newlines should be \r\n and not \n\r. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] php4 + sqlite - quoting stuff

2004-12-25 Thread Jason Wong
); $sql_semester = sqlite_escape_string($semester); ... $sql = INSERT INTO course VALUES ('$sql_termcode', '$sql_semester', ...); sqlite_query( $handle, $sql) or die(Error bravo in query [$sql]: . sqlite_error_string(sqlite_last_error($handle))); -- Jason Wong - Gremlins Associates

Re: [PHP-DB] how to connect new html page in PHP.

2004-12-25 Thread Jason Wong
On Saturday 25 December 2004 17:07, Zareef Ahmed wrote: On Sat, 25 Dec 2004 16:41:40 +0800, Jason Wong [EMAIL PROTECTED] wrote: On Saturday 25 December 2004 16:32, Zareef Ahmed wrote: $header=from:[EMAIL PROTECTED] \n\r\n\r; The newlines should be \r\n and not \n\r. Does it really make

Re: [PHP-DB] fopen

2004-12-23 Thread Jason Wong
On Thursday 23 December 2004 16:36, Yemi Obembe wrote: How can I get the file name of the home page of a url I opened with fopen() this way: $handle = fopen(http://www.example.com/;, r); ? You can't. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] _POST, _GET, _REQUEST not working

2004-12-22 Thread Jason Wong
verbatim and is the actual code that you're having problems with. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives

Re: [PHP-DB] Redhat-MySQL Issues

2004-12-21 Thread Jason Wong
to fix this! If all else fails, extract a fresh copy of php.ini from one of the RPMs. Or ask someone on the RH mailing lists to send you one. Oh, and next time you edit php.ini, make a backup! -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators

Re: [PHP-DB] Looping within a string?

2004-12-16 Thread Jason Wong
. A string is a string. Code doesn't execute inside a string. What else are you doing to the string? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Looping within a string?

2004-12-16 Thread Jason Wong
)) { $text .= 'some html markup' . $row['id'] . 'more html'; } Now stick $text somewhere in the body of your mail. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] date conversions

2004-12-15 Thread Jason Wong
than to hit upon the appropriate keywords to search for. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before

Re: [PHP-DB] stumped-mail and database

2004-12-07 Thread Jason Wong
a Fatal error: Call to a member function on a non-object in /ho What happens when you do this: $to = $rsVendorJobs-fields('Conmail'); echo $to; echo $rsVendorJobs-fields('Conmail'); $to = $rsVendorJobs-fields('Conmail'); echo $to; -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] stumped-mail and database

2004-12-07 Thread Jason Wong
On Tuesday 07 December 2004 19:15, Stuart Felenstein wrote: --- Jason Wong [EMAIL PROTECTED] wrote: Please be explicit, do you mean this what you get?: What happens when you do this: $to = $rsVendorJobs-fields('Conmail'); Call to a member function on a non-object echo $to; Nothing

Re: [PHP-DB] Checkboxes on repeat regions

2004-12-06 Thread Jason Wong
. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db

Re: [PHP-DB] Checkboxes on repeat regions

2004-12-06 Thread Jason Wong
On Monday 06 December 2004 20:39, Stuart Felenstein wrote: --- Jason Wong [EMAIL PROTECTED] wrote: I'm not sure what you mean exactly by intended use checkboxes. Intended use - I generate a list (via a repeat region) of records. Each item on the list has an associated checkbox. If I put

Re: [PHP-DB] php5 and mysql_connect

2004-12-06 Thread Jason Wong
mysql support when it is supposed to be enabled by default). Actually, reading it again, it doesn't explicitly say the versions of PHP older than PHP5 enabled by mysql by default. Maybe it is your interpretation and reading between the lines which led to your above statement :) -- Jason Wong

Re: [PHP-DB] php5 and mysql_connect

2004-12-06 Thread Jason Wong
circumstances I declare this a mistrial :) -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http

Re: [PHP-DB] Use of 'as' name in where sub-clause

2004-12-01 Thread Jason Wong
On Wednesday 01 December 2004 17:53, Ross Honniball wrote: If someone can give me a good reason why this is so, it will stop it annoying me so much. I'm sure someone on the _MYSQL_ list will give you a jolly good reason or two. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open

Re: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread Jason Wong
are you trying to prevent? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http

Re: [PHP-DB] PHP-HTML-select deny

2004-12-01 Thread Jason Wong
On Thursday 02 December 2004 00:37, denys wrote: wouldn't it be possible to display the text in a form text area and put it state to disabled ? But if someone really want your text he just have to rewrite it... sigh View source copy paste -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Using a loop on a result destroys array??

2004-11-24 Thread Jason Wong
next you need it. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com

Re: [PHP-DB] Using a loop on a result destroys array??

2004-11-24 Thread Jason Wong
Construct a stripped-down, bare-bones, *working* example that illustrates your problem. (Working in the sense that it is free from syntax and other errors that are not the focus of the problem). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web

Re: [PHP-DB] PHP / Javascript question

2004-11-15 Thread Jason Wong
such as del[] ??? manual PHP and HTML -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http

Re: [PHP-DB] mysqldump

2004-11-09 Thread Jason Wong
anyone have any suggestions for regarding this. Try using double quotes. Also just like performing SQL queries, it's a very good idea to build up the command you want executed, store it in a string ($cmd), then echo it to see whether it looks good, then exec($cmd). -- Jason Wong - Gremlins

Re: [PHP-DB] mysqldump

2004-11-09 Thread Jason Wong
); make use of the extra arguments to exec() (see manual) so that you can see what's being output. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Re: [EMAIL PROTECTED] November 2, 2004

2004-11-02 Thread Jason Wong
keep espousing? Now can we go back to discussing php and databases. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list

Re: [PHP-DB] Parsing CSV files into a MySQL Table

2004-11-02 Thread Jason Wong
, foo7) VALUES '$foo1', '$foo2', '$foo3', '$foo4', '$foo5', '$foo6', '$foo7')); } Again, use mysql_error(). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] How to get unique entries?

2004-11-02 Thread Jason Wong
please remind me? I know it was dead simple, but cant remember the command. google sql unique -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] can i display an image _directly_ from postgres db storage?

2004-11-01 Thread Jason Wong
? is this possible? Yes. if so, how? Tutorials that shows how to upload and store image/binary files in a database also usually shows how to retrieve them (and in the case of images, also how to display them). One function you'll find useful is imagecreatefromstring() -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Problems with mysql_num-rows()

2004-10-31 Thread Jason Wong
On Sunday 31 October 2004 18:32, Arne Essa Madsen wrote: I have the following problem: This one does not work: $query = SELECT * from user where name='$userid' and pass=password('$password'); print $query; $result = mysql_query($query, $link); Use mysql_error(). -- Jason Wong

Re: [PHP-DB] Something wierd with time() and curdate()

2004-10-31 Thread Jason Wong
would be sufficient. If you suspect MySQL is the culprit then a single query would be sufficient. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] printer dialouge box

2004-10-30 Thread Jason Wong
On Saturday 30 October 2004 12:33, balwantsingh wrote: how i can open the printer dialouge box of browser in PHP. pls. help. You don't because you can't. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] PHP Javascript

2004-10-30 Thread Jason Wong
be displayed in next page. You can pass values from client-side using Javascript either via the URL ($_GET) or form ($_POST) or cookies ($_COOKIE). You can't manipulate the session variables directly. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators

Re: [PHP-DB] MySQL backup software

2004-10-27 Thread Jason Wong
On Wednesday 27 October 2004 13:57, Perry, Matthew (Fire Marshal's Office) wrote: Does anyone know a free MySQL backup program to schedule regular backups? www.mysql.com google mysql mailing list -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] Implementing search in a database driven website

2004-10-26 Thread Jason Wong
Functions (Perl-Compatible) Pattern Modifiers -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http

Re: [PHP-DB] How to send a SID in a security way

2004-10-22 Thread Jason Wong
to be propagated from page to page whether by cookies, URL or form. In other words you *have* to send it one way or another. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] how to connect to dbase

2004-10-15 Thread Jason Wong
, but I can't believe that dbase is exactly popular amongst php users. Its lack of popularity could explain the lack of response. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] DB will INSERT wont UPDATE..error in code?

2004-10-12 Thread Jason Wong
].' ttlpst = '.$HTTP_POST_VARS[ttlpst].' mnthpst = '.$HTTP_POST_VARS[mnthpst].' ttlicon = '.$HTTP_POST_VARS[ttlicon].' mnthicon = '.$HTTP_POST_VARS[mnthicon].' WHERE fid = $fid; echo $sql; Make use of mysql_error(). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] DB will INSERT wont UPDATE..error in code?

2004-10-12 Thread Jason Wong
look up the manual entry for UPDATE, you'll find that you're missing the commas separating the columns. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread Jason Wong
On Monday 11 October 2004 16:47, Stuart Felenstein wrote: I can't seem to figure this out. Right now I'm still trying to get the multi page form down. For the facts, running php 4.3.8, apache 1.3.x Register Globals are enabled If you don't have a specific reason for this to be enabled you

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread Jason Wong
variable Alright , I guess the light isn't shining through here. 'Something' is setting the variable to something the user can change with the form input ? The 'something' in your particular case is the data from the form on Page1. Eg $_SESSION['variable'] = $_POST['myforminput']; -- Jason Wong

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread Jason Wong
) and hence setting your field value to it is meaningless. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before

Re: [PHP-DB] PHP compile error: Cannot find mysql header files

2004-10-10 Thread Jason Wong
On Monday 11 October 2004 09:49, andy wrote: First, read manual MySQL Functions Second, decide whether you want to compile using the bundled MySQL library. If so the above tells all you need to know. If not you need to install the devel package for MySQL. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Addslashes / DB Sort

2004-09-27 Thread Jason Wong
on data coming from the database. You're not supposed to use stripslashes() on data coming from the database -- read up on addslashes() and also search manual for magic quotes. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Jason Wong
the following more simple methods: - Send user a system generated password with which they can login and subsequently change. - Send user an activation link which once clicked on would activate them and allow them to choose a password. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Jason Wong
link which once clicked on would activate them and allow them to choose a password. What is the advantage in sending someone a password AND making them click on a link to activate? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design

Re: [PHP-DB] mySQL searching through serialized arrays

2004-09-09 Thread Jason Wong
properly. Have a separate table where each record contains a user_id and the record_id to which it is linked. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] New to the list

2004-08-29 Thread Jason Wong
and not the database / tables I wish to use. Have php pull the data required, have php output the appropriate javascript code using the pulled data _instead_ of the 'preformatted values'. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] letting a table name be a constant

2004-08-23 Thread Jason Wong
. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db

Re: [PHP-DB]different heading

2004-08-19 Thread Jason Wong
? If you insist, you can use something like: SELECT clumsy_column_name AS goodname FROM ... Refer to MySQL documentation for more info. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] Check Boxes

2004-08-18 Thread Jason Wong
if data is not sanitised. Where do you begin? Where do you end? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives

Re: [PHP-DB] Re: MySQL denying access to everything

2004-08-18 Thread Jason Wong
depend on how you installed it in the first place. And in any case this isn't the list for discussing how to install and configure MySQL. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] Tricky MySQL / php Script

2004-08-18 Thread Jason Wong
': loop through recordset looking for 'photoID' when found, use mysql_data_seek() to grab the previous and next records -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] SMTP

2004-08-17 Thread Jason Wong
blocked port 25) - thus you are forced to send your mail through your ISP's SMTP server. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] SMTP

2004-08-16 Thread Jason Wong
. SMTP = localhost SMTP = 587 I believe the 587 is the port number to use. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list

Re: [PHP-DB] I'm not getting any mailing list messages

2004-08-12 Thread Jason Wong
whether any messages have been posted to the list then have a look at the archives. Messages to the list will appear in the archives almost immediately. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet

Re: [PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Jason Wong
tutorial for details. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l

Re: [PHP-DB] Last monday query question

2004-08-06 Thread Jason Wong
all the time. Any ideas? Use strtotime() and maybe PHP's other date/time functions then plug into your query. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Re: sendmail

2004-08-04 Thread Jason Wong
. That would tell you whether a mail was injected into the queue. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Jason Wong
(involving few relationships) then MySQL is more than sufficient and a tried and tested solution. This probably covers the vast majority of the data storage needs of web apps. No sense in going for a DB with features you're never ever going to use and is probably slower to boot. -- Jason Wong

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Jason Wong
- Their host only supports MySQL SQLite is a different matter and the obvious new base for beginners, but for real applications ... Use Postgresql! -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Jason Wong
not mistaken, I think he means that *unless* you have a big cheque book to pay for Oracle then MySQL is the next fastest thing around. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Enabling LDAP support

2004-08-02 Thread Jason Wong
suggestions b/c I'm stuck? 1) post some *concise* code that illustrates your problem 2) state exactly what and how it is not working 3) post any error messages that you get (having first made sure that FULL error reporting is enabled). -- Jason Wong - Gremlins Associates - www.gremlins.biz

Re: [PHP-DB] Re: form results to email

2004-07-31 Thread Jason Wong
On Saturday 31 July 2004 23:25, Vincent Jordan wrote: I have tried to add some html such as strong$firstname $lastname /strong...; however when I do this there is nothing displated in the email message. google html mime message Or look on www.phpclasses.org -- Jason Wong - Gremlins

Re: [PHP-DB] Empty query result

2004-07-26 Thread Jason Wong
. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db

Re: [PHP-DB] DB access failure...

2004-07-24 Thread Jason Wong
, somewhere is not using the system's DNS resolve mechanism. As I don't have a Windows box handy I'm afraid I cannot help you. Sometimes things are not done for practical purposes. Right. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design

Re: [PHP-DB] DB access failure...

2004-07-23 Thread Jason Wong
there will be no difference whether you connect using IP address or hostname. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before

Re: [PHP-DB] What's wrong with this QUERY??

2004-07-22 Thread Jason Wong
table but still doesn't produce any results. mysql_error() would let you know that there was an error in your query. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] Wait Statement... ?

2004-07-20 Thread Jason Wong
and be done with? Why wait 1 second, another second, ... ? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives

Re: [PHP-DB] howto get PK id after INSERT??

2004-07-20 Thread Jason Wong
); mysql_query() returns a resource id. $last_id = urlencode ($last_id); header(Location: UserMain.php?custid='$last_id'); So the above is meaningless. Please check the previous responses where you have been pointed to a more appropriate function to use. -- Jason Wong - Gremlins Associates

Re: Re[2]: [PHP-DB] Wait Statement... ?

2004-07-20 Thread Jason Wong
On Wednesday 21 July 2004 05:00, Pablo M. Rivas wrote: sleep() is the brute deffense of the brute force attack... You can make a script that opens simultaneous attacks One thing to bear in mind is that sleep() will hog resources and can lead to DOS. -- Jason Wong - Gremlins Associates

Re: [PHP-DB] Concurrent rutines

2004-07-20 Thread Jason Wong
You have started a new thread by taking an existing posting and replying to it while you changed the subject. That is bad, because it breaks threading. Whenever you reply to a message, your mail client generates a References: header that tells all recipients which posting(s) your posting refers

Re: [PHP-DB] howto get PK id after INSERT??

2004-07-19 Thread Jason Wong
On Tuesday 20 July 2004 10:09, Vincent Jordan wrote: Is there a way to get the ID (custid PK UNIQUE AUTO_INCREMENT) from mysql after INSERT then pass to final page using urlencode to pull cust record? manual MySQL Functions -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] DB access failure...

2004-07-19 Thread Jason Wong
your DNS properly. Or just use the IP address. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http

Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

2004-07-16 Thread Jason Wong
On Saturday 17 July 2004 09:31, Ross Honniball wrote: Attention all Sql gurus, Is there a way to FORCE mysql resolve specific conditions within a query before wasting it's time trying to resolve other conditions? www.mysql.com -- Jason Wong - Gremlins Associates - www.gremlins.biz Open

Re: [PHP-DB] Easy reg expression problem

2004-07-16 Thread Jason Wong
On Friday 16 July 2004 16:01, Tim Van Wassenhove wrote: In article [EMAIL PROTECTED], Jason Wong wrote: On Friday 16 July 2004 08:05, Justin Patrin wrote: If you're simply trying to get '@email.com' then use strstr(). Of courseI'm just so used to pregs... Well the advantage

Re: [PHP-DB] Easy reg expression problem

2004-07-15 Thread Jason Wong
On Friday 16 July 2004 08:05, Justin Patrin wrote: If you're simply trying to get '@email.com' then use strstr(). Of courseI'm just so used to pregs... Well the advantage of using a regex is that you can perform some form of validation on the address. -- Jason Wong - Gremlins

Re: [PHP-DB] session_start

2004-07-15 Thread Jason Wong
you use phpinfo() you will see that the ini file you need to edit is called php.ini. Note the path and edit that file, if it's not there then copy one of php.ini-* there. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] mysql auto increment

2004-07-12 Thread Jason Wong
your answer or ask on the mysql mailing list. I have a primary key in a table the is setup and working with auto increment. Now I want to change it so it will start auto incrementing from 1000. So each entry will be: 1001, then 1002, -- Jason Wong - Gremlins Associates

  1   2   3   4   5   6   7   >