RE: [PHP-DB] How can you hide database login passwd in your script?

2001-09-05 Thread speedboy
> $0 option: > Put your user ID and password in a config file, then give only the > webserver user access to it. Read the config file to make it work. This > also allows easy switching between test and production environments. You can't change the group owner of a file unless you have root. Th

Re: [PHP-DB] PHP+ postgresql help?

2001-08-20 Thread speedboy
> print_r? Am I about to learn something new? Be still, my beating heart! print_r will print the array $row which is one of the rows returned by running your query. You can then see all the values in the array. Just run it, you will see what it does. Or alternatively echo just one field from

Re: [PHP-DB] PHP+ postgresql help?

2001-08-20 Thread speedboy
> $conn = pg_connect ("host=localhost user=username password=password > bname=dbname"); > > $sql = "SELECT * FROM database where lower('$name%') order by last;"; > $result = pg_exec($conn, $sql); for ($i = 0; $i < pg_numrows($result); $i++) { $row = pg_fetch_array($result, $i);

Re: [PHP-DB] Re: delete user but keep the article

2001-08-15 Thread speedboy
> > i want to delete user_x, but keep article abc. > > how php/mysql display that there is article named 'abc', input by > 'user_x', > > but there are no further information about that user (except maybe only Have a user status, 1 = active, 2 = deleted. So when they are deleted their account is

Re: [PHP-DB] blinking background

2001-08-09 Thread speedboy
> Fergawdsake -- WHY?!! > > Irritating, annoying, amateurish -- go read Jakob Nielsen on usability. > > Here's an alternate suggestion: A contrasting colour for the row you wish > to highlight, keeping in mind that some people are colour blind. 1. You can create an animated gif with the an ast