[PHP-DB] PHP compile error: Cannot find mysql header files

onfiguring PHP, I'm using this: [EMAIL PROTECTED] mysql]# ./configure --with-apache=../apache_1.3.31 --with-mysql=/usr/bin/mysql This is the Error: configure: error: Cannot find MySQL header files under /usr/bin/mysql When I search for mysql.h, I get this: [EMAIL PROTECTED] local]$ locate mys

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

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

'$picture', '$caption', '$country', '$province', '$city', '$glacier', '$park', '$lake', '$mountain', '$beach', '$comment', '$keyword'

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

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

Hi there, I am building a picture search engine with a gui where the user can choose categories and then choose from those categories several points. It is almost impossible to build a querry out of that. I am having a problem keeping it dynamic. It works if I am naming the category, but I would

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

he propper 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

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

0]_cities, $DB2.$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

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 "* R&Ze:" <[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 da

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

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

. Forums can be deleted and created by the admin. As soon as one is deleted, there is an empty number. E.g. 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

[PHP-DB] Building secure authentification with sessions

. Maybe someone 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://www.php.net/) To unsubscribe, visit: http://www.php.net

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

wrong: SELECT COUNT(t.*) AS c, f.archive, f.forum_id FROM fo_topics t, fo_forums f WHERE f.archive != 1 Can this be that difficult? Thanx for any help 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

ith a input 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://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

day, 19-01-2038 but the mysql timestamp says: 20020305211704 So whats going on? Can anybody help please? Thanx andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[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: > &g

[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

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

. The question is what would be the fastest way. I never heared of unix shell scripting, but I asume it is something what youwould call a batch file in win or apple script on mac. Thanx again for your help. Andy "Gurhan Ozen" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECT

[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 an

[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] 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] 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

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

[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

[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] 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 he

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

[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] 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

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

.country_c = co.country_c ORDER BY country , province limit 0, 10 This takes 30 s on a 2.5 mio entries table How could I really restrict the results to 10. So that mysql just returns after 10 results? Thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

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 &g

[PHP-DB] What would be a propper way to back up a huge db while server is up

?) - flusch the tables (the whole db? How?) - copy the dirs with the dbs - unlock the db (how?) 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: What would be a propper way to back up a huge db while server is up

oh ... on MySQL "Andy" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi there, > > how would a backup procedure look like on a mysql server with root access to > make a backup while the db is up and running. As fa

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

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

r 2million 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 Ma

[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/) To

[PHP-DB] difficult sql statement. Help needed

he name of the province) Maybe there is a way to do if statements in sql?? Thanx for any help Andy begin 666 transparent.gif K1TE&.#EA`@`"`( ``/___P```"'Y! $`+ `"``(```("A%$`.P`` ` end -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[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

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

what if I have 50 tables?? "Andrey Hristov" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 02f701c1e177$abd40040$0b01a8c0@ANDreY">news:02f701c1e177$abd40040$0b01a8c0@ANDreY... > Get all table names in a db and lock them :"show tables;"; > > Andrey &

[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

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" <[EM

[PHP-DB] complicated transtable problem

give me a hint 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

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

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

ot just get a random number 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

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

[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 > WHER

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

HAVING ranking > 0 /* dont return all users! */ ORDER BY ranking desc 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.

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

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 [EMAI

[PHP-DB] problem with grant

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

Re: [PHP-DB] problem with grant

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 200

[PHP-DB] sw for printing out a db shema for mysql

Hi there, I am wondering if there is already a sw for printing out db shema. Like all tables with its structure. Maybe someone has already done some nice php code on that? thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] indexing text fields in mysql ?

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

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

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

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 entr

[PHP-DB] Re: displaying records

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 displ

[PHP-DB] Problem with JOIN

'3' Somehow my syntax must 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?

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

[PHP-DB] problems with storing image data to the db

o the db, but it did not change anything. Thank you so much for any hint, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

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?

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?

OK, 35 rows affected (0.04 sec) 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 PR

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

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

lp 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

stamp june 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

stamp june 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)

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

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 002a0

[PHP-DB] addslashes for db search?

I have to change this db 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

put: INSERT INTO beaches VALUES ('','Carrabelle Beach','US','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

put: INSERT INTO beaches VALUES ('','Carrabelle Beach','US','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

put: INSERT INTO beaches VALUES ('','Carrabelle Beach','US','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

put: INSERT INTO beaches VALUES ('','Carrabelle Beach','US','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

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

[PHP-DB] Re: Resetting auto_incremented values

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

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

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 dat

[PHP-DB] Re: question from newbie

use you are not allowed to start with an OR. But you get the idea? Hope this helps, Andy -- http://www.globosapiens.net Global Travellers Network! "Chris Barnes" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 000201c21ace$65e66ba0$[EMAI

[PHP-DB] Re: MySQL query from multiple tables

tables with the same id*/ AND pf.yourcriteria = whatever /* put your criteria for table 2 here*/ Hope this helps a bit, Andy -- -- http://www.globosapiens.net Global Travellers Network "Matthew Nock" <[EMAIL PROTECTED]> schrieb im

[PHP-DB] Re: [PHP] saving temporary image to database

t;>news:[EMAIL PROTECTED]... > There is no imagejpeg() call in the code snippet you provided. And you > don't say how it is failing. You haven't provided us with enough data to > answer this question. > > -Rasmus > > On Sat, 29 Jun 2002, andy wrote: > > > Hi

[PHP-DB] blob versus file

show up on the site. Is there a way to improve the performance, and why is this happening? I thought the performance might even boost after storing them to blobs. Thank you for any comments on that, Andy PS: I was planing to store all the other images (20 - 50 KB) to blobs as well (thousands

Re: [PHP-DB] blob versus file

schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Mon, 1 Jul 2002 14:17:53 +0200 > "andy" <[EMAIL PROTECTED]> wrote: > > > Hi there, > > > > I am wondering if anybody has experiance in saving images to blob in mysql. > &

[PHP-DB] storing content data outside the application

by the client anymore. Does anybody know a good method to store the images outside the rootfolder and still access them the old fashion way? Any suggestions are appreciated. Thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] resizing images comming out of blobs

Hi there, I am wondering how to resize an image which is stored in a mysql blob field. With files this workes just fine, but how to do this with the image comming from blob? Has anybody done this already? Thank you for any help on that, andy -- PHP Database Mailing List (http

[PHP-DB] Calculating inside query?

see the error: Mysql: SELECT ID, rating_total / ratings_amount AS top10 FROM rating ORDER BY top10 desc LIMIT 10 Thanx for any help, Andy query -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Calculating inside query?

[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... i assume you're using MySQL because of the Limit clause, but what error are you receiving? -Original Message- From: andy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] C

Re: [PHP-DB] Calculating inside query?

oh I see! There have been '' values in some columns. Thanx Andy "Ryan Jameson" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... do both of the fields contain values and are they both numeric? It sure seems strange to me

[PHP-DB] sort problem

sort the other arrays with the same sorting algo? Or a way to include a iff clause in the query? currently I am doing: SELECT u_name, id, points FROM user WHERE points > 0 ORDER by points desc LIMIT 5 and the top10 reports extra. Has anybody a good idea on that? Andy --

[PHP-DB] how can this be? GET instead of POST -> db error

where this GET request could come from. This has caused a empty sql statement and therefore a db error. How can could this be achieved? By clicking back in the browser window? I dont think so since the same user was on another site before. Has anybody a idea on that? Andy -- PHP Database Ma

[PHP-DB] escaping line brakes

that? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] sucking news out of the usenet

se help me, many thanks sebastian . Lots of text.. puhh! I hope this is somehow possible. Maybe one of you guys has a good idea on that. You can just cut and past the code underneath and try it out by yourself. Thanx for any help on that. Andy - http://www.OZforu

[PHP-DB] Re: sucking news out of the usenet

sorry for posting into the wrong forum. My mistake! "Andy" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi guys, > > I am trying to build a usenet gateway which is collecting usenet posts and > puts them into

[PHP-DB] best way to stare true, false

, but cant remember where and how, all tryes did not succeeed so far. Thanx for any help on that. Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] best way to stare true, false

hmm.. thats how I am doing it right now. There might be a better way?! "Raquel Rice" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Sat, 10 Aug 2002 16:46:54 +0200 > "andy" <[EMAIL PROTECTED]> wrote:

  1   2   >