[PHP-DB] cannot create database

2001-07-18 Thread Andy
why it is now not work. Any suggestions greatfully received. Andy -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA+AwUBO1TyGA8TW1jK3d3CEQI9PgCYlLBjUoCKRRDLZQkFcfyvXNmlYwCdEuVA KOSk5zEaJipSxw9x3ZmutxU= =VW3P -END PGP SIGNATURE

[PHP-DB] cannot create database

2001-07-18 Thread Andy
why it is now not work. Any suggestions greatfully received. Andy -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA+AwUBO1TyGA8TW1jK3d3CEQI9PgCYlLBjUoCKRRDLZQkFcfyvXNmlYwCdEuVA KOSk5zEaJipSxw9x3ZmutxU= =VW3P -END PGP SIGNATURE

[PHP-DB] DBM databases - un-clear

2001-08-28 Thread andy
: Call to undefined function: dbmopen() in path/to/my/script.php on line 48 HELP! Andy.

[PHP-DB] DBM DATABASE PROBLEM!

2001-08-30 Thread andy
: Call to undefined function: dbmopen() in path/to/my/script.php on line 48 HELP! Andy.

[PHP-DB] Performance problems in NC

2001-10-29 Thread Andy
Hi there, I have problems with the performance while using NC. It workes fine with IE. As soon as I access the db. It takes aproximatelly 1 -2 min till I see the page. Does anybody know some help? Thank you Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

[PHP-DB] Combination of SQL statements invalid in MySQL?

2001-11-22 Thread Andy
Hi there, I am trying to do a combination of SQL statements like described in a SQL bóok. Is it possible, that mysql does not allow this syntax? Thanx Andy Error: Occured during executing DELETE FROM test_user_interests WHERE user_id = (SELECT user_id FROM test_user WHERE user_name

[PHP-DB] Data - countinents, countries, provinces, cities 10.000

2001-12-12 Thread Andy
. cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Is MySQL enough for a huge amount of data?

2001-12-14 Thread Andy
, how could I optimize the table? Thanx for you help guys Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] MyODBC returns only SQL errors while writing with MS ACCESS to MySQL

2001-12-22 Thread Andy
help Cheers, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] MyODBC problem with MySQL and ACCESS

2001-12-25 Thread Andy
it as Memo and this works. How about integer? This does not work at all? Is there anywhere a table flying around where I can see which datatypes I have to use? Thanx for any help, Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] How to speed up querries in a humangous db?

2001-12-25 Thread Andy
: char2 field3 : tinyint2 I have an index on field 2 and 3 The SQL Querry is searching for: field 2 AND field 3 Does anybody have an Idea how to spead this up? Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] How to speed up querries in a humangous db?

2001-12-26 Thread Andy
this is my sql statement: $stmt= SELECT * from $geo_T3 WHERE country_code = '$country' AND province = '$province' order by city ASC ; cheers Andy Miles Thompson [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...

[PHP-DB] Backup of huge DB fails because of max execusion time

2001-12-26 Thread Andy
\07_production\actual\mysqladmin\tbl_dump.php/b on line b27/bbr Does anybody know how to get this huge table transfered to my providers machine? Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

[PHP-DB] Potential for optimizing a huge table for querries?

2001-12-27 Thread Andy
: country_code province Type: MyISAM Querry on country_code AND province Does anybody know if this has potential to optimize? Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

[PHP-DB] Iinserting into 250 tables filtered data automaticly. delaytime??

2001-12-29 Thread Andy
and the for loop requests the next one. So it does not work. Is there a delay function to make php wait for 3 min before proceeding, or does anybody have a better idea? Cheers Andy PS: Here is the code: $sql = select country_code from countries ; $result2 = execute_stmt($sql, $link

[PHP-DB] BUG in MySQL 3.23.42-nt

2001-12-30 Thread Andy
. Did anybody make the same experiance? Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] How to write this querry?

2001-12-30 Thread Andy
something like that: delete from cities where NOT cities.province_id = provinces.province_id Does not work though :-( Can anybody help please? cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

[PHP-DB] db not visible if created from remote server

2001-12-31 Thread Andy
Hi there, I was uploading my db from my local machine to a server. mysqldump geodata | mysql -h 192.168.1.1 -u root geodata; Everything went ok. But the db is not visible for my application! I can see the db in mysqladmin, but my app does not? Anybody know what to do? Cheers Andy -- PHP

[PHP-DB] Making a Querry on two db possible?

2002-01-02 Thread Andy
Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] How to compress a jpeg (qualitysetting) before saving it to the server?

2002-01-04 Thread Andy
); Thanx for any help. Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] How to querry two db in a single statement?

