Hello there...
I have a problem with sort order. I use greek and english characters.
The manual says to put the following lines to my.cnf:
[client]
character-sets-dir=/usr/local/mysql/share/mysql/charsets
default-character-set=greek
i restart the demon but the problem still exist.
I have 3.23.49
On Tuesday 05 November 2002 05:47, Graeme McLaren wrote:
Hi, Anyone know how I can use two mysql_fetch_array() functions similar
to the code below? I've tried a few different ways but I keep getting
Resource ID #4. I need to do this to retrieve an email address from one
table and retrieve
I concur with Jason, but if restructuring is out of the question, just
rearrange your queries like this:
$query = SELECT Name, Address FROM users;
$result = mysql_query($query);
while($details = mysql_fetch_array($result)){
echo Name: $details[Name];
echo Address: $details[Address];
}
I'm working on a new site, and I'm wondering whether to use an
abstraction layer or not. I don't have any plans to switch DB system,
but you never know what the future holds. I figure that there's no
reason not to, but are there any down sides? Which abstraction layers
are good?
You have to put the same under [server]
Nikos wrote:
Hello there...
I have a problem with sort order. I use greek and english characters.
The manual says to put the following lines to my.cnf:
[client]
character-sets-dir=/usr/local/mysql/share/mysql/charsets
default-character-set=greek
i restart
I have two tables, one contains event information and the other dates
that the event takes place:
| id| int(11) | | PRI | 0 | auto_increment |
| title | varchar(100) | YES | | NULL||
| location | varchar(100) | YES | | NULL
Hi,
Can anyone help I'm going mad with this...
I'm using postgresql with php and writing a small login and sign-up system.
Whena user wishes to sign-up Iwant to check there are not any other users
with the same username, so I'm doing a select against the db with the
requested username before
if i get your point:
1 event can have more dates.. and you wanna show for each event just the
first date...
so you wanna show more from one table as the other one
in that case you should try to use the left join !! so check the manual on
left join
-Original Message-
From: Terry
Ok, going out on a limb here... have you tried something like
select e.id, title, location, address, contact, category, event_time,
urllink, descript, min(event_date) from eventTable e inner join
dateTable d on e.id = d.id group by e.id
?
Marco
--
php|architect - The magazine
why does everybody always gives the answers?? why not a hint, or where to
search that they can learn something about it???
-Original Message-
From: Marco Tabini [mailto:marcot;inicode.com]
Sent: woensdag 6 november 2002 16:08
To: Terry Romine
Cc: [EMAIL PROTECTED]
Subject: Re:
My guess? Because we're all professionals at work and trying to solve a
specific problem...since we're adults, I guess the learning part should
be up to each of us--the information is certainly there even in the
answer. :-)
Marco
--
php|architect - The magazine for PHP
Good point.
Tell me and I forget, show me and I remember, involve me and I understand
Ignatius
- Original Message -
From: Snijders, Mark [EMAIL PROTECTED]
To: 'Marco Tabini' [EMAIL PROTECTED]; Terry Romine
[EMAIL PROTECTED]
Cc: [EMAIL
Agreed. we prove day in and out that the answers are only an email
away...why would anyone go a different route. manual? whats a manual?
There are some brilliant people on this list, but some equally intelligent
people wrote some fine documentation.
Well, excuse me for being a bit cynical, but it's hard to be
philosophical with a deadline hanging over your head. It's true that
most of the questions can be answered by looking at the manual, but you
also have to assume the possibility that the person who's asking them
has a real and immediate
Just to weigh in on the tail end here, a FAQ of the top N items would be
nice. But I have to say, I use the archives a lot before I post to the list.
The archives contain the answers to most questions out there. If subscribers
to this list checked the archives to see if their answer is there, then
Thanks.
My error seemed to be just in the group declaration. Comparing yours
and mine with slight modifications to yours that eventually worked as
desired:
yours:
select e.id, title, min(event_date) as event_date from eventTable e,
dateTable d where e.id = d.event_key group by e.id;
mine:
I agree, but in regard to your last paragraph, you're assuming that they
read your post and respond to it. Everybody's quick to answer simple
redundant questions that every programmer *should* know the answer to,
but higher level stuff seems to just get ignored. I'd hope in a
high-frequency list
Hey, there are a lot of new people who are starting with PHP. We all are
here to help people learn how to use PHP because we are all PHP fans and
want the world to use PHP. register_globals is an issue that us more
advanced folk know about and deal with on a regular basis. There are lazy
people
Besides, if they don't search the archives and newsgroups and Google
already, why would we believe they'd read the FAQ?
Peter
On Wed, 6 Nov 2002, Hutchins, Richard wrote:
Just to weigh in on the tail end here, a FAQ of the top N items would be
nice. But I have to say, I use the archives a lot
I have a manual and use it plus lots of sample code to work through,
but there are times when we hit a wall and a simple second set of
eyes to spot what should be obvious is helpful.
I appreciate having a forum to throw out a question and get a rapid
response. I could have rewritten this
What archive and how do I access it?
-Original Message-
From: Hutchins, Richard [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, November 06, 2002 10:50 AM
Subject: RE: [PHP-DB] sort by date
Just to weigh in on the tail end here, a FAQ of the top N items would
Go here: http://www.php.net/mailing-lists.php and scroll down to find the
archive for your type of question. Just click and search away - no
subscription necessary. Lots of good help in there if you're diligent.
-Original Message-
From: dwalker [mailto:dwalker;healthyproductsplus.com]
This is how you'd find it in the future. It's fairly simple.
http://php.net/ -- Mailing Lists -- Databases and PHP archive link YES
OR -- Databases and PHP Newsgroup link Yes
Archives: http://marc.theaimsgroup.com/?l=php-db
Newsgroup: news://news.php.net/php.db
Great! But, many people cannot *understand* the manuals for their own
reasons, that is why they ask - they hope to get some sample code. Shall
we?
--
Maxim Maletsky
[EMAIL PROTECTED]
Peter Beckman [EMAIL PROTECTED] wrote... :
Hey, there are a lot of new people who are starting with PHP.
Hi there everyone,
Why are so many attachments coming in to the list? Hopefully it's not
because somebody has a virus and is infecting people who open them.
So don't open attachments unless you are expecting something.
Are there any plans to make PHP for windows a full blown programming
Peter Beckman [EMAIL PROTECTED] wrote... :
Besides, if they don't search the archives and newsgroups and Google
already, why would we believe they'd read the FAQ?
There are already lots of FAQs, but even you who argue about that do not
know much aboiut. So, an FAQ whether gets incorporated
Well, you can already do that--just download and install the CGI
version.
Unless, of course, you meant that you want to write Windows GUI
applications, in which case I think someone is working on something like
that with PHP-GTK.
Oh, the attachments are either quoted messages or patches, for the
This isn't the place for discussions of php development, I think php-dev
is what you want... but ah, PHP is a full-blown programming language,
even under widnows.
http://www.php.net/manual/sv/features.commandline.php -- check this
page out
You can write shell scripts with it, associate windows
Josh, Thank you for reply. Thank you to everyone else who replied to my
email also. I solved the problem shortly after posting my question, I've
now got a massive SQL query which does the trick.
I was interested when you replied and part of it read: Just
remember that you can only work with
Hi there everyone,
Thanks for the response to my question - both the attachments and PHP as a
full blown dev language. I know the latter isn't really for this group, but
this is the best PHP group I have found and the only one I write in
regularly.
Thanks again
Chris
--
PHP Database Mailing
In my experience, (I haven't checked the docs just yet to figure out
exactly why), you can only work with one result id at a time. Every time
you call mysql_query, it resets the result id (I think it frees the
result id automatically so you can send another query before getting the
new result id),
That's not true. You can assign them to different variables and it works
fine.
$r1 = mysql_query(select * from main limit 1) or die(mysql_error());
$r2 = mysql_query(select * from apft limit 1) or die(mysql_error());
$row1 = mysql_fetch_array($r1);
$row2 = mysql_fetch_array($r2);
Hi everyone, I just uploaded my forum and would like to have it field tested
by everyone. It'll prob still have some bugs in there.
http://seabird.jmtech.ca
go to website and then click on forum. please ignore the login in the left
top for now,
Jacco
--
http://seabird.jmtech.ca
Attitude is
:) see why I love mailing lists! :)
It must have been their logic then, I respectfully retract everything I
said, sorry Graeme! Why do I have to work, I could spend my days
researching this stuff before I post!
Thanks John!
-- Josh
-Original Message-
From: 1LT John W. Holmes
John is right. In fact one routinely calls two different $result(s) when
coding nested loops:
while( $details = mysql_fetch_array( $result ) ) {
while ( $Email = mysql_fetch_array( $result2 ) )
..
}
}
when executing the next instance of your loop:
while( $details = mysql_fetch_array(
Of course, you can avoid that problem if you use a join, I guess it all
comes down to code complexity vs SQL complexity.
-- Josh
-Original Message-
From: Ignatius Reilly [mailto:ignatius.reilly;free.fr]
Sent: Wednesday, November 06, 2002 1:38 PM
To: Josh Johnson; '1LT John W. Holmes';
Hey all,
Can't seem to figure out why this won't work:
$test = implode(,, $order_index[$i]);
When I print_r() the variable I have values so I know that works.
Any thoughts on this?
Thanks.
Aaron
You sure you want [$i] on that? Is it a 2-dimensional array?
On Wed, 6 Nov 2002, Aaron Wolski wrote:
Hey all,
Can't seem to figure out why this won't work:
$test = implode(,, $order_index[$i]);
When I print_r() the variable I have values so I know that works.
Any thoughts on this?
isn't $order_index[$i] only one index? or is it multi dimensional?
Aaron Wolski
Does $i have a value?
-- Josh
-Original Message-
From: Rasmus Lerdorf [mailto:rasmus;php.net]
Sent: Wednesday, November 06, 2002 2:16 PM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Imploding an array?
You sure you want [$i] on that? Is it a 2-dimensional array?
On
Ok...
This is the code I have setup:
for ($i=0;$isizeof($order_index);$i++) {
if ($delete[$i] == 1) {
print_r($order_index[$i]);
$str = implode(,,$order_index[$i]);
echo
Well, your code will do this:
if delete[7] == 1, you will print_r($order_index[7]) which contains ???
Now from what you say $order_index[7] == 2627;
That's just weird. Whatever it is you are doing is bad.
Regardless, you could do this:
$foo = preg_split(//,$order_index[7]);
Now $foo is an
I'll look into it, thanx,
can you access the jump-menu?? Forum should be all the way in the bottom.
Jacco
--
http://seabird.jmtech.ca
Attitude is Everything!
But Remember, Attitudes are Contagious!
Is Yours worth Catching
Mignon Hunter [EMAIL PROTECTED] wrote in message
Hi all
I was wondering if it is possible to protect my password to the MySQL-server
from being in a PHP-script. Now I can't do that, so everybody who gets to
see my php-sourcecode also can see my (not protected/not encrypted)
password.
How can I change this?
Thanks,
William
---
William
I was wondering if it is possible to protect my password to the
MySQL-server
from being in a PHP-script. Now I can't do that, so everybody who gets to
see my php-sourcecode also can see my (not protected/not encrypted)
password.
How can I change this?
You can't, unless you want to put it in
actually you can make a .php file with your connection info, include it in
your .php files at the top and encrypt that one file (they don't need to see
it anyway). use a php encoder for the file with your login info in it.
-Original Message-
From: 1LT John W. Holmes
You could put it anywhere. Stick it in a text file somewhere, fopen()
and read the file for the password. Or keep it in a php script outside
of the web root if that's the issue, then just include() it when you
need to.
Of course any file you put it in will have to be readable by whatever
user
Are you sure you can include an encoded file into a non-encoded one?
I had forgotten about this option, but if you can find a worthwhile
compiler/encoder/etc, then that's a solution.
---John Holmes...
- Original Message -
From: SELPH,JASON (HP-Richardson,ex1) [EMAIL PROTECTED]
To: '1LT
Make sure that the encoder you use actually makes string unreadable.
Otherwise, you can use a simple trick, like for example XORing the whole
string with FF or something similar.
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide magazine dedicated to
Is it more efficient to store record IDs in a MySQL database as an Integer
or a String? I like string IDs better because you can create meaningful
names, but, not sure if this means the DB has to work harder or not.
Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Numeric IDs are probably a bit faster--although if properly indexed not
by much--plus you can use self-numbering columns with them.
Marco
--
php|architect - The magazine for PHP Professionals
The first monthly worldwide magazine dedicated to PHP programmer
Come visit us at
And make sure you make sure the webserver will not SERVE that file!!! You
see the source, see that you are fopening the file, I'll find it on your
system and get it from the web server and I have your password!
Make sure the file is NOT in the document root that the web server serves
from. You
Always use ints. Also, make sure you actually need an INT before using it:
Max Value
Unsigned Integer: 4.3 billion or so
Unsigned MediumInt: 16.7 million
unsigned SmallInt: 65,535
unsigned TinyInt: 255
If you'll only ever have 300,000 rows in a table, use a mediumint.
The standard apache install filters anything named .ht*. on the web
tree.
-- Josh
-Original Message-
From: Peter Beckman [mailto:beckman;purplecow.com]
Sent: Wednesday, November 06, 2002 6:44 PM
To: Steve Cayford
Cc: [EMAIL PROTECTED]; William Trappeniers
Subject: Re: [PHP-DB] MySQL
Also, you can limit access to a specific table in a specific database
for a specific user, if it makes sense in your application.
-- Josh
-Original Message-
From: Peter Beckman [mailto:beckman;purplecow.com]
Sent: Wednesday, November 06, 2002 6:41 PM
To: William Trappeniers
Cc: [EMAIL
Seabird wrote:
I'll look into it, thanx,
can you access the jump-menu?? Forum should be all the way in the bottom.
The jump menu doesn't work.
I think you nad a 'name' field for each option... of your select... box.
Jacco
--
http://seabird.jmtech.ca
Attitude is Everything!
But Remember,
One thing I do with Postgres that I'm not sure MySQL supports is
Kerberos5 authentication. This way, a user logs in (and they have a user
account on the DB) and I use their remote user name and their Kerberos
ticket to authenticate them to the DB. That works without having to
store a password
Hi,
I'm trying to call a script with the ?= after the php script name in the
URL, but can't seem to pick up the variable to use in my script...
any help would be greatly appreciated :)
I'm calling the script with this url:
http://localhost/Data/test/dbconnect2c.php?id=TestPage
The section of
did you try echoing the value of $id after you have assigned it?
you may find it's because you aren't connected to your database or something
and also, i am assuming that you are using a recent install/verison of PHP,
because $_GET wasn't available until the last few releases.
beau
//
I'm trying to call a script with the ?= after the php script name in
the
URL, but can't seem to pick up the variable to use in my script...
any help would be greatly appreciated :)
I'm calling the script with this url:
http://localhost/Data/test/dbconnect2c.php?id=TestPage
The section of
i wrote a really basic script sucessfully to echo the url variable to the
screen... will go from there. thanks beau.
EXCELLENT :)
The single quotes around the $id variable in the select statement worked
wonderfully. thanks John.
Gav
-Original Message-
From: John W. Holmes
Well, first of all, you have to connect to the database.
?php
$db_server = localhost; // Usual server. :P
$db_login = USERNAME;
$db_pass = USERPASS;
mysql_connect($db_server,$db_login,$db_pass);
?
And, its not always nesecary to have to type in $_GET['id'] to
Hi
There is an article on sitepoint.com about benchmarking J2EE and .NET and
some controversy over the result
http://www.sitepoint.com/newsletters/viewissue.php?fid=3id=3issue=52
Does anybody have experience of php/MySql in comparison with either of the
above in terms of efficiency or ultimate
Hi,
For some reason the page worked the 1st few times, now I get the error
message (after making no changes to the code from when it worked...):
(line 5 references the $db = mysql_co... line of code)
Warning: Unknown MySQL Server Host 'mysql.db.*.net.au' (2) in
Make sure DNS is working and mysql.db.*.net.au resolves. Better yet,
use the IP address unless absolutely necessary to use the hostname.
Peter
On Thu, 7 Nov 2002, Gavin Amm wrote:
Hi,
For some reason the page worked the 1st few times, now I get the error
message (after making no
Do you need to archive it forever? Do you need live access to it?
If you just need to archive it, read the man page for mysqldump. You can
dump specific rows to a file, rename that file dump.2002.05.24, compress it
with gzip, and voila, you have all of your data readily available, easily
Well, I know from experience this:
PHP 3 and 4.various, sessions enabled on every page (using DB to store)
MySQL 3.23.various
Apache 1.2.various
300,000 users in the DB
2600 dynamic pages
No images or static multimedia content (on this server)
PC, Dual 800Mhz
1GB Ram
4 18GB drives,
Hi,
Sorry if this is ametuer, but I have been staring at this code for so long, trying to
find out why my selection fields are gathering values, and I cant find the problem.
Thanks,
Tyler
--
?
include './include/vars.php';
include './include/dbconnect.php';
?
html
head
title?= $title
Tyler,
You probably need one or two of the following:
1. Put single-quotes around case in your SQL (where type like 'case')
2. Use wild-cards in your where statement (where type like '%case%')
Good luck!
--Dave
On Wed, 2002-11-06 at 23:31, Tyler Whitesides wrote:
Hi,
Sorry if this is
Thank you putting '%case%' instead of case worked!
- Original Message -
From: David Smith [EMAIL PROTECTED]
To: Tyler Whitesides [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 10:47 PM
Subject: Re: [PHP-DB] Select Fields
Tyler,
You probably need one or two
There is a difference between a general, how do I do this question and a
specific here's my code, I can't find the bug question. Sometimes people
just need a quick answer specific to their code.
Also, unfortunately, many times when people want to point to a resource
they give the standard
Hi everybody
What should I do for useing OCI functions of oracle 9i in PHP4. I think I
should recompile PHP with somthing but I don't know with what and how should
I do this. I installed oracle 9i on SUSE linux 8.0.
Best Regards
Maizar
--
PHP Database Mailing List (http://www.php.net/)
To
72 matches
Mail list logo
