Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Peter Lind
On 29 April 2010 16:44, Alexander Schunk wrote: > Hello, > > i have it now as follows: > > while($dbbenutzer = mysql_fetch_assoc($sqlbenutzername)) >        while($dbpasswort = mysql_fetch_assoc($sqlpasswort)){ You have things very twisted. Check the code posted by Karl - you only need *ONE* row

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Karl DeSaulniers
Yes. You are correct. Did not include that part, sry. Dont forget mysql_real_escape_string. :) Karl On Apr 29, 2010, at 9:37 AM, Peter Lind wrote: On 29 April 2010 15:00, Karl DeSaulniers wrote: Hi, Maybe try... $benutzername = $_GET['username']; $pass = $_GET['password']; $result = "SELE

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Peter Lind
On 29 April 2010 15:00, Karl DeSaulniers wrote: > Hi, > Maybe try... > > $benutzername = $_GET['username']; > $pass = $_GET['password']; > > $result = "SELECT * FROM usertable WHERE sqlbenutzername='$benutzername'"; Don't use values from $_GET without sanitizing first. If using mysql_* functions,

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Karl DeSaulniers
Hi, Maybe try... $benutzername = $_GET['username']; $pass = $_GET['password']; $result = "SELECT * FROM usertable WHERE sqlbenutzername='$benutzername'"; while($r = mysql_fetch_row($result)) { $dbbenutzer = $r["sqlbenutzername"]; $dbpasswort = $r["sqlpasswort"]; } if($b

Re: [PHP-DB] PHP- Mysql problem

2009-06-28 Thread Gary
Daniel, Now that is just funny stuff... Have you tried http://lmgtfy.com/?q=access+denied+for+user+odbc+localhost or the newer http://www.lmbify.com/search.php?s=access+denied+for+user+odbc+localhost "Daniel Brown" wrote in message news:ab5568160906180636r239f214eh7e4871da7139c...@mail.g

Re: [PHP-DB] PHP- Mysql problem

2009-06-18 Thread Daniel Brown
On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN NADARAJAH wrote: > > Warning: mysql_query() [function.mysql-query]: Access denied for user > 'ODBC'@'localhost' (using password: NO) in > C:\wamp\www\ap_v5\inc\profile.inc.php on line 285 http://google.com/search?q=Access%20denied%20for%20user%

Re: [PHP-DB] PHP- Mysql problem

2009-06-18 Thread Bastien Koert
On Thu, Jun 18, 2009 at 6:03 AM, NADARAJAH SIVASUTHAN NADARAJAH wrote: > > > > Dear all, > >        When I try to retrive data from two tables using JOIN OR INNER JOIN it > display error message > > given below; > > > > Warning: mysql_query() [function.mysql-query]: Access denied for user > 'ODBC

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Micah Gersten
Chris wrote: > Micah Gersten wrote: >> Chris wrote: >>> Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli >>> Either mysqli or pdo since they'd deal with the mysql client directly. >>> >>> ADODB is a php library, so it's not going to be as fast because

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
YVES SUCAET wrote: How does the "default" php_mysql.dll compare to these? Is mysqli faster than mysql? I'd call that a native driver. No idea about mysqli vs mysql. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php code overhead. ADODB is precompi

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Micah Gersten
Chris wrote: > Micah Gersten wrote: >> Which is the fastest driver for this? >> ADODB >> PDO >> mysqli > > Either mysqli or pdo since they'd deal with the mysql client directly. > > ADODB is a php library, so it's not going to be as fast because you > have php code overhead. > ADODB is precompiled

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread YVES SUCAET
How does the "default" php_mysql.dll compare to these? Is mysqli faster than mysql? tia, Yves -- Original Message -- Received: Wed, 19 Nov 2008 04:00:46 PM CST From: Chris <[EMAIL PROTECTED]> To: Micah Gersten <[EMAIL PROTECTED]>Cc: PHP DB Subject: Re: [PHP-DB] P

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php code overhead. -- Postgresql & php tutorials http://www.designmagic

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-20 Thread Evert Lammerts
I should've checked the assumption. A little strange though for a scripting language. I'd say, since default behaviour of mysql_* functions is to assume the last opened link when a parameter is not passed, and since default behaviour is to evaluate null, false and 0 the same, mysql_* functions sho

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread Chris
> [new code] > if (!mysql_connect($a, $b, $c)) return; > > if (!mysql_select_db($dbname)) return; > > $res = mysql_query("SELECT * FROM manual;", $link); > [/new code] Isn't going to work because $link is not defined and definitely not a resource like mysql_query expects. > OR, optionally, to

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread bateivan
Eric, You gessed right. Both of the files are in my "docroot" directory. I tried this. Unfortunely, it did not work ( perhaps, I did not use it right), although, I followed your instructions. Isaak gave me an idea which solved my problem (see his replies). Thank you Eric-275 wrote: > > > --

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread Isaak Malik
It's great that you got your problem solved :). On Thu, Jun 19, 2008 at 12:30 PM, bateivan <[EMAIL PROTECTED]> wrote: > > Hello Isaak, > > You've scored the bulleye! It works! > Also, I tested by including "common.php" instead of "database.php" and it > worked too. > This solution is perfect for

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread bateivan
Hello Isaak, You've scored the bulleye! It works! Also, I tested by including "common.php" instead of "database.php" and it worked too. This solution is perfect for me as I can keep my code compact and tidy. I would, definetely, recommend this site to my fellow developers. Thank you very much,

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread Evert Lammerts
What you said wasn't wrong - you'd just produce a couple of warnings. By taking away the assignment of the $link variable you're unsetting it, meaning it will have a value equal to NULL. All of the following should work. [old code] if (!($link = mysql_connect($a, $b, $c))) return; if (!mysql_sele

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread Isaak Malik
My mistake then, it's been a while that I used it that way so some things do fade away from my mind. On Thu, Jun 19, 2008 at 1:57 AM, Chris <[EMAIL PROTECTED]> wrote: > Isaak Malik wrote: > > Because then the connection resource isn't stored in the $link variable > > and you will be able to use t

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Chris
Isaak Malik wrote: > Because then the connection resource isn't stored in the $link variable > and you will be able to use the mysql functions without passing that > variable to each function. RTM again. The link parameter is completely optional. If you don't specify it, it uses the last connect

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Isaak Malik
To Evert: 4. I am posting some of my code to compare. Module "carmade.php" works v.s. "login.php" which does not. Also, I am posting my "database.php" which is establishing the connection and is included in every page through "layout.php"->"common.php"->"database.php". To bateivan: I can only gu

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Evert Lammerts
Pastebin works lots better when you're posting code: www.pastebin.com I don't see your database.php included in both of these modules. Where do you include it? EVert On Wed, Jun 18, 2008 at 9:38 PM, bateivan <[EMAIL PROTECTED]> wrote: > > Hello, > > To answer these qwestions: > 1. I am using "in

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread bateivan
Hello, To answer these qwestions: 1. I am using "include" in my code. 2. About the "$link = mysql_connect('localhost', 'root', 'testing');" variable. I can just include this line before mysql_query function and it works even without entering into mysql_query the "$link" variable. (Like the connec

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread bateivan
Thank you, Chris, I tried your suggestion using regular connection. Unfortunately, I got the same result. See my reply to Isaak,s reply where I am going to post portion of my code to visualize what I am talking about. Thanx again chris smith-9 wrote: > > >> It means that either your mysql co

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Isaak Malik
Because then the connection resource isn't stored in the $link variable and you will be able to use the mysql functions without passing that variable to each function. On Wed, Jun 18, 2008 at 1:51 AM, Chris <[EMAIL PROTECTED]> wrote: > > > It means that either your mysql conenction details are no

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-17 Thread Roberto Carlos García Luís
excuseme but, you can access by terminal? [shell] ODBC is the user? or is a ODBC database? Please answer me and i can help you. **Excuse me my english is bad. :( El 17/06/2008, a las 06:51 p.m., Chris escribió: It means that either your mysql conenction details are not correctly set or th

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-17 Thread Chris
> It means that either your mysql conenction details are not correctly set or > the connection resource isn't accessible for your mysql functions. I suggest > you first try by replacing: > > $link = mysql_pconnect('localhost', 'root', 'testing'); > > into: > > mysql_pconnect('localhost', 'root'

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-17 Thread Eric
http://myprojects.srhost.info eric{at}myprojects{dot}srhost{dot}info - Original Message - From: "bateivan" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 17, 2008 11:19 PM Subject: [PHP-DB] PHP-MySQL connection for particular module :

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-17 Thread Isaak Malik
If you get an error of this kind: "Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache Software Foundation\Apache2.2\htdocs\login.php on line 17 Warning: mysql_query() [function.mysql-query]: A link to the server

Re: [PHP-DB] php + mysql + copy file

2008-04-04 Thread tacio vilela
Hi, try this, $carpeta = $_SERVER['DOCUMENT_ROOT']."/subidos"; // nombre de la carpeta ya creada. chmool 777 (todos los permisos) copy($_FILES['file']['tmp_name'] , $carpeta . $_FILE['file']['name']); Regards, Tacio Vilela 2008/4/2 Chris <[EMAIL PROTECTED]>: > > $carpeta = "subidos";

Re: [PHP-DB] php + mysql + copy file

2008-04-02 Thread Chris
$carpeta = "subidos"; // nombre de la carpeta ya creada. chmool 777 (todos los permisos) copy($_FILES['file']['tmp_name'] , $carpeta . '/' . $_FILE ['file']['name']); It's $_FILES not $_FILE (an 's' on the end). It's always worth using error_reporting(E_ALL) and ini_set('d

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-27 Thread Daniel Brown
On Wed, Feb 27, 2008 at 9:52 AM, Tobias Franzén <[EMAIL PROTECTED]> wrote: > Consider this, if you have not already: > What if two users happen to have the same password? > > It is wrong to assume that no two users will never have the same > password. Doing an update like that, just based on th

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-27 Thread Tobias Franzén
Daniel Brown wrote: On Tue, Feb 26, 2008 at 8:55 AM, Henry Felton <[EMAIL PROTECTED]> wrote: Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the ot

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-26 Thread Daniel Brown
On Tue, Feb 26, 2008 at 8:55 AM, Henry Felton <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I'm just getting into PHP at the moment and was wondering; what code would I > need to look at a field value entered in a form, then if that value is found > in my table, enter all the other information e

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-26 Thread Jason Pruim
On Feb 26, 2008, at 8:55 AM, Henry Felton wrote: Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the other information entered in the form, to the

Re: [PHP-DB] PHP/MySQL - Matrix

2007-11-01 Thread Chris
Eduardo Vizcarra wrote: Hi Chris How do I save the matrix in the session ? Actually, my first question is, what do you mean by a session ? http://www.php.net/session Look under the examples. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www

Re: [PHP-DB] PHP/MySQL - Matrix

2007-11-01 Thread Eduardo Vizcarra
Hi Chris How do I save the matrix in the session ? Actually, my first question is, what do you mean by a session ? Regards Eduardo "Chris" <[EMAIL PROTECTED]> escribió en el mensaje news:[EMAIL PROTECTED] > >> When I get all the records from the photos table, I am using a web page >> to displ

Re: [PHP-DB] PHP/MySQL - Matrix

2007-11-01 Thread Chris
When I get all the records from the photos table, I am using a web page to display only the first record, then, if the user hits a next link then the user should be able to see the next record (next picture) and so on, I do not want to do a select every time the user hits next or back to get t

Re: [PHP-DB] PHP + MySQL

2007-07-18 Thread Dimiter Ivanov
On 7/18/07, Dan Maret <[EMAIL PROTECTED]> wrote: I just can't figure it out and Google yielded no help. I have a table named 'settings' which contains two fields, 'item' and 'content'. What I would like to do is grab that data and use the 'item' field as the name, and use the respective 'content

Re: [PHP-DB] PHP & MySQL Issue!

2007-07-13 Thread Dwight Altman
On Jul 12, 2007, at 9:50 PM, Austin C wrote: Hello, I dont get any errors. Just a blank page. But, I go to the database, and it did what I told it to with the header table, but not with the circulation table. After you built the SQL for the circulation table, you did not execute it [with

Re: [PHP-DB] PHP & MySQL Issue!

2007-07-13 Thread Dwight Altman
On Jul 12, 2007, at 9:50 PM, Austin C wrote: Hello, I dont get any errors. Just a blank page. But, I go to the database, and it did what I told it to with the header table, but not with the circulation table. Check your error log or add this as the first line in your script. ini_set('displa

Re: [PHP-DB] PHP/MySQL UTF-8 SNAFU

2007-07-13 Thread OKi98
Charles Sheinin napsal(a): Ok, so I have a fully UTF-8 MySQL database with a fully UTF-8 table. I have a php page which has "content="application/xhtml+xml; charset=utf-8" />" at the top of the html section and "mysql_set_charset("utf8");" after my connection (it's php 2.2.3, so that's more or

Re: [PHP-DB] PHP & MySQL Issue!

2007-07-12 Thread Austin C
Hello, I dont get any errors. Just a blank page. But, I go to the database, and it did what I told it to with the header table, but not with the circulation table. On 7/12/07, Niel <[EMAIL PROTECTED]> wrote: Hi Give us a clue? What's the error(s) you get returned? -- Niel Archer -- PHP Databa

Re: [PHP-DB] PHP & MySQL Issue!

2007-07-12 Thread Chris
Austin C wrote: Hello everyone, im trying to use PHP to create 2 tables in a database and populate them with tables, however, it just wont work. Where does it stop working? Looks fine from what you've shown us but you need to track down the problem a bit further. -- Postgresql & php tutoria

Re: [PHP-DB] PHP & MySQL Issue!

2007-07-12 Thread Niel
Hi Give us a clue? What's the error(s) you get returned? -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP & MySQL Issue!

2007-07-12 Thread bedul
- Original Message - From: "Austin C" <[EMAIL PROTECTED]> To: Sent: Friday, July 13, 2007 8:41 AM Subject: [PHP-DB] PHP & MySQL Issue! > Hello everyone, im trying to use PHP to create 2 tables in a database and > populate them with tables, however, it just wont work. Here is my full co

Re: [PHP-DB] PHP/MySQL UTF-8 SNAFU

2007-07-12 Thread Niel
Hi What functions are you using? Many of PHP's functions are not multibyte aware and default to ASCII. I had this problems myself end of last year. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] PHP/Mysql search

2006-05-22 Thread Eustace
Thanks, I have somewhere to start! Eustace -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 4:10 PM To: [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] PHP/Mysql search http://www.weberdev.com/get_example-4236.html is an example

Re: [PHP-DB] PHP/Mysql search

2006-05-22 Thread John Hicks
Miguel Guirao wrote: CREATIVITY is what you are looking for. What do you mean by CREATIVITY? -J -Original Message- From: Eustace [mailto:[EMAIL PROTECTED] Sent: Lunes, 22 de Mayo de 2006 07:59 a.m. To: php-db@lists.php.net Subject: [PHP-DB] PHP/Mysql search Hello, Please be patie

RE: [PHP-DB] PHP/Mysql search

2006-05-22 Thread Bastien Koert
http://www.weberdev.com/get_example-4236.html is an example that I wrote that does this bastien From: "Eustace" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: Subject: [PHP-DB] PHP/Mysql search Date: Mon, 22 May 2006 14:58:59 +0200 Hello, Please be patient and assist meI am buil

RE: [PHP-DB] PHP/Mysql search

2006-05-22 Thread Miguel Guirao
CREATIVITY is what you are looking for. -Original Message- From: Eustace [mailto:[EMAIL PROTECTED] Sent: Lunes, 22 de Mayo de 2006 07:59 a.m. To: php-db@lists.php.net Subject: [PHP-DB] PHP/Mysql search Hello, Please be patient and assist meI am building a web application where a s

Re: [PHP-DB] PHP, MySQL and Apache

2006-02-27 Thread Luis Morales
Hi kinfe, To connect to myql from php you only need build your php with mysql support. Now, for render vxml documents you are using apache o IIS ? I recommend LAMP (Linux+Apache+Myql+Php) Regards, Luis Morales On Mon, 2006-02-27 at 16:07 +0100, Kinfe Tadesse wrote: > Hi all, > > I intend

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

2006-02-27 Thread Miguel Guirao
Answer 1. No, you do not need Apache. You could be using IIS along with PHP and MySQL if that is what you need! But talking about natural relationships, there is nothing better that the great combitation formed by XAMP. Answer 2. There is a MySQL API specially done for PHP, so there is no need t

RE: [PHP-DB] Php-MySQL general function for insert, update,delete, count query

2005-06-25 Thread Bastien Koert
I wrote this one and use it in a lot of places //echo "server is : ".$_SERVER['SERVER_NAME']; //use this the first time to get the host name...then comment it out or delete to complete the security check //if (($_SERVER['SERVER_NAME']!="www.fishinweather.com")){ if (($_SERVER['SERVER_NAME']!

RE: [PHP-DB] PHP/MySQL with Javascript

2005-06-15 Thread Bastien Koert
you can supply the value to js as a hidden variable in the form bastien From: "Chris Payne" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] PHP/MySQL with Javascript Date: Wed, 15 Jun 2005 16:55:32 -0400 Hi there everyone, Just a quick question, I have a login system that stores whether you are

Re: [PHP-DB] PHP/MySQL with Javascript

2005-06-15 Thread Frank M. Kromann
You can have PHP generate a small javascript section where you define the variables or you can use cookies. - Frank > Hi there everyone, > > > > Just a quick question, I have a login system that stores whether you are > logged in or not with a PHP Session. However, I need it so when people >

RE: [PHP-DB] PHP&MySQL left/substring etc problem

2005-04-18 Thread Juffermans, Jos
If you do "SELECT LEFT(loc1,3) FROM openart_table" the column name in $row (Bis probably not "loc1". Try this: "SELECT LEFT(loc1,3) AS loc1 FROM (Bopenart_table". Also, after the fetch you can do some debuggin thru this: (B (B"; print_r($row); print ""; (B?> (B (BThat prints out a list of al

Re: [PHP-DB] PHP&MySQL left/substring etc problem

2005-04-18 Thread Andrés G . Montañez
> But when I tried, "select left (loc1,3) from openart_table where.." Try without the space between 'left' and '(', I mean... LEFT(loc1, 3) where loc1 is the name of the column, and 3 the characters you want to show. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevide

RE: [PHP-DB] PHP, MySQL and phpMyAdmin versions...

2004-12-17 Thread Norland, Martin
> -Original Message- > From: Bastien Koert [mailto:[EMAIL PROTECTED] > > huh? you can and should be able to upgrade to 4.0.x without too many > problems. PHP 4.3.9 has no problems with that, nor will PHPMyAdmin. Moving > to mySQL 4.1 will involve more pain as the protocols are vastly diff

RE: [PHP-DB] PHP, MySQL and phpMyAdmin versions...

2004-12-17 Thread Bastien Koert
huh? you can and should be able to upgrade to 4.0.x without too many problems. PHP 4.3.9 has no problems with that, nor will PHPMyAdmin. Moving to mySQL 4.1 will involve more pain as the protocols are vastly different and uses a different php library (mysqli). For upgrade info see here (http://

Re: [PHP-DB] php mysql dates

2004-07-28 Thread zareef ahmed
Dear Irm Jr, Here are two functions:: http::/www.php.net/strtotime http::/www.php.net/mktime using these functions togethor you can do the need full. BTW why not store just unix time stamp in mysql database. Most People use a string field in mysql database to store timestamp, it simply work wit

RE: [PHP-DB] php mysql dates

2004-07-28 Thread Irm Jr
Thanks for the replies. I believe I have two solutions now! Take care. Much apprecitated. -Original Message- From: Swan, Nicole [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 28, 2004 2:48 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] php mysql dates I would suggest creating

RE: [PHP-DB] php mysql dates

2004-07-28 Thread Swan, Nicole
Specialist Carroll College CCIT (406)447-4310 -Original Message- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 28, 2004 3:44 PM To: Irm Jr Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] php mysql dates On Wed, 28 Jul 2004 14:39:01 -0700, Irm Jr <[EMAIL PROTECTED]>

Re: [PHP-DB] php mysql dates

2004-07-28 Thread Justin Patrin
ay to deal with that, IMHO, is strtotime and date. $mysqlDate = date('Y-m-d', strtotime($month.' '.$day.', '.$year)); If you're using dates far in the past or future, though, this won't work. Better to use a date handling class, such as: http://pear.p

RE: [PHP-DB] php mysql dates

2004-07-28 Thread Irm Jr
Sure I understand Y-m-d. But won't the database cry because the Month is in text format? (January, february)? Thanks again. Subject: Re: [PHP-DB] php mysql dates On Wed, 28 Jul 2004 14:30:24 -0700, Irm Jr <[EMAIL PROTECTED]> wrote: > > Hi all, currently I have a form

Re: [PHP-DB] php-mysql problem

2004-05-13 Thread Stefan Dengscherz
hello, did you load the mysql module in your php.ini configuration file? i.e. is the following line there: extension=mysql.so regards On Thu, 13 May 2004 11:47:41 -0400 Jianping Zhu <[EMAIL PROTECTED]> wrote: > have redhat 9.0 and Server version: Apache/2.0.40. > i have installed rpms php-4.

Re: [Fwd: Re: [PHP-DB] php, mysql security question]

2004-03-31 Thread JeRRy
Doug, No worries, thanks for the link. J --- Doug Thompson <[EMAIL PROTECTED]> wrote: > Oops. For some reason my filter concluded your > email was spam and it modifies the subject line. I > missed cleaning the subject line on the first > reply. Here is is again in case others filter on > th

[Fwd: Re: [PHP-DB] php, mysql security question]

2004-03-31 Thread Doug Thompson
Oops. For some reason my filter concluded your email was spam and it modifies the subject line. I missed cleaning the subject line on the first reply. Here is is again in case others filter on that keyword. I apologize for the double post and possible confusion. \Doug JeRRy wrote: Hi, I

Re: [PHP-DB] php, mysql security question

2004-03-31 Thread John Holmes
JeRRy wrote: You know how there is a way to enable/disable hot linking to your images via CPanel to allow/disallow people to link to your images from an external site? Well is there a way to allow/disable external sites connecting to a mysql via PHP? So is there a way to allow only localhost acc

Re: [PHP-DB] PHP-Mysql speed

2003-10-12 Thread Lester Caine
As I know PostNuke use ADO connection. Are the normal Mysql php function faster than the ADO variant? How big is the difference? ADO just wraps the base functions. Zend PHP Optimizer can help for me? Probably a bit How is it possible to handle 40-50,000 visitors? A second machine with Firebird da

Re: [PHP-DB] PHP, MySQL and Apache 2 ?

2003-09-03 Thread j.zanen
I use apache 2.0.47 withMysql 4.1 (beta) and php 4.3.2 All that I want to do seems to work fine (no issues yet) Installation was a breeze Jack > > from: David Haines <[EMAIL PROTECTED]> > date: 2003/09/02 Tue PM 09:11:54 CEST > to: <[EMAIL PROTECTED]> > subject: [PHP-DB] PHP, MySQL and Apache

Re: [PHP-DB] PHP, MySQL and Apache 2 ?

2003-09-03 Thread Balaji H. Kasal
> > How many of you are using PHP with MySQL and Apache 2 ? > I am using. PHP:4.2.2, MySQL: 3.23 Apache 2. > I know there _were_ some problems, but do the current (stable) PHP and MySQL > work fine with Apache 2 ? > They work fine together. Only I faced problem during installation. But t

Re: [PHP-DB] PHP, MySQL and Apache 2 ?

2003-09-02 Thread Martin Marques
El Mar 02 Sep 2003 16:11, David Haines escribió: > This is maybe a bit Off-topic, and yet I could think of no better place to > ask: > > How many of you are using PHP with MySQL and Apache 2 ? > > I know there _were_ some problems, but do the current (stable) PHP and > MySQL work fine with Apache 2

Re: [PHP-DB] php mysql arrays and totals

2003-07-18 Thread Dirk Kredler
Am Freitag, 18. Juli 2003 12:33 schrieb Wendell Frohwein: > i didnt even know that function existed, could you maybe give me a little > more detail on it, then im sure i can figure it out, thanks allot, SUM() is a standard function from (my)SQL. just use it and be happy, if you need in depth deta

Re: [PHP-DB] php mysql arrays and totals

2003-07-18 Thread Wendell Frohwein
i didnt even know that function existed, could you maybe give me a little more detail on it, then im sure i can figure it out, thanks allot, -wendell "Dirk Kredler" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Am Freitag, 18. Juli 2003 12:18 schrieb Wendell Frohwein: > > called

Re: [PHP-DB] php mysql arrays and totals

2003-07-18 Thread Dirk Kredler
Am Freitag, 18. Juli 2003 12:18 schrieb Wendell Frohwein: > called amount. I use mysql_query("SELECT amount FROM items"); to get the > amounts into the script. > I would then like all the values to be added up for a grand total. I have > tried this and the why dont you use : SELECT SUM(amount) FR

Re: [PHP-DB] PHP MySQL news display probs

2003-07-15 Thread jeffrey_n_Dyke
you'll need to use $_GET['id'] or you'll need to set register_globals = On. I would use the first method, and replace $query = "SELECT slug, content, contact, timestamp FROM news WHERE id = '$id'"; with --> $query = "SELECT slug, content, contact, timestamp FROM news WHERE id = '". $_GET['id']."

Re: [PHP-DB] PHP MySQL news display probs

2003-07-15 Thread CPT John W. Holmes
> I have created a simple news system and am having a > problem in that all the code compiles so I think it is > correct and the news headlines display but when you > point to the link to read the article (for example > http://localhost/news/user/story.php?id=2) nothing > displays, it returns that

Re: [PHP-DB] PHP, MySQL and Flash

2003-07-09 Thread Stan Lemon
One hesitation regarding Flash... If you want to use the old and, respectively dead, libswf cool beans, but if you steer the way of Ming beware, it is ridiculously buggy. I personally have had quite a pickle with it. If I was asked to do Flash work I'd be tempted to go out and buy the prog, m

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

2003-07-09 Thread Rich Hutchins
Randy, There ARE javascript solutions for this and a few can be found here: http://www.webreference.com/programming/javascript/dragdropie/ http://www.walterzorn.com/dragdrop/dragdrop_e.htm http://www.webreference.com/dhtml/column7/ (particularly good) What you'll find is that JS does not natively

RE: [PHP-DB] php /mysql / viewing offline question

2003-06-14 Thread Mike
You'll want a webserver running and PHP configured for that server. You can easily use IIS or Apache for this purpose. Which one you want to use is something that many people will argue over, but the simple fact is that you're doing some offline development and you should use what's easiest for you

RE: [PHP-DB] PHP/Mysql Script help.

2003-06-06 Thread Fulco of Scarborough
net [EMAIL PROTECTED] Vincit imitationem veritas. > -Original Message- > From: Becoming Digital [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 05, 2003 4:59 AM > To: 'PHP-DB' > Subject: Re: [PHP-DB] PHP/Mysql Script help. > > I debugged the code and there were

Re: [PHP-DB] PHP/Mysql Script help.

2003-06-05 Thread Becoming Digital
. " R" . " S" . " T" . " U" . " V" . " W" . " X" . " Y" . " Z" . "" . " " . " &

Re: [PHP-DB] PHP/Mysql Script help.

2003-06-05 Thread Jason Wong
On Thursday 05 June 2003 12:25, Fulco of Scarborough wrote: > I have still been getting errors, so here goes again. [snip] > I am still getting "Parse error: parse error, unexpected T_STRING in > /home/wwwfulc/public_html/st/races.php on line 38" Parse error means that you have written incorrect

Re: [PHP-DB] PHP/Mysql Script help.

2003-06-05 Thread Fulco of Scarborough
I have still been getting errors, so here goes again. I am attempting to design a script that presents the user with a form with 26 letters to choose from. When they pick a letter I want it to take them to a list of all the entries in my database that begin with the letter they selected in lin

Re: [PHP-DB] PHP/Mysql Script help.

2003-06-05 Thread heilo
hi! wow - cool code! it is very well structured i think (i like it ;-)! i just would change 2 little details (thats only what i'd do): if($id) is not enough for me - first of all i want that it can only be transportet by GET. secondly i do not want people trying to hack my mysql-server with some

RE: [PHP-DB] php/mysql query

2003-02-20 Thread Kelly Protsko
Well if the zip codes have something in common just do a pattern match for them or are you just picking random zip codes? This way you only need one one sql statement to bring everything back. Kelly -Original Message- From: Julie Keywell [mailto:[EMAIL PROTECTED]] Sent: February 20, 200

RE: [PHP-DB] PHP && MySQL: temporary table problem

2003-01-24 Thread Damir Dezeljin
Hi. > I would like to know, if there is any change to export/import data from > SQL/EXCEL/SQL with php??? It?s very important. So if someone knows a way > please help me. HeHe ... I don't know how this is related to my question, but. To import directly in Excel from MySQL, you can use MyODBC (I s

RE: [PHP-DB] PHP && MySQL: temporary table problem

2003-01-24 Thread Bruno Pereira
I would like to know, if there is any change to export/import data from SQL/EXCEL/SQL with php??? It?s very important. So if someone knows a way please help me. Thanks. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -Original Message- From: Damir Dezeljin [mailto:[EMAIL PROTECTED]] Sent: s

Re: [PHP-DB] php - mysql connection via Apache

2003-01-13 Thread Jason Wong
On Monday 13 January 2003 19:00, Vic Sutton wrote: > Folks, > I have PHP 4.2.2, Apache 1.3.6 & MySQL 3.22.53 installed. The access to > MySQL is fine from the command line, but fails from Apache with "Fatal > error: Call to undefined function: mysql_connect() in .." when running > same scri

Re: [PHP-DB] php-mysql connect

2003-01-12 Thread Larry E. Ullman
I've setup a form to submit data into my MySQL database and it appears to connect properly and whatnot but when I check to see that the data has been inserted properly using phpMyAdmin, the table refelcts a new row entry but the fields are empty. ??? I suspect this is a register_globals problem

Re: [PHP-DB] php-mysql connect

2003-01-12 Thread Jeffrey_N_Dyke
does this have anything to do with register_globals being off. are you using $_POST['var_name']? or $_GET['var_name']? can you send some code? jeff "Jared

Re: [PHP-DB] PHP/MySQL

2003-01-04 Thread Micah Stevens
The script is generating a filename based on the id and then copies the file from somewhere to the new location. It's doing just what it's supposed to. IF you don't want it to do it, just use the following instead: // // Insert the photo details into the database /

Re: [PHP-DB] php/mysql

2002-12-26 Thread 1LT John W. Holmes
> >> I don't know where the error lays, in php, mysql or red hat 8. > >> But, I can't get my databased php-apps to work. > >> I am trying to run: > >> > >> apache_1.3.27 > >> php-4.2.3 > >> mysql-3.23.53 > >> redhat 8.0 > >> > >> What happens is that apache and php work nicely, but my apps cannot >

Re: [PHP-DB] php/mysql

2002-12-26 Thread 1LT John W. Holmes
> > I don't use RedHat, but I've heard (possibly here) that the RH PHP > > RPM does not properly install MySQL support by default and that > > there's something like php_mysql.rpm (or something similar) that > > needs to be installed as well? Does any of that sound familiar to > > anyone? > > > I'v

Re: [PHP-DB] php/mysql

2002-12-26 Thread Martin S
Mark wrote: > I don't use RedHat, but I've heard (possibly here) that the RH PHP > RPM does not properly install MySQL support by default and that > there's something like php_mysql.rpm (or something similar) that > needs to be installed as well? Does any of that sound familiar to > anyone? > I'v

Re: [PHP-DB] php/mysql

2002-12-26 Thread Martin S
1lt John W. Holmes wrote: >> I don't know where the error lays, in php, mysql or red hat 8. >> But, I can't get my databased php-apps to work. >> I am trying to run: >> >> apache_1.3.27 >> php-4.2.3 >> mysql-3.23.53 >> redhat 8.0 >> >> What happens is that apache and php work nicely, but my apps c

Re: [PHP-DB] php/mysql

2002-12-26 Thread Mark
I don't use RedHat, but I've heard (possibly here) that the RH PHP RPM does not *properly* install MySQL support by default and that there's something like php_mysql.rpm (or something similar) that needs to be installed as well? Does any of that sound familiar to anyone? Have I qualified that enou

  1   2   >