This is good brain-storming guys!
Better to use an integer rather than a date field as 2 simultaneous
transactions can still occur on the same second; most date time fields
are accurate only to the nearest second.
Good point, John.
However MySQL (AFAIK) does not have any time functions
Frank,
As yet no response from Garry, but I wanted to ask:
You already have DateTable set up (presumably), so extending its application
into a relationship with the
breeding table is no big deal. Given that one suggestion was that Garry could
consider storing monthly
statistics in
I'm working through the New Riders MySQL book and I get the following error
when running a php script, can someone help? Thanks, Matt -
Parse error: parse error in c:\program files\apache
group\apache\htdocs\genesis\dump_info.php on line 25
Here's lines 25 -
printf (TD%s/TD\n,
Well I have oracle 8.0.5 running on Win xp, with php4 and apache.
When I define php for using php_oci8.dll it gives me this error:
Warning: Unable to load dynamic library 'c:\php\extensions\php_oci8.dll' -
The specified module could not be found. in C:\htdocs\php.php on line 4
Well for what i
I want the date to automatically be updated. So if a post was made on
2/10/2001 I would like it to put it automatically in the database.
I do have a column called Date and the datatype is set to date. But when
I add a record even if the sql states to insert the date it doesn't, or does
the
Hi,
This is a technique I first saw in the O'Reilly book
Oracle Design. The idea is to use integers rather than
dates, and treat the integers as semaphores (or latches in
Oracle terminology). This technique is very portable
as it does not require date types.
Create an integer column called
I have PHP 4.0.6 compiled as an Apache 1.3.20 module with OCI8 and MySQL
on RedHat 6.2. I use persistent connections with OCI8 to avoid the
costly connection construction for Oracle for each request. However, I
notice that these persistent connections get poisoned under certain
circumstances.
actually, try using $park = NULL instead go $park = NULL;
in php NULL is the same that which is the same that 0
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Andy' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, February 01, 2002 7:51 AM
Subject: RE: [PHP-DB]
From Windows Help:
You can use Data Sources Open Database Connectivity (ODBC) to access data
from a variety of database management systems. For example, if you have a
program that accesses data in a SQL database, Data Sources (ODBC) will let
you use the same program to access data in a Visual
From Windows Help:
You can use Data Sources Open Database Connectivity (ODBC) to access data
from a variety of database management systems. For example, if you have a
program that accesses data in a SQL database, Data Sources (ODBC) will let
you use the same program to access data in a
Thanks to those who replied...but I was hoping perhaps
of a creative idea in solving the problem of deleting
from multiple tables...I can't believe I will have to
delete 265 records (x 3 tables) by hand... is there
any other way out? I cannot install version 4 since it
is on a hosted site.
Hi there, you could grab the whole file name from db, form, etc... strip it
down to the '.jpg' , concatenate $IDNUMBER . $NUMBER OF PICTURE , then
rename it using the combination of $IDNUMBER . $NUMBER OF PICTURE .
?php
$myfile = 'webgraphic.jpg';
$IDNUMBER = 55;
$NUMBEROFPICTURE = 999;
Hi there everyone,
Once i've gotten an image from my DB, is it possible to resize it proportionatly?
Currently all images are resized to 160x120 but for some images this is really bad as
it stretches them, is there a way for example where I can go through the loop of
images and then resize
hi there. check out the image functions : 'imagecreatefromjpeg',
'imagecopyresized', 'imagecreatefromgif', and 'imagecreate' in the php
manual http://www.php.net
hth joe
;0
Chris Payne [EMAIL PROTECTED] wrote in message
hi there. if you are unable to set it on the db end why not insert/update
the current date along with your insert and update queries?
hth joe :)
Todd Williamsen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I want the date to automatically be updated. So if a
did test to see if $id was actual the value you were expecting? is $id an
auto increment field?
Chris Payne [EMAIL PROTECTED] wrote in message
000c01c1a23a$ef779900$0200a8c0@chris">news:000c01c1a23a$ef779900$0200a8c0@chris...
Hi there,
Can anyone see what is wrong with this query? I am trying
Great, simple solution, which I really should have thought if myself
considering I did semaphores, IPC and other process management stuff last
year in my Uni course!
Cheers Everyone, I'll let you know what solution I use in the end (probably
won't know until Easter when my second prototype/ beta
17 matches
Mail list logo