[PHP] MySQL+PHP

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

"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

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

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

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

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

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

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

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?

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?

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?

[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?

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?

[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?

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?

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?

[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?

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

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

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

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

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

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

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

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

[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

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

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

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

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

* 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

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

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

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

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

: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

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

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.

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.

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.

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.

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

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

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

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

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

- 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

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

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

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

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

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

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

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

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

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

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

"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

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

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

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

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

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

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

> 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

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

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

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   >