2002-01-04 Thread Andy
Hi there, I would like to make a querry on 2 db. There is info in tables I would like to compare. As I know, there has first to be a conect on the db before the querry. But how to do this on 2 db?? Thanx for any help. Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Array not supported for strings???

2002-01-04 Thread Andy
the same experience? Thanx for any help buddys. Regards Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Is this kind of querry possible in MySQL?

2002-01-07 Thread Andy
country. I guess there has to be a subselect ore something like this. Maybe one of you guys have an idea. Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

[PHP-DB] Logicproblem in WHERE statement

2002-01-15 Thread Andy
But it should also show all users from canada. How would this look like? SELECT * FROM table WHERE sex=1 AND country='CA' This is wrong I know. But how does it work??? Thanx for any help cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

[PHP-DB] How to design a user table with 1 mio entries

2002-01-15 Thread Andy
and girls, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] How can recommend a book for SQL and DB design

2002-01-15 Thread Andy
Hi, I am searching for a good book on how to design a db for web apps. Normalisation rools, performancejust describing how to do it on a proffesional way. The second one, I am searching for is a book about SQL for MySQL. Any good books on the market? Thanx for the recommendation Andy

[PHP-DB] How to find out the number of rows in a table?

2002-01-24 Thread Andy
Hi there, I am trying to find out the number of rows in a table. The mysql docu says there is a mysql_num_rows statement but it requiers a sql statement in front. How could I do this more efficiently? Can anybody make an example, please? I am sure that there is an more easy way. Cheers Andy

[PHP-DB] Inserting NULL values does not work

2002-02-01 Thread Andy
', '$country', '$province', '$city', '$glacier', '$park', '$lake', '$mountain', '$beach', '$comment', '$keyword', '$date_taken', '$date_posted' ); Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

[PHP-DB] display a waiting loop while searching the db?

2002-02-03 Thread Andy
if there is no output in front. So I can't just echo the sentence. Does anybody know the trick? Thanx for your help. Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Creating a dynamic querry ??

2002-02-07 Thread Andy
(count($glacier)-1)) $search .= OR glacier =; } } Do you see my trouble?? Thanx for any help Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Converting upper case letters to lower case because of db??

2002-02-07 Thread Andy
function on the php site. Can anybody please help on changing this thing into lower case? Thanx ANdy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Cant create temporary tables on linux

2002-02-07 Thread Andy
no clue how to solve this. Can anybody give a hint? Thanx for any help Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Creating temp table with data out of 2 tables possible?

2002-02-08 Thread Andy
.$country_found[1]_cities ; Does anybody have a clue whats going on here? Thanx for any help Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Getting days after last login. Date problem

2002-02-13 Thread Andy
possible to convert the memberdate format to the other one and just search for something like picturedate logindate? Thanx for any help Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting days after last login. Date problem

