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

2005-02-28 Thread Jason Wong
r you have configured httpd to run 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

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

2005-02-28 Thread Jason Wong
ture: http://marc.theaimsgroup.com/?l=php-general&m=110137778213700&w=2 -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * --

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

2005-02-26 Thread Jason Wong
le to use it to connect to the mysql 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

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

2005-02-25 Thread Jason Wong
e if I'm wrong: 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 * -

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

2005-02-05 Thread Jason Wong
se it doesn't come into play. > Have you succesfully connected from a php/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 &am

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

2005-02-05 Thread Jason Wong
.default_port in php.ini. 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 * Intern

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

2005-02-02 Thread Jason Wong
nstruct a suitable 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 archiv

Re: [PHP-DB] Storing JPEGS in MySQL

2005-02-02 Thread Jason Wong
;image/jpeg" > > Again this script runs without errors but doesnt produce anything. Yep, because you haven't stored anything resembling an image in the DB! -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Sy

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

Re: [PHP-DB] Auto Responses?

2005-01-23 Thread Jason Wong
ost mail systems allows you to exclude certain > domains 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

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Jason Wong
no need to use stripslashes when selecting it out. Additionally, it should be noted that whether you 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 stripsl

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Jason Wong
t stripslashes() 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 & Intra

Re: [PHP-DB] ssh tunneling with phpmyadmin

2005-01-10 Thread Jason Wong
ccess MySQL using address 127.0.0.1 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 arc

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

2005-01-06 Thread Jason Wong
7;affect'. ;) Yeah and it annoys me too when people mix up "you're" and "your", and just to annoy the Americans, it's "ensure" and not "insure"! -- Jason Wong -> Gremlins Associates -> www.gre

Re: [PHP-DB] MySQL Auto PK

2005-01-06 Thread Jason Wong
date, add 1 to it, and stick 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 th

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

2005-01-06 Thread Jason Wong
very informative at all. 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 * Inte

Re: [PHP-DB] str_replace question

2005-01-05 Thread Jason Wong
WHERE AND with just WHERE as Iâm building > a > very complex SQL query and itâs 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

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.grem

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

2005-01-03 Thread Jason Wong
ing. You can use preg_replace(), 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 * Inte

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

2005-01-01 Thread Jason Wong
e /usr] NB no matter which MySQL library you use (whether 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 &

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

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

2005-01-01 Thread Jason Wong
b/mysql That should point to the socket _file_ that is used by RH's 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 Applica

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

2005-01-01 Thread Jason Wong
her (i) compile PHP (or tweak php.ini) to tell it to look > in /var/lib/mysql 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 th

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"; > > >

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

2004-12-25 Thread Jason Wong
e_string($termcode); $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_s

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 & Hostin

Re: [PHP-DB] Re: HTTP Auth for PHPMyAdmin

2004-12-23 Thread Jason Wong
t; locked at all times from all points of access. Did you try asking on the phpMyAdmin support channels? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intrane

Re: [PHP-DB] New to the Mailing List

2004-12-23 Thread Jason Wong
#x27;t include it? Or is this a trick question? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list a

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 -> Greml

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

2004-12-22 Thread Jason Wong
e it's 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 *

Re: [PHP-DB] Redhat-MySQL Issues

2004-12-21 Thread Jason Wong
setting to whether you had changed that accidently. > I am so in the dark on how 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 -&

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

2004-12-16 Thread Jason Wong
x27;'; while ($row = mysql_fetch_array($sql_resultc)) { $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

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

2004-12-16 Thread Jason Wong
are doing. 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 & Intra

Re: [PHP-DB] date conversions

2004-12-15 Thread Jason Wong
this have been posted in the past. But it might be quicker to write your own 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 App

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 membe

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

2004-12-07 Thread Jason Wong
->fields('Conmail'); > > I get 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 = $rsV

Re: [PHP-DB] php5 and mysql_connect

2004-12-06 Thread Jason Wong
n of PHP I'm installing. In light of the mitigating 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 * --

Re: [PHP-DB] php5 and mysql_connect

2004-12-06 Thread Jason Wong
eading between the lines which led to your above statement :) -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search

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 reco

