[PHP-DB] Use of database

2004-03-27 Thread Will 
I have searched but I cannot find anything that will help me.

I am using phpMyAdmin and I want to have a user not see the privilages,
mysql info and such. How do you get rid of those links in the main page.

Thank in adanvce.
~WILL~

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

[PHP-DB] Uses of Databases

2004-03-27 Thread Will 
I have searched but I cannot find anything that will help me.

I am using phpMyAdmin and I want to have a user not see the privilages,
mysql info and such. How do you get rid of those links in the main page.

Thank in adanvce.
~WILL~

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

RE: [PHP-DB] Use of database

2004-03-27 Thread Peter Lovatt 
Hi

only users with the privileges will be able to access those pages.

if you are using mysql 3.xx the link wont show for low privilege users (I
think !)

4.xx seems to show the links, but you can still only access them if you have
the right privileges

HTH

Peter




 -Original Message-
 From: Will [mailto:[EMAIL PROTECTED]
 Sent: 27 March 2004 15:21
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Use of database


 I have searched but I cannot find anything that will help me.

 I am using phpMyAdmin and I want to have a user not see the privilages,
 mysql info and such. How do you get rid of those links in the main page.

 Thank in adanvce.
 ~WILL~

 --
 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] Select Query--Need help urgently

2004-03-27 Thread Katie Evans-Young 
Irin said:
 $sql = mysql_query(SELECT * FROM class where timetable_day='Monday');

 $row = mysql_fetch_array($sql);
 $result = $db-query($sql);
 $numofrows = mysql_num_rows($sql);

From the PHP manual:

array mysql_fetch_array ( resource result [, int result_type])

You can't send the function mysql_fetch_array a string as a parameter. It
needs a result resource.

Assuming that your $db class returns a result resource, you can try this:

$sql = SELECT * FROM table;
$result = $db-query($sql);
$row = mysql_fetch_array($result);
$numofrows = mysql_num_rows($result);

If for some reason you don't know what that class function query is
returning, you can do it this way and it will work for sure:

$sql = SELECT * FROM table;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$numofrows = mysql_num_rows($result);

HTH,

Katie Dewees
Web Developer
E-mail: [EMAIL PROTECTED]

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

RE: [PHP-DB] Select Query--Need help urgently

2004-03-27 Thread Katie Evans-Young 
Irin said:
 $sql = mysql_query(SELECT * FROM class where timetable_day='Monday');

Oops, I see that he DID do a mysql_query and save the result resource in
$sql. Sorry, guys! I haven't had my coffee yet this morning!

Katie Dewees
Web Developer
E-mail: [EMAIL PROTECTED]

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

[PHP-DB] Connect php to middle tier server

2004-03-27 Thread Maximiliano Robaina 
Hi,

Anybody can perform connect a php application to middle tier server (COM
Object)?
It's possible do it? How?

For example a middle tier server made with Delphi (Datasnap server)

Thank in advance
--
Maxi.

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