Re: [PHP-DB] need help with SHOW Colums

2002-10-31 Thread 1LT John W. Holmes 
So show us the code that you tried with. This code doesn't do us any good
because it's not causing the error.

---John Holmes...

- Original Message -
From: David Rice [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 31, 2002 11:31 AM
Subject: [PHP-DB] need help with SHOW Colums










 mysql_select_db(filterseveuk);

 $query = (  SHOW COLUMNS FROM user );

 $result = mysql_query ( $query ) or die( mysql_error () );

 while ( $row = mysql_fetch_array ($result) ){

 $x = 0 ;

 echo $row[$x] ;

 $x++ ;
 }


 I would like to replace the table name user with a variable $table, that
 wil automatically take the value of the selected table. I have tried many
 times but cannot get the correct sql syntax, it keeps saying
 you have an error in your sql syntax near 'user' line 1 when i try it
with
 $table.
 any ideas??

 thank's,
 dave rice ([EMAIL PROTECTED])

 _
 Choose an Internet access plan right for you -- try MSN!
 http://resourcecenter.msn.com/access/plans/default.asp


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] need help with SHOW Colums

2002-10-31 Thread rolf vreijdenberger 

$table=user;
  $query =   SHOW COLUMNS FROM $user ;
 
  $result = mysql_query ( $query ) or die( mysql_error () );
 
  while ( $row = mysql_fetch_array ($result) ){
 
  $x = 0 ;// i don't know what you're trying to do here, but it's wrong!!
It keeps resetting$x to zero and does nothing with the update
 
  echo $row[$x] ;
 
  $x++ ;//
  }



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php