[PHP] MySQL+PHP

2010-07-21 Thread Diana Wu
Dear all, I'm a newbie, need your help. Now I am building a databasea using MySQL and PHP, I want to put two tables in one searching, the two are in one database. $query = "SELECT SQL_CALC_FOUND_ROWS * FROM table1 WHERE ".implode(" AND ", $data); $number = "SELECT FOUND_ROWS()"; How can

Re: [PHP] mysql + PHP

2006-06-15 Thread tedd
At 2:14 PM +0800 6/15/06, weetat wrote: >Hi all, > > I have SQL query , for example , Select country , name from tbl_chassis > order by country. > > The problem of the sql statement is that , if there are empty value in > country field , it be sorted first . > >How to do sorting the empty value

Re: [PHP] mysql + PHP

2006-06-15 Thread weetat
Thank all for your inputs. Yes . the data should be null , really bad data , will try to change database structure. Richard Lynch wrote: On Thu, June 15, 2006 1:14 am, weetat wrote: I have SQL query , for example , Select country , name from tbl_chassis order by country. The problem of

Re: [PHP] mysql + PHP

2006-06-15 Thread Richard Lynch
On Thu, June 15, 2006 1:14 am, weetat wrote: >I have SQL query , for example , Select country , name from > tbl_chassis order by country. > > The problem of the sql statement is that , if there are empty value > in > country field , it be sorted first . > > How to do sorting the empty value l

Re: [PHP] mysql + PHP

2006-06-15 Thread Martin Alterisio
2006/6/15, weetat <[EMAIL PROTECTED]>: Hi all, I have SQL query , for example , Select country , name from tbl_chassis order by country. The problem of the sql statement is that , if there are empty value in country field , it be sorted first . How to do sorting the empty value last ? I

Re: [PHP] mysql + PHP

2006-06-15 Thread Satyam
OTECTED]> To: ; "Satyam" <[EMAIL PROTECTED]> Cc: Sent: Thursday, June 15, 2006 8:51 AM Subject: Re: [PHP] mysql + PHP hi , not working . The empty value still sorted first. Thanks. Satyam wrote: perhaps this will work: Select country , name from tbl_chassis order by ifnul

Re: [PHP] mysql + PHP

2006-06-14 Thread weetat
t: Thursday, June 15, 2006 8:14 AM Subject: [PHP] mysql + PHP Hi all, I have SQL query , for example , Select country , name from tbl_chassis order by country. The problem of the sql statement is that , if there are empty value in country field , it be sorted first . How to do sorting

Re: [PHP] mysql + PHP

2006-06-14 Thread Satyam
perhaps this will work: Select country , name from tbl_chassis order by ifnull(country,'') didn't try it. - Original Message - From: "weetat" <[EMAIL PROTECTED]> To: Sent: Thursday, June 15, 2006 8:14 AM Subject: [PHP] mysql + PHP Hi all,

[PHP] mysql + PHP

2006-06-14 Thread weetat
Hi all, I have SQL query , for example , Select country , name from tbl_chassis order by country. The problem of the sql statement is that , if there are empty value in country field , it be sorted first . How to do sorting the empty value last ? I can cp() function to do this ? or any m

[PHP] Mysql & php & Load Data Infiles

2005-11-06 Thread Vizion
While I think this is primarily a mysql syntax problem I have asked on the mysql forum but not got a reply. I am trying using php to set up a system for loading a new data base using the Load Data Infile statement. I could not get it to work properly with php so I thought I would try some comma

[PHP] mysql/php date functions..

2005-09-26 Thread info
Hello Bruce, While the date functions are well documented - http://php.net/date - here is a little example to manipulate the date with php, rather than mysql: // set the new expiry date // DATE FUNCTIONS FOR THE EXPIRY MODULE // first perform date arithmetic $listingExpiry = mktime (0,0,0,date("m

RE: [PHP] mysql/php date functions..

2005-09-26 Thread Chrome
TECTED] Sent: 26 September 2005 19:46 To: 'John Nichel'; php-general@lists.php.net Subject: RE: [PHP] mysql/php date functions.. john... that appears to be it!! although i would have assumes it would have done a most significant bit fill with 0's... so my question also comes down t

Re: [PHP] mysql/php date functions..

