[PHP-DB] Re: navigation...
Deco [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... My will is to return the areas in some cascade order... I can do it recursively, but it generates too many queries. I was wondering how i could do this with only one query to the database. Here's the structure i have so far: AREAS (area_id INT; parent_id INT; root_id(??) INT; description VARCHAR(60)); Hello, I've come across this type of thing for link categories/subcategories. Heres how I solved it: Table Structure: cat_id INT; parent_id INT; desc VARCHAR(255); sort_id INT; Example rows: 10Computers1 21Hardware 2 32Modems 3 41Software 4 Take a look at the sort_id field. Now, to get all the categories subcategories I just sort all records by sort_id ASC. This however requires severe maintenance when adding/deleting records. Hope this helped. Charade. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: PHP and MS Access
For information: For step by step info on using ODBC to connect MySQL to M$ Access go to: http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm Cheers. Russ On Wed, 3 Oct 2001 15:47:07 -0500 Carlos Augusto Abarca [EMAIL PROTECTED] wrote: This is absolutely not true. Although there isn´t a direct way to connect to Access from PHP (like you can do with PosgresSQL) you may connect to access using an ODBC connection. The only thing they have to do is Configure an ODBC DSN in their server pointing to your specific DB file and that´s it. I hope I understood your problem correctly and I hope this answer is satisfactory. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] MYSQL Problems Please help
I am runing RH 7 Mysql (installed of RPM), Apache (compiled version) and PHP 4.0.4pl1 configure command './configure' '--with-xml' '--with-apache=../apache_1.3.19' '--enable-shared-pdflib' '--enable-track-vars' I am trying to connect to a mysql database using the following: html Body ? echo Php is starting herebr; $host = localhost; $user = root; $password = password here; $database = webgen; echo trying to connect to $host as $userbr; $db = mysql_connect($host,$user,$password) or die (Connection could not be establishedbr); echo Connectedbr; echo End of PHp.br; ? /body /html and I am getting the following error Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/webgen/public_html/index3.php on line 10 I have tried to recompile PHP using --with-mysql but it wont compile even if I specify the mysql location. It claims it cant find mysql.h runnig locate mysql.h brings back nothing. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] MYSQL Problems Please help
-Original Message- From: Peter [mailto:[EMAIL PROTECTED]] Sent: 04 October 2001 16:42 To: [EMAIL PROTECTED] Subject: [PHP-DB] MYSQL Problems Please help I am runing RH 7 Mysql (installed of RPM), Apache (compiled version) and PHP 4.0.4pl1 configure command './configure' '--with-xml' '--with-apache=../apache_1.3.19' '--enable-shared-pdflib' '--enable-track-vars' [snip] and I am getting the following error Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/webgen/public_html/index3.php on line 10 It sounds like the mysql server is not running. Do: /etc/init.d/mysql status If that says mysql is not running (or words to that effect) then do: /etc/init.d/mysql start I have tried to recompile PHP using --with-mysql but it wont compile even if I specify the mysql location. It claims it cant find mysql.h IIRC you have to specify the parent directory. EG if you had: /usr/include/mysql/mysql.h then you would specify /usr/include runnig locate mysql.h brings back nothing. If this is a fresh install you probably need to run updatedb to update the db that locate uses. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] MYSQL Problems Please help
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 04 October 2001 17:11 To: Jason Wong Subject: Re: [PHP-DB] MYSQL Problems Please help Jason, Mysql is running, so thats not the problem. I tired to run your updatedb to no avail. my directory for mysql is /var/lib/mysql so I tried the configure with the directory /var/lib still no joy. I really dont want to have to rebuid the box again as I have been doing this for a couple of days now. Any other ideas?? Thank you for your help it is much appreciated OK, you say you can't find mysql.h, that is a file which is provided by the MySQL-devel package --have you installed it? Next, you need to configure php using --with-mysql=/dir/to/parent/of/mysql/mysql.h. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] padding an id field
Is there anyway to pad an id field in MySQL? I have a table with a PK field (id). This field is auto incrementing a 6 digit number ie. 000223. Is there anyway to pad this id so that it is padded with a code along with the auto incrementing part, such as ABC000223. Now I wouldn't want the ABC pad to change but the 6 digits would still auto incr as required. Is this possible without doing any field editing, exclusively with a MySQL utility? thanks /Merle -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Bug in new PHP Version?
which version you ised before? and which version of the mysqladmin you are using? seems you need a new version of mysqladmin. -- Hidulf http://www.hidulf.com Luditus [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi there, I just downloaded the new 4.06 PHP Version and installed it on a new machine. My application does not work properly anymore, nor does mysqladmin. This are some warnings: Warning: mysql_db_query is deprecated; use mysql_select_db() and mysql_query() instead in c:\dokumente und einstellungen\administrator\desktop\my files\projects\globosapiens\07_production\actual\mysqladmin\lib.inc.php on line 506 Warning: Undefined variable: picture in c:\dokumente und einstellungen\administrator\desktop\my files\projects\globosapiens\07_production\actual\gallery\app_local\dsp_album .inc on line 273 Does anybody have an idea? Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] MS SQL 7
Is there a way to retrieve records from a stored procedure with MS SQL 7? I've tried but I couldn't get anything. I read on the PHP bug site that I can only use SELECT statement, but ODBC should work; is that true? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] MySql special characters (éàôï)
Hi ! My question is pretty simple. How do I specify a language for MySQL ? I cannot retreive (or correctly insert, i'm not sure) any accentuated characters (french canada) from my database with php, ODBC or the mysql client. I may be a little off-topic, but it's pretty important for me to be able to display these characters on my webpage. Thank you -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] sybase extensions
Hello, I am very new to PHP and am having problems finding out information regarding loading up the Sybase extensions for IIS on Win2K. Any help would be greatly appreciated. Art Chevalier Sybase Replication Administrator Space and Naval Warfare Center, Chesapeake 1-757-523-8303 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Howto make a double LEFT JOIN
Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Bas Jobsen [EMAIL PROTECTED] To: Sheridan Saint-Michel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 2:52 PM Subject: Re: [PHP-DB] Howto make a double LEFT JOIN Hello Sheridan Saint-Michel, Let's see. Table2 contains data with a unique identifier (id) b.e id|url Table1 and Table3 contain the same identifier (id) but it isn't unique now. Table1 and Table3 contain couting of action. Cause i want to count only the actions of the last X hours, each count is on a row apart. Each row in this table contains a timestamp, so i could do something like DELETE FROM Table1 WHERE timeY (Oke, so Table1 (Table3 ) must have an other unique identifier (sid)). Table1 and Table3: sid|id|count|time count is always 1 You probably don't need count, as each entry implies one event, unless you are using it for something else I don't know about... otherwise this looks good. Oke, what do i want? First i want to know which id's are in Table1 and how many times (know not all the id's from Table2 have to be in Table1(or in Table3, and not all the id's from Table1 have to be in Table3)) something like: SELECT DISTINCT id, SUM(count) FROM table1 GROUP BY id For each id found in Table1 i want to know two things: 1) the url from Table2 2) is there any row in Table3 where table1.id=table3.id and if so, how many are there? This is it. thanks!!!, Bas Okay, now that you have added a unique Primary Key to each table this becomes a doable task. The query to do everything you list here should be: select table1.id,bit_count(bit_or(1table1.sid)) as count1,bit_count(bit_or(1table3.sid)) as count2,table2.url as url from table1 left join table3 using(id) left join table2 using(id) group by table1.id; As you can see, count is never used... which is why I said you probably don't need it. Let me know if this helps Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Difference between OCI* functions and ORA_* functions
ORA are for Oracle7 OCI8 for Oracle8 Read the manual on www.php.net B. le jeu 04-10-2001 at 17:02 Sridhar Moparthy a écrit : Hi All, Does any one know the difference between OCI* functions from PHP_OCI8.DLL and ORA_* functions from PHP_ORACLE.DLL? Which one is better in terms of speed and which one is better for future compatibility?. Thanks in advance Sridhar Moparthy. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: Re[2]: [PHP-DB] padding an id field
On Thu, 4 Oct 2001 14:17:22 -0300 WebDev [EMAIL PROTECTED] wrote: Thursday, October 04, 2001, 1:13:59 PM, you wrote: RR When you define your auto-incrementing column, can't you specify RR ZEROFILL? I believe it pads to the left with zeroes. Hello Raquel, Yes, but is it possible to append a code such as 'abc' along with the zerofill to create an id like 'abc000123' for the 123rd id record. /Merle I don't believe that's a possibility. However, if I were doing it myself, I would have two columns ... one that contained the 'abc' identifier (or whatever) and the second which contained the auto-incremented ID. Then when I retrieved the full ID, I would do it using ... SELECT concat(first_id,auto_id) AS full_id FROM id_table ORDER BY full_id; -- Raquel Don't be afraid of opposition. Remember, a kite rises against ... not with ... the wind. --Hamilton Mabie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Bug in new PHP Version?
-Original Message- From: Luditus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 3:13 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Bug in new PHP Version? I just downloaded the new 4.06 PHP Version and installed it on a new machine. My application does not work properly anymore, nor does mysqladmin. This are some warnings: [snip] Does anybody have an idea? You don't say what version you were upgrading from, but if you jumped forward a few versions, I believe there was a change in the default value of the error_reporting configuration option that'd result in the display of more non-fatal warning messages (things like the unitialized variable message you posted). Note that, for the most part, your application should still behave the way it did before (except for the printing of those messages). I didn't see anything in either of the messages you posted that appeared to indicate a change in functionality...do you have some reason to believe that things aren't working the same behind the scenes as they did before? --- Mark Roedel | Blessed is he who has learned to laugh Systems Programmer | at himself, for he shall never cease LeTourneau University | to be entertained. Longview, Texas, USA| -- John Powell -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] RE: [PHP-WIN] Setting up MySQL for PHP
Even with it being on a separate server, setting up MySQL and PHP to work together is almost flawless, with ODBC and MySQL being enabled by default on the windows PHP ver, just plugin the code.. To test this theory you can always use the following code (as I do when setting up a new server): ?php $sqlhost = 12.110.x.x; $sqluser = username; $sqlpass = password; $conn = mysql_connect($sqlhost, $sqluser, $sqlpass) or die(mysql_error()); ? That will test to see if you can connect to the host. Simple :) For more information, either read the MySQL documentation along with the PHP documentation, or check out devshed's tutorials. -- Charles Butler [EMAIL PROTECTED] Research and Development American Telanet Corp. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Howto make a double LEFT JOIN
Hello Sheridan Saint-Michel, Well it works fine, tnx!!! But now i want to understand it too. bit_count(bit_or(1table1.sid)) ?? What does bit mean? I thougt 1table1.sid was something like a backward bit(e)swich stepsize 1?? I creat my sid by: srand((double)microtime()*100); $sid = md5(uniqid(rand())); a the sid-field as varchar(32) (i realise now, maybe better use char(32)) (Maybe you will ask why i don't use a auto_increment sid (int(9) or something like that). Cause I don't want the table will be full ever (sid999.999.999)) Now i thougth bit_count(bit_or(32table1.sid)) should do the trick, but it doesn't? Best regards, Bas - Original Message - From: Sheridan Saint-Michel [EMAIL PROTECTED] To: Bas Jobsen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 04, 2001 8:02 PM Subject: Re: [PHP-DB] Howto make a double LEFT JOIN Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Bas Jobsen [EMAIL PROTECTED] To: Sheridan Saint-Michel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 2:52 PM Subject: Re: [PHP-DB] Howto make a double LEFT JOIN Hello Sheridan Saint-Michel, Let's see. Table2 contains data with a unique identifier (id) b.e id|url Table1 and Table3 contain the same identifier (id) but it isn't unique now. Table1 and Table3 contain couting of action. Cause i want to count only the actions of the last X hours, each count is on a row apart. Each row in this table contains a timestamp, so i could do something like DELETE FROM Table1 WHERE timeY (Oke, so Table1 (Table3 ) must have an other unique identifier (sid)). Table1 and Table3: sid|id|count|time count is always 1 You probably don't need count, as each entry implies one event, unless you are using it for something else I don't know about... otherwise this looks good. Oke, what do i want? First i want to know which id's are in Table1 and how many times (know not all the id's from Table2 have to be in Table1(or in Table3, and not all the id's from Table1 have to be in Table3)) something like: SELECT DISTINCT id, SUM(count) FROM table1 GROUP BY id For each id found in Table1 i want to know two things: 1) the url from Table2 2) is there any row in Table3 where table1.id=table3.id and if so, how many are there? This is it. thanks!!!, Bas Okay, now that you have added a unique Primary Key to each table this becomes a doable task. The query to do everything you list here should be: select table1.id,bit_count(bit_or(1table1.sid)) as count1,bit_count(bit_or(1table3.sid)) as count2,table2.url as url from table1 left join table3 using(id) left join table2 using(id) group by table1.id; As you can see, count is never used... which is why I said you probably don't need it. Let me know if this helps Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Date
Is there a way that the default sql data base date -00-00 can be changed using php? Cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] updating records in ODBC with cursor
is there a way to update records with cursor thru ODBC? thanx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Email Processors Wanted Immediately!!!
Dear [EMAIL PROTECTED], WE are looking for serious inquires from individuals who want to make a difference!!! Our company is offering an opportunity for individuals who want to become an E-Mail PROCESSOR. Work from home and be apart of this tremendous opportunity to sustain an income of your choice. Free 30 day trial membership, not MLM. Requirements: Computer, internet hookup, some basic computer skills and a little time effort. SEND AN EMAIL TO: [EMAIL PROTECTED] WITH SUBJECT: SHOW ME. ***Thanks for taking the time to look at this offer. Please accept my apologies if this email has offended you in any way. If you wish to no longer receive email please send an email message to [EMAIL PROTECTED] with Remove placed in the subject line.*** Web Site; http://www.geocities.com/project_internetca/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Email Processors Wanted Immediately!!!
HAAHAHAHAHAHAHHAHAHH!!! does this seem like a spam mail or what! :) my suggestion. do not even touch this email. the person is wanting some more emails to spam. Neil - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 04, 2001 4:04 PM Subject: [PHP-DB] Email Processors Wanted Immediately!!! Dear [EMAIL PROTECTED], WE are looking for serious inquires from individuals who want to make a difference!!! Our company is offering an opportunity for individuals who want to become an E-Mail PROCESSOR. Work from home and be apart of this tremendous opportunity to sustain an income of your choice. Free 30 day trial membership, not MLM. Requirements: Computer, internet hookup, some basic computer skills and a little time effort. SEND AN EMAIL TO: [EMAIL PROTECTED] WITH SUBJECT: SHOW ME. ***Thanks for taking the time to look at this offer. Please accept my apologies if this email has offended you in any way. If you wish to no longer receive email please send an email message to [EMAIL PROTECTED] with Remove placed in the subject line.*** Web Site; http://www.geocities.com/project_internetca/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