Re: [PHP-DB] Checkboxes on repeat regions

2004-12-06 Thread Jason Wong
7;t mean you can't use the overall principle and change the code to "delete stuff" into "display stuff". -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet &am

Re: [PHP-DB] Checkboxes on repeat regions

2004-12-06 Thread Jason Wong
r the IBM developerworks article looks like ideal reading for you. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * --

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... View source > copy > paste -- Jason Wong -&

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

2004-12-01 Thread Jason Wong
tead of text. What 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 li

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.

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

2004-11-24 Thread Jason Wong
the exactly the same fashion as another piece of code" 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 Assoc

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

2004-11-24 Thread Jason Wong
e round then you can read results from the array whenever next you need it. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * --

Re: [PHP-DB] mysql db dump with php

2004-11-16 Thread Jason Wong
ram execution functions. > if you can hook me up i'll paypal you $20 bucks to buy you and yours a few > pints of your favorite ale on me. Donate it to your local Red Cross/Red Crescent or equivalent. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Sof

Re: [PHP-DB] PHP / Javascript question

2004-11-15 Thread Jason Wong
t; box is an Array 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

Re: [PHP-DB] mysqldump

2004-11-09 Thread Jason Wong
t; $filename"; > echo $command; If what is being echoed looks OK then > exec($command); 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 Softwa

Re: [PHP-DB] mysqldump

2004-11-09 Thread Jason Wong
ion the file was being > saved. But I have gone through my server and found nothing. Does 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 stri

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

2004-11-02 Thread Jason Wong
t; this, can anyone please remind me? I know it was dead simple, but canât > remember the command. google > sql unique -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & I

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

2004-11-02 Thread Jason Wong
SERT INTO 'footable' (foo1, foo2, foo3, foo4, foo5, foo6, > foo7) VALUES '$foo1', '$foo2', '$foo3', '$foo4', '$foo5', '$foo6', > '$foo7')"); } Again, use mysql_error(). -- Jason Wong -> Gremli

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

2004-11-02 Thread Jason Wong
the "beacon of hope" that current administration 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 Develo

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

2004-11-01 Thread Jason Wong
base? > > 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 imagecreatefromstrin

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