2005-09-26 Thread John Nichel
Chris W. Parker wrote: John Nichel on Monday, September 26, 2005 12:43 PM said: I don't convert it. I store the UNIX timestamp in an INT(11) column. This is going to be a basic question I'm sure but why INT and not VARCHAR? Is it simply because a timestamp is

Re: [PHP] mysql/php date functions..

2005-09-26 Thread Kristen G. Thorson
tamp var ->> the php var? thanks bruce -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:38 PM To: 'John Nichel'; php-general@lists.php.net Subject: RE: [PHP] mysql/php date functions.. so you play with the time/date vars on the p

RE: [PHP] mysql/php date functions..

2005-09-26 Thread Chris W. Parker
John Nichel on Monday, September 26, 2005 12:43 PM said: > I don't convert it. I store the UNIX timestamp in an INT(11) column. This is going to be a basic question I'm sure but why INT and not VARCHAR? Is it simply because a timestamp is a number? Chris. -- PH

Re: [PHP] mysql/php date functions..

2005-09-26 Thread John Nichel
bruce wrote: or.. better yet. if i do a php -> time(), i get a unix_timestamp var. how do you guys store this in mysql. you can't simply do an insert into a mysql/timestamp var. so how do you convert it? I don't convert it. I store the UNIX timestamp in an INT(11) column. also, once you hav

RE: [PHP] mysql/php date functions..

2005-09-26 Thread bruce
p var? thanks bruce -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 12:38 PM To: 'John Nichel'; php-general@lists.php.net Subject: RE: [PHP] mysql/php date functions.. so you play with the time/date vars on the php side, and then simply

RE: [PHP] mysql/php date functions..

