[PHP-DB] Re: mail function help

Here is an example how to use the mail-function right. Hope it helps. #mailtje versturen naar $m_adres = $klant_email; $m_subject = $onderwerp; $m_body = Onderwerp: $onderwerp\r\n\r\nUw link is: $link\r\nUw categorie is: $categorie\r\n\r\nU moet uw link bla

[PHP-DB] htaccess quick ?

Hi All I want to make this htaccess file Allow to www.domain.com/admin Allow ip number1 Allow ip number2 Allow ip number3 Allow ip number4 Deny everyone else On error go to a 404 page of my own making. How do I do that? As always your help and pointers are most appreciated.

[PHP-DB] Error creating new table

I am trying to create the following table using PHPMyAdmin: CREATE TABLE IF NOT EXISTS ayny( organization varchar(50) NOT NULL, subtitle varchar(50) NOT NULL, img varchar(20) NOT NULL, width varchar(5), height varchar(5), link varchar(30) NOT

Re: [PHP-DB] Error creating new table

I don't think you can use text(50), It should be one of the following tinytext, mediumtext or text Or you should use char(50). I would try to avoid using varchar() it fragments the database. Remco - Original Message - From: Lisi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday,

Re: [PHP-DB] Error creating new table

Worked like a charm, thanks. How do I avoid varchar if I the size of the text will vary with each entry? It's going to be a pretty small database anyway so I'm not that worried, but how often do I optimize the table to avoid fragmentation? -Lisi At 10:29 AM 4/8/02 +0200, you wrote: I don't

Re: [PHP-DB] Error creating new table

You can store string with 3 characters in a char(5) or even char(50); If you have a string that can have between 1 and 50 characters you can use varchar. If the size is always close to 50 I would use char(50). But in my opinion a varchar(5) doesn't make much sense since it doesn't take up much

[PHP-DB] Re: htaccess quick ?

In article 001301c1ded0$498373c0$d95527d9@phpdevdc001, [EMAIL PROTECTED] says... Hi All I want to make this htaccess file Allow to www.domain.com/admin Allow ip number1 Allow ip number2 Allow ip number3 Allow ip number4 Deny everyone else On error go to a 404

Re: [PHP-DB] Re: htaccess quick ?

On Monday 08 April 2002 18:55, David Robley wrote: This is rather out of the scope of php_db, no? But you need something like Unfortunately people take advantage of the good-natured people on this list who answer off-topic questions such as this. -- Jason Wong - Gremlins Associates -

Re: [PHP-DB] New PostgreSQL functions

I'm just curious is the purpose of these functions to remove the requirement that programmers know SQL? I'm not trying to sound sarcastic or anything, but I mean, whats next a pgsql_select_join for joins? If someones smart enough to figure out the Postgres install and performance tuning (and I

Re: [PHP-DB] New PostgreSQL functions

I need to simple way to insert zval which has array type into PostgreSQL table. (I need to check/convert then insert) Python has similar API for PostgreSQL. (insert/update/delete/select) I've wrote it in C that do the same thing, so I added module functions do the same. $fields =

Re: [PHP-DB] New PostgreSQL functions

Adam Voigt wrote: think it's funny PHP has so many ways to do certain things, and so few ways to do other things. =) I forgot to ask. May I ask what kind of features/functions are missing? It does not have to be about PostgreSQL module. -- Yasuo Ohgaki -- PHP Database Mailing List

Re: Re: [PHP-DB] New PostgreSQL functions

Well since I've programmed in PHP for a while, I think PHP is quite capable in damn near all of the possible programming areas. But for instance, here are some of their complaints: 1. Weak PHP-Internal Date Manipulation Functions, on certain sites we do quite a bit of non-sql based date

Re: [PHP-DB] New PostgreSQL functions

Adam Voigt wrote: Well since I've programmed in PHP for a while, I think PHP is quite capable in damn near all of the possible programming areas. But for instance, here are some of their complaints: 1. Weak PHP-Internal Date Manipulation Functions, on certain sites we do quite a bit of

[PHP-DB] Apology for htaccess post

Hi All I accidentally posted a topic concerning htaccess in this list. In my rush I posted to this list which was not intentional. I humbly apologize for this and will try to slow down in the future And check to where I am posting. I am sorry if this caused any annoyance to any

[PHP-DB] Re: Making a txt file from db data, is it possible?

Hi! Ok, I think I maybe have to explain this a little better : ) I have this website that have a webshop that is driven by mysql and php. This is working fine, but when a customer puts something into his cart and he is sending his order, I would like to send this order by fax to the store

RE: [PHP-DB] Re: Making a txt file from db data, is it possible?

fopen() fwrite() fclose() -Original Message- From: Raymond [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 12:05 PM To: Frank Flynn; [EMAIL PROTECTED] Subject: [PHP-DB] Re: Making a txt file from db data, is it possible? Hi! Ok, I think I maybe have to explain this a little

[PHP-DB] Re: executing cgi

In article 000d01c1df6c$962e8e20$0300a8c0@alex, [EMAIL PROTECTED] says... hey guys, kinda OT for the db list, but since most ppl know a lot about php can somehow tell me how to execute a cgi script within a php page? Thanks! I could, but I'll just point you to the manual and the Program

[PHP-DB] Stroing info in a variable

I am really new at this PHP stuff, so please go easy on me. I am trying to query the database and then store the result of the query into a variable to compare to another variable. This is for a login function so for example: $c1 = ociparse($db, select ssn from schema.table where ssn =

[PHP-DB] Multiple selects?

Hi all, You are probably getting tired of me asking questions but I have another and will try to keep them down from now on. If I have let's say five items with different id's, image's and so forth how do I display all items on one page. Do I have to use multiple selects or is there another

[PHP-DB] Re: Multiple selects?

Are you talking about something that will display a list of products like this page: http://survivalherbs.com:8080/order/index.php?command=viewCategorycategory= Herbal+Remedies These are all gathered from the database with one SELECT statement then put together in the table with a while loop..

[PHP-DB] Re: Stroing info in a variable

This is what I have.. I think it's along the same lines as what you are asking.. If not, just ignore my drunken ramblings.. It isn't with oci stuff but if it's similar to what you need then you should be able to convert it over.. $result = $database-query( SELECT * FROM contacts WHERE

[PHP-DB] Re: Multiple selects?

Hi Bob, That would be just about what I am looking for. And I wouldn't mind seeing the code you have. Thanks Jennifer [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Are you talking about something that will display a list of products like this page:

[PHP-DB] Re: Multiple selects?

This is whole main() function.. I'm sure you didn't need all this but I wasn't sure what to send without possibly leaving out something important.. So here it is: function main( $category = ) { global $database, $PHP_SELF, $settings, $secure, $PHPSESSID, $items, $cartId; $inventory =

[PHP-DB] No results from query

I have the following query: SELECT * FROM ayny WHERE organization LIKE 'Hatzoloh' which produces no results, when I set $numrows = mysql_num_rows($result); it equals 0. When I do the following: SELECT * FROM ayny and then loop through the results, echoing them to the screen with the