Sander,
I'm also in Europe but here in the UK we prefer dd/mm/ and I've cobbled
together a couple of functions to handle this for me.
function dbdate($input)
{
$today = explode(-,$input);
$month = $today[1];
$day = $today[2];
$year = $today[0];
$p_date = $day . / . $month . / . $year ;
hallo guys!
i'm a newbie in php..I've installed phpMyAdmin on my pc, together with MySQL
and Apache with PHP 4 on Win98.
the index.php page is blank! any ideas/suggestions from u ppl?
gracias!
_
Join the worlds largest e-mail
Christopher,
I do a lot of work with Perl and have decided to see what this PHP is all
about. The best way for me to do that, is to just do a project. Here is what
I am looking to do. I would like to use PHP and the SQL language on a CSV or
Flat File Database. A lot of my work is on unix
hi guys, just looking for verification on this, as i don't think there's any
way to do it
Basically, i want to return the results for a search, but only return the
first 20 results from the start number given
LIMIT $start, 20
BUT... i'd like to have a page 1-whatever so if there are 65
Hello!
It's me again, with the magazine database : )
Is there any way to combine INSERT...SELECT and INSERT INTO so
one could insert a new row with a few values inserted by hand and others
from another table? something like
INSERT INTO mag_table (mag_id,issn,year,info,volume,numbers,remarks)
On Monday 14 January 2002 19:06, matt stewart wrote:
but presumably if i'm doing a SELECT count(*) FROM Designs WHERE Keywords
LIKE %sport%
followed by a SELECT * FROM Designs WHERE Keywords LIKE %sport% LIMIT
0,20
it's still using nearly as much processing time as just returning all the
On Monday 14 January 2002 19:21, Markus Lervik wrote:
Damnit.
Forgot to cc to the list, again. Here it is.
-- Forwarded Message --
On Monday 14 January 2002 12:55, you wrote:
hi guys, just looking for verification on this, as i don't think there's
any way to do it
Hi
Just noticed that NuSphere are now including the Gemini table type in their
free binary download. It seems that everything is there, apart from the
online backup, which is only available in the commercial version.
I need transactions, and took a look at InnoDB. But it seems to have some
I'm trying to use PHP and MySQL to query a table and write the contents to a
new file. When run the command to outfile it tells me I don't have
permissions. This is on a Unix machine.
mysql select * into outfile
/home/u1/funfun/www.somewebsite.com/catalogreq/
catalog.txt
mysql fields terminated
hallo guys!
i'm a newbie in php..I've installed phpMyAdmin on my pc, together with MySQL
and Apache with PHP 4 on Win98.
the index.php page is blank! any ideas/suggestions from u ppl?
gracias!
Can you post some of the code from your index.php?
Have you installed it all correctly, ie placed
I'm trying to use PHP and MySQL to query a table and write the contents to a
new file. When run the command to outfile it tells me I don't have
permissions. This is on a Unix machine.
I haven't run this on Unix myself, but I think this answer might be
useful. Someone please correct me if I'm
but presumably if i'm doing a SELECT count(*) FROM Designs WHERE Keywords
LIKE %sport%
followed by a SELECT * FROM Designs WHERE Keywords LIKE %sport% LIMIT 0,20
it's still using nearly as much processing time as just returning all the
designs and just using a get_num_rows and then only using
Have you (original post-er) tested performing a SELECT ... LIMIT 0, 20 and then
calling mysql_num_rows()?
Does it return 20 (the LIMIT) or the number of rows SELECT-ed before/without regard to
the limit?
=dn
- Original Message -
From: matt stewart [EMAIL PROTECTED]
To: [EMAIL
yep, it returns 20.
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: 14 January 2002 14:17
To: matt stewart; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] RE: LIMIT and get_num_rows
Have you (original post-er) tested performing a SELECT ... LIMIT 0, 20 and
then calling
Hi,
Is there a way to grab the ID (from ID field) while INSERTing a new record?
I am currently doing a separate INSERT then a SELECT query to find the most
recently added record by that user:
select ID from table where user = '$user' order by ID DESC limit 0,1
This does the trick but it may
My problem is that I'm trying to run the query via a telnet sessions before
I code through PHP. Is there a solution that anyone knows for this?
James Kupernik [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'm trying to use PHP and MySQL to query a table and
Hi.
What about Auto_increemnt field ??
Your's id can be auto_increment field. for example:
create table dupencja (id int(7) auto_increment not null, primary key(id));
so when you insert records:
insert into dupencja values('') - id will be 1
insert into dupencja values('') - id will be 2
this
I am sorry, I was not clear in my original request.
The id is auto-incremented. I want to grab the id so that I can use it as
part of a redirect
$q2=select Course_ID from course where HEI_ID = '$inst' order by Course_ID
desc limit 0,1;
$result2=mysql_query($q2) or die(q2 failed);
while
straight after you do the insert command, use the call:
$ID = mysql_insert_id();
The $ID is now the primary key for the record you just inserted.
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: 14 January 2002 14:56
To: Ireneusz Piasecki; [EMAIL PROTECTED]
Thanks, just what I was looking for.
George
- Original Message -
From: matt stewart [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 14, 2002 3:26 PM
Subject: RE: [PHP-DB] grabbing id from new record
straight after you do the insert command, use the call:
$ID =
That actually isn't a safe way to do it. Consider the following scenario:
Insert A occurs generating row Y in your table.
Insert B occurs generating row Z in your table.
select occurs (after insert A) to grab last ID inserted...your result is the
ID from row Z.
select occurs (after insert B),
Sam,
Thanks, I got the mysql_insert_id() tip a few seconds earlier.
However, my alternative method (which I will now drop in the interests of
efficiency) is perfectly safe.
It is impossible for the same user to go and create another record in that
verys small interim period between the two
I'm trying to create a new file on my server from the data in a table. When
I do the query it returns a permission error. I'm logged into my server
through a telnet sessions and the permissions on the dir allow me to write
to it. Here is the query below.
mysql select * into outfile
Hi, I'm looking for a good web based email client (preferably easy to setup and done
in PHP of course). We have a sendmail server that works great. I'm not sure how the
webmail systems work though. Can I use a different Apache server or do I have to setup
the PHP webmail on the actual mail
Hi there...
I have a problem mailing out approx. 180 emails (no attachments) using the
mail() php function. I loop through the email table once, sending the email
to everyone in the list.
The problem is that my page seems to time out when I send the emails, and it
refreshes itself. So if I
Hello,
I saw here somewhere a functions that breakes up a string at a nother string
like
120,120,122 and break up at ,
and it would result
$var[0]=120;
$var[1]=120;
$var[2]=122;
Thanks for the info
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
I have the following short web page to delete dealer bulletins from a
database. My page lists
all the bulletins in the database - id and subject. There is a text input
field to enter the bulletin
id number and hit the delete button, and the bulletin is deleted. It works
except after the submit
$var = explode(,,120,120,122);
-Original Message-
From: Thomas omega Henning [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 11:14 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Breaking strings up
Hello,
I saw here somewhere a functions that breakes up a string at a nother
Ok i got here:
When i type the ecrypted msg oomoeogoao ohooomoeo it types out omega hmeo
code:
elseif($cmd==@)
{
$sep=substr($enc,0,1);
$denc=explode($sep,$enc);
for($i=0;$istrlen($enc);$i++)
{
$test[]=substr($enc,$i,1);
$tests=$test[$i-2].$test[$i-1].$test[$i];
I just realized, I think that indices may not avail you when you're doing a search
based on double-sided wildcards.
I'm afraid you may be forcing a full table-scan by performing that kind of search.
So run a few benchmark tests. Maybe populate a test database with a large volume
(like
First, if $submit is not set, then the delete statement will be
executed. This will not return an array upon which mysql_fetch_array() will
act. Therefore $result will not be valid.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002
People, people:
In general, I do agree, that when a post starts with ... but i am getting lazy
I find it a little lazy. Well, it even claims to be lazy.
However, there have been a bunch of instances of newbie-attacks on this list
lately, and if that's the type of environment this is
Rick Emery [EMAIL PROTECTED] wrote on 01/14/2002 10:35:37 AM:
First, if $submit is not set, then the delete statement will be
executed. This will not return an array upon which mysql_fetch_array()
will
act. Therefore $result will not be valid.
I made this change:
if
Hi All,
I am currently looking for a reliable web host to host my personal website.
I know there are millions of web hosting companies that have PHP and MYSQL
support but I just can't trust any of the fully-assured and confident
webhosting ads anymore. I would like to get a service from a
Try www.aletiahosting.com $9.95 a month
-- Original Message --
From: Gurhan Ozen [EMAIL PROTECTED]
Date: Mon, 14 Jan 2002 13:17:59 -0500
Hi All,
I am currently looking for a reliable web host to host my personal website.
I know there are millions of
I use http://www.nomonthly fees.com
Initial buy-in is $200. However, that includes domain name registration,
500 megs of disks pace, 5 giga-bytes of band-width per month.
Complete PHP and MYSQL support. Bunch of other stuff too, like 1000 POP3
email boxes, PGP, shopping carts, etc.
After
I use FGDesigner.com. They have proven to be quite reliable and have a wide
range of plans available based on what you would need. You can check out
the website. My husband and I have been hosting our site through them for a
couple of years and never had any problems. I also know that they
Starting @ $20.00/month http://www.ocsny.com
-- Original Message --
From: Gurhan Ozen [EMAIL PROTECTED]
Date: Mon, 14 Jan 2002 13:17:59 -0500
Hi All,
I am currently looking for a reliable web host to host my personal website.
I know there are
In my previous email, I mentioned that http://www.nomonthlyfees.com provided
500 megs of disk space per account. I host several a domains by redirecting
domains (5) to sub-directories within that 500. I don't have a 500-meg
account for each domain. After the first year, the 500-megs cost
Go to www.webhostingtalk.com
this is forum about hosting services.
_
Valery Vlasyuk
http://www.cgi-network.net
- Original Message -
From: Shannon Kendrick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, January 14, 2002 8:43 PM
Well maybe I should just go out and join that perl list.
Christopher J. Crane wrote:
It's not that MySQL is not free, I know that and I am using iton my
development servers. The problem is some of the work I do is for clients
that do not have their own server. So their site is hosted by a
In another thread there's a comment about newbie bashing, the author now gets to see
that there are always two
sides to a story!
Christopher: I notice that you have found it necessary to explain your rationale for
They do not want to pay
the extra amount of money for a MySQL database. The fact
on 1/14/02 2:12 PM, Daniel Barton at [EMAIL PROTECTED] appended the following
bits to my mbox:
Well maybe I should just go out and join that perl list.
I was going to respond to you but I didn't have a good answer. :)
I don't know of any built in PHP functions that do what you are looking to
On 14 Jan 2002, at 13:17, Gurhan Ozen wrote:
I am currently looking for a reliable web host to host my personal
website.
I know there are millions of web hosting companies that have PHP and
MYSQL support but I just can't trust any of the fully-assured and
IS there anyone who have web
People, people!
I wish we could all just get along. ;^)
I did have a problem understanding the exact question. My response was a little
off-target owing to ambiguity.
Also, I did read (or participate in) the other threads mentioned by Mr. Neil, (aka Mr
anti-Guru basher.)
Sincerely,
Mr
Paul,
Just a clarification: I wasn't the original poster.
Christopher J. Crane was the original asker of the CSV/flat file database
question.
I do have a db to use.
Cheers,
db
Paul Burney wrote:
on 1/14/02 2:12 PM, Daniel Barton at [EMAIL PROTECTED] appended the following
bits to my mbox:
Don't know anything about ole 30 second timeout... what does it do?
I checked out phpbuilder, and tried the sleep function after each loop
iteration (didn't seem to work), so now am trying to send out the headlines
in groups of 50...
Sounds like others have the same problem. mail() is a php
Hello,
I'm running a select-query and getting this warning:
--
Warning: Unable to jump to row 100 on MySQL result index 2
--
I know the reason for the warning, but what exactly does this number two mean?
The query is in een for-loop and the resultnumber rises by 2.
Best regards,
Bas
--
Hi, Faye. There's a parm in the configuration file (php.ini) cleverly
called max_execution_time. Its default setting is 30. There's also a
set_time_limit() function that allows massaging this variable.
Does this help?
On Mon, 14 Jan 2002, Faye Keesic wrote:
Don't know anything about ole 30
I've been running a PHP4 script on a Linux server every day for quite a
while now. All of a sudden, it stops working. The error message is:
[ODBC SQL Server Driver][SQL Server]The cursor was not declared.
What does this mean and how can I fix it? Nothing has changed as far as I
know. Nobody
I just tried installing MDAC 2.7 on my SQL Server, based on another user's
recommendation. That didn't resolve the problem.
Any other ideas?
Thanks,
Pat
Patrick Brown [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I've been running a PHP4 script on a Linux
Is there a solution to this if you do not have edit
access to the php.ini file? [ie. a shared server]
I found this function that seems to be a solution.
What would the proper use be?
ignore_user_abort(TRUE); ???
http://www.php.net/manual/en/function.ignore-user-abort.php
Just came across this post and wondered if anyone has
done this - if so can you share some code?
The idea is to order emails by the mailservers
Would you just order the emails by domain name? [that
would group all aol.com, msn.com, yahoo.com emails]
On Tuesday 15 January 2002 10:53, olinux wrote:
Is there a solution to this if you do not have edit
access to the php.ini file? [ie. a shared server]
A number of the settings in php.ini can be set/altered from within your
script. Check out ini_set() and friends.
--
Jason Wong - Gremlins
54 matches
Mail list logo