On Thu, April 7, 2005 5:32 pm, Andras Kende said:
I would like to do the following:
mysql db:
andrew
anthony
joe
janice
john
simon
sql_query ( select names .
I would need only the distinct first character from the query
result would
Hi Neo
Just some observations and hints.
I see you use the contents of a user variable ($_POST,$_GET,$_REQUEST,
$_SESSION) without check. Possibly you checked them on another page but you
shouldn't rely on that. You should take NOTHING for granted. You should
escape the input by using a
On Monday 04 April 2005 18:45, Andy Pieters wrote:
After the ? must be NO character, not even a CR or LF
Best way to check this is to put your cursor right next to the and press
the left key. If you r cursor moves then press left followed by del. Keep
pressing the del key until all the
Mikey wrote:
I have not changed any of my hostname/username/password code
in the last 6 months and I can still connect to
mysql.timerescue.co.uk via the command line interface.
Has anyone seen this before - any ideas at all - just
started happening
today! :o(
Strange indeed.
I tried to
it cant find your host
mysql.timerescue.co.uk
try use an ip address... or try connect via the command line.
Glen Beamson wrote:
Hi,
I have suddenly started getting an 'unknown host' error when trying to connect via php (see below).
Unknown MySQL Server Host 'mysql.timerescue.co.uk' (0)2005
I
I have not changed any of my hostname/username/password code
in the last 6 months and I can still connect to
mysql.timerescue.co.uk via the command line interface.
Has anyone seen this before - any ideas at all - just
started happening
today! :o(
Strange indeed.
I tried to connect
Hope I was helpful
Yaron Khazai
Thanks - will try that out soon.
--
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
Tyler Replogle schrieb:
Can you update two tables in one mysql query
i've got these two queries
$db-query(update `dbn_members_counters` set views =(views +1) where
id = '$this-id' );
$db-query(update `dbn_members` set lastaction = $conf-site_time,
page = '$this-page' where id = '$this-id' );
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
Jed R. Brubaker wrote:
I could use a lead on a problem. I just don't know where to start.
I have a PHP script that populates a database table. No big deal. It
creates
mailing labels. However, a weird things keeps happening - every once in a
while, a query is run twice. It is the same query,
Jed R. Brubaker wrote:
Hi all -
I could use a lead on a problem. I just don't know where to start.
I have a PHP script that populates a database table. No big deal. It creates
mailing labels. However, a weird things keeps happening - every once in a
while, a query is run twice. It is the same
Thanks for all the help, I managed to get it working, though I'm not
quite sure the reasoning behind it. I used some info I got off of
http://bugs.php.net/bug.php?id=29860 to do it.
I posted my particular resolution to the bug report. It seems to me that
*something* isn't right
Chris
--
PHP
Chris wrote:
Hi, I've been trying to get these 2 compiled together for a while, and
have had no luck.
WHere my problem lies, I think, is that I'm not sure what directory
should be specified on the --with-mysql part
./configure --with-apxs2=/usr/local/apache/bin/apxs
Chris wrote:
Hi, I've been trying to get these 2 compiled together for a while, and
have had no luck.
WHere my problem lies, I think, is that I'm not sure what directory
should be specified on the --with-mysql part
Here's the deal:
configure needs to find *BOTH* 'mysql.h' files and
Chris wrote:
./configure --with-apxs2=/usr/local/apache/bin/apxs --with-mysql=/usr
--with-mysql-include-dir=/usr/include/mysql
--with-mysql-lib-dir=/usr/lib/mysql --with-mysqli=/usr/bin/mysql_config
it might work. I've managed to stave of the need for the mysql
extension for a week or two, but
Richard Lynch wrote:
Here's the deal:
configure needs to find *BOTH* 'mysql.h' files and
'mysql.so'/'mysql.lib' files *UNDER* the directory you feed it.
Figure out where your mysql.h files are.
Figure out where your mysql.lib/mysql.so files are.
.
Thanks for the response, in fact I can't find
Chris wrote:
Hi, I've been trying to get these 2 compiled together for a while, and
have had no luck.
WHere my problem lies, I think, is that I'm not sure what directory
should be specified on the --with-mysql part
./configure --with-apxs2=/usr/local/apache/bin/apxs
Hi, I've been trying to get these 2 compiled together for a while, and
have had no luck.
WHere my problem lies, I think, is that I'm not sure what directory
should be specified on the --with-mysql part
./configure --with-apxs2=/usr/local/apache/bin/apxs
--with-mysql=/usr/include/mysql/
Sebastian wrote:
Hello,
im working on an article system and looking to avoid running three queries.
example, i have this query:
SELECT id,title FROM articles WHERE id=$_GET[id]
now say $_GET[id] = 5
I would like to get the previous id 4 and the next id 6 (if there is one)
so i can do something
Now I am assuming that 4 and 6 would not always be the next article ID -
otherwise you could just increment your id accordingly.
If you wanted to do that without running multiple queries, this is who I
might do it, rather sloppy, but I think it would work.
$idGet= $_GET['id'];
$sql = select id,
On Thu, 2005-02-17 at 18:24, Sebastian wrote:
Hello,
im working on an article system and looking to avoid running three queries.
example, i have this query:
SELECT id,title FROM articles WHERE id=$_GET[id]
now say $_GET[id] = 5
I would like to get the previous id 4 and the next id 6
On 17 Feb 2005 19:28:18 -0600, Bret Hughes [EMAIL PROTECTED] wrote:
On Thu, 2005-02-17 at 18:24, Sebastian wrote:
Hello,
im working on an article system and looking to avoid running three queries.
example, i have this query:
SELECT id,title FROM articles WHERE id=$_GET[id]
now say
On Thu, 2005-02-17 at 22:02, Jason Petersen wrote:
On 17 Feb 2005 19:28:18 -0600, Bret Hughes [EMAIL PROTECTED] wrote:
On Thu, 2005-02-17 at 18:24, Sebastian wrote:
Hello,
im working on an article system and looking to avoid running three
queries.
example, i have this query:
dan wrote:
Chris wrote:
Hi, I've been trying to get these 2 compiled together for a while,
and have had no luck.
WHere my problem lies, I think, is that I'm not sure what directory
should be specified on the --with-mysql part
./configure --with-apxs2=/usr/local/apache/bin/apxs
Hans Zaunere wrote:
Hi, I've been trying to get these 2 compiled together for a while, and
have had no luck.
WHere my problem lies, I think, is that I'm not sure what directory
should be specified on the --with-mysql part
./configure --with-apxs2=/usr/local/apache/bin/apxs
C.F. Scheidecker Antunes wrote:
Hello all,
Does anyone upgraded from MySQL 4.0 to MySQL 4.1 using PHP 4 code?
If so, what are the changes that were required on the code?
PHP website says that it is required to install a new MySQL extension.
http://www.php.net/mysqli
^---
Darren Kirby wrote:
Hello all,
On the main page of my website I have written a very simple comments feature
that allows people to leave a message under my posts, much like a blog. I
have purposely kept this very simple...
On the main page I have simple text links that someone can click on if they
C.F. Scheidecker Antunes wrote:
Hello all,
Does anyone upgraded from MySQL 4.0 to MySQL 4.1 using PHP 4 code?
If so, what are the changes that were required on the code?
PHP website says that it is required to install a new MySQL extension.
I am doing PHP4 programming under Linux.
What do you
quoth the Jason Barnett:
Darren Kirby wrote:
The problem is that after playing around with this a bit, it is clear
that someone can craft a url with an arbitrary $postid that is not in the
database yet. Now naively, it would seem that the worst someone could do
is just create arbitrary
Tom wrote:
...
It correctly updates 4 rows, but returns 1 as the count.
I think that this may actually be a mysql issue - I've put the same
php/apache configs onto another similar box, the only difference being
that the second box is mysql 5.0.1, whereas the problem is reported
against 5.0.0
Richard Lynch wrote:
Tom wrote:
I've just started playing with the php5 improved mysqli extensions.
I have the following code:-
?php
$mysqlim = new mysqli(localhost, myUser, myPassword,myDB);
$updateQuery = UPDATE client SET status = 'INACTIVE' WHERE clientName =
'Tom';
if
Tom wrote:
Richard Lynch wrote:
Tom wrote:
I've just started playing with the php5 improved mysqli extensions.
I have the following code:-
?php
$mysqlim = new mysqli(localhost, myUser, myPassword,myDB);
$updateQuery = UPDATE client SET status = 'INACTIVE' WHERE clientName =
'Tom';
if
Tom wrote:
I've just started playing with the php5 improved mysqli extensions.
I have the following code:-
?php
$mysqlim = new mysqli(localhost, myUser, myPassword,myDB);
$updateQuery = UPDATE client SET status = 'INACTIVE' WHERE clientName =
'Tom';
if ($mysqli-query($updateQuery))
{
It depends on what you are trying to do. If you need full text
searching, MyISAM is what you should be using. If you are doing
transactions, InnoDB is what you probably want to use. If you write a
lot to the database, InnoDB may be better, if you read a lot MyISAM may
be better. But that
Jason Morehouse wrote:
Hello all,
Has anyone had an experience with storing sessions in mysql (or
sqlite)? If so, what if any are the performance benefits? Obviously,
there would have to be an extra db query per page... but would that be
faster then opening a text file?
Speed depends on
On Fri, 2004-12-17 at 11:34, Richard Lynch wrote:
Granted, this assumes you've got a good clean working SQL-based session
setup in the first place, which is several days, perhaps even weeks of
work for the beginner, before they really understand all the bits and
pieces and ins and outs of the
Jason Morehouse wrote:
Has anyone had an experience with storing sessions in mysql (or sqlite)?
Yes, in MySQL.
If so, what if any are the performance benefits?
This depends on *SO* many factors...
Is your MySQL database pretty small?
Is your site heavy traffic?
Are most of your sessions
Robert Cummings wrote:
On Fri, 2004-12-17 at 11:34, Richard Lynch wrote:
Granted, this assumes you've got a good clean working SQL-based session
setup in the first place, which is several days, perhaps even weeks of
work for the beginner, before they really understand all the bits and
On Fri, 17 Dec 2004 09:57:56 -0800 (PST), Richard Lynch [EMAIL PROTECTED]
wrote:
Yeah, a beginner trying to write an OOP MySQL session based system would
take MONTHS, and still get it all wrong with nasty snarled code.
Months? Come on.. it's just six functions and a call to
Found the problem.
I set ( default_charset = iso-8859-1 ) in php.ini and it solve the
problem.
Just in case anyone want to know.
Jonathan [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I have encounter something rather weird. In my development server,
when I insert a
Reinhart Viane wrote:
And a last question:
I always seem to get stuck on mysql queries when scripting. mysql.com
gives me a headache whens earching something. Does someone know a good
mysql manual site or a good mysql book?
That does not mean mysql questions should be posted on php mailing
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MYSQL Query question
Reinhart Viane wrote:
And a last question:
I always seem to get stuck on mysql queries when scripting. mysql.com
gives me a headache whens earching something. Does someone know a good
mysql manual site or a good mysql book?
That does
Raditha Dissanayake wrote:
Reinhart Viane wrote:
And a last question:
I always seem to get stuck on mysql queries when scripting. mysql.com
gives me a headache whens earching something. Does someone know a good
mysql manual site or a good mysql book?
That does not mean mysql questions should be
John Nichel wrote:
Raditha Dissanayake wrote:
Reinhart Viane wrote:
And a last question:
I always seem to get stuck on mysql queries when scripting. mysql.com
gives me a headache whens earching something. Does someone know a good
mysql manual site or a good mysql book?
That does not mean mysql
query=SELECT * FROM listing WHERE `state` = 'WA' AND `type` = 'RES'
AND `county` = 'clark' AND (`price` '15' OR `price` = '20');;
if that doesn't work - break it down into individual parts and find out
where the problem is.
Respectfully,
Ligaya Turmelle
---
Life is a game... so have
Richard Kurth wrote:
Could somebody tell me way these query gets a error 1064 and does not
work.
no. wrong list.
--
Raditha Dissanayake.
--
http://www.radinks.com/print/card-designer/ | Card Designer Applet
Try:
SELECT * FROM listing WHERE listing.state = 'WA' AND listing.type = 'RES'
AND listing.county = 'clark' AND (listing.price 15 OR listing.price
=20)
Try to not use the word type. Do not know what it is but I have some
problems using it. In the event you have weird problems, try
Travis Conway wrote:
Try:
SELECT * FROM listing WHERE listing.state = 'WA' AND listing.type =
'RES' AND listing.county = 'clark' AND (listing.price 15 OR
listing.price =20)
Once again you have posted to the wrong list. Please send this message
to the mysql list. This is the php list.
.user2_sessionid = $thisuser));
Can I do something like this?
-Original Message-
From: Ligaya Turmelle [mailto:[EMAIL PROTECTED]
Sent: zondag 28 november 2004 2:25
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] mysql query with exclude
Sounds like you need a join. Maybe
.user1_sessionid =
$thisuser)) or (c2.user1_sessionid if(c1.user2_sessionid =
$thisuser));
Can I do something like this?
-Original Message-
From: Ligaya Turmelle [mailto:[EMAIL PROTECTED]
Sent: zondag 28 november 2004 2:25
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] mysql query
Sounds like you need a join. Maybe something like:
select * from chat c1,
chat_online c2
where
UNIX_TIMESTAMP(c2.activity)=$limit_time and
c2.session_id = $thisuser and
((c1.user1_sessionid = $thisuser) or
c1.user2_sessionid = $thisuser));
Nathan Mealey wrote:
The following line of code:
mysql_connect('database','user','password'); [with values of course]
Generates the following error:
Fatal error: Call to undefined function: mysql_connect() in
/var/www/html/phptest.php on line 3
My PHP info page says that PHP (4.3) was compiled
You should enable php_mysql module in your php.ini file.
-- Manoj Kr. Sheoran
-Original Message-
From: Nathan Mealey [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 21, 2004 10:56 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Mysql Connect Help
A seemingly simple problem, still
-- Original message --
From: Sam Smith [EMAIL PROTECTED]
I've got it working writing out a file (fopen) to CSV (comma delimited) and
the header('Content-Disposition: attachment; filename=myFile.csv')
method but it's clumsy for the user to figure out how to use
If I do something like:
$string = null;
mysql_query(insert ignore into table(field) values($string));
It gives me an error.
Pass a string value of 'NULL'.
Ie INSERT INTO table (field) VALUES (NULL);
Or, in your example:
$string = 'NULL';
mysql_query(INSERT INTO table (field) VALUES
Octavian Rasnita wrote:
Please tell me how to send a null string to be inserted in a MySQL database.
If I do something like:
$string = null;
mysql_query(insert ignore into table(field) values($string));
This will result in the following SQL query:
insert ignore into table(field) values()
If you
Aalee wrote:
Hi guys,
I have a small home network working with just 4 computers (PC's on WinXP
Pro) connected through a switch just using the local ip's 192.168.0.1 and so
on. And the netwok is working fine. I have installed MySQL on one computer
and setup a database and installed MySQL on the
Hi its a php mailing list ? Okey .
-- Manoj Kr. Sheoran
Aalee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
Hi guys,
I have a small home network working with just 4 computers (PC's on WinXP
Pro) connected through a switch just using the local ip's 192.168.0.1 and so
on. And
On Mon, 2004-11-08 at 07:41, John Nichel wrote:
Aalee wrote:
Hi guys,
I have a small home network working with just 4 computers (PC's on WinXP
Pro) connected through a switch just using the local ip's 192.168.0.1 and so
on. And the netwok is working fine. I have installed MySQL on one
* Thus wrote Kevin Grigorenko:
Zareef Ahmed [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
-Original Message-
From: Kevin Grigorenko [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 12:36 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL Scalability, part 2
-Original Message-
From: Kevin Grigorenko [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 12:36 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL Scalability, part 2
Hi,
First, sorry for posting an attachment. Second, I fixed my problem to
use
files, but I just had a general
Zareef Ahmed [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
-Original Message-
From: Kevin Grigorenko [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 12:36 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL Scalability, part 2
Hi,
First, sorry for posting an
Kevin Grigorenko [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Zareef Ahmed [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
-Original Message-
From: Kevin Grigorenko [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 12:36 AM
To: [EMAIL PROTECTED]
-Original Message-
From: Kevin Grigorenko [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 8:13 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL Scalability, part 2
Zareef Ahmed [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
-Original Message-
From: Kevin
-Original Message-
From: Zareef Ahmed [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 8:41 AM
To: 'Kevin Grigorenko'; [EMAIL PROTECTED]
Subject: RE: [PHP] MySQL Scalability, part 2
-Original Message-
From: Kevin Grigorenko [mailto:[EMAIL PROTECTED]
Sent: Monday, October
Kevin Grigorenko wrote:
Unfortunately, for some security
issues, I cannot get to the Apache statistics for the site, so I have to
create my own solution.
I recommend you find a better host that gives you access to the raw logs
and/or doesn't have safe_mode on.
--
---John Holmes...
Amazon
John Holmes [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Kevin Grigorenko wrote:
Unfortunately, for some security
issues, I cannot get to the Apache statistics for the site, so I have to
create my own solution.
I recommend you find a better host that gives you access to the
* Thus wrote Kevin Grigorenko:
begin 666 hitcounter.doc
Please dont post attatchments, put the file up on weberver instead
and just reference it here.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
* Thus wrote Nick Lane-Smith:
Hello php-list,
I'm curious to why default mysql support was dropped from PHP 5?
It was due to the changes in the mysql license. Due to the changes
the PHP Team decided not to enable mysql by default. MySQL had
modified there license but it was too late, the
Nick Lane-Smith wrote:
Hello php-list,
I'm curious to why default mysql support was dropped from PHP 5?
The separation seems to have been done for license issues with the
mysql library.
PHP 4.X uses a libmysql with an abandoned copyright for mysql access.
Suffice to say it's pretty hard to find
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
John Holmes wrote:
From: Neo Theone [EMAIL PROTECTED]
I am searching for a MySQl to Object abstraction class.
I am thinking something like WebObjects does in Java (it is just a
part) in PHP. I had one for Ruby but now I have to use a DB in MySQL
and such a class would make it alot easier.
Are
From: Neo Theone [EMAIL PROTECTED]
I am searching for a MySQl to Object abstraction class.
I am thinking something like WebObjects does in Java (it is just a part)
in PHP. I had one for Ruby but now I have to use a DB in MySQL and such
a class would make it alot easier.
Are you talking about
[snip]
I am looking for a absolute transparent interface to access each field a
s a object.
So if i would have a table like this:
tablename: namedtable
--
| id | foo | bar |
--
| 01 | aaa | uuu |
--
| 02 | bbb | mmm |
--
I could
Select date1,count(date1) group by date1 where date1 '$today'
That'll get you the count of how many records were done on each day
(excluding today). I don't know what you're trying to average, but you
can probably figure it out from there.
-TG
-Original Message-
From: Jeff Oien
From: Jeff Oien [EMAIL PROTECTED]
I have a database with a date field in this format
20041016
I'd like to count how many records were made on each day (except today)
and average them. Can I do this in one query or will I need to do some
more PHP stuff after I get some results? Thanks.
Bare
[snip]
I have a database with a date field in this format
20041016
I'd like to count how many records were made on each day (except today)
and average them. Can I do this in one query or will I need to do some
more PHP stuff after I get some results? Thanks.
Bare bones so far:
$sql = select
On Thu, 16 Sep 2004 15:15:01 -0400, John Holmes
[EMAIL PROTECTED] wrote:
You can't get the average and a count in the same query
Sure you can.
desc numbers;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
[snip]
You can't get the average and a count in the same query
Sure you can.
mysql select count(number), avg(number) from numbers;
+---+-+
| count(number) | avg(number) |
+---+-+
|18 | 2.3889 |
+---+-+
1
From: Greg Donald [EMAIL PROTECTED]
You can't get the average and a count in the same query
Sure you can.
mysql select count(number), avg(number) from numbers;
Depends how you interpret his request, I guess. I took it as a request for
the count of records per day and then the average of those
On Thu, 16 Sep 2004 16:08:45 -0400, John Holmes
[EMAIL PROTECTED] wrote:
Depends how you interpret his request, I guess. I took it as a request for
the count of records per day and then the average of those counts.
So, if you had
D1
D1
D1
D1
D2
D2
D3
The count would be
D1 - 4
John Holmes wrote:
From: Greg Donald [EMAIL PROTECTED]
You can't get the average and a count in the same query
Sure you can.
mysql select count(number), avg(number) from numbers;
Depends how you interpret his request, I guess. I took it as a request
for the count of records per day and then the
From: Greg Donald [EMAIL PROTECTED]
mysql select the_date, count(number), avg(number) from dates group by
the_date;
++---+-+
| the_date | count(number) | avg(number) |
++---+-+
| 2004-01-01 | 3 | 2. |
|
[snip]
mysql desc dates;
+--+-+--+-+-+---+
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-+---+
| the_date | date| YES | | NULL| |
| number | int(11) | | | 0 | |
[snip]
I am searching for a MySQl to Object abstraction class.
I am thinking something like WebObjects does in Java (it is just a part)
in PHP. I had one for Ruby but now I have to use a DB in MySQL and such
a class would make it alot easier.
Does anybody know such a project or something
From: Neo Theone [EMAIL PROTECTED]
I am searching for a MySQl to Object abstraction class.
I am thinking something like WebObjects does in Java (it is just a part)
in PHP. I had one for Ruby but now I have to use a DB in MySQL and such a
class would make it alot easier.
Are you talking about
I do that a lot using Microsoft Access. I just finished on a project where I
had to eliminate duplicates from each of three or more queries, a couple of
which have three keys. However I am not much more experienced han you are;
Microsoft Access generates SQL for us so I am not sure what the SQL
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
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
The one technique that I have a bit of a question about is realted to the
handling of MySQL results. It seems that when you query the database with
their system, it takes all the results and outputs them into a string
similar to:
I have a question:I have an answer
which is then
On Thu, 5 Aug 2004 08:48:01 -0500, Jay Blanchard
[EMAIL PROTECTED] wrote:
[snip]
[snip]
A quickie for you:
How do I say
SELECT * FROM mytable where the sum of this field + this field + this
field x
I can't say I've done one of those before.
[/snip]
How many SQL queries can a PHP list handle in
On Thursday 05 August 2004 08:51, DIFF FanneHH offered up the following
tid-bit of information :
How many records can be in a MyIsam table?
Thanks
I'm sure they could tell you on the MySQL mailing list.
--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--
PHP General
On Thursday 05 August 2004 08:58, Jay Blanchard offered up the following
tid-bit of information :
[snip]
How many records can be in a MyIsam table?
[/snip]
Bazillions. Only limited by your storage capacity and ability to manage
large sets of records.
Now wait a minute, my table hit a wall
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]
601 - 700 of 1710 matches
Mail list logo