Re: [PHP-DB] Job interview test - I give up...

2004-12-01 Thread Raymond Chua Sing
/* NOTE: this is what I came up with though I don't have the time to test it. I think theres another way to solve this just by using a different sql statement. */ function getNumDvdsInCategories() { $query = SELECT ca_id , ca_name FROM categories, dvds WHERE

[PHP-DB] php-db-unsubscribe@lists.php.net

2004-06-07 Thread Raymond
[EMAIL PROTECTED] Christopher Jones wrote: Philippe wrote: Well, the exact message is: Unable to load dynamic library php_oci8.dll: The specified procedure could not be found If I remove the library the message becomes The specified module could not be found. It seems to be able to find the

[PHP-DB] php-db-unsubscribe@lists.php.net

2004-06-04 Thread Raymond
[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] php-general-unsubscribe@lists.php.net

2004-06-03 Thread Raymond
Christopher Jones wrote: Torsten Roehr wrote: Torsten Lange [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] But when using queries on the USER_... data dictionary, Oracle delivers always big letters, which is for chemical elements (NA vs. Na) or location names (ALICE SPRINGS vs.

[PHP-DB] PHP command not function after upgrade to 4.22

2004-02-12 Thread Raymond
Hi, I've upgrade the PHP 4.06 to PHP4 .2.2 in Redhat 9.0. after that, it was found the following script can't work well. the empty seems not function. Any one can help! ... If (empty ($A) . else ... Best regards, Raymond -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: Making a txt file from db data, is it possible?

2002-04-08 Thread Raymond
or help : ) Best regards Raymond - Original Message - From: Frank Flynn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, April 07, 2002 6:02 AM Subject: Re: Making a txt file from db data, is it possible? On 4/6/02 4:12 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote

[PHP-DB] Re: Making a txt file from db data, is it possible?

2002-04-06 Thread Raymond Lilleodegard
May I use this dump method with a query too? Or is this only for making a hole table into a txt file? Because I'm trying to get a website into a txt file and save it into a directory on the server to get a order sendt by fax. Or is this a long way to go? Regards Raymond Andy [EMAIL PROTECTED

[PHP-DB] Making a txt file from db data, is it possible?

2002-04-05 Thread Raymond Lilleodegard
Hi! I would like to make a txt file our from some db output, is this possible? Couldn't find anything about it in the function list. Thanks for all help! Best regards Raymond Lilleodegard -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Re: mysql_connect() and phpmyadmin

2002-02-13 Thread Raymond Lilleodegard
Hi Martin! I dont think I understood your question right here. Are you trying to connect to mysql ? regards Raymond Martin Allan Jensen [EMAIL PROTECTED] wrote in message 005901c1b40d$6143c390$040a@IceSystems">news:005901c1b40d$6143c390$040a@IceSystems... I just don't unders

[PHP-DB] Re: count from the results

2002-02-09 Thread Raymond Lilleodegard
Hi Barry! you can do it like this for example: $query = SELECT * FROM artist WHERE artist_name LIKE 'b%' ORDER BY artist ASC; $count = mysql_query(SELECT COUNT(artist) AS count FROM artist WHERE artist_name LIKE 'b%',$db); $x = mysql_fetch_array($count); $result = mysql_query($query) or

[PHP-DB] Query with numbers like 1, 3, 5..........

2002-02-07 Thread Raymond Lilleodegard
Hi! Is there a way to get the rows with id's like 1, 3, 5, and so on or 2, 4, 6, ...? Best regards Raymond -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Query with numbers like 1, 3, 5..........

2002-02-07 Thread Raymond Lilleodegard
it? Reagrds Raymond - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Raymond Lilleodegard' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 8:55 PM Subject: RE: [PHP-DB] Query with numbers like 1, 3, 5.. Yes, but the question is why? -Original

Re: [PHP-DB] Query with numbers like 1, 3, 5..........

2002-02-07 Thread Raymond Lilleodegard
( $ref1 = mysql_fetch_object($qry) ) { $ref2 = mysql_fetch_object($qry) ?trtd$ref1-id nbsp;/tdtd$ref2-id nbsp;/td/tr? } ? /table btw, the nbsp; is to keep the internal cell borders from not appearing using netscape. (keeps it from being empty). Hope this helps Mike... Raymond Lilleodega

[PHP-DB] Is this possible?

2002-02-06 Thread Raymond Lilleodegard
several sizes. So... how do I get only one row from the product table and two rows from the price table in one line in a page? Is it possible? Best regards Raymond -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Is this possible?

2002-02-06 Thread Raymond Lilleødegård
- From: Rick Emery [EMAIL PROTECTED] To: 'Raymond Lilleodegard' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 06, 2002 6:23 PM Subject: RE: [PHP-DB] Is this possible? Yes, you can do that easily. It is easier to answer your question if you show us your table structure

Re: [PHP-DB] Another dynamic sql.

2002-01-25 Thread Raymond Lilleødegård
] To: Raymond Lilleodegard [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 25, 2002 8:11 PM Subject: RE: [PHP-DB] Another dynamic sql. Seems like it will NOT work because you are selecting $car which is already chosen by the user (i.e. which is a known value). I don't know how you laid

[PHP-DB] MySQL Update Logging ???

2001-09-20 Thread Christopher Raymond
logging with their MySQL server. Is it possible for them or me to turn on update logging just for MY database(s) ??? I appreciate any help God Bless America, Christopher Raymond

[PHP-DB] order by clause

2001-05-24 Thread luc raymond
I have the following warning message on the client web page when I use an order by in my query. If I remove it, the message dissapear. I have the following code odbc_close_all(); $sql=odbc_connect(informatique,userinfo,userinfopswd); $statement = odbc_prepare($sql, select

[PHP-DB] order by clause

2001-05-24 Thread luc raymond
I have the following warning message on the client web page when I use an order by in my query. If I remove it, the message dissapear. Warning: SQL error: