Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-15 Thread Govinda
Better late then never! :) I played around with your code tonight and got this working on a test server: $db_billing = mysql_connect($DBHOST, $DBUSER, $DBPASS) or die("Could not connect: " .mysql_error()); $db_selected = mysql_select_db($DB, $db_billing); if(!$db_selected) {

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-15 Thread Jason Pruim
On Jul 13, 2009, at 10:03 AM, Govinda wrote: I have this code: $db_billing=mysqli_connect(localhost,metheuser,mypass,billing); if (mysqli_connect_error()) { die("Can't connect: " . mysqli_connect_error()); } mysqli //$dbname = 'billing'; $sql = "SHOW TABLES";

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-13 Thread Govinda
I have this code: $db_billing=mysqli_connect(localhost,metheuser,mypass,billing); if (mysqli_connect_error()) { die("Can't connect: " . mysqli_connect_error()); } mysqli //$dbname = 'billing'; $sql = "SHOW TABLES"; $result = mysql_query($sql); // line 53

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-12 Thread Zareef Ahmed
On Mon, Jul 13, 2009 at 3:19 AM, Govinda wrote: > On Sat, Jul 11, 2009 at 19:57, Govinda >> wrote: >> >>> I have been using PEAR's tableInfo() to remind myself about the columns >>> in >>> the table.. but now I want to see as much data as possible about the >>> table >>> and its contents *without

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-12 Thread Daniel Brown
Top-posting. This would be an excellent question for Prune (CC'd) to field, based on the error message. Prune? On Sun, Jul 12, 2009 at 17:49, Govinda wrote: >> On Sat, Jul 11, 2009 at 19:57, Govinda >> wrote: >>> >>> I have been using PEAR's tableInfo() to remind myself about the co

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-12 Thread Govinda
On Sat, Jul 11, 2009 at 19:57, Govinda wrote: I have been using PEAR's tableInfo() to remind myself about the columns in the table.. but now I want to see as much data as possible about the table and its contents *without* using PEAR. (I.e. just using built in stuff for mysqli.) Th

Re: [PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-11 Thread Daniel Brown
On Sat, Jul 11, 2009 at 19:57, Govinda wrote: > I have been using PEAR's tableInfo() to remind myself about the columns in > the table..  but now I want to see as much data as possible about the table > and its contents *without* using PEAR.   (I.e. just using built in stuff for > mysqli.) Thi

[PHP] PHP/mysql equivalent of PEAR's tableInfo()??

2009-07-11 Thread Govinda
I have been using PEAR's tableInfo() to remind myself about the columns in the table.. but now I want to see as much data as possible about the table and its contents *without* using PEAR. (I.e. just using built in stuff for mysqli.) I have been looking through the manuals, even tried th