[PHP-DB] database sends unclear messages

t could be happening here? Thanx a lot in advance, Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Get next data set

$prev[id] LIMIT 1 "; That unfortunatelly returns the very first row in the table. Any ideas how to solve that? Thanx for any help, Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Get next data set

Merlin wrote: Hi there, I am trying to figure out how to write a sql statement for mysql with php that returns the next possible data set. For example I do have the ID number of a current data set, now I would like to retrieve the next data set with the next higher ID number. Sometimes there

[PHP-DB] selecting rows with no reference

not have the belonging user anymore. So I tried this: SELECT m.subject, m.status FROM user u, messages m WHERE m.sender_user_id != u.user_id But this returns far to many rows. Has anybody an idea how to do that? Thank you in advance, Merlin -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Getting total results

the data. Any ideas which could help? Thank you in advance, Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting total results

around that, anyhow), but hopefully optimized better by MySQL. Perform your own tests, of course. See the documentation on FOUND_ROWS() at the following URL for more info: http://dev.mysql.com/doc/mysql/en/Information_functions.html Thank you everybody, Merlin -- PHP Database Mailing List (http:/

[PHP-DB] Placing html entities into database?

Hi there, I am wondering how to store special characters like the german ö for example into a mysql db. Should the characters somehow be transforemd into html entities like ö? What are the benefits if it works without them as well? Thank you for any hint, Merlin -- PHP Database Mailing List

Re: [PHP-DB] Placing html entities into database?

notice? Regards, Merlin 2(bad) - before storing encode all string to base64 or something like this :-) On Tue, 08 Feb 2005 10:29:20 +0100, Merlin <[EMAIL PROTECTED]> wrote: Hi there, I am wondering how to store special characters like the german ö for example into a mysql db. Should the char

Re: [PHP-DB] Placing html entities into database?

acters in english?! Thanx, Merlin Viacheslav Kaloshin wrote: On Tue, 08 Feb 2005 10:54:33 +0100, Merlin <[EMAIL PROTECTED]> wrote: 1 - use latest versions (4.1) of mysql and UTF-8 encoding. I am using 4.0.18 and the data look korrekt when retriefed out of the database. I did not enable any kind o

[PHP-DB] sorting values

after pulling out the values into variables (sort after time desc)? for esample: new user pictures time 10:00:00 new user articles time 12:00:00 new whatever time 11:00:00 thanx for any help, merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] incrementing values

Hi there, is there a function in mysql to increment a value inside a field? I am always doing this with php, just thought this might be really usefull?! Thanx, Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] simple sql problem

ids from table pictures which are not in table album_pictures, but I would like to have it the other way arround. Can anybody help on this. Thanx a lot in advance for any help, Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] To many connections error

re problem here (celleron 1GHZ 256 MB ram)? The traffic for the site is rising constantly and I fear to get in trouble. Thanx for your help. Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] sql or php?

the picture table. Somehow it returns always yes. Has anybody a good idea? Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql problem importing data

INTO TABLE test.hotels_descriptionFIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; ERROR 2013: Lost connection to MySQL server during query mysql> 030806 02:08:37 mysqld ended As you can see, my db server creashed! Nothing special about this file. I am running MySQL 3.23

[PHP-DB] mysql problem importing data

=mysql --pid-file=/home/mysqladm/var/mysqld.pid --skip-lo cking -u mysqladm >>/home/mysqladm/data/SARATOGA.err 2>&1 030807 00:00:45 mysqld ended Has anybody an idea on how to import that data? Its nicely seperated by ; Thanx for any help, Merlin -- PHP Database Mailing List (http:

Re: [PHP-DB] full text search in mysql

> As of Version 4.0.1, MySQL can also perform boolean full-text searches I am running Mysql 3.x . This sounds like a simple task to me. Is it not implemented in 3.x? It does not have to be OR, NOR or anything, just AND merlin "Larry E . Ullman" <[EMAIL PROTECTED]> schrieb

[PHP-DB] full text search in mysql

statement, that both words have to be present? Thanx for any hint on that, Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] joining two sql statements

/* AND u.premium_terminates >= $today */ $where_stmt ORDER BY p.timestamp desc LIMIT $limit_bottom,$hits_per_site "; Thanx for any help on that, Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] delte stmt problem with joins

JOIN $table2 AS p ON p.ID = pi.product_id WHERE p.owner_id = '15173' Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] delte stmt problem with joins

AS p ON p.ID = pi.product_id WHERE p.ow' at line 3 Merlin John W. Holmes wrote: Merlin wrote: I would like to delete a row inside a mysql table. To find out which rows are affected the system has to check another table. Somehow I am doing this statement wrong and I cant find out

[PHP-DB] To many connections problem with LAMP

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

[PHP-DB] how to deal with this (hack) attack?

"connection:close" comming from unspecified clients. The site is running again (I did not do anything). Can anybody give me a hint on how to prevent such atacks? What is that connection:close thing? Any help is greatly appreciated! Merlin -- PHP Database Mailing List (http://www.php.net/) To u

[PHP-DB] most popular places

now and cant find a way. Maybe someone of you guys could give me a smart push. Thank you for any help, Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Truncated data retrieved from MSSQL Server

Hello, I'm trying to retrieve data from a table sitting on a MSSQL Server Database but the query result is always truncated over 255 characters... PHP 4.05 is running on a Linux box The column is a varchar 5000 Thanks for any help. Thomas. -- PHP Database Mailing List (http://www.php.net/