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

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] selecting records on a random basis with mysql function rand possible?

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

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?

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

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

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] sql querry problem

= 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] complicated transtable problem

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

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

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] Insert select does not insert all rows.

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

[PHP-DB] need help on insert select statement

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

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?

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] Copy data from one table to another. How to? Subselects not supported as far as I know.

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] Re: Making a txt file from db data, is it possible?

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

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] how to index this table with over 2 mill entries?

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!

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] How to lock the entire db?

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] Advanced. Optimizing querry performance on a huge db with over 2.5 million entries

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

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 bring down the mysql server smoothly

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] how to start and bring down mysql.server on OSX

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

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

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] Renaming files after a name in a db field possible?

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

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

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

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] Where to get freetype2.x precompiled for windows 2000

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?

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] Difficulty on how to extract data out of a text with string functions.

. 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] addslashes needed for db security? Hack proving web apps

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

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

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] Difficult count statement. Need some sql advice

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] Building secure authentification with sessions

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] Keeping autoincrement ID 2 digits. Possible?

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] Getting the ID of the last inserted record possible?

on that? Thanx 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

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

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] Creating temp table with data out of 2 tables possible?

.$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] Creating a dynamic querry ??

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

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

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] display a waiting loop while searching the db?

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] Inserting NULL values does not work

', '$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] Logicproblem in WHERE statement

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

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

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] Is this kind of querry possible in MySQL?

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] How to compress a jpeg (qualitysetting) before saving it to the server?

); 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?

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

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] Making a Querry on two db possible?

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] db not visible if created from remote server

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] BUG in MySQL 3.23.42-nt

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

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] Iinserting into 250 tables filtered data automaticly. delaytime??

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] Potential for optimizing a huge table for querries?

: 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

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

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

\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] MyODBC problem with MySQL and ACCESS

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?

: 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

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

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] Is MySQL enough for a huge amount of data?

, 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] Data - countinents, countries, provinces, cities 10.000

. 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] Combination of SQL statements invalid in MySQL?

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] Performance problems in NC

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] DBM DATABASE PROBLEM!

: Call to undefined function: dbmopen() in path/to/my/script.php on line 48 HELP! Andy.

[PHP-DB] DBM databases - un-clear

: Call to undefined function: dbmopen() in path/to/my/script.php on line 48 HELP! Andy.

[PHP-DB] Re: br appear in Text file

Hi Jack, The 'black box' you see is a newline, which can be removed by doing this: $string=str_replace(\n,,$string); $string=str_replace(\r,,$string); That will replace \n (The newlines) and \r (The returns) with nothing, getting rid of your problem. Hope this helps, -Andy Jack [EMAIL PROTECTED

[PHP-DB] cannot create database

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

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

<    1   2