2002-02-13 Thread Andy
Thanx! Andy * RZe: [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi there, I would like to find out the changes on content after a members last login. The format of the date stored in the member db is e.g.: Feb 13, 2002 The forma

[PHP-DB] Getting the ID of the last inserted record possible?

2002-02-23 Thread Andy
on that? Thanx Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Keeping autoincrement ID 2 digits. Possible?

2002-02-28 Thread Andy
can be deleted and created by the admin As soon as one is deleted, there is an empty number Eg 5 So we reach 99 and the next number should be not 100 but 5! I did set the type of the field to int(2), but it does not change anything Still 100 Has anybody a good idea? Thanx Andy PS: if somebody

[PHP-DB] Building secure authentification with sessions

2002-03-01 Thread Andy
can relate to a good site dealing with security issuses on this topic I would really like to avoid that some hacker gets admin access on my website :-) Thanx for any hints, Cheers Andy -- PHP Database Mailing List (http://wwwphpnet/) To unsubscribe, visit: http://wwwphpnet/unsubphp

[PHP-DB] Difficult count statement. Need some sql advice

2002-03-02 Thread Andy
wrong: SELECT COUNT(t*) AS c, farchive, fforum_id FROM fo_topics t, fo_forums f WHERE farchive != 1 Can this be that difficult? Thanx for any help Andy -- PHP Database Mailing List (http://wwwphpnet/) To unsubscribe, visit: http://wwwphpnet/unsubphp

[PHP-DB] addslashes needed for db security? Hack proving web apps

2002-03-05 Thread Andy
like 'delete Are there any good articles on the web about checking user input, securing webapps against hackers? Thanx andy -- PHP Database Mailing List (http://wwwphpnet/) To unsubscribe, visit: http://wwwphpnet/unsubphp

[PHP-DB] timestamp iin MySQL not compatible to the one in PHP???

2002-03-05 Thread Andy
but the mysql timestamp says: 20020305211704 So whats going on? Can anybody help please? Thanx andy -- PHP Database Mailing List (http://wwwphpnet/) To unsubscribe, visit: http://wwwphpnet/unsubphp

[PHP-DB] Re: [PHP] timestamp iin MySQL not compatible to the one in PHP???

2002-03-05 Thread Andy
So what is the proper function in PHP to convert the MySQL timestamp into a proper format like Sonday, Apr. 20th 2002? Thanx, Andy Jason Wong [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED]; On Wednesday 06 March 2002 04:31, Andy wrote: Hi there, I am playing around

[PHP-DB] Difficulty on how to extract data out of a text with string functions.

2002-03-06 Thread Andy
. I am open for any idea! Thanx a lot for any help Cheers, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] counting of values in one field possible with one sql statement?

2002-03-07 Thread Andy
following querry $stmt= SELECT COUNT(*) AS c FROM $T5 WHERE age = 4 ; $row = db_get_row2($stmt); $age_4 = $row-c; This returns only the value for 4. To get all values (10 different ones) I would have to make 10 querrys, right? Is there a faster way? Thanx for any help, Andy

[PHP-DB] Where to get freetype2.x precompiled for windows 2000

2002-03-08 Thread Andy
Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Storing sesssions in a db bad for the performance?

2002-03-11 Thread Andy
Hi there, I am wondering if it is producing a lot of extra load if I would store the sessions inside a mysql db. I use phbb as a discussion board as well, and I saw that those guys are doing that. Does anybody have some experiance on that? Or knows a good article? Thanx for any help, ANdy

[PHP-DB] Renaming files after a name in a db field possible?

2002-03-13 Thread Andy
a php script which scannes the dir for matching Countrycode patterns and renames the filename ? E.g.: Make out of CA-map.gif - canada-map.gif? Thanx for any hint, andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Avoiding the update of a timestamp in MySQL

2002-03-13 Thread Andy
Hi there, I have a timestamp in my table to store a date. Now I have to update other columns and everytime I do this, the timestamp is updated as well. Is there a other way then getting the value infront and storing it again? Thanx , andy -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Avoiding the update of a timestamp in MySQL

2002-03-14 Thread andy
Hi, thanx I try that. andy PS: yes I did, but did not try it yet. Thanx Dl Neil [EMAIL PROTECTED] schrieb im Newsbeitrag 0c8601c1cae2$d26b6dc0$c200a8c0@jrbrown">news:0c8601c1cae2$d26b6dc0$c200a8c0@jrbrown... Hi Andy, I have a timestamp in my table to store a date. Now I have t

[PHP-DB] how to start and bring down mysql.server on OSX

2002-03-15 Thread andy
in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to bring down the mysql server smoothly

2002-03-18 Thread andy
Hi there, how is it possible to bring down the server after starting with safe_mysqld. I read, that killing the ps with -9 is demmaging the tables. Thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Advanced. Optimizing querry performance on a huge db with over 2.5 million entries

2002-03-29 Thread Andy
looks like this: ID -mediumint(9) unique index city -char(100) province_id- char(2) index A nother story would be that it might take even longer because I have to get the province name and the country name out of the table countries and provinces Thank you for any help, Andy

[PHP-DB] Re: Advanced. Optimizing querry performance on a huge db with over 2.5 million entries

2002-03-29 Thread Andy
thanx, I am gonna play with it Andy Lutz Brückner [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi Andy, it is difficult to give you an advice without the knowing about how you are searching the database. But if you have to search thr

[PHP-DB] How to lock the entire db?

2002-03-30 Thread andy
Hi there, I know that there is a command lock table but what if I have hundrets of tables and want to copy them for backup. How could I lock the entire db and flush all tables? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] how to index this table with over 2 mill entries?

2002-03-31 Thread Andy
already put a 10 char index on city this boosted up the table to 89 MB Now I am wondering how to do the index on country and province. A index on both, or 2 indexes. One for each. Thanx for any advice. Regards, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] LIMIT 0,10 retrieves 10 records, but takes forever!

2002-03-31 Thread Andy
thanx, I am gonna play with it Andy Andrey Hristov [EMAIL PROTECTED] schrieb im Newsbeitrag 004301c1d8ca$276af940$0b01a8c0@ANDreY">news:004301c1d8ca$276af940$0b01a8c0@ANDreY... Another suggestion - use explicit joins. SELECT c.*, p.province, co.country FROM test.cities AS c L

[PHP-DB] Re: Making a txt file from db data, is it possible?

2002-04-06 Thread andy
mysqldump dbname.tablename filename.txt Cheers, Andy Raymond Lilleodegard [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi! I would like to make a txt file our from some db output, is this possible? Couldn't find anything about it in the

[PHP-DB] how to change a column to ENUM

2002-04-06 Thread andy
entries, while the field has only 250 different values. Is this type really faster? Currently my structure looks like this: idmedium_int(9) field1 char50 field2 char2 field3 char2 Field 1 contains about 1.5 million different entries. Thanx for any help, Andy -- PHP Database Mailing List

[PHP-DB] Copy data from one table to another. How to? Subselects not supported as far as I know.

2002-04-10 Thread andy
Hi there, I have a table containing data already. Now there is another table with data I would like to add to the other one. As far as I know mysql does not support subselects. So how could I add this data to the old table? Thanx, Andy -- PHP Database Mailing List (http://www.php.net

[PHP-DB] need help on insert select statement

2002-04-11 Thread andy
Hi there, I would like to copy data from one table to another. My code just inserts one record. Not all 20. Why? This is my try: insert into parks_new (country, province, park) select * from national_parks_us_imported Thanx for any help Andy -- PHP Database Mailing List (http

[PHP-DB] how to notify admin by e-mail only once if mysql server is down

2002-04-11 Thread andy
Hi there, I am wondering if it would be possible to set up a php application like this: If the mysql server is down notify by e-mail, but only once. Right now I am getting an e-mail per view if the server is down (might be lots of e-mails :-) thanx for any hint, Andy -- PHP Database

[PHP-DB] how to bring down the mysqlserver without getting an inconsistant db?

2002-04-11 Thread andy
Hi there, I am wondering what would be the best way to update a db. I would like to bring down the server, but I am afraid to get an inconsistant state of data. What if someone is just registering on another db? Is there a way to flush and lock the whole db not just some tables? Thanx, Andy

[PHP-DB] Insert select does not insert all rows.

2002-04-14 Thread andy
help on this. Thanx in advance. Andy Statement: insert into geodata_backup.provinces_test (country_code,province,province_id) select country_code, name, province_id from import.provinces_update_imported -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Insert select does not insert all rows.

2002-04-15 Thread andy
the statement is executed directly on the server without php just mysql any other ideas? thanx, Andy insert into geodata_backup.provinces_test (country_code,province,province_id) select country_code, name, province_id from import.provinces_update_imported Olinux [EMAIL PROTECTED] schrieb

[PHP-DB] complicated transtable problem

2002-04-18 Thread andy
on this Thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] sql querry problem

2002-05-03 Thread andy
= o.country_code But does not work though:-( can anybody help on that? thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] selecting records on a random basis with mysql function rand possible?

2002-05-07 Thread andy
, but this does take forever (doing it for a couple of times) Thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] selecting records on a random basis with mysql function rand possible?

2002-05-07 Thread andy
r in PHP and do a select statement like that? IE SELECT ID, city FROM data.cities WHERE country = 'CA' and ID = rand() -Chris At 02:52 PM 5/7/2002 +0200, andy wrote: Hi there, is it possible to get mysql to return a record out of a table on a random basis? I tryed: select rand()

Re: [PHP-DB] selecting records on a random basis with mysql function rand possible?

2002-05-07 Thread andy
cool! works. thanx, Andy Jason Wong [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED]... On Tuesday 07 May 2002 20:52, andy wrote: Hi there, is it possible to get mysql to return a record out of a table on a random basis? I tryed: select rand() ID, city from

[PHP-DB] need help on improving performance on this querry

2002-05-07 Thread andy
Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] need help on improving performance on this querry

2002-05-07 Thread andy
thank you! I did not know this command. Its 0.16s instead of 1.6! Andy [EMAIL PROTECTED] schrieb im Newsbeitrag 043c01c1f5f2$47f5b3e0$[EMAIL PROTECTED]">news:043c01c1f5f2$47f5b3e0$[EMAIL PROTECTED]... SELECT DISTINCT L.* from data.languages L, data2.user U WHERE L.id IN (U.la

[PHP-DB] stmt should return user-id only once. difficult select statement.

2002-05-10 Thread andy
LIMIT 0,5 Thanx for any help guys, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] stmt should return user-id only once. difficult select statement.

2002-05-10 Thread andy
unfortunatelly not. I did already try this. It does not make a difference. Still three results for each user do you have another idea? thanks, Andy Ryan Jameson [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... This may only be preference but you'

Re: [PHP-DB] stmt should return user-id only once. difficult select statement.

2002-05-10 Thread Andy
20 The statement would return only if I search for language hr, because it is the first it finds. If I search for en I do get nothing. Maybe I can't see what you mean. Please correct me, it sounds wired to me as well Andy Ryan Jameson schrieb im Newsbeitrag [EMAIL PROTECTED]">new

[PHP-DB] problem with grant

2002-05-11 Thread andy
is: Connection failed: 1045- Access denied for user: [EMAIL PROTECTED] (using password NO) What's wrong with my grant table statement? Or is there somehow a firewal involved? php works with db access. I am running it on suse7.2 Thanx for your help guys Andy -- PHP Database Mailing List (http

Re: [PHP-DB] problem with grant

2002-05-11 Thread andy
can you send me the link for the english mysql user group, please. I did search a while for this link on mysql.com but did not find any. Thanx in advance, Andy Jason Wong [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED]... On Saturday 11 May 2002 19:19, andy wrote: Hi

[PHP-DB] indexing text fields in mysql ?

2002-05-19 Thread andy
or smalltext columns as the info may vary between 1 and 1000 chars. Thanx for any help on that, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql crashed and created huge .MYI files. All data lost? :-((

2002-05-19 Thread andy
anybody know what happened here? I hope I do not need to role out my backup tapes :-( Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] 50.000 records, 2 values and 1.5 s to find out?!!

2002-05-22 Thread andy
? SELECT count(*) AS c FROM .user where sex = 1 takes about half the time :-) So maybe some of you guys do have some experiance on that. This is just way to long. I appreciate every help on that, Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Re: 50.000 records, 2 values and 1.5 s to find out?!!

2002-05-22 Thread andy
oh... on MySQL Andy [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi there, I have a user table, containing a column on gender. Type is tinyint(1) and 1 is male 2 is female. No index. 5 entries This statement: SELECT sex, count

[PHP-DB] Re: displaying records

2002-05-23 Thread andy
table_name WHERE criteria LIMIT 1,10 This will pull out the first 10 records http://www.mysql.com/doc Hope this helps, Andy Natividad Castro [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi to all, I'm displaying a set of records in differe

[PHP-DB] Problem with JOIN

2002-05-23 Thread andy
be wrong, but I can not find the error :-( Maybe one of you guys does know why. Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to store an image into a db?

2002-05-25 Thread andy
Hi there, I recently heard about storing images in a blob column in MySQl. Now I am wondering how to do that. I mean isn't there a potential security problem because of buffer over flow? How would I do that with php anyway? Thank you guys for any hint. Andy -- PHP Database Mailing List

[PHP-DB] php is connecting to the wrong mysql server

2002-05-31 Thread andy
is running but how could I tell php to connect to the right server? Thanx for any help on that, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Ho to write output of sql query to txt file?

2002-06-04 Thread andy
to the other db on the other machine. Is this possible? Thank you for any help, andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] Ho to write output of sql query to txt file?

2002-06-04 Thread andy
) Records: 35 Deleted: 0 Skipped: 0 Warnings: 630 The warning already tells it. the datasets are totally empty. Only default of the columns is set. do u have an idea why? Thanx, Andy - Original Message - From: Jay Blanchard [EMAIL PROTECTED] To: 'andy' [EMAIL PROTECTED]; [EMAIL PROTECTED

Re: [PHP-DB] how to create a graph from a db?

2002-06-04 Thread Andy
Hi Chris, this is very easy done with a library called jpgraph. Check out: http://www.aditus.nu/jpgraph/ A nice example can be found on my website at: http://www.globosapiens.net/community/03010001.html Hope this helps, Andy -- http

[PHP-DB] Converting non latin characters

2002-06-04 Thread Andy
on that, Andy http://www.globosapiens.net Global Travellers Network! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] date problem

2002-06-05 Thread andy
1, 02 SELECT COUNT(*) AS c FROM users_table WHERE UNIX_TIMESTAMP( user_regdate ) '1022882400' Thanx for any help on that, andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] date problem

2002-06-05 Thread andy
1, 02 SELECT COUNT(*) AS c FROM users_table WHERE UNIX_TIMESTAMP( user_regdate ) '1022882400' Thanx for any help on that, andy query -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Slow performance (PHP MYSQL)

2002-06-07 Thread Andy
PHP is known to be verry fast. MySQL as well. So your problem my be somewhere else. I am doing a similar thing on my site with thumbnails. Check it out on http://www.globosapiens.net Andy -- http://www.globosapiens.net Global Travellers

[PHP-DB] Re: MyCC Problem

2002-06-09 Thread Andy
maybe you do not have the propper rights set. Check your grant privillegs on the db. Andy -- http://www.globosapiens.net Global Travellers Network! César l . aracena [EMAIL PROTECTED] schrieb im Newsbeitrag 002a01c20e80$743a3650$14ed0dd1

[PHP-DB] addslashes for db search?

2002-06-11 Thread andy
entries, and if how? How should they look like and is there a good method to change all this thousands of records at once? Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] dumping only selected records into another table

2002-06-11 Thread andy
','9'); does anybody know how to do this? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] dumping only selected records into another table

2002-06-11 Thread andy
','9'); does anybody know how to do this? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] dumping only selected records into another table

2002-06-11 Thread andy
','9'); does anybody know how to do this? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] dumping only selected records into another table

2002-06-11 Thread andy
','9'); does anybody know how to do this? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Copy table

2002-06-20 Thread Andy
the easiest way would be if you install myphpadmin which is a awesome free mysql webadmin tool. You can get it at http://www.hotscripts.com/Detailed/7180.html Have fun, Andy -- http://www.globosapiens.net Global Travellers Network! Rosen

[PHP-DB] Re: Resetting auto_incremented values

2002-06-20 Thread Andy
sorry buddy, as far as I know you can't. The only thing you can do is to set the counter higher but you can't return to a value under the given row. Please correct me if I am wrong, Andy -- http://www.globosapiens.net Global Travellers

[PHP-DB] Re: Converting values from text to numerical

2002-06-21 Thread Andy
and y. Good luck, Andy -- http://www.globosapiens.net Global Travellers Network! Matthew Nock [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am about to build a database of products that wi

  1   2   >