Re: [PHP-DB] retrieving field names in ascending order

2005-09-09 Thread hope
it is capital or smal lettr. i want my output to look like this ( abc ABB def MBB ztt ZZZ ) even if i use parameter sort($myarray, SORT_ASC); doesnt help. Regards hope Bastien Koert wrote: AFAIK you can't order the SHOW COLUMNS from TABLE Yo could pass the results to an arra

[PHP-DB] retrieving field names in ascending order

2005-09-08 Thread hope
hi how can i retrieve field names from a table(e.g products_attributes) in ascending order??? i need to display each of the fieldnames alongwith its datatype and length on the page. regards hope -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Problems getting data out from the database

2005-08-17 Thread hOpE
else { echo "no records "; } i hope this wil help u out regards umeed Micah Stevens wrote: Do you get error messages? Try this: $host='localhost'; $username='root'; $password='asd'; $connection = mysql_connect($host,$username,$passwor

[PHP-DB] Re: printing errors

2005-08-03 Thread hope
i use mysql_error() bt stil even sometimes i donnot understand the real error. is ther any other function tht wil let me know if error is regarding my syntax, parameters, database connection or something else like fetching records etc. David Robley wrote: (umeed wrote: most of the time wen

[PHP-DB] Re: General UPDATE question

2005-08-02 Thread hope
well if u use simple statmnt update tablename then it wil update all rows n if u hv some where criteria then only those rows (mayb 0,1 or many) tht match criteria wil b updated -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] IF command

2005-08-02 Thread hope
1st of all b sure tht wt i the type of $delete n wt value r u geting in it now if u echo or print it. then u can get a bettr idea as wt change mite b needd in ur if condition -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mail function

2005-08-02 Thread hope of life
i m uing a form where user enters its email address i get it on next page n email user id n pwd (tht i get from database using query) 2 the provided email address if ($rec_email != "") { mail($rec_email, $subject, $message, $from); echo "You will shortly receive our e

[PHP-DB] Oracle8->Oracle7 and ref cursors, perhaps ociNewCollection?

2002-04-22 Thread Theodore Hope
I'm trying to use a stored procedure and "ref cursors". The PHP server has the Oracle 8.x client library and the Oracle server is 7.x. When I try to use the ref cursor I get the infamous "ORA-24370" error. This error goes away when I connect to an Oracle 8 server (and everything else, including

[PHP-DB] php 4 + Oracle 8 + FreeBSD w/ Linux Emulation

2001-05-07 Thread Theodore Hope
We're looking into getting PHP under FreeBSD (4.3) to talk to a remote Oracle server that runs on NT. In the past we have used OpenLink, but we'd rather not touch anything on the NT side. It's apparent that one can install Oracle 8.x for Linux under Linux emulation on FreeBSD. My question is, w