2004-10-31 Thread Jason Wong
rrectly then a few lines of code showing the date calculations 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

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($qu

Re: [PHP-DB] PHP & Javascript

2004-10-30 Thread Jason Wong
at the values can 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.b

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 &

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

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

2004-10-26 Thread Jason Wong
; > Any pointers. manual > Regular Expression Functions (Perl-Compatible) > Pattern Modifiers -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -

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

2004-10-22 Thread Jason Wong
27;stay in the session', the session id has 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 &

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

2004-10-15 Thread Jason Wong
impossible. I may be wrong, 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 & Hosti

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

2004-10-12 Thread Jason Wong
ERE fid = 61Query3 failed: You > have an error in your SQL syntax near 'ttlpst ='1' mnthpst = '1' ttlicon = > 'trophie' at line 3 If you look up the manual entry for UPDATE, you'll find that you're missing the commas separating the

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

2004-10-12 Thread Jason Wong
when $sql is defined like so: > $sql = "UPDATE badges SET staff = '".$HTTP_POST_VARS["staff"]."' ttlpst = > '".$HTTP_POST_VARS["ttlpst"]."' mnthpst = '".$HTTP_POST_VARS["mnthpst"]."' &g

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

2004-10-11 Thread Jason Wong
d (not registered, and even if it was registered you have nothing to put in it just yet) 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 & Intran

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

2004-10-11 Thread Jason Wong
er 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 -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators *

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 yo

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 -> Gr

Re: [PHP-DB] Addslashes / DB Sort

2004-09-27 Thread Jason Wong
ipslashes function is being used 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 Sof

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Jason Wong
change. OR > > - Send user an activation 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 -> w

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Jason Wong
me on what extra security this method provides over and above 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

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

2004-09-09 Thread Jason Wong
unction to filter through > the serialized array You're not using the database 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 I

Re: [PHP-DB] New to the list

2004-08-29 Thread Jason Wong
alues 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 Softw

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

2004-08-23 Thread Jason Wong
l problem rather than on your typos. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives befor

Re: [PHP-DB]different heading

2004-08-19 Thread Jason Wong
where's the problem? 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 * Intern

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

2004-08-18 Thread Jason Wong
cordset based on the > user's id? Assuming you have already created your 'recordset': 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.

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

2004-08-18 Thread Jason Wong
SQL manual. Uninstalling would 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 & Ho

Re: [PHP-DB] Check Boxes

2004-08-18 Thread Jason Wong
question concerning sql queries and accepting info from POST, GET etc have security implications 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 * In

Re: [PHP-DB] SMTP

2004-08-17 Thread Jason Wong
way (your ISP may have 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 &a

Re: [PHP-DB] SMTP

2004-08-16 Thread Jason Wong
On Tuesday 17 August 2004 12:58, Jason Wong wrote: > On Tuesday 17 August 2004 14:07, John Holmes wrote: > > > In the Outgoing mail (SMTP): field, change the number that displays to > > > 587. > > > > I guess "587" is the name of AOL's outgoing S

Re: [PHP-DB] SMTP

2004-08-16 Thread Jason Wong
hen. > > > [mail function] > > ; For Win32 only. > > 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

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

2004-08-12 Thread Jason Wong
heck 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 & Hos

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

2004-08-09 Thread Jason Wong
nce, = and LIKE have different purposes. Refer to manual and/or some SQL tutorial for details. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -

Re: [PHP-DB] "Last monday" query question

2004-08-05 Thread Jason Wong
t doesn't seem to work 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 * Interne

Re: [PHP-DB] Re: sendmail

2004-08-04 Thread Jason Wong
hing to look at would be the mail logs. 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 * --

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Jason Wong
of the hardware ;) Hmm, if I'm 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 &

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Jason Wong
equate for their needs - An app they want to use only supports MySQL - 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

Re: [PHP-DB] Re: LAMP

2004-08-02 Thread Jason Wong
rage of data (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

Re: [PHP-DB] Enabling LDAP support

2004-08-02 Thread Jason Wong
ight make it work... but it didn't. So HOW didn't it work? > Anyone have any 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 th

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 "$firstname $lastname > ..."; however when I do this there is nothing displated in > the email message. google > html mime message Or look on www.phpclasses.org --

Re: [PHP-DB] Empty query result

2004-07-26 Thread Jason Wong
x27; page. However, I just want it to move on. For > example, if there is no 'phone2' given in the database, I want it to > just assign $phone2 to zero/nothing, not go to the error page. Well you wrote the code so that it will go to the error page. -- Jason Wong -> Gremlins

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

2004-07-24 Thread Jason Wong
rres.ws' Well that sounds like something, 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 Asso

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

2004-07-23 Thread Jason Wong
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 * --

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

2004-07-22 Thread Jason Wong
eir values enclosed by quotes. > The email address does exist exactly as quoted above in the "email" field > in my "members" table but still doesn't produce any results. mysql_error() would let you know that there was an error in your query. -- Jason Wong -> Grem

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: 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 ->

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

2004-07-20 Thread Jason Wong
T LAST_INSERT_ID() from customerinfo"); 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

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

2004-07-20 Thread Jason Wong
one in normal html code... WHy don't you just validate the login 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 De

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

2004-07-19 Thread Jason Wong
OSTS file. Or setup 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 * -- Se

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

  1   2   3   4   5   6   7   >