On 21 January 2011 12:39, Karl DeSaulniers k...@designdrumm.com wrote:
Very informative,
Thank you Richard.
I will have to flag this one and come back to it.
My database structure may require something of this measure down the line
with the auditing ability I plan on building into the admin
Thanks Robbyka,
The username would be what your referring to with the .idvip
So..
select username, userlevel,email, timestamp from .USERS., .VIP.
where .VIP..username=.USERS..username;
yes?
Karl
On Jan 20, 2011, at 7:24 PM, Robbyka Gheo wrote:
i think its wrong, try this script?
select
Hi Robbyka,
.USERS. and .VIP. are constant variables used to hide the actual
names of the tables for security reasons.
Those variables will have content. Not sure what you mean by semi
locon like = from .users;
The user names are set up to be unique. No two user names can be
identical and
@lists.php.net
Subject: Re: [PHP-DB] Configuring PHP with GD and JPEG support
On Jan 10, 2011, at 9:35 AM, mike dorian wrote:
Hello,
Questions with regards to compiling PHP to support GD with JPEG on
64-bit CentOS 5.5.
1) Specifying folder for jpeg library
When I execute the following command
Resolved itself, just had to reboot. Works fine now.
Thanks anyway :)
From: cristiano_di_bu...@hotmail.com
To: phps...@gmail.com
Subject: RE: [PHP-DB] Connecting to MySQL
Date: Fri, 14 Jan 2011 21:58:33 +0100
It outputs:
PDO
PDO support enabled
note that you'll have to restart apache after any changes to httpd.conf/php.ini
in your case httpd.conf was changed when u installed PDO
Kranthi.
http://goo.gl/e6t3
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
);
}
create_image();
?
From: k...@designdrumm.com
Date: Mon, 10 Jan 2011 17:10:35 -0600
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Configuring PHP with GD and JPEG support
On Jan 10, 2011, at 9:35 AM, mike dorian wrote:
Hello,
Questions with regards to compiling PHP to support GD
On Fri, Jan 14, 2011 at 2:15 PM, Cristiano Di Buduo
cristiano_di_bu...@hotmail.com wrote:
I just downloaded both PHP and MySQL, both newest stable versions, both are
working well, but when i try{} to :
$dbh = new PDO('mysql:host=localhost;dbname=test', user, passwd);
i catch{} a could
Glad you resolved it.
Overall, I have to recommend the OCI8 extension over the unmaintained
(like much of PDO) PDO_OCI extension.
Chris
On 01/13/2011 11:36 PM, Karsten Lehmann wrote:
I found out that the error depends on the wrong character set of the Oracle
Database. In my case this was a
Try increasing this: PDO::MYSQL_ATTR_MAX_BUFFER_SIZE
More info here: http://php.net/manual/en/ref.pdo-mysql.php
On Thu, Jan 13, 2011 at 7:23 PM, Karsten Lehmann lehm...@maqsima.de wrote:
Hello
I try to read a 2000 character long string out of database. The database is
an oracle 10g Express
Doesn't work.
I got the following error after i set the parameter in the PDO construct
Fatal error: Undefined class constant 'MYSQL_ATTR_MAX_BUFFER_SIZE'
IMHO this is only a MYSQL parameter but i worked with oracle.
Am 13.01.2011 10:27, schrieb kesavan trichy rengarajan:
Try increasing this:
you have renamed places_data table to 'a'
2011/1/13 Harvey har...@harveyk.com:
Hello,
I have a query on a page that used to work fine, but is now generating an
error.
I assume that the version of php or mysql was updated on the webhost server
or something like that?
Here is the query:
Thanks, I got it working now, had to use the a/b/c thing a few times
-Original Message-
From: jose [mailto:jojap...@gmail.com]
Sent: Thursday, January 13, 2011 9:52 AM
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Query syntax error?
you have renamed places_data table to 'a'
2011/1
I found out that the error depends on the wrong character set of the
Oracle Database. In my case this was a Western Europ instance of the
Database. The same data on a UTF8 instance was displayed as excpected.
Am 13.01.2011 10:42, schrieb Karsten Lehmann:
Doesn't work.
I got the following
On Jan 10, 2011, at 9:35 AM, mike dorian wrote:
Hello,
Questions with regards to compiling PHP to support GD with JPEG on
64-bit CentOS 5.5.
1) Specifying folder for jpeg library
When I execute the following command, am I saying the full path to
libdir is at /usr/source/lib64?
Hi,
Thanks to everyone who assisted me.
Removing the line:
::1 localhost
from the c:\windows\system32\drivers\etc\hosts file did the trick and
allowed me to access MySQL databases without any problems.
I confirmed this was the correct solution by re-adding the line and seeing
it fail
Hello,
I have a script that is calling sqlite_open, however, sqlite_open can't be
found on my systems. I'm running RHEL5 and I get the following relevant
output from php -i:
PDO support = enabled
PDO drivers = odbc, sqlite
pdo_sqlite
PDO Driver for SQLite 3.x = enabled
PECL Module
On 1/7/2011 12:10 AM, Fahim M wrote:
Hi
I have a certain number of mysql tables(relation), say 50, some of them
having 5 fields and some with 6 fields. a particular search item may be
found in multiple tables with multiple rows. I am using a loop to find all
those.
My problem is I want to first
On Fri, Jan 7, 2011 at 9:46 AM, Toby Hart Dyke t...@hartdyke.com wrote:
On 1/7/2011 12:10 AM, Fahim M wrote:
Hi
I have a certain number of mysql tables(relation), say 50, some of them
having 5 fields and some with 6 fields. a particular search item may be
found in multiple tables with
Mike,
A plain HOST file should have the commented part at the top, and only 1
reference to localhost unless you are creating Virtual hosts.
I would suggest removing the ::1 line
BR
Gavin
On Fri, Jan 7, 2011 at 4:18 AM, michael manning
michaelgmann...@gmail.comwrote:
Hi,
I swapped out
On Fri, Jan 7, 2011 at 15:06, Gavin Chalkley gavin.chalk...@gmail.com wrote:
Mike,
A plain HOST file should have the commented part at the top, and only 1
reference to localhost unless you are creating Virtual hosts.
I would suggest removing the ::1 line
As long as he never plans to use
On Thu, Jan 6, 2011 at 01:13, michael manning michaelgmann...@gmail.com wrote:
Hi,
I have installed MySQL 5.1.52, Apache 2.2.15 and PHP 5.3.2 on my Windows
Vista computer.
The MySQL works fine with the command line client and I have tested the
Apache and PHP and it appears fine when I test
On Thu, Jan 6, 2011 at 02:52, Miriam Natanzon miriamna...@gmail.com wrote:
Hi,
I want to build an internal module for common DB-involved tasks: starting
with connection, simple queries and go on to multiple pages of results and
connecting tables and so on.
We are currently working with
Hi Daniel,
When testing with the CLI, netstat shows:
=
C:\Users\mmanningnetstat -b
Active Connections
Proto Local Address Foreign AddressState
TCP127.0.0.1:80 mmanning-PC:49391 ESTABLISHED
[httpd.exe]
TCP127.0.0.1:3306
Hi,
I swapped out 'localhost for '127.0.0.1' in the url but this had no effect.
I had a look at my hosts file at c:\windows\system32\drivers\etc and this
contained:
# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file
On Wed, Jan 5, 2011 at 21:23, Ron Piggott
ron.pigg...@actsministries.org wrote:
I only know how to do one array at a time, using FOREACH, like this:
===
echo ul\r\n;
foreach($match_words as $word) {
echo li . $word . /li\r\n;
}
echo /ul\r\n;
===
You could either swap
Subject: Re: [PHP-DB] Word Matching Application
On Wed, Jan 5, 2011 at 21:23, Ron Piggott
ron.pigg...@actsministries.org wrote:
I only know how to do one array at a time, using FOREACH, like this:
===
echo ul\r\n;
foreach($match_words as $word) {
echo li . $word . /li\r\n;
}
echo
The FOREACH below is giving me the error:
Invalid argument supplied for foreach()
Not surprising as the $match_words will contain a boolean result from
shuffle. Shuffle works directly on the variable it is given and returns
true or false, depending on success. rtfm ;-)
Does anyone
On 1/3/2011 10:52 PM, Ethan Rosenberg wrote:
Dear List -
I would like to have two(2) forms in one PHP script. I would like to
have the forms appear sequentially; ie, that the first form would
appear, the data would be entered, and then the second form would
appear, the data would be
On Jan 3, 2011, at 5:17 PM, Ethan Rosenberg wrote:
'Submit Ktten'
Shouldn't this be..
'Submit Kitten'
If your asking for it to explicitly equal that (===), then you need
to spell Kitten with an i in it?
But, that may not be what is actually wrong, just somehting I think I
caught.
On Thu, Dec 30, 2010 at 14:07, Ethan Rosenberg eth...@earthlink.net wrote:
Josh -
I used use \d{3}-\d{3}-\d{4}.
It works beautifully!!
Just keep in mind that invalid numbers will also pass that check,
such as 000-000- or 123-456-6789. That's why my example was a bit
more involved.
Hi Ethan,
Could you do a string compare and check at certain characters for a
dash?
IE:
check the second character to see if it is a dash for 1-800...
if that is not a dash, check the fourth character for a dash, 469-9...
then the other places where dashes would be based on those two
You could also help them out a little with something like..
$phone = str_replace((, , $phone);
$phone = str_replace(), -, $phone);
HTH,
Karl
On Dec 29, 2010, at 6:27 PM, Josh Kehn wrote:
On Dec 29, 2010, at 7:12 PM, Ethan Rosenberg eth...@earthlink.net
wrote:
Dear List -
Thank you
i am not 100% sure but should you not remove ' from around the
variables to have (NULL, :f1, :l1 etc? prepared statements take care
of escaping and quoting.
http://www.php.net/manual/en/pdo.prepare.php
does it help?
art
--
Visit me at:
http://artur.ejsmont.org/blog/
--
PHP Database Mailing
On Sat, Dec 18, 2010 at 17:02, David Hutto smokefl...@gmail.com wrote:
or maybe it's saturday morning and i'm drunk?
This seems to be the most likely, and considering how all messages
are permanently and independently archived and propagate throughout
the Internet, it might be a good reason
On Mon, Dec 20, 2010 at 7:37 AM, Daniel Brown danbr...@php.net wrote:
On Sat, Dec 18, 2010 at 17:02, David Hutto smokefl...@gmail.com wrote:
or maybe it's saturday morning and i'm drunk?
This seems to be the most likely, and considering how all messages
are permanently and independently
On 20/12/10 15:38, Ron Piggott wrote:
I am working on the query below. It’s purpose is to manage the RSS Feed for
the site.
The part of the query I am struggling with is:
SUM(`include_in_rss_feed`) AS current_rss_feed
What I need is the total value of *ALL* the `include_in_rss_feed` , not
On Fri, Dec 17, 2010 at 12:16, Richard Quadling rquadl...@gmail.com wrote:
And have you seen all the sad faces ...
: {
on http://docs.php.net/manual/en/control-structures.goto.php#92763
Can't be good for them.
If only people knew how many hours - literally, hours - it took me
to keep
On 14 December 2010 21:53, Ron Piggott ron.pigg...@actsministries.org wrote:
What change is needed to this query so if “currently_in_rss” is NULL it will
be assigned a value of 0
SELECT `reference`, COUNT(`reference`) AS currently_in_rss FROM
`ministry_profiles` WHERE `rss_feed_include` =
On 15/12/10 21:42, Richard Quadling wrote:
On 14 December 2010 21:53, Ron Piggottron.pigg...@actsministries.org wrote:
What change is needed to this query so if “currently_in_rss” is NULL it will be
assigned a value of 0
SELECT `reference`, COUNT(`reference`) AS currently_in_rss FROM
On Tue, Dec 14, 2010 at 12:34, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your help.
How do I reset auto_increment so that the primary key will start from 1.
The primary key is now 2421. I have deleted all the data in the table and
started over, and the primary
At 12:38 PM 12/14/2010, Daniel Brown wrote:
On Tue, Dec 14, 2010 at 12:34, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your help.
How do I reset auto_increment so that the primary key will start from 1.
The primary key is now 2421. I have deleted all the data
On 12/14/2010 1:02 PM, Ethan Rosenberg wrote:
At 12:38 PM 12/14/2010, Daniel Brown wrote:
On Tue, Dec 14, 2010 at 12:34, Ethan Rosenberg eth...@earthlink.net
wrote:
Dear List -
Thanks for all your help.
How do I reset auto_increment so that the primary key will start
from 1.
The
On Tue, Dec 14, 2010 at 13:02, Ethan Rosenberg eth...@earthlink.net wrote:
UPDATE tablename AUTO_INCREMENT=1;
mysql update Visit3 auto_increment=1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax
On Tue, Dec 14, 2010 at 13:43, Toby Hart Dyke t...@hartdyke.com wrote:
Use 'ALTER tablename AUTO_INCREMENT=1' rather than 'UPDATE tablename
AUTO_INCREMENT=1'.
Yeah, again, my fault. Not enough coffee on this cold (~7F)
winter's day, perhaps.
--
/Daniel P. Brown
Network Infrastructure
On Tue, Dec 14, 2010 at 4:53 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
What change is needed to this query so if “currently_in_rss” is NULL it will
be assigned a value of 0
SELECT `reference`, COUNT(`reference`) AS currently_in_rss FROM
`ministry_profiles` WHERE
On Fri, Dec 3, 2010 at 4:42 AM, Neil Jackson n...@webcoza.co.za wrote:
Hi,
I am designing a website that requires storing data in 3 different languages,
English, Portuguese and Tetum.
When I read the data from the database the accented characters are displayed
as a ? in Firefox and Opera, a
If you are trying to do some automation type stuff you might want to look at
something like Robo Task -
http://www.robotask.com/
You can schedule a browser open to specified URL's (php script) and have it
close the window handle after the page is loaded.
Regards,
Will T
Chief Technical
Dear Ron
Or try this
SELECT * FROM `paypal_payment_info` WHERE ifnull(os1, '')
'commission_paid'
regds
amit
The difference between fiction and reality? Fiction has to make sense.
On Sat, Dec 4, 2010 at 7:55 AM, Ron Piggott
ron.pigg...@actsministries.orgwrote:
When I do the
On 4 December 2010 11:40, Amit Tandon att...@gmail.com wrote:
Dear Ron
Or try this
SELECT * FROM `paypal_payment_info` WHERE ifnull(os1, '')
'commission_paid'
regds
amit
The difference between fiction and reality? Fiction has to make sense.
On Sat, Dec 4, 2010 at 7:55
On Fri, Dec 3, 2010 at 6:25 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
When I do the following query in mySQL only 1 record is retrieved.
SELECT * FROM `paypal_payment_info` WHERE `os1` NOT LIKE 'commission_paid'
I am surprised by this. This one record has no characters in it,
? Bastien phps...@gmail.com wrote in message
news:962f0fd6-0eaa-495a-831e-da05bc1ab...@gmail.com...
On 2010-11-26, at 7:46 PM, None abcdef...@mailinator.com wrote:
?Could be a silly question, but i can't find a method to use placeholder
(MySqli) without passing by reference (bind_param) or
On Nov 27, 2010, at 10:08 AM, Daniel P. Brown wrote:
one primary question: are you using the mysql_*
family, mysqli_* family, or another method of interfacing with MySQL?
mysql_
$results = mysql_query($query) or die(mysql_error());
Don
--
PHP Database Mailing List
Read through this:
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html, especially
the last 2 paragraphs.
On Sun, Nov 28, 2010 at 12:40 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
My question is with the syntax below: If the “ON DUPLICATE KEY UPDATE
`name` = '$name'”
On Nov 27, 2010, at 1:24 PM, Don Wieland wrote:
On Nov 27, 2010, at 10:44 AM, Daniel P. Brown wrote:
Note how you keep changing case here. For example, m.aucciim_id
vs. m.AUCCIIM_ID. Also note that all of this is cAsE-sEnSiTiVe.
You are right. But it still chokes in PHP:
select m.*
On 2010-11-26, at 7:46 PM, None abcdef...@mailinator.com wrote:
?Could be a silly question, but i can't find a method to use placeholder
(MySqli) without passing by reference (bind_param) or receive by reference
(bind_result)? is that right? I really hate use reference becouse in large
Dear list -
Thank you for all your excellent help.
I wish to search a table. In this case, I have five(5) columns:
site, Record, BMI, Weight and Height.
I wish to be able to search on one or more of the columns. If I use
a query like:
$ste = $_POST['site'];
$req =
My question -
1. why have u used mysqli_fetch_array($result[0]), in place of
mysqli_fetch_array($result)) i.e. without array brackets as $result is not
an array. What is returned by mysqli_fetch_array is an array.
2. Have u checked the your query (print $sq1) after u added *extra test in
the
well i guess you could do that. but it gets complicated after a
while and there will be a lot of work and probably after a while you
will get into some problems. You have to handle escaping, special
types etc. Then what about performance? how to query the data ...
using similar approach or is
On Wed, Nov 17, 2010 at 8:51 AM, Vinay Kannan viny...@gmail.com wrote:
Hello PHP Gurus,
I need your help on an insert query.
I wanted to know if there is way to insert an array of values into a DB. An
eg would explain this better :
If I have 2 tables in a DB, 1) users has 3 columns 2)
From: Vinay Kannan viny...@gmail.com
To: PHP DB php-db@lists.php.net, php mysql
php_mysql_usergr...@yahoogroups.com
Sent: Wednesday, November 17, 2010 2:51:35 PM GMT +01:00 Amsterdam / Berlin /
Bern / Rome / Stockholm / Vienna
Subject: [PHP-DB] query help
Hello PHP Gurus,
I need your help on
Hello PHP Gurus,
I need your help on an insert query.
I wanted to know if there is way to insert an array of values into a DB. An
eg would explain this better :
If I have 2 tables in a DB, 1) users has 3 columns 2) hobbies = 5 columns
I was thinking of having a single function which
[mailto:ejsmont.ar...@gmail.com]
Sent: 17 noiembrie 2010 16:07
To: Vinay Kannan
Cc: PHP DB; php mysql
Subject: Re: [PHP-DB] query help
well i guess you could do that. but it gets complicated after a while
and there will be a lot of work and probably after a while you will get into
some
The most performant methods are to use well parameterized stored procedure or a
prepared parameterized statement.
: Ashay
-Original Message-
From: Niel Archer [mailto:n...@chance.now]
Sent: Wednesday, November 17, 2010 6:30 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] query help
On Wed, Nov 10, 2010 at 10:03, Ron Piggott
ron.pigg...@actsministries.org wrote:
I have a column that is VARCHAR 250. I need it to be able to accept french
and spanish accents. The purpose of the column is organization names. The
“Collation” default is “latin1_swedish_ci” What do I need
On Wed, Nov 10, 2010 at 10:16, Ron Piggott
ron.pigg...@actsministries.org wrote:
I did Daniel --- php-db@lists.php.net ; Thank you for telling me about the
mySQL list.
I failed to mention in my original e-mail the database is mySQL.
My fault. Force of habit mentioning the php-db@ list.
Hi Ron, you should use
CHARSET=utf8 COLLATE=utf8_unicode_ci
in your table for a wide option of languages.
Example:
CREATE TABLE `t_my_table` (
`row_id` int(10) unsigned NOT NULL,
`row_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8
I use utf-8 for that it works well
Bastien Koert
905-904-0334
Sent from my iPhone
On 2010-11-10, at 10:03 AM, Ron Piggott ron.pigg...@actsministries.org
wrote:
I have a column that is VARCHAR 250. I need it to be able to accept french
and spanish accents. The purpose of the column is
with kind regards,
From: Karl DeSaulniers k...@designdrumm.com
To: php-db@lists.php.net
Sent: Monday, November 8, 2010 12:19:23 PM GMT +01:00 Amsterdam / Berlin / Bern
/ Rome / Stockholm / Vienna
Subject: [PHP-DB] Data Migration
Hello All,
I was wondering if I could get some pointers on the
On 2010-11-08, at 6:19 AM, Karl DeSaulniers k...@designdrumm.com wrote:
Hello All,
I was wondering if I could get some pointers on the best/safest method to
migrate data on a fairly simple scale.
I have a registration form that gets submitted. I want to take that info and
store it in a
On Fri, 2010-11-05 at 06:58 -0500, Karl DeSaulniers wrote:
Hi, Can anyone admin please explain this to me?
I received one myself.
--
Blessings,
David M.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Karl DeSaulniers wrote:
Hi, Can anyone admin please explain this to me?
If the email server gets bounce messages back for emails set out, then it tries
to check those emails. If the warning message gets through then nothing really
happens, but if that bounces as well, then it will disable
On Fri, Nov 5, 2010 at 08:13, Lester Caine les...@lsces.co.uk wrote:
Karl DeSaulniers wrote:
Hi, Can anyone admin please explain this to me?
If the email server gets bounce messages back for emails set out, then it
tries to check those emails. If the warning message gets through then
On 5 November 2010 16:14, Daniel Brown danbr...@php.net wrote:
On Fri, Nov 5, 2010 at 08:13, Lester Caine les...@lsces.co.uk wrote:
Karl DeSaulniers wrote:
Hi, Can anyone admin please explain this to me?
If the email server gets bounce messages back for emails set out, then it
tries to
I see. Thank you all.
Best,
Karl
Sent from losPhone
On Nov 5, 2010, at 11:14 AM, Daniel Brown danbr...@php.net wrote:
On Fri, Nov 5, 2010 at 08:13, Lester Caine les...@lsces.co.uk wrote:
Karl DeSaulniers wrote:
Hi, Can anyone admin please explain this to me?
If the email server gets
Return Values
If only two parameters were passed to this function, the values parsed
will be returned as an array. Otherwise, if optional parameters are
passed, the function will return the number of assigned values. The
optional parameters must be passed by reference.
At 06:08 AM 11/2/2010, Artur Ejsmont wrote:
Return Values
If only two parameters were passed to this function, the values parsed
will be returned as an array. Otherwise, if optional parameters are
passed, the function will return the number of assigned values. The
optional parameters must be
On 02/11/10 14:34, Ethan Rosenberg wrote:
Dear List -
Thank you for all your help. Here is another one.
I have a file [/home/ethan/PHP/RecNum] which consists of the number
1005. It also has been 1005. No matter how I do it, it is only
recognized as 1.
Here is the code. In this case, the
Sanjay Mantoor wrote:
Twaha,
I found PHP manual is best.
Refer http://www.php.net/manual/en/
On Fri, Oct 31, 2008 at 1:49 PM, Twaha Uddessy udde...@yahoo.com wrote:
Hello all,
Iam new here,trying hard to study PHP.Can anyone help me with a link
where I can get PHP exercises
sure that was a bit more helpful, thanks :)
i was still wondering to what other use cases would that apply. This
is a good article (best so far i guess):
http://code.google.com/edu/parallel/mapreduce-tutorial.html
The thing is that reduce has to aggregate data or it would be
impractical. So i am
Hi Artur,
in your IPs examples, lets supouse you have ten access log files (from
ten different servers),
there you already have the mapping part done.
Then you reduce each log into anonther new file, indicating the IP
address and the times it's repeated.
At this stage you have a reduced version
yeah i think that would make sense.
if you find more good examples from different areas let me know ... i
think i get the basic idea ... will try to apply it some time :)
cheers :)
art
On 30 October 2010 18:58, Andrés G. Montañez andresmonta...@gmail.com wrote:
Hi Artur,
in your IPs
From: Ethan Rosenberg eth...@earthlink.net
To: rquadl...@googlemail.com, Ethan Rosenberg eth...@earthlink.net
Cc: php-db-lists.php.net php-db@lists.php.net
Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin /
Bern / Rome / Stockholm / Vienna
Subject: Re: [PHP-DB
/ Vienna
Subject: Re: [PHP-DB] Incrementing Primary Key
At 10:10 AM 10/27/2010, Richard Quadling wrote:
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your excellent help.
I am setting up a database for medical
research, which
, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin
/ Bern / Rome / Stockholm / Vienna
Subject: Re: [PHP-DB] Incrementing Primary Key
At 10:10 AM 10/27/2010, Richard Quadling wrote:
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your
-lists.php.net php-db@lists.php.net
Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin
/ Bern / Rome / Stockholm / Vienna
Subject: Re: [PHP-DB] Incrementing Primary Key
At 10:10 AM 10/27/2010, Richard Quadling wrote:
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net
: Re: [PHP-DB] Incrementing Primary Key
At 01:17 PM 10/28/2010, Bastien Koert wrote:
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net
wrote:
At 03:40 AM 10/28/2010, Max E.K wrote:
From: Ethan Rosenberg eth...@earthlink.net
To: rquadl...@googlemail.com, Ethan Rosenberg
-lists.php.net; rquadl...@googlemail.com
Subject: Re: [PHP-DB] Incrementing Primary Key
At 01:17 PM 10/28/2010, Bastien Koert wrote:
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net
wrote:
At 03:40 AM 10/28/2010, Max E.K wrote:
From: Ethan Rosenberg eth...@earthlink.net
: Thursday, October 28, 2010 2:02 PM
To: Bastien Koert
Cc: Max E.K; php-db-lists.php.net; rquadl...@googlemail.com
Subject: Re: [PHP-DB] Incrementing Primary Key
At 01:17 PM 10/28/2010, Bastien Koert wrote:
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net
wrote:
At 03:40 AM
mysql SET @st=100;
mysql SELECT @st;
+--+
| @st |
+--+
| 100 |
+--+
Cheers.
On 28 October 2010 19:10, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
I cannot figure this one out:
mysql $st=1000;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
At 05:13 PM 10/28/2010, Andrés G. Montañez wrote:
mysql SET @st=100;
mysql SELECT @st;
+--+
| @st |
+--+
| 100 |
+--+
Cheers.
On 28 October 2010 19:10, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
I cannot figure this one out:
mysql $st=1000;
ERROR 1064
However, I am totally confused. All the texts state that to set a
variable, the code is: $st=100;
That's how you do it in php.
Doing it in the db is different and depends on the db you are using.
--
Postgresql php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List
Mysql doesn't have a printf function
Regards
Den 2010 10 29 00:47 skrev Ethan Rosenberg eth...@earthlink.net:
Dear List -
I am afraid that I am missing something in a major way.
mysql printf(%b %d %f %s\n, 123, 123, 123, test);
ERROR 1064 (42000): You have an error in your SQL syntax;
I think having a table for each site would be sufficent
-Original Message-
From: Ethan Rosenberg [mailto:eth...@earthlink.net]
Sent: Wednesday, October 27, 2010 9:11 AM
To: php-db-lists.php.net
Subject: [PHP-DB] Incrementing Primary Key
Dear List -
Thanks for all your excellent help.
Just set the primary key to AUTO_INCREMENT on each field and you won't have
to worry about it
-Original Message-
From: Ethan Rosenberg [mailto:eth...@earthlink.net]
Sent: Wednesday, October 27, 2010 9:11 AM
To: php-db-lists.php.net
Subject: [PHP-DB] Incrementing Primary Key
Dear List -
Hi Ethan,
in this case, you should manage the keys by your application, and
store the used ids in aonther table,
similar to a sequence in Oracle or Postgresql.
Thats so if you want all the records un one table (a field for the
letter, and the other for the numeric part).
Otherwise, having a table
for PHP every time you want to
use a different database.
I use the PDO mysql adapter, what do you use?
-Original Message-
From: Andrés G. Montañez [mailto:andresmonta...@gmail.com]
Sent: Wednesday, October 27, 2010 9:19 AM
To: Ethan Rosenberg
Cc: php-db-lists.php.net
Subject: Re: [PHP-DB
Hi Ethan,
I am working currently as clinical developer and have developed multi site
databases for clinical trials.
I would say the approach you take will depend on number of factors.
How is the site connectivity?
I had a scenario where sites had erratic and slow connectivity so i had to
-
From: Andrés G. Montañez [mailto:andresmonta...@gmail.com]
Sent: Wednesday, October 27, 2010 9:19 AM
To: Ethan Rosenberg
Cc: php-db-lists.php.net
Subject: Re: [PHP-DB] Incrementing Primary Key
Hi Ethan,
in this case, you should manage the keys by your application, and store the
used ids
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your excellent help.
I am setting up a database for medical research, which will be conducted at
various sites. The sites will be identified by a letter {A,B,C }. The
medical record number
1001 - 1100 of 21034 matches
Mail list logo