[PHP-DB] From MySQL to EXCEL

2004-02-02 Thread Christine Clerc
Hi, I need to turn data extracted from MySQL into an EXCEL spreadsheet (.xls, not a .txt that is imported into Excel). Is it possible ? Thank you. Christine -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Different character sets

2004-01-20 Thread Christine Clerc
Hi, My pages collect short texts from different languages through HTML forms. The texts are stored in a MySQL database. Then, they are used in HTML pages. Problem 1 : the carriage returns don't show back up. Problem 2 : The character above chr128 are not coded properly (obviously) Problem 3 :

[PHP-DB] Subselect ?

2004-01-16 Thread Christine Clerc
Hi, I have a Mysql table of texts in different languages : id_readme id_script (the object that the text describes) id_language (the language the text is written in) etc. So two texts may have the same id_script but with different id_language. I need to retrieve the list (without duplicate) of

Re: [PHP-DB] Re: Subselect ?

2004-01-16 Thread Christine Clerc
Patrin wrote: Christine Clerc wrote: Hi, I have a Mysql table of texts in different languages : id_readme id_script (the object that the text describes) id_language (the language the text is written in) etc. So two texts may have the same id_script but with different id_language. I need

[PHP-DB] A JOIN that works sometimes ?

2002-06-25 Thread Christine Clerc
Could anyone please help me with that query ? $req=SELECT * FROM tab AS C INNER JOIN inter AS A ON C.id_tab=A.id_tab WHERE A.id_cat IS NULL OR A.id_cat = 0 ORDER BY num; $result = mysql_query ($req,$db); It works on my machine but not on the server. Christine

[PHP-DB] Works with one server and not the other

2002-06-24 Thread Christine Clerc
Hi, I want to populate two related tables : here is the code include (connect.php); $req=select * from tab where num='$mod'; $result=mysql_query($req,$db); if ($ligne=mysql_fetch_array($result)) //if the data is already there do nothing