e far bigger db's much
quicker than MySQL but the downside is that it's a very steep learning curve
after coming from mysql.
It's relatively easy to install & there are the drivers of course for PHP
but it'll take up a lot of your time to learn it to the extent of bei
Like by minutes... the first one is what I
> really want though Currently working with a dataset of 89 million records,
> will be expanding that to many many more times that... To the tune of possibly
> a couple billion records...
>
> Any ideas? :)
PostgreSQL?
;-)...
Cheer
I've got a mail form that automatically pulls in the addressee from a MySQL db,
and lets the sender
fill in his/her own info before sending. I figured out how to set up tests for
legal input in the
different fields, but I don't know how to incorporate the test results into my
form submission cod
De-lurking here. I am trying to modify a mailing script that I originally wrote to use a small form
to send mail to different people from a MySQL database. I would like to modify it so that instead of
using a form, the user's regular default email program opens on activating the link. I can't q
MySQL.However,there
are two
things I doubted as follows:
1.Can database owner who has been given lock privilege lock row??
2.I am not sure that using transaction as queries in PHP script is
the correct way to keep data's unity.
Regards,
Phil
Bastien Koert wrote:
> Transactions
e one data row may be modified by different user at the same time.
Should I use Transaction in my queries ?
Regards,
Phil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
n, I see the server being called and data being sent, but
nothing is being received. I'm just wondering if I've appended those two things
correctly.
TIA for your continued assistance.
Cheers --- Phil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
PHP lists
and sources, but I just cannot figure out this piece of the puzzle.
TIA for your suggestions, and for your patience with my lack of knowledge here.
-- Phil Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
tional variables for processing on the second page, I'm assuming
that the syntax would be (where $foo is another variable)
Thanks again for restoring my sanity!
Cheers --- Phil Matt
t this:
Send e-mail to $myrow[0]
Instead of the VALUE contained in the variable!
What am I doing wrong?
TIA --- Phil Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ault '-00-00 00:00:00',
PRIMARY KEY (`statid`)
) TYPE=MyISAM;
select count(weekday(stat03)) AS dayname from stat where and
date_format(rms03,'%m %Y') = '09 2003' and weekday(stat03) = '0'
I hope this is a simple question, I've googled for over a
ng an index on that field will speed things up lots -
especially as the table becomes big.
--
Phil Driscoll
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
o 24 goes 3 times with
a remainder of 4, hence
$mod=25%4
gives $mod=4
Cheers
--
Phil Driscoll
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Tuesday 12 August 2003 10:39 am, Phil Driscoll wrote:
> The modulus is the remainder after division hence 5 into 24 goes 3 times
> with a remainder of 4,
oops - 4 times with a remainder of 4 :(
--
Phil Driscoll
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
t; <[EMAIL PROTECTED]>
To: "Phil Dowson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, July 06, 2003 2:29 am
Subject: Re: [PHP-DB] Create Temporary Table
> Does the ip address of where you are trying to access the mysql database
>
7;t changed, and I have CREATE TEMPORARY
TABLE rights.
Any ideas why this is intermittent?
Thanks for your help!
Phil Dowson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
Could someone let me know if it is possible to pass a resultset of a query
to a single variable so it can be included as the message part of the mail
function?
Thanks!
Phil Dowson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi everybody,
If I edit the php3.ini and activate a extension, I can see the effect with
the function phpinfo(). This works with all extensions, exept mssql.dll and
mssql70.dll. What am I doing wrong?? I dont think this is a general
problem!!
And, ladies and gentleman, I need help... thx!!
--
On Tue, Jul 03, 2001 at 09:43:52AM -0400, Brian S. Dunworth wrote:
> Hi Phil...
>
>Since you have the server name (vs. the IP address) in the HOST= verb,
> make sure you have an entry in /etc/hosts for a server called 'staging'
yes, that's there, otherwise, I wou
a little more info...
I've just tried a few public oracle-sql tools.
Seems to have the same problem.
I can connect just fine to the database using sqlplus.
But when I try the hand-compiled tools, linked against
libclntsh.so, it doenst properly authenticate to the remote system.
Hey... $ORACLE_HO
On Mon, Jul 02, 2001 at 02:07:38PM -0400, Brian S. Dunworth wrote:
> Hi Phil,
>
>Make sure that the web user (usually 'nobody' on an Apache installation)
> has access to the $ORA_HOME/bin directory and permissions to execute the
> binaries within. Also,
On Mon, Jul 02, 2001 at 10:53:55AM -0400, Anthony Carlos wrote:
> Phil,
>
> Perhaps I'm being nit-picky, but shouldn't it be OCILogon("$user",
> "$PASSWORD", "$connect_string"); ?
I have tried both
$user="realuser";
$password=&
Hi folks,
I'm having difficulties getting php4 to connect to a remote oracle
database.
I have an entry in tnsnames.ora, along the lines of
shorthostname = (etc, etc)
and I can use "sqlplus user/name@shorthostname" to connect just fine, as
a regular user. Even without ORACLE_SID set, since I ha
The error is probably caused by you inserting a value (127) nto a unique or
key field which is identical to one in another record.
--
Phil Driscoll
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED
L support (but as with all versions
of php, it does not include MySQL itself).
Cheers
--
Phil Driscoll
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mai
sensible*/
}
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administra
Check www.p2p.wrox.com...more later on this
Phil J.
Nicolas Machado wrote:
> Hy, somebody knows if exist a driver for database access to DB2/400, running
> on AS/400.
> Something like a module.
>
> Thanks.
>
> ---
> Este Mail NO contiene Virus.
> Checked by
And store the file type - it does make a difference when you go to display
it..i.e. *.gif or *.jpg..
Phil J.
olinux o wrote:
> Best way to do it is to store the filename in the db,
> faster and really simple.
>
> What I have done at my site is write a script that
> uploads the
flexiblity, but
keep it simple enough that you don't have to join 30 tables together to
display one studen't class schedule...
Phil J.
Duke Normandin wrote:
I asked this a year or so ago, but never did receive a "practical" reply
> that I could understand. So I'll give it anot
ion to asp material...
Phil J.
Doug Schasteen wrote:
> I've been programming PHP w/ mysql for almost 2 years now for my company. We develop
>online testing and surveying software. We are currently running operations for a few
>specific companies where maybe 20-30 tests will be
Try stripslashes(fieldname) to "unescape" those slashes when retieving from DB
Phil J.
Jennifer Arcino Demeterio wrote:
> Hello all,
>
> I am having a problem in inserting text with apostrophe to mysql database.
>
> When a user fills out a form field that inclu
be entered in a text field
Phil J.
Joni Järvinen - Wandu wrote:
> Hey
>
> I'm quite new to databases so I though I'd ask you for
> some tips in designing a database.
>
> The db that I'm supposed to design holds information
> about workstations: Motherb
hope that type behavior will not be tolerated - the goal here is to share
info and all benefit and become more proficient - folks come into this from
all levels of experience - The only really stupid questions are those that
go un-asked!
My Thoughts,
Phil J.
Paul S wrote:
> I have a question tha
thing else if
it appears elsewhere - and don't change it's type!
Phil J.
- Original Message -
From: "Richard Scott Crawford" <[EMAIL PROTECTED]>
To: "Phil Jackson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, April 22, 2001 1:17
ntenttype");
echo $thisphoto;
?>
Make sense? Follow the link I gave to the previous post for more extensive
info...
Phil J.
Sharmad Naik wrote:
> I have written a small script having connectivity with postgresql which
> can upload an image and display the already uploaded
Probably the most efficient method - but if you must see:
http://www.zdnet.com/devhead/stories/articles/0,4413,2643888,00.html
For an excellent tutorial by Julie Meloni - her knowledge of PHP is
impressive!
Phil J.
Johannes Janson wrote:
> Hi,
>
> why storing the pictures in the
if any...don't remember!) you will find them easier to read,
maintain, and also spot obvious errors.
Hope this helps,
Phil J.
Todd Pillars wrote:
> I have checked the mysql.com docs and phpbuilder.com and zend.com and I am
> more confused than ever on selecting a single common rec
SERT INTO Images (..all the fields...) VALUES ('$filecontents',...and all
the rest of the fields')";
$sql_result = mysql_query($sql,$someconnection) or die ("could not insert into DB");
mysql_close($someconnection);
-
page 1 - set a session variable $visitedPageOne = true
On the top of that page, first thing - check for the value of $visitedPageOne, if
true, redirect to the next page, ect.
Phil J.
olinux wrote:
> I am using sessions to store variables until all forms have been filled out. at this
>po
If you are speaking of Microsoft SQLServer, there are some lists that
specialize in this product at http://www.sqlteam.com
Also - try www.4guysfromrolla.com and asp101.com
hope this helps a little,
Phil J.
"André M.S.\"
> How can i use MSSQL + IIS?
> i´m having some pro
Hi,
Check out
http://www.zdnet.com/devhead/stories/articles/0,4413,2643888,00.html
for a good workable example of using PHP/MySql to do this - the principles
should
be the same.
Also, search www.asptoday.com for the word "blob" to find some good articles
on the topic.
Phil J.
Marc
Looks reasonable enough
LeTourneau - hmmm - Longview, Texas?
Phil J.
Mark Roedel wrote:
> > -Original Message-
> > From: Jordan Elver [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 04, 2001 10:46 AM
> > To: PHP Database Mailing List; PHP General
Hmmm...given that the form fields all had the same names - i.e. you were
performing
the same sql, you could use and include or "required" file that did all the DB
work.
Or - you could have a generic includr file function that you passed a
connectstring and
sqlstring to as variables..
DB2 server on PC, if you will) for future
development. Best I can say here to anyone is "stay away"!
My vote is with MySql, unless you'vegot to do triggers, sub-selects, or
views, or simply have to create work for a pre-existing DBA
Phil J.
"Brian.J.Mauter" wrote:
mber.focus()
alert("Enter fleet vehicle number")
return false
}
Have a look at http://www.wsabstract.com/ for good javascript info.
good luck,
Phil J.
"Julio Cuz, Jr." wrote:
> Hi--
>
> I have a form that cannot have a specific field blank, so I would l
-like, as the "arrows" would somehow comprise a form.
Phil J.
CC Zona wrote:
> In article <001301c0bafa$34d15be0$[EMAIL PROTECTED]>,
> [EMAIL PROTECTED] ("David Drummond") wrote:
>
> > Can anyone tell me what is the best way to implement displaying multi
Yes, exactly. What you want are image tags, as in
http://www.fractal-vibes.com
.
"Stuart J. Browne" wrote:
> Hello,
>
> I'm trying to retrieve and output all the binary images in my images table.
> This is what I have,
>
> $result = mysql_query("SELECT * FROM images",$db);
>
> if ($myrow =
"mime_mail.inc" and a "mail.php" file that are
good examples.
Phil J.
"Pedro M. S. Oliveira" wrote:
> hello all. this is what i need to do
> i have a dinamic page, buitl with mysql and php,
> and then i have this form saying, send this page to a frie
color isn't
nor is model.
$sql = "Select * from someDB where make =" . $make;
If $model > "" {
$sql = $sql . " And model = " . $model;
}
If $color > "" {
$sql = $sql . " and color=" . $color
}
Build your sql string incrementally a
What is retrieved if you do a Select Count(*) from myDb where
condition = parameters?
Seems your result set should contain this value...
Phil J.
DC wrote:
> Hi All
> I cant quite work out how to count the number of rows in my mysql db that
> match a certain critieria and the show th
I think your only choices are to put this value into either a database or if
you are using
php4 - to use a session varible - or use a cookie if you are trying to
persist this value
across multiple pages for multiple users...or pass as a querystring to the
next page..
or as a hidden form variable i
an do in a few lines with ODBC.. - but I have a
project
using both DB2 on a mainframe and DB2 UDB - so I am very interested in your
thoughts on all this!
Phil J.
Chris Book wrote:
> Hi,
>
> I've compiled php before with --with-ibm-db2 to use DB2's CLI driver. Now
> I'm w
Dunno without looking at code, but try storing the value of $customer into a
local variable when the script is invoked - something is wiping it clean.
my thunks,
Phil J.
Scott Kalbach wrote:
> I am having a problem with losing a variables value. What I am doing is
> taking the value
uckle
and offer to send
consultants for hundreds of dollars an hour to tell you what you could
figure out if their
reference manuals weren't circular refernces to obtuse garbage...
Phil J.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
Perhaps the quote marks within quote marks? PHP,as is javascript, very
particular..
Try:
echo "Name: $row['user_id'].'\n"; or some such.
or
echo "Name".$row[user_id]."\n";
It's the quote marks within that are playing havoc..
Phil J.
Chris Ha
$sql = "INSERT INTO Images (Image,
ImageType,ImageGallery,ImageLink,ThumbnailLink) VALUES
('$filecontents','$txtImageType', '$txtImageGallery', '$txtImageLink',
'$txtThumbnailLink')";
$sql_result = mysql_query($sql,$connection) or die
the possibility of being caught out by errant scripts running
away with your machine.
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
y strings (and hence your
mysql_fetch_array calls will have an entry for that field containing an
entry string) and then back again to null. I've just tried it on my machine
and it works a treat.
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http
Good heavens, another PHP developer in Leeds:)
I think (I haven't tried this!) you could change the field type to
not-null - then your array should get populated with empty strings for any
records where this field is not set.
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
} elseif ((int)$Date_array[2] >59 AND (int)$Date_array[2] <100) {
$Date_array[2] = "19". $Date_array[2];
}
/*Make a unix time stamp out of the array elements */
$TransDate = mktime(0,0,0,$Date_array[1],$Date_array[0],$Date_array[2]);
Phil
--
PHP Database Mailing Li
I suspect that what is going on is that your code is just going around in
circles - the redirect is just opening the same page over and over again
because your logic is flawed somewhere. Instead of outputting the location
header, output an http://www.dialsolutions.com
http://www.dtonline.org
--
om the command line run e:/php4/php.exe -i)
If that works ok (and prints out the phpinfo() html, then double check your
httpd.conf.
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org
--
PHP Database Mailing List (http://www.php.net/)
m php somehow and then use the appropriate C
function to talk to the tables and then pass data back to the php class?
Any other way of doing what I want?
Thanks,
Phil.
-
Philip Rhoades
Pricom Pty Limited (ACN 003 252 275)
GPO Box 3411
Sydney NSW 2001
Australia
Mobile: +61:0411-185-65
I want?
Thanks,
Phil.
-
Philip Rhoades
Pricom Pty Limited (ACN 003 252 275)
GPO Box 3411
Sydney NSW 2001
Australia
Mobile: +61:0411-185-652
Fax: +61:2:8923-5363
E-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addi
64 matches
Mail list logo