2005-09-26 Thread bruce
John Nichel [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:48 AM To: php-general@lists.php.net Subject: Re: [PHP] mysql/php date functions.. bruce wrote: > john... > > that appears to be it!! although i would have assumes it would have done a > most significant bit fill with

RE: [PHP] mysql/php date functions..

2005-09-26 Thread Jim Moseby
> -Original Message- > From: bruce [mailto:[EMAIL PROTECTED] > Sent: Monday, September 26, 2005 2:46 PM > To: 'John Nichel'; php-general@lists.php.net > Subject: RE: [PHP] mysql/php date functions.. > > > john... > > that appears to be it!! a

Re: [PHP] mysql/php date functions..

2005-09-26 Thread John Nichel
bruce wrote: john... that appears to be it!! although i would have assumes it would have done a most significant bit fill with 0's... so my question also comes down to .. do i use the php date functions for date/time manipulation.. or do i use the mysql functions any thoughts/suggestions..

RE: [PHP] mysql/php date functions..

2005-09-26 Thread bruce
bruce -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:19 AM To: php-general@lists.php.net Subject: Re: [PHP] mysql/php date functions.. bruce wrote: > thanks... > > but that's not it john... i'm not worried about creatin

RE: [PHP] mysql/php date functions..

2005-09-26 Thread bruce
but that still doesn't explain why i can't slam some value directly into the timestamp var within the mysql tbl... -Original Message- From: Chris W. Parker [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:15 AM To: php-general@lists.php.net Subject: RE: [PHP] mysq

Re: [PHP] mysql/php date functions..

2005-09-26 Thread John Nichel
bruce wrote: thanks... but that's not it john... i'm not worried about creating the sql_statement in the php... i'm concerned that i can't seem to craft/create a basic sql cmd within mysql to get a value (other than NOW()) to work... if i do (from mysql) -->> insert into foo (id, time) values

RE: [PHP] mysql/php date functions..

2005-09-26 Thread Chris W. Parker
bruce on Monday, September 26, 2005 11:13 AM said: > i'm concerned that i can't seem to craft/create a basic sql cmd > within mysql to get a value (other than NOW()) to work... [snip] > my question is why??? MySQL timestamps are different from UNIX timestamps. Chr

RE: [PHP] mysql/php date functions..

2005-09-26 Thread bruce
D] Sent: Monday, September 26, 2005 11:00 AM To: php-general@lists.php.net Subject: Re: [PHP] mysql/php date functions.. bruce wrote: > how can i create a mysql sql statement to insert a php 'time()' into mysql? > > i've got the mysql var 't1, timestamp' but i can

RE: [PHP] mysql/php date functions..

2005-09-26 Thread bruce
d, time) values (2, 33), it doesn't work... if i -->> insert into foo (id, time) values (2, NOW()), it works!!... my question is why??? -bruce -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 11:00 AM To: php-general@lists.php.

Re: [PHP] mysql/php date functions..

2005-09-26 Thread John Nichel
bruce wrote: how can i create a mysql sql statement to insert a php 'time()' into mysql? i've got the mysql var 't1, timestamp' but i can't figure out how to do an insert $q = time(); $sql = sprintf("insert into foo (id, ctime) values(%d, %???), $id, $q); can't figure out how to get this to wo

RE: [PHP] mysql/php date functions..

2005-09-26 Thread bruce
so what's the basic part i'm missing??!! -bruce -Original Message- From: Silvio Porcellana [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 8:51 AM To: php-general@lists.php.net Subject: Re: [PHP] mysql/php date functions.. Jim Moseby wrote: > > Hi Bruce! > > MySQ

Re: [PHP] mysql/php date functions..

2005-09-26 Thread Silvio Porcellana
Jim Moseby wrote: > > Hi Bruce! > > MySQL and PHP both have extensive built-in date functions that are clearly > documented and extraordinarily easy to use. For the vast majority of > situations, there is no need to manually write any custom date-handling > code. The decision to use MySQL or PHP

RE: [PHP] mysql/php date functions..

2005-09-26 Thread Jim Moseby
> -Original Message- > From: bruce [mailto:[EMAIL PROTECTED] > Sent: Monday, September 26, 2005 11:12 AM > To: php-general@lists.php.net > Subject: [PHP] mysql/php date functions.. > > > hi... > > can anybody point me to a good/basic tutorial (tested) for

[PHP] mysql/php date functions..

2005-09-26 Thread bruce
hi... can anybody point me to a good/basic tutorial (tested) for php/mysql date functions... basically, i want to store a date/time in a column, and be able to read it, manipulate it, and update the table. i've seen various articles/sample code, but i'm looking for something that i cna pretty much

RE: [PHP] MySQL + PHP question

2005-07-26 Thread Shaw, Chris - Accenture
arent. HTH. C. -Original Message- From: Mark Rees [mailto:[EMAIL PROTECTED] Sent: 26 July 2005 13:39 To: php-general@lists.php.net Subject: Re: [PHP] MySQL + PHP question * This e-mail has been received by the Revenue Internet

Re: [PHP] MySQL + PHP question

2005-07-26 Thread André Medeiros
On Tue, 2005-07-26 at 13:39 +0100, Mark Rees wrote: > "André Medeiros" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > One thing I didn't quite explain myself well... I'm building this to > > register objects on a permission system. > > > > The SQL weight is heavy as it is, and I

Re: [PHP] MySQL + PHP question

2005-07-26 Thread Mark Rees
"André Medeiros" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > One thing I didn't quite explain myself well... I'm building this to > register objects on a permission system. > > The SQL weight is heavy as it is, and I want to save queries as much as > possible. Making two queries t

RE: [PHP] MySQL + PHP question

2005-07-26 Thread André Medeiros
You're missing the point here. I know how to get the parent project's info. I know recursiveness. I _JUST_ don't know how to get the current and parent project's info in just ONE QUERY (since I'm trying to save them because the sql weight is getting pretty heavy). -- PHP General Mailing List (htt

Re: [PHP] MySQL + PHP question

2005-07-26 Thread André Medeiros
One thing I didn't quite explain myself well... I'm building this to register objects on a permission system. The SQL weight is heavy as it is, and I want to save queries as much as possible. Making two queries to extract information about a project and it's parent is not something I'd want to do.

RE: [PHP] MySQL + PHP question

2005-07-26 Thread Shaw, Chris - Accenture
t on MySQL, but this query should work on MSSQL and Oracle. HTH. C. -Original Message- From: André Medeiros [mailto:[EMAIL PROTECTED] Sent: 26 July 2005 12:53 To: Shaw, Chris - Accenture Cc: php-general@lists.php.net Subject: RE: [PHP] MySQL + PH

Re: [PHP] MySQL + PHP question

2005-07-26 Thread Mark Rees
riginal Message- From: André Medeiros [mailto:[EMAIL PROTECTED] Sent: 26 July 2005 12:18 To: php-general@lists.php.net Subject: [PHP] MySQL + PHP question Hi guys. I'm having some trouble here regarding a project. I have a table with projects, wich can be recursive (ie. sub-projects) and it

RE: [PHP] MySQL + PHP question

2005-07-26 Thread André Medeiros
ill overwrite the object's properties). If not... heck, I'll have to make another query or use the associative array sollution (wich neither will make me very happy, but that's life). Thanks for your prompt reply :) > > C. > -Original Message----- > From: An

RE: [PHP] MySQL + PHP question

2005-07-26 Thread Shaw, Chris - Accenture
ject 5, do you want to find out its parent (2), or do you want to find out all its parents including grandparents (2) and (1)? What do you need to know? C. -Original Message- From: André Medeiros [mailto:[EMAIL PROTECTED] Sent: 26 July 2005 12:18 To: php-general@lists.php.net Subject: [

[PHP] MySQL + PHP question

2005-07-26 Thread André Medeiros
Hi guys. I'm having some trouble here regarding a project. I have a table with projects, wich can be recursive (ie. sub-projects) and it is related to itself. By making the following query -8<-- SELECT * FROM projects LEFT JOIN projects proj_parent ON

Re: [PHP] MySQL PHP issue?

2005-04-27 Thread John Nichel
Dustin Wish wrote: It is version 3.23.56 Know thy software. 3.x doesn't support sub-queries. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] MySQL PHP issue?

2005-04-27 Thread Dustin Wish
SH^*&^t Thanks guys. Figured something like that. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 2:53 PM To: Dustin Wish; php-general@lists.php.net Subject: RE: [PHP] MySQL PHP issue? [snip] It is version 3.23.56 [/snip] Sub-que

RE: [PHP] MySQL PHP issue?

2005-04-27 Thread Jay Blanchard
[snip] It is version 3.23.56 [/snip] Sub-queries are not supported in that version of MySQL. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] MySQL PHP issue?

2005-04-27 Thread Dustin Wish
It is version 3.23.56 -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 2:44 PM To: php-general@lists.php.net Subject: Re: [PHP] MySQL PHP issue? Jay Blanchard wrote: > Asking a MySQL question on a PHP list? *slaps knee!* I bet you th

RE: [PHP] MySQL PHP issue?

2005-04-27 Thread Jay Blanchard
[snip] Jay Blanchard wrote: > Asking a MySQL question on a PHP list? *slaps knee!* I bet you think you're funny. ;) [/snip] I know that you think I am. Yuk-yuk! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL PHP issue?

2005-04-27 Thread John Nichel
Jay Blanchard wrote: Asking a MySQL question on a PHP list? *slaps knee!* I bet you think you're funny. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL PHP issue?

2005-04-27 Thread John Nichel
Dustin Wish wrote: Anyone have any idea what I'm doing wrong? Asking on the wrong list. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] MySQL PHP issue?

2005-04-27 Thread Jay Blanchard
[snip] OK, I have check all the mysql doc and php docs on using exists in the query, but it seems I still can not get the query to work. Here it is: SELECT * FROM icisp.account WHERE id in (select oldaccountID from BillMax.account) Or Using sELECT * FROM icisp.account WHERE id exists(select ol

[PHP] MySQL PHP issue?

2005-04-27 Thread Dustin Wish
OK, I have check all the mysql doc and php docs on using exists in the query, but it seems I still can not get the query to work. Here it is: SELECT * FROM icisp.account WHERE id in (select oldaccountID from BillMax.account) Or Using sELECT * FROM icisp.account WHERE id exists(select oldaccou

Re: [PHP] MySQL, PHP and JBOSS

2005-03-15 Thread Marek Kilimajer
david joffrin wrote: Hi, I finally managed to run JBOSS/Tomcat with PHP, however, I am facing the following error message when my PHP code is accessing MySQL: Fatal error: Call to undefined function mysql_connect() in C:\APPS\jboss-3.2.6\server\sudetp\deploy\jbossweb-tomcat50.sar\ROOT.war\regist

[PHP] MySQL, PHP and JBOSS

2005-03-14 Thread david joffrin
Hi, I finally managed to run JBOSS/Tomcat with PHP, however, I am facing the following error message when my PHP code is accessing MySQL: Fatal error: Call to undefined function mysql_connect() in C:\APPS\jboss-3.2.6\server\sudetp\deploy\jbossweb-tomcat50.sar\ROOT.war\registration.php on line 8

Re: [PHP] MySQL - PHP - limits...

2005-03-09 Thread Richard Lynch
> Is there a records limit when browsing (a sql SELECT) in PHP from a MySQL > table? Sort of, I think... When MySQL is compiled, there is a buffer limit on how much crap you can squirt through a single connection. You can maybe alter this in my.cnf or be re-compiling MySQL. If you are trying to

Re: [PHP] MySQL - PHP - limits...

2005-03-09 Thread Marek Kilimajer
Alex Ortiz wrote: Hello. Is there a records limit when browsing (a sql SELECT) in PHP from a MySQL table? no limit on php side, perhaps 2^31 if you do calculations. I´m browsing a table with PHP from MySQL, and something is wrong, if the table has more than 5047 records, the browse appears blank.

[PHP] MySQL - PHP - limits...

2005-03-08 Thread Alex Ortiz
Hello. Is there a records limit when browsing (a sql SELECT) in PHP from a MySQL table? I´m browsing a table with PHP from MySQL, and something is wrong, if the table has more than 5047 records, the browse appears blank. Additionaly, if make the browse in a child window (target="_blank"), the

Re: [PHP] MySQL & PHP database script PLEASE

2004-10-21 Thread Matthew Sims
> > > When GO =< 1000 ), the links to PDF file are shown, > and when GO > 1000, the links to PDF file are not shown (just brank > cells). > > So probably I need to change this part. > ?>.pdf">pdf > But dont know how to do it. > > Please help me anybody, thank you!! My syntax may look different

Re: [PHP] MySQL & PHP database script PLEASE

2004-10-21 Thread Ramil Sagum
> > .pdf">pdf > replace the above block with .pdf">pdf ganbatte! ramil http://ramil.sagum.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] MySQL & PHP Examples & Training Providers Required

2004-08-11 Thread Jay Blanchard
[snip] I'm looking for some examples of sites that are purely MySQL and PHP running on Unix and that contain a few thousand records preferably held in relational databases. Rationale: I need to justify PHP as a tool of choice over say vb.net or Oracle. My recommendation, despite my limited knowle

Re: [PHP] MySQL & PHP Examples & Training Providers Required

2004-08-11 Thread Lester Caine
Robby Russell wrote: Not to start a SQL war, but have you consider PostgreSQL as well in your decisions? And how about Firebird, Oracle has roots from the same original development in the 1980's. -- Lester Caine - L.S.Caine Electronic Services -- PHP General Mailing Li

Re: [PHP] MySQL & PHP Examples & Training Providers Required

2004-08-10 Thread Robby Russell
Not to start a SQL war, but have you consider PostgreSQL as well in your decisions? PostgreSQL has more features that are more comparable to MSSQL and Oracle. Just making sure you make the right decision. ;-) -Robby On Tue, 2004-08-10 at 16:06, Harlequin wrote: > Hi all. > > This might sound l

[PHP] MySQL & PHP Examples & Training Providers Required

2004-08-10 Thread Harlequin
Hi all. This might sound like a strange request but here goes. I'm looking for some examples of sites that are purely MySQL and PHP running on Unix and that contain a few thousand records preferably held in relational databases. Rationale: I need to justify PHP as a tool of choice over say vb.n

Re: [PHP] MySQL/PHP Tunneling

2004-07-11 Thread Karam Chand
Hello, Well, I know there are issues regarding this (security as well as others). But tools like MySQL-Front and DBTools are just doing that and it just happens that the project i am working on needed something like that, so I was just asking :) Regards, Karam --- Curt Zirzow <[EMAIL PROTECTED]>

Re: [PHP] MySQL/PHP Tunneling

2004-07-11 Thread Curt Zirzow
* Thus wrote Karam Chand: > --- Curt Zirzow <[EMAIL PROTECTED]> wrote: > > Now, many of the ISPs blokc 3306 for security reason > and you cannot access MySQL from a 3rd party tool and > have to use phpMyAdmin which is able to access the > MySQL server as it is running on the same box. > Sometimes,

Re: [PHP] MySQL/PHP Tunneling

2004-07-11 Thread Jason Wong
On Sunday 11 July 2004 13:07, Karam Chand wrote: > Sorry. But I just didnt remember the email addy so I > took that way :). Can't resist picking on this one. All posts to the list should/would have the list address in the To: header. It's not that hard to copy paste the address into a *new* mai

Re: [PHP] MySQL/PHP Tunneling

2004-07-10 Thread Karam Chand
--- Curt Zirzow <[EMAIL PROTECTED]> wrote: > > First off, when starting a new topic, don't reply to > message and > then change the topic. Sorry. But I just didnt remember the email addy so I took that way :). > > * Thus wrote Karam Chand: > > Hello, > > > > Recently lot of MySQL clients try t

Re: [PHP] MySQL/PHP Tunneling

2004-07-10 Thread Curt Zirzow
First off, when starting a new topic, don't reply to message and then change the topic. * Thus wrote Karam Chand: > Hello, > > Recently lot of MySQL clients try to overcome host > based privilege system of MySQL by using PHP tunneling > method. > > In this method they call up a PHP file in the

[PHP] MySQL/PHP Tunneling

2004-07-10 Thread Karam Chand
Hello, Recently lot of MySQL clients try to overcome host based privilege system of MySQL by using PHP tunneling method. In this method they call up a PHP file in the server and the PHP file executes a query and sends the data in XML format. I am using C API() and I was just wondering if somebo

RE: [PHP] MySQL & PHP

2004-06-04 Thread Robert Sossomon
:07 AM To: [EMAIL PROTECTED] Subject: [PHP] MySQL & PHP I've just installed Fedora Core 2, including I believe both PHP & MySQL.. However whenever I try and run something that connects to MySQL, it comes up with the following: "cannot load MySQL extension, please ch

RE: [PHP] MySQL & PHP

2004-06-04 Thread Thijs Lensselink
Looks like the mysql module for php is not loaded. Is extension=mysql.so included in the php.ini. Nunners wrote on vrijdag 4 juni 2004 14:07: > I've just installed Fedora Core 2, including I believe both PHP & > MySQL.. However whenever I try and run something that connects to > MySQL, it comes u

[PHP] MySQL & PHP

2004-06-04 Thread Nunners
I've just installed Fedora Core 2, including I believe both PHP & MySQL.. However whenever I try and run something that connects to MySQL, it comes up with the following: "cannot load MySQL extension, please check PHP Configuration." Does this mean anything to anyone? I've checked load

RE: [PHP] MySQL/PHP problem.

2003-07-22 Thread Jennifer Goodie
or just the overall total? > -Original Message- > From: Phillip Blancher [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 22, 2003 2:09 PM > To: PHP List > Subject: [PHP] MySQL/PHP problem. > > > I am trying to count in mySQL the number of entries in the field > &quo

Re: [PHP] MySQL/PHP problem.

2003-07-22 Thread David Otton
On Tue, 22 Jul 2003 17:08:50 -0400, you wrote: >I am trying to count in mySQL the number of entries in the field "day" where day=2 or >3. > >Then I want to check just to see if that returned a value greater than 0 or not. > >I am using the code below, but having a problem, I keep getting 0 as th

Re: [PHP] MySQL/PHP problem.

2003-07-22 Thread Phillip Blancher
ot;amount from DB query"; echo $shipping; ?> - Original Message - From: "Curt Zirzow" <[EMAIL PROTECTED]> To: "PHP List" <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 5:23 PM Subject: Re: [PHP] MySQL/PHP problem. > * Thus wrote Phillip Blan

Re: [PHP] MySQL/PHP problem.

2003-07-22 Thread Curt Zirzow
* Thus wrote Phillip Blancher ([EMAIL PROTECTED]): > I am trying to count in mySQL the number of entries in the field "day" where day=2 > or 3. > > Then I want to check just to see if that returned a value greater than 0 or not. > > I am using the code below, but having a problem, I keep gettin

[PHP] MySQL/PHP problem.

2003-07-22 Thread Phillip Blancher
I am trying to count in mySQL the number of entries in the field "day" where day=2 or 3. Then I want to check just to see if that returned a value greater than 0 or not. I am using the code below, but having a problem, I keep getting 0 as the total What am i doing wrong. $dbqueryshippi

Re: [PHP] mysql/php query - wrox

2003-02-03 Thread Anthony Ritter
Chris Shiflett" wrote in message: > Your query returns two rows because you have two rows in > the database that match the condition: > > host='localhost' > > -- > Chris .. Chris, I was under the impression that the mysql database had as default user when instal

Re: [PHP] mysql/php query - wrox

2003-02-02 Thread Chris Shiflett
--- Anthony Ritter wrote: > I installed mysql 3.23.55 and wanted to check the user > table in the mysql db. > > The query was: > SELECT User FROM user WHERE host='localhost'; This is a PHP list. There are mailing lists for MySQL that you should check out if you are having trouble understanding da

[PHP] mysql/php query - wrox

2003-02-02 Thread Anthony Ritter
Working on: Win 98 / mysql 3.23.55 / php 4 I installed mysql 3.23.55 and wanted to check the user table in the mysql db. The query was: SELECT User FROM user WHERE host='localhost'; The output was: xx user | xx || || root

Re: [PHP] MySQL/PHP Associative Array Insert

2003-02-02 Thread Matt
- Original Message - From: "CDitty" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 01, 2003 11:26 AM Subject: [PHP] MySQL/PHP Associative Array Insert > A co-worker is teaching me to move to the next level in php. I have > started usi

RE: [PHP] MySQL/PHP Associative Array Insert

2003-02-01 Thread @ Nilaab
Saturday, February 01, 2003 1:00 PM > To: [EMAIL PROTECTED] > Subject: RE: [PHP] MySQL/PHP Associative Array Insert > > > Yes Chris, > > When you add the item to the database, make sure to leave out the single > quotes inside the brackets of the associative array. For e

RE: [PHP] MySQL/PHP Associative Array Insert

2003-02-01 Thread @ Nilaab
]'; Hope that helps. > -Original Message- > From: CDitty [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 01, 2003 10:26 AM > To: [EMAIL PROTECTED] > Subject: [PHP] MySQL/PHP Associative Array Insert > > > A co-worker is teaching me to move to the next level in p

[PHP] MySQL/PHP Associative Array Insert

2003-02-01 Thread CDitty
A co-worker is teaching me to move to the next level in php. I have started using associative arrays for my scripts, but I am having a problem using them to do an insert into MySQL. Can someone give me an example of how to do an insert to the database using these arrays? My array is this...$item['i

Re: [PHP] Mysql/php database performance question

2003-01-10 Thread Brent Baisley
I'm coming in a little late on this thread, but I would suggest structuring you data differently. I would have two tables: words and meanings. Then you won't have any null fields and you won't limit yourself to just 5 definitions. It will also be a heck of a lot easier to setup a full text inde

Re: [PHP] Mysql/php database performance question

2003-01-10 Thread Khalid El-Kary
Matt Schroebel wrote: -Original Message- From: Marek Kilimajer [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 11:45 AM To: Matt Schroebel Cc: Simon Dedeyne; [EMAIL PROTECTED] Subject: Re: [PHP] Mysql/php database performance question Sure, just tried it (32-bit platform

Re: [PHP] Mysql/php database performance question

2003-01-10 Thread Marek Kilimajer
in one table Matt Schroebel wrote: -Original Message- From: Marek Kilimajer [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 11:45 AM To: Matt Schroebel Cc: Simon Dedeyne; [EMAIL PROTECTED] Subject: Re: [PHP] Mysql/php database performance question Sure, just tried it (32-bit

RE: [PHP] Mysql/php database performance question

2003-01-10 Thread Matt Schroebel
> -Original Message- > From: Marek Kilimajer [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 10, 2003 11:45 AM > To: Matt Schroebel > Cc: Simon Dedeyne; [EMAIL PROTECTED] > Subject: Re: [PHP] Mysql/php database performance question > > > Sure, just tried it

Re: [PHP] Mysql/php database performance question

2003-01-10 Thread Marek Kilimajer
AIL PROTECTED] Subject: Re: [PHP] Mysql/php database performance question char of greater size than 3 is converted to varchar anyways Are you sure? I've been reading up on this stuff over the last few days, and my understanding is that char is stored fixed width with trailin

RE: [PHP] Mysql/php database performance question

2003-01-10 Thread Matt Schroebel
> -Original Message- > From: Marek Kilimajer [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 10, 2003 11:04 AM > To: Matt Schroebel > Cc: Simon Dedeyne; [EMAIL PROTECTED] > Subject: Re: [PHP] Mysql/php database performance question > > > char of greater

Re: [PHP] Mysql/php database performance question

2003-01-10 Thread Marek Kilimajer
char of greater size than 3 is converted to varchar anyways Where's the pain? The trade off between char and varchar is speed vs table size. Are just trying to be as fast as possible? If the db is small, I wouldn't worry about it and do what ever way you want (i.e. what's a microsecond or two

Re: [PHP] Mysql/php database performance question

2003-01-10 Thread Maxim Maletsky
"keeping those 5 columns with a lot of empty cells in the last columns" is better as it is means exactly for that. Just don't make it a not null field. -- Maxim Maletsky [EMAIL PROTECTED] "Khalid El-Kary" <[EMAIL PROTECTED]> wrote... : > the thing that may make difference in performance (as i

RE: [PHP] Mysql/php database performance question

2003-01-10 Thread Matt Schroebel
> -Original Message- > From: Simon Dedeyne [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 10, 2003 9:03 AM > To: [EMAIL PROTECTED] > Subject: RE: [PHP] Mysql/php database performance question > So I think I have to reformulate the question: which is > better

RE: [PHP] Mysql/php database performance question

2003-01-10 Thread Simon Dedeyne
I see what you mean Khalid, but I only retrieve 1 entry at the time, so exploding wouldn't be the biggest problem I suppose. Furthermore, if I use char columns, and some of those columns have lots of empty cells, isn't it a waste of space/lookup-time? So I think I have to reformulate the questio

Re: [PHP] Mysql/php database performance question

2003-01-10 Thread Khalid El-Kary
the thing that may make difference in performance (as i think) is whether you make it a fixed -CHAR- or a variable -VARCHAR- it's preferable that you make separate char columns, so that PHP will not have to explode every record! Regards, Khalid Al-Kary, Hi, I got a question about using Mysq

[PHP] Mysql/php database performance question

2003-01-10 Thread Simon Dedeyne
Hi, I got a question about using Mysql databases. I load textdata in VARCHAR colums up to size 50. I have about 5 of those columns. The last columns often contain empty cells. (data are wordmeanings, many words have only a 1 or 2meanings) What would be faster/better: - putting everything in a b

Re: [PHP] mysql, php, checkbox

2002-12-05 Thread Adrian Partenie
Indeed, now it works, I put the form tag by mistake... Thanks, Adrian - Original Message - From: "rija" <[EMAIL PROTECTED]> To: "Adrian Partenie" <[EMAIL PROTECTED]> Sent: Tuesday, December 03, 2002 11:30 PM Subject: Re: [PHP] mysql, php, checkbox &g

Re: [PHP] mysql, php, checkbox

2002-12-03 Thread Adrian Partenie
other checkbox, I get the errors PHP Notice: Undefined index: ids in selectare.php PHP Warning: Variable passed to each() is not an array or object in selectare.php - Original Message - From: "John W. Holmes" <[EMAIL PROTECTED]> To: "'Adrian Partenie'&qu

RE: [PHP] mysql, php, checkbox

2002-11-28 Thread John W. Holmes
> I'm displaying the content of a mysql table with autoincrement index. I > want to be able to select the each row from the table using the check > boxes. In order to do that, i want to assign to each checkbox the > name=index of selected row. > I assign to the checkboxes the value of selected id,

[PHP] mysql, php, checkbox

2002-11-28 Thread Adrian Partenie
Hello, I'm displaying the content of a mysql table with autoincrement index. I want to be able to select the each row from the table using the check boxes. In order to do that, i want to assign to each checkbox the name=index of selected row. I assign to the checkboxes the value of selected

[PHP] MySql->PHP->Excel=french weird chars

2002-11-27 Thread Marios Adamantopoulos
Hi all I'm using a MySql database to save French data. In addition, I have a PHP page which is using header("Content-Type: application/vnd.ms-excel; name='excel'"); header("Content-Disposition: attachment; filename=filename.xls"); to save all the data from the database to the excel file. The

[PHP] mysql/php large integer query oddity

2002-11-13 Thread Steve Edberg
I have a query oddity that looks like an integer overflow, but it shouldn't be. Excerpt from my program: #DEBUG echo "\n$Query\n"; #DEBUG $hResult = _do_query(__LINE__, $Query); # _do_query() simply executes mysql_query, and does nice error formatting if necessary $First =

  1   2   >