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
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.
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
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: Mond
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 t
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 s
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 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 -> ww
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 kno
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 = pg
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 (http:/
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 manipulat
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 o
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 u
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
neares
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 bet
Yes, I'd say this is the way to go. As the customer submits the order
simply write out the file as you'd like it. It doesn't take long and you
have all the data in the cart (I'm not sure how you're dealing with the
cart - saving it in the DB, cookies, session variables - but it doesn't
r
a little lateral thinking.
there are a number of email to fax services out there (www.j2.com is one).
Last time I looked it was as cheap to use as a normal fax, and it saves much
hassle. just email the order to their servers and it gets faxed.
Might be worth a look
Peter
--
You can't have NOT NULL assigned to a text field.
george
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 10:11 AM
Subject: [PHP-DB] Error creating new table
> I am trying to create the following table using PHPMyAdmin:
>
> CRE
The problem is that he assigned a length to a TEXT field. You cannot do
that.
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 3:13 AM
To: [EMAIL PROTECTED]; Lisi
Subject: Re: [PHP-DB] Error creating new table
You can't have NOT NULL assig
you sure, I use NOT NULL on text fields all the time and it works fine.
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
O
I'm building a site that will eventually hold several hundred photos. (Kids
soccer photos.) The first page will display a table of 9 thumbnails, with
buttons at the bottom to move 9 forward or 9 back (after the first 9, of
course).
The names of the files will be in a MySQL database and the pages
>You can't have NOT NULL assigned to a text field.
So...should it be
maintext text NULL,
or just
maintext text
???
Russell Griechen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I to have about 16 text fields in my db that are NOT NULL and they work
fine.
Just an observation.
Jennifer
"Lisi" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am trying to create the following table using PHPMyAdmin:
>
> CREATE TABLE IF NOT EXISTS ayny(
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!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!
In article <000701c1df50$0e2a1060$[EMAIL PROTECTED]>, [EMAIL PROTECTED]
says...
> I'm building a site that will eventually hold several hundred photos. (Kids
> soccer photos.) The first page will display a table of 9 thumbnails, with
> buttons at the bottom to move 9 forward or 9 back (after the
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
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 = $passwo
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 easi
Are you talking about something that will display a list of products like
this page:
http://survivalherbs.com:8080/order/index.php?command=viewCategory&category=
Herbal+Remedies
These are all gathered from the database with one SELECT statement then put
together in the table with a while loop..
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 cartId='$
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:
>
>
ht
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 = $dat
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
follow
Lisi a écrit :
> I have the following query:
>
> SELECT * FROM ayny WHERE organization LIKE 'Hatzoloh'
>
try "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 followin
For the record, the problem was assigning a length to a text field. The NOT
NULL part is fine.
Thanks everyone for your input!
-Lisi
At 04:59 PM 4/8/02 -0700, Jennifer Downey wrote:
>I to have about 16 text fields in my db that are NOT NULL and they work
>fine.
>Just an observation.
>
>Jenni
That worked...why?
-Lisi
At 09:23 AM 4/9/02 +0300, Marius Ursache wrote:
>Lisi a écrit :
>
> > I have the following query:
> >
> > SELECT * FROM ayny WHERE organization LIKE 'Hatzoloh'
> >
>
>try "SELECT * FROM ayny WHERE organization LIKE '%Hatzoloh%' "
>
> >
> > which produces no results, wh
Lisi a écrit :
> That worked...why?
>
because in your table you wrote "_SPACE_Hatzoloh_SPACE_"
or _NEWLINE_Hatzoloh_NEWLINE_ ...any way you wrote "Hatzoloh" and some
caracter that you don't see it so easy (space, tab, new_line).
% is like * on regular expresion (wildcard)
>
> -Lisi
>
> At 09
38 matches
Mail list logo
