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

2005-01-06 Thread Jason Davis
This helped a LOT! With that info I was able to figure out that I need to do this. http://dev.mysql.com/doc/mysql/en/Old_client.html Thanks everyone, Jason Davis Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Thursday 06 January 2005 23:41, Jason Davis wrote: Hi all

[PHP-DB] Warnings and Notices

2005-01-06 Thread Jason Davis
I just got the software I was fighting with working. Only issue now is that the top of the page is filled with notices and warnings, even though the code is working. Is there any way to turn off or hide these notifications? Jason -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Re: Warnings and Notices

2005-01-06 Thread Jason Davis
Figured it out myself. Changed PHP.ini to read error_reporting = E_ALL ~E_NOTICE instead of error_reporting = E_ALL Jason Davis [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I just got the software I was fighting with working. Only issue now is that the top of the page is filled

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] PHP query to mysql database returns emtpy data, but Query Browser shows records

2005-01-06 Thread Jason Walker
category like '39%47%48%172' There is something between each element, but PHP can not seem to handle the third empty space. Thanks to all for your help and ideas! Jason Walker [EMAIL PROTECTED] http://www.desktophero.com -Original Message- From: graeme [mailto:[EMAIL PROTECTED] Sent

RE: [PHP-DB] SQL statement

2005-01-06 Thread Jason Walker
First off - $_POST['CompanyName'] is valid, right? Can you do something like this?: if (isset($_POST['CompanyName'])){ $sqlCompanyName = $_POST['CompanyName']; } else { return them back to the form, or something? } $query_company_listing = SELECT CompanyID, CompanyName,

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

[PHP-DB] PHP query to mysql database returns emtpy data, but Query Browser shows records

2005-01-05 Thread Jason Walker
. Jason Walker [EMAIL PROTECTED] http://www.desktophero.com No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.8 - Release Date: 1/3/2005 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

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] MYSQL Maximum Time Exceeded

2004-12-15 Thread Jason Walker
This not be what you need, but I think there are some squiggle brackets missing. $conexion = mysql_connect(servername,username,password); ?php If (!$conexion){ Echo Error connecting.; } ? Again, I don't think this is the root of the problem but it's the first thing that popped out

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

[PHP-DB] Data from a pull down menu

2004-12-10 Thread Jason T. Davidson
that is right under my nose. If there is some material out there on this can someone point me in the right direction or show some sample coding? -- Jason Davidson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

[PHP-DB] Forms list from database

2004-11-01 Thread Jason T. Davidson
I am trying to take information from a database and show that info in a forms list. I have been trying this with while(), but it never comes out and displays correctly. Any help would be appreciated. -- Jason Davidson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Forms list from database

2004-11-01 Thread Jason T. Davidson
($check=mysql_fetch_array($result)){ print $check[LNAME],$check[FNAME]($check[CID]); } ? /option /select /div/td /tr -- Jason Davidson Juan Stiller wrote: It might be usefull to see the code you are using to show the query results. --- Jason T. Davidson [EMAIL

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] Cookies with databases

2004-10-21 Thread Jason T. Davidson
just fine, but it's variable doesn't come from a database. -- Jason Davidson Bastien Koert wrote: Hi Jason, 1. I don't think you need the quotes around the values. 2. is the user cookie set? bastien From: Jason T. Davidson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED

Re: [PHP-DB] Cookies with databases

2004-10-21 Thread Jason T. Davidson
Tyler- I have been to that section of php.net many times. My first cookie ($cid) doesn't have them domain listed and works just fine. Don't see I would need it for the cookie ($user)? -- Jason Davidson Tyler Replogle wrote: Yes you need to set the string domain http://us2.php.net/manual/en

[PHP-DB] Cookies with databases

2004-10-20 Thread Jason T. Davidson
align=centerAwaiting Approval/div/td /tr /table /body /html So I am assuming that somewhere in my first page that my cookie isn't actually gettting set properly. I have tried many varitites and can't find any help sections on cookies from a database. Any help would be appreciated! -- Jason

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

[PHP-DB] mysqli bind_param un-matched number of variables woes

2004-08-25 Thread Jason Wilkes
Jason ?php $mysqli = new mysqli('localhost', 'xxx', 'xxx', 'world'); /* check connection */ if (mysqli_connect_errno()) { printf(Connect failed: %s\n, mysqli_connect_error()); exit(); } $stmt = $mysqli-stmt_init(); $stmt-prepare(INSERT INTO CountryLanguage VALUES

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] 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] SQLite security

2004-08-16 Thread Jason Sheets
to access your database regardless of the engine you use. Jason -Original Message- From: Adam Q [mailto:[EMAIL PROTECTED] Sent: Monday, August 16, 2004 7:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] SQLite security I would like to use an SQLite DB for the prefs for an open source PHP

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

Re: [PHP-DB] Table locking

2004-07-08 Thread Jason Wong
in a table ? Depends on what type of LOCK you specify. Refer to your DB docs for details. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] MySQL query, using DISTINCT...

2004-07-06 Thread Jason Wong
is: SELECT DISTINCT col1, col2, etc FROM table ... Please follow the examples in the manual and incorporate error checking when using mysql. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications

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

2004-06-24 Thread Jason Wong
session_write_close() before you redirect. header(location: user.php?action=0); You should be using an absolute URI rather than a relative one. And just to be safe always have an exit() right after your redirect header(s). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source

Re: [PHP-DB] value error in PHP form

2004-06-24 Thread Jason Wong
() even when you haven't entered anything into them. If you want to check that something has been entered into them then use: if (!empty($POST['doo'] ... but depending on what type of inputs your application accepts you may have to do further tests. -- Jason Wong - Gremlins Associates

<    1   2   3   4   5   6   7   8   9   >