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 I
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
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: php-general@lists.php.net
Sent: Thursday, June 15, 2006 8:14 AM
Subject: [PHP] mysql + PHP
Hi all,
I have SQL
: 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 the empty
-general@lists.php.net; Satyam [EMAIL PROTECTED]
Cc: php-general@lists.php.net
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
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
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 last
?
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
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 last
? I
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
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
-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 date
functions... basically
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 to
-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!
MySQL and PHP both have extensive built-in date functions that are clearly
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
), 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.net
Subject: Re: [PHP] mysql/php date
, 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't figure out how to do an
insert
$q = time
bruce mailto:[EMAIL PROTECTED]
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.
Chris.
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
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] mysql/php date
-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 creating the sql_statement
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
-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!! although i would have assumes it
would have done
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 0's...
so my
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 store
them in the mysql tbl
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
John Nichel mailto:[EMAIL PROTECTED]
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.
--
PHP
- 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 php side, and then simply
Chris W. Parker wrote:
John Nichel mailto:[EMAIL PROTECTED]
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
]
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 to .. do i use the php
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
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
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
sollution (wich neither will make me very happy, but that's life).
Thanks for your prompt reply :)
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
-
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
, 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 + 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
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
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 to
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 want to save
.
-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 e-mail service
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
[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
Dustin Wish wrote:
snip
Anyone have any idea what I'm doing wrong?
/snip
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
Jay Blanchard wrote:
snip
Asking a MySQL question on a PHP list? *slaps knee!*
/snip
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
[snip]
Jay Blanchard wrote:
snip
Asking a MySQL question on a PHP list? *slaps knee!*
/snip
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
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:
snip
Asking a MySQL question on a PHP list? *slaps knee!*
/snip
I bet
[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
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-queries
Dustin Wish wrote:
It is version 3.23.56
snip
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
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
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
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
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
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
td? echo $row[end]; ?/td
tdA HREF=/momatlib/gendai/pdf/? echo $row[GO]; ?.pdfpdf/A/td
/tr
replace the above block with
td? echo $row[end]; ?/td
td
?php if($row[GO] = 1000) { ?
A HREF=/momatlib/gendai/pdf/? echo $row[GO]; ?.pdfpdf/A
?php }?
/td
/tr
ganbatte!
snip
I NEED THIS
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.
tdA HREF=/momatlib/gendai/pdf/? echo $row[GO];
?.pdfpdf/A/td
But dont know how to do it.
Please help
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
[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
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
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
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*
* 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, SSH
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]
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
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 server
--- 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 to overcome
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 loads
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 up
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 check PHP Configuration.
Does
* 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 getting 0 as
print_r($shipping3);
echo 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 Blancher ([EMAIL PROTECTED
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 the 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
day where day=2 or 3.
Then I want to check just to see
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.
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
installed:
- 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 using associative arrays for my scripts
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
--- 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
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
.
-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 php. I have
started using associative arrays for my scripts
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 example:
Instead Of:
$item['itemID']
Do This:
$item[itemID
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
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
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
-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 5 varchar columns of size 50
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
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
-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 size than 3 is converted to varchar
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
trailing spaces
-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, might be 7 for 64
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
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
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
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
There are form/form tags around input type
, November 28, 2002 5:54 PM
Subject: 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
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
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, but
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
I have a query oddity that looks like an integer overflow, but it shouldn't be.
Excerpt from my program:
snip
#DEBUG
echo \nbr$Querybr\n;
#DEBUG
$hResult = _do_query(__LINE__, $Query); # _do_query() simply
executes mysql_query, and does nice error formatting if necessary
1 - 100 of 129 matches
Mail list logo