am using mysql 3 so i can't do that subquery, how can we do that in mysql 3 ?
On Mon, 7 Feb 2005 19:47:08 +, Simon Rees
[EMAIL PROTECTED] wrote:
On Monday 07 February 2005 18:22, Zouari Fourat wrote:
Hello
I have 2 tables with two columns in each one (cloned tables) like this :
ID
http://pear.php.net/manual/en/package.database.php
good luck
On Mon, 7 Feb 2005 17:09:22 +, Jonathan Trepczyk
[EMAIL PROTECTED] wrote:
hiya guys, just trying to find the best way of translating natural
language queries to sql queries to put in a website, i will be glad if
you can help or
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 ouml;? What are the benefits if it works without them as well?
Thank you for any hint,
Merlin
--
PHP Database Mailing List
2 possible solutions:
1 - use latest versions (4.1) of mysql and UTF-8 encoding.
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
Zouari Fourat wrote:
am using mysql 3 so i can't do that subquery, how can we do that in mysql 3 ?
and neither can anyone else ;-)... rather a pain, but mysql.com have been
kind enough
to give a detailed explaination on how to rewrite subselect queries as join
queries:
If you put your brain in
Viacheslav Kaloshin wrote:
2 possible solutions:
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 of encodeing. Is there a downfall in how I am doing
it, which I just now do not
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 of encodeing. Is there a downfall in how I am doing
it,
Only one: if you plan to use more, than one character set. Say, you
want store in one column text with greek, german, italian and chineese
characters ;-)
The same column should hold english and german text. Acording to your reply this
seems fine since there are no special characters in
On Tue, 08 Feb 2005 11:30:19 +0100, Merlin [EMAIL PROTECTED] wrote:
Only one: if you plan to use more, than one character set. Say, you
want store in one column text with greek, german, italian and chineese
characters ;-)
The same column should hold english and german text. Acording to
It would make things easier if you could determine the error, so try to
use mysql_error after all your mysql_queries, not just after the first one.
Stefan
[EMAIL PROTECTED] wrote:
I'm having trouble with having trouble with doing an update after doing an
insert on and a select on a table. The
Does anyone know where to get any script to be able to backup an oracle db???
i've tried phpclasses.org but didn't find anything...
--
Ade Anom A
[http://www.a3rex.info]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello all,
I am having difficulties working with a JavaScript menu that should load on
each page of my intranet site.
Here is a brief background of the problem:
1) I am using PHP and SQL Server and it is running on Windows 2000
Server (yes I know this stinks but I have no choice in
Perry, Matthew (Fire Marshal's Office) wrote:
Hello all,
I am having difficulties working with a JavaScript menu that should load on
each page of my intranet site.
[snip]
hint - you're already on the wrong list. Read on.
Here is a brief background of the problem:
[snip]
4) I am using a
I have a query which can result in an empty set/ no matching records.
The code I have which returns a code is:
$result = mysqli_query($link, $sql);
while ($query = mysqli_fetch_array($result)){
$title = $query['title'];
$director = $query['director'];
echo tabletrtd$title/tdtd
Every var should be set at the beggining of the script
$title = '';
$director = '';
then if there is no result, already has a value
bastien
From: J. Connolly [EMAIL PROTECTED]
To: PHP list php-db@lists.php.net
Subject: [PHP-DB] empty set query
Date: Tue, 08 Feb 2005 13:22:56 -0500
I have a query
Many ways to remove the epidermis from a feline, but...
You may want to do something equivalent (I think you're using mysqlite) to
the mysql_num_rows() function on your result set as a condition to running
your while loop . In pseudocode...
if(mysql_num_rows($result_set) 1){
echo out
Hello,
This question was asked many times, but I can't find a good answer.
I am getting this error message while trying to connect to MySQL server
(PHP
+ PEAR::DB_DataObject):
Can't connect to local MySQL server through socket '' (111)
(notice '' - is that right?)
Does
My intention of setting the reply-to was not to offend, or claim you
were wrong - merely to move the discussion to the list I felt (and still
feel - as I've done it again) is most appropriate for the question.
anyway, back to the task at hand
( first: I'm assuming you restarted apache after
Thanks to you both Richard and Bastian. I am a newb and am trying to
work alot out for myself. I decided to use the number rows method and
validate against that. But now that I know that I should be defining my
variables at the top, that will help alot.
jzf
Hutchins, Richard wrote:
Many ways
Is there a site that someone could recommend that does PHP, Mysql
hosting? If they do .NET that would be good also. This is for practice
and development not for a company so I am looking to keep the costs
down. There are so many sites, I thought maybe someone here might have a
good solution.
i buy my hosting on ebay. haven't had a problem
bastien
From: J. Connolly [EMAIL PROTECTED]
To: PHP list php-db@lists.php.net
Subject: [PHP-DB] MySQL PHP hosting
Date: Tue, 08 Feb 2005 16:07:47 -0500
Is there a site that someone could recommend that does PHP, Mysql hosting?
If they do .NET that
joe,
thanks for the advicei just can't host where i work and trying to
develop only on my laptop only at work is becoing tedious. The sys admin
is not happy about me running iis or apache on my laptop here. But at
least I didn't ask how you how to configure my php and mysql
richard,
22 matches
Mail list logo