Hi,
I have 2 Identical programs but with different users.
Program lure3 / lure4 are exactly the same but lure4 is with root user
rights the other one with lure user (an other user but with all rigths
on MAPI database.) I cannot figure out what is wrong probably very
simple but I seem to be overlooking it. If I run the program with root
user it works fine. By the way this program give output table
information and field information of a specific database (in my case
MAPI).
Program source code !
<?php
// Connecting, selecting database
$Host = "hostIP";
$USER = "lure";
$PASSWORD = "password";
$DB = "MAPI";
$dbh = mysql_connect($HOST,$USER,$PASSWORD);
mysql_select_db($DB);
$tables=mysql_list_tables($DB);
while (list($TheTableName)=mysql_fetch_array($tables))
{
$fields = mysql_list_fields($DB, $TheTableName);
$columns = mysql_num_fields($fields);
echo "<TABLE BORDER=0 width=100% style=\"border-style: outset;
border-color: #C8C8C8; border-width: 1px;\">";
echo "<TR><TH COLSPAN=4 bgcolor=#003399><font
face=\"Verdana, Arial, Helvetica, sans-serif\" size=4
color=#FFFFFF><b>".$TheTableName."</b></font></TH></TR>";
echo "<TR><TH WIDTH=30%
bgcolor=#8CC6FF>ColumnName</TH><TH WIDTH=30%
bgcolor=#8CC6FF>ColumnType</TH>";
echo "<TH WIDTH=20% bgcolor=#8CC6FF>Maximum
Length</TH><TH WIDTH=20%
bgcolor=#8CC6FF>ColumnFlag</TH></TR>";
for ( $i = 0; $i < $columns; $i++ )
{
echo "<TR>";
echo
"<TD
bgcolor=#DFEFFF>".mysql_field_name($fields,$i)."</TD>";
echo
"<TD
bgcolor=#DFEFFF>".mysql_field_type($fields,$i)."</TD>";
echo "<TD bgcolor=#DFEFFF>".
mysql_field_len($fields,$i)."</TD>";
$TheFlag=mysql_field_flags($fields,$i);
if ( empty($TheFlag) )
$TheFlag="null";
echo "<TD
bgcolor=#DFEFFF>".$TheFlag."</TD>";
echo "</TR>";
}
echo "</TABLE>";
}
?>
Error message !
Warning: Unable to save MySQL query result in
c:\websites\www.chrisboer.nl\lure3.php on line 13 (the red text)
Warning: Supplied argument is not a valid MySQL result resource in
c:\websites\www.chrisboer.nl\lure3.php on line 14 (the red text)
Does anyone know a quick answer to this one.
Thanx in advance
Chris Boer
Email... : [EMAIL PROTECTED]
WWW.. : www.point-it.nl
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
