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
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
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
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
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:/
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
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
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
$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
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
"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
hanx in advance.
Regards,
Merlin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
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
/* 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
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
> 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
=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:
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
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 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
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
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
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
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/
25 matches
Mail list logo