in the encrypted emails.
That way the email does not contain a customer name, but only an order id
(which could even be a unique and hidden value stored via AES in the mysql
db). What are your thoughts? Keith - Original Message -
From: Bastien Koert [EMAIL PROTECTED] To: Keith Spiller
On Dec 19, 2007 4:45 PM, Bastien Koert
[EMAIL PROTECTED] wrote: Nope, I still would not recommmend it. The
only place the CC data should travel to is the payment gateway. Anything else
is a security risk. Why does your client process by hand? They should be
using a payment gateway. That's
and omissions insurance, or would they take the position
that the developer should have known better and was negligent in creating a
non-compliant system leaving the developer on the hook for damages? Gary
-Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Wed
Think very carefully about what you want to do here. PCI (payment card
industry) has radically changed the rules about how CC data is stored in a
networked environment. If your data environment is shared (shared web hosting),
don't even think about it. There are a large number of rules that
http://www.php.net/manual/en/function.number-format.php
bastien
Date: Sun, 16 Dec 2007 17:17:41 +0600
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] sql problem
my problem in the following code
INSERT INTO `test` (
so the simple solution is to disable the button after the call until the
results are returned
bastien Date: Fri, 9 Nov 2007 15:02:31 -0500 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] Corrupted query results in memory. I
posted an issue to the mysql dev forums last
I would approach this by having a main people table (with a unique id of
course) and then create a second addresses table which uses the people Id key
as the foreign key to this table...then you can have multiple (more than two)
addresses for those users, you could add a season in the
list the persons name and then on a
second table use a 1 to many relationship on a foreign key to link all the
addresses into the name? Or did I miss the mark? :) On Oct 24, 2007, at 9:30
AM, Bastien Koert wrote: I would approach this by having a main people table
(with a unique id of course
Is logging turned on?
bastien
Date: Tue, 23 Oct 2007 16:12:14
-0600 From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] PG:
Table last updated? We've got a huge table in one of our Postgres databases
and nobody seems to know what it's
select [table.field]
from
table1 t1 inner join table2 on t1.some_field = t2.some_field
inner join table3 t3 on t1.some_field = t3.some_field
where [clauses as needed]
bastien
From: [EMAIL PROTECTED] To:
php-db@lists.php.net Date: Sun, 21 Oct 2007
Unions required that the the queries have the same number of columns and the
same data type for each column
bastien To: php-db@lists.php.net Date: Fri, 19 Oct 2007 09:24:38 -0600 From:
[EMAIL PROTECTED] Subject: [PHP-DB] union/select statement number of
columns Hello all, I receive an
Unions required that the the queries have the same number of columns and the
same data type for each column
bastien To: php-db@lists.php.net Date: Fri, 19 Oct 2007 09:24:38 -0600 From:
[EMAIL PROTECTED] Subject: [PHP-DB] union/select statement number of
columns Hello all, I receive an
Ron,
The email subject line should not have a br / tag in it at all. It is not
allowed under the specifications if I remember correctly. I would suggest that
when you suck the message in, first thing to do is to remove the br / tag
with str_replace...
Would this get you on your way?
Unless you are using a text field (which holds 64K [mysql]) a normal varchar
maxs out at 255 characters
Post is limited by the php.ini file amounts (usually in the megabyte range).
what is the size of the post?
Bastien Date: Fri, 12 Oct 2007 10:41:15 -0400 From: [EMAIL PROTECTED] To:
is as such: TEXTAREA
name=Customer_Description cols=100 rows=10 tabindex=44/TEXTAREA The
confirmation page is: ?php echo ($_POST['Customer_Description']); ?
From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007
11:26 AM To: VanBuskirk, Patricia; php-db@lists.php.net
variable” errors wherever the database was supposed to send back info, and no
record was created.
From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007
11:12 AMTo: VanBuskirk, Patricia; [EMAIL PROTECTED]: RE: [PHP-DB] php maximum
characters in text field
Unless you
What about setting up replication between the servers? Make the the web a slave
of the office one and make it read only so avoid messing up the data.
bastien Date: Thu, 11 Oct 2007 18:08:29 -0600 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: Re: [PHP-DB] Remote DB Connection: Pros
Hey Ron,
You should be able to do it. Do the query for the data and then output the data
in to tables that roughly match the size of the labels. The hard part will be
to match the tables to labels. Start by making the main table 750px wide, since
that seems to about the width of the page.
after submit direct the user to a different page...or use js and disable the
button after the first click
bastien Date: Thu, 4 Oct 2007 20:09:01 +0900 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] Prevention for multiple submissions
from the same form Hi, I have a form
try
input type='submit' name='submit' value='Submit'
onclick='this.style.disabled=true;' /
bastien
Date: Fri, 5 Oct 2007 00:14:44 +0900 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: Re: [PHP-DB] Prevention for multiple
submissions from the same form Thank you for answering
Chris
try just initializing the variable
$view = 0; // if int
$view = ''; // if string
Bastien Date: Tue, 2 Oct 2007 10:55:06 +1000 From: [EMAIL PROTECTED] To:
[EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB]
Error:Undefined index, for a simple line. Chris Carter
Realistically, there are three options:
1. run the code twice to connect and pass the data to each server
2. set up a primary server and use a stored procedure to load the other server
(providing db supports it)
3. set up replication and make one a master and the other a slave and the the
what about wordpress? you may also want to look at some of the code generators
bastien Date: Fri, 28 Sep 2007 10:44:31 +0900 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] Looking for a small open-source PHP-DB
app that utilize OOP. Hi, For a study purpose, I'm looking
are you sure that you have
1. error handling turned on
2. browser set to display all errors ( friendly error messages unchecked)
bastien
Date: Fri, 21 Sep 2007 23:42:40 +0100 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] Pages not fully loading I am
stumped and
Condition is a reserved word in mysql...you will need to change the field name
bastien Date: Tue, 28 Aug 2007 18:11:20 -0700 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] mysql error... this is bugging me to
no end (no pun intended)... I am getting the error: invalid
Why not look at mambo or drupal to provide the framework? Be a lot quicker than
coding it from scratch
bastien Date: Fri, 24 Aug 2007 23:18:48 -0500 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] Looking for some help on a project!
Hello, im working on making a custom
http://www1.auspost.com.au/postcodes/
bastien
Date: Tue, 14 Aug 2007 13:36:54 -0400 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] australian city db -lat/lon? I've
found a few places to get a zipped file of US cities with zips and lat/lon
for insertion into my
Or assuming he really wants to print the page
script language='javascript'window.print();/script
Bastien From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net
Date: Mon, 13 Aug 2007 16:26:40 +0300 Subject: RE: [PHP-DB] this is arafat
So far I understood from your question:
explode(delimiter, $string);
is the correct function
Bastien Date: Thu, 9 Aug 2007 04:53:53 -0700 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] use of str_split Hi when i try to
use this function str_split() it shows me as invalid function what
is solution
store your password/access credentials outside the web root and use php to
read the data in. Another alternative is to wrap those items in a function
and check the calling source to make sure its only your application
hth
Bastien
From: Roberto Mansfield [EMAIL PROTECTED]
To:
use cURL to execute the remote code
Bastien
From: ioannes [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Include function across servers
Date: Tue, 03 Apr 2007 00:06:25 +0100
I have a particular business application so just returning html is OK,
I would say no, due to the overhead. What I would recommned is setting that
up as a cron task and running it on a scheduled basis, usually when the
server is liightly loaded. Monitor the server and pick an optimal time. This
is the same for all server mainenance type situations like index
you need to escape double quotes in an echo if you use double quotes as the
wrapper.
bastien
From: elk dolk [EMAIL PROTECTED]
To: php-db@lists.php.net php-db@lists.php.net
Subject: [PHP-DB] width height
Date: Fri, 30 Mar 2007 04:31:52 -0700 (PDT)
it might be a stupid question but I think it
try
echo img src='/album/img/{$row[photoFileName]}' / ;
warpping the array element in braces allows for proper evaluation
bastien
From: elk dolk [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] echo
Date: Thu, 29 Mar 2007 05:08:36 -0700 (PDT)
thanks to Chris and Dimiter,
I
Hve you tried the ODBC connections instead?
http://ca3.php.net/manual/en/ref.dbx.php
bastien
From: Phares Kariuki [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] DBX
Date: Thu, 29 Mar 2007 15:25:12 +0300
Hello,
Is there a DBX module for php5 on debian... I have just installed
That is not a two dimensional array. Its two one dimensional arrays and yo
do it like this
while ($row = mysql_fetch_array($result))
{
$title[] =$row['title'];
$description[] =$row['description'];
}
bastien
From: elk dolk [EMAIL PROTECTED]
To: php-db@lists.php.net
use
mysql_real_escape_string($_POST['field'] IN the query
use addslashes
use htmlspecialentities
use str_replace to switch it to an ascii equivalent
hth
bastien
From: Stephen Smith [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Using apostrophe's within a text field
Date: Wed,
if you view the source of the generated page, is the image name correct? is
the path to the image correct?
bastien
From: elk dolk [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] echo Date: Tue, 27 Mar 2007 22:07:37 -0700 (PDT)
Hi all,
I am new to web programming.
I have code
Wouldn't the simplest solution be to update the entire account all the time?
You are presenting all the data to the user each time any way...so updating
the record is a given anyway.
The benefits are that the sql is simplified since there are only two
statments (insert and update) and the
select date_format(datefield,'%M') as theDate from table [where clause]
Bastien
From: Ron Piggott [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Values in a date field
Date: Sat, 17 Mar 2007 09:44:43 -0400
I have a $subscription_begins
you can write an html page on the fly and save that to the hard drive
have a look at fopen/fwrite etc
bastien
From: Vincent [EMAIL PROTECTED]
Reply-To: Vicente [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Caching query results in html pages
Date: Tue, 13 Mar 2007 14:20:58
http://www.weberdev.com/get_example-4082.html
From: Vincent [EMAIL PROTECTED]
Reply-To: Vincent [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re[2]: [PHP-DB] Caching query results in html pages
Date: Tue, 13 Mar 2007 18:41:42 +0100
Bastien wrote:
BK you can write an html page on the
too small a sort space on the server? have you checked the server config?
Bastien
From: Tony Grimes [EMAIL PROTECTED]
To: PHP-DB php-db@lists.php.net
Subject: [PHP-DB] MySQL sort stopped working
Date: Tue, 13 Mar 2007 13:22:25 -0600
I have this page that lists artists alphabetically:
are you dumping the data or you just want to reset?
issuing the 'empty table' command in phpmyadmin will do that
or you can do
ALTER TABLE tbl AUTO_INCREMENT = 100;
bastien
From: Ron Piggott [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB]
explain to him that there is a perfomance hit to storing images in the db as
well as causing some db bloat. You will also need to handle the output of
the images differently to ensure that they show up
see these example for getting info in and out of the db
best sore the image on the filesystem and use that field to store the path
and image name. Its simpler to manage
Bastien
From: Chetan Graham [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Storing 4KB jpeg images on hospital web server
Date: Thu, 8 Mar 2007 07:06:39 +0300 (EAT)
another option might be to store xml snippets that match the array.
if you are using large numbers of arrays, perhaps a revamping of the db
structure to map the arrays to sub-tables might be in order
bastien
From: Micah Stevens [EMAIL PROTECTED]
To: Sancar Saran [EMAIL PROTECTED]
CC:
check your php ini file for memory limits and filesize limits. Also check
the mysql (if that is where the problem is) config to make sure you have
enough resources allocated in memory
bastien
From: bedul [EMAIL PROTECTED]
To: Hartleigh Burton [EMAIL PROTECTED]
CC:
Can you supply the code...because if you are trying to use the php
imageftbbox function
a. you spelled it wrong
b. do you have the appropriat arguements ( float $size, float $angle, string
$font_file, string $text [, array $extrainfo] )
Bastien
From: Mad Unix [EMAIL PROTECTED]
To:
You could use php+gtk to write it that way, but a simple batch file is the
best bet since you could then use task scheduler to run this batch file at
scheduled times.
Just google dos batch files
bastien
From: bedul [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: php-db
1. install php, we have both running on our iis servers with no problems
2. you can use either one iis or apache ( my work machine runs several
servers at once) The trick will be to designate the ports that the servers
listen on
bastien
From: bedul [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
have you tried to 'flush privileges' to get the server to recognize the user
account. Another option might be to open the mysqld from the command line
and use the GRANT statement to create user without the gui.
bastien
From: Roberto F Tavares Neto [EMAIL PROTECTED]
To: php-db@lists.php.net
What about just writing a batch script that opens the ftp services and sends
the file?
Bastien
From: bedul [EMAIL PROTECTED]
To: php-windows@lists.php.net,php-db@lists.php.net
Subject: [PHP-DB] auto upload
Date: Thu, 1 Mar 2007 12:03:48 +0700
this might a strange code i request, plz forgive
select * from table where field_3 is not null
bastien
From: Ron Piggott [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] NOT NULL query
Date: Mon, 26 Feb 2007 07:55:41 -0500
Is it possible to do a SELECT query where field_3 isn't null? What
Not sure if you got a reply to this yet, but another option is to read the
mailbox via a cron job. I use this successfully. You can see an example here
( http://www.weberdev.com/get_example-4015.html )
bastien
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To:
Simple, just add the image tag around it
$query=SELECT logos FROM table WHERE sno = '$sno';
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$logos=mysql_result($result,$i,logos);
echo
div
pimg src'$logos' /p
/div;
Bastien
From: Chris Carter [EMAIL PROTECTED]
To:
I would suggest placing all the data into divs and using some js to show
those divs when the time is right
bastien
From: Matthew Ferry [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] echo delay...
Date: Fri, 16 Feb 2007 03:37:17 -0500
Hi fellow php late night peoples
http://en.wikipedia.org/wiki/Multidimensional_database
http://en.wikipedia.org/wiki/OLAP
bastien
From: Santiago Zarate [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] OLAP Multidimensional databases and PHP
Date: Sun, 4 Feb 2007 13:37:01 -0400
I would tend to agree with this
Bastien
From: Edward Vermillion [EMAIL PROTECTED]
To: Ritesh Nadhani [EMAIL PROTECTED]
CC: PHP DB php-db@lists.php.net
Subject: Re: [PHP-DB] PHP with a XML database
Date: Fri, 26 Jan 2007 15:36:33 -0600
I would imagine that parsing the XML file you get once a
I think the issue might be that you cannot stack the queries in mysqlyou
can't run both queries separated by a semi-colon. You will likely need to
loop thru the queries and execute them one at a time
Bastien
From: marga [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB]
are you sure that the problem is not in the browser settings (not to accept
session cookies)?
Bastien
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: RE: [PHP-DB] Session Problem
Date: Fri, 12 Jan 2007 15:34:06 +0900
1. Did you mean that on phpinfo(),
i tend to have a function that show the form and a processing function. In
the processing function i preform my sanity checks and then if there are
errors pass the $_POST data back to the show_form($data, $errors) with the
relevant errors. This removes the need to have the users press the back
1. yes indexes could help, if mysql uses them. The mysql optimiser may or
may not use the index for the query depending on the statement...it sounds
like you are doing a full table scan on the data
2. there are two schools of thought here:
a. run the whole thing as two statements (one outer
why not just create a simple single logon page and not include itthen on
sucessful login, redirect the user to the index page?
bastien
From: Haig Dedeyan [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Login script help
Date: Thu, 21 Dec 2006 16:36:11 -0500
Hi everyone,
My
I would think the one huge query (using an IN clause) would be better than
multiple queries...especially if you structure it to use an index
$query=UPDATE some_table SET x='$y' WHERE id
IN('.$z[$key].','.$z[$another_key].','.$z[$another_key]...
bastien
From: Jeffrey [EMAIL PROTECTED]
To:
use the limit clause
$count = 25;
$query=SELECT * FROM WHERE hello = '$hello' limit $count;
Bastien
From: Chris Carter [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Limited number of database results
Date: Wed, 13 Dec 2006 08:51:47 -0800 (PST)
Hi,
I have more than 200
here is a link to one such example
http://www.weberdev.com/get_example-3852.html
Bastien
From: Miguel Guirao [EMAIL PROTECTED]
To: David Skyers [EMAIL PROTECTED], php-db@lists.php.net
Subject: RE: [PHP-DB] List menus
Date: Tue, 05 Dec 2006 08:59:44 -0600
The solution has been posted
insert into tableb (select * from tablea)
bastien
From: Rosen [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Transfer data between tables in MySQL
Date: Wed, 29 Nov 2006 13:44:24 +0200
Hi,
I have to transfer all data between two tables ( with identical structure )
Is this
Have you tried limiting it first via a subselect and then doing the full
text match?
bastien
From: benmoreassynt [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Speeding up a query by narrowing it down
Date: Wed, 29 Nov 2006 21:02:03 -0500
Hi,
I have a query which works
have you tried the standard sql method
select database_name1.table_name1.field_nameA,
database_name2.table_name2.field_nameB from
...
Bastien
From: C. Tate Baumrucker [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] multiple database join with pdo
Date: Tue, 28 Nov 2006
Adiran
There are several solutions that i can see in doing this without csv
1. create a vba module in the excel sheet to handle the connections and
insert/update the data in either direction. This does suppose that the web
server you are using can be accessed directly from the client machine
goolge cross tab query ... that is what you are looking for
bastien
From: Suprie [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Help on query report...
Date: Wed, 15 Nov 2006 13:28:15 +0700
dear all,
i have this table
id | contract No | site id | handover date |status|
1. yes, user a rich text editor plugin in you web page
(http://www.kevinroth.com/rte/ is one such beast)
2. sure, in a text / blob field
3. yes, but likely you'll need to do it as CDATA
hth
Bastien
From: David Skyers [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Help
The code does need to know what the fields are...I think a more likely issue
is the query for some reason, also change the $query to result in the query
statement
try
$result=pg_query($query) or die(pg_error()); //to see if there are any
errors with the query
is your server set to work with php files?
Bastien
From: Desmond Coughlan [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED], [EMAIL PROTECTED],
php-db@lists.php.net
Subject: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL
(basic question, not small)
Date: Tue, 7 Nov 2006
WE use XML here to store the values, however our requirements also add the
ability to use mutiple languages so its a little more complex.
For personal projects I store the various data like this into a
system_option table as text (1,Male;2,Female;) and then have a common
routine that grabs
chmod will work for both folders and files...
bastien
From: Andrew Darby [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] Permissions for mkdirs
Date: Sat, 28 Oct 2006 18:06:36 -0400
Unfortunately, I can't get in to the conents
www.fpdf.org has a free class / tutorial
bastien
From: Jorge Giménez [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Converting text field to barcode CODE 39
Date: Fri, 27 Oct 2006 23:49:22 +0200
Hello.
Can anyone tell me where I can find information or examples about
show relevant code around the query and attempt to loop thru resultset
bastien
From: Vignesh M P N [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Problem with pg_fetch_array
Date: Mon, 23 Oct 2006 15:12:25 -0500
Hi
I am trying to display the rows from a database table in a
mysql_query($query) or die(mysql_error);
will give an error and stop the script if there is an issue, this also can
work for the mysql_select_db
bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Verifying syntax
use an array
$months = array('01'='January','02'='February'...);
$thisMonths = array_flip($months);
$month = $thisMonths['January'];
echo $month;
though its easier to just create the array the other way and the just
reference it
$months = array(''January''='01','February'='02...');
$month
whynot keep all and just sort/limit them to get the data you want?
bastien
From: bob plano [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB] mysql databases
Date: Sat, 14 Oct 2006 12:47:38 -0500
sorry, i meant that i wanted to remove the oldest entry and put in a
new entry
easist way is to wrap the entire value in single quotes not double
quotes...kinda breaks the rules but it will work..the other option is to
search your value and do a replace on the double quotes
bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB
i tend to take the approach of
$next_wed = date(Y-m-d, strtotime(next wednesday));
Bastien
From: Niel Archer [EMAIL PROTECTED]
Reply-To: php-db@lists.php.net
To: php-db@lists.php.net
Subject: Re: [PHP-DB] SELECT date query
Date: Sat, 07 Oct 2006 05:49:36 +0100
Hi Ron
I've made the
You need to just start adding echo statements to the code to see where the
hang up is
Bastien
From: David Skyers [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] How to stop the server timing out
Date: Tue, 3 Oct 2006 11:51:30 +0100
Hi,
I have written a php page and every time
eregi_replace or str_replace can do that for you
Bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Searching PHP strings
Date: Thu, 28 Sep 2006 21:12:18 -0400
I have been playing tonight for a few minutes.
The
same again on the back end
Bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: PHP DB php-db@lists.php.net
Subject: [PHP-DB] I still have a bit more of the string to get rid of ...
Date: Thu, 28 Sep 2006 22:13:59 -0400
Where
Assuming that tim is a pure timestamp column then try
select * from table where date_format(tim,'%Y-%m-%d) = DATE_SUB(curdate(),
INTERVAL 7 DAY)
Bastien
From: Muhammad Mustafa [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] how to show all recordes inserts in a table for the
I think you need to add a content-type of application/pdf to the code to
tell the browser that its a pdf coming down
// We'll be outputting a PDF
header('Content-type: application/pdf');
Bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB
try
while($row = $db-sql_fetchrow($result))
{
//[INSERT CODE HERE, I want to display the 'user' and 'count']
$user = $row[0];
$count = $row[1];
}
bastien
From: JM [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Displaying SQL
Try base_64_encod(ing) it then compressing it. on the way out, uncompress,
base-64-decode the value and see what you get
Bastien
From: Nathan Harmon [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Postgres and gzcompress
Date: Wed, 06 Sep 2006 15:39:37 -0700
Hi,
I would like
SQL Server and DB2 (version dependant) don't support regexp in sql
Bastien
From: Micah Stevens [EMAIL PROTECTED]
To: J R [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] Distinct Partial Matches: RegExp
Date: Wed, 30 Aug 2006 18:29:19 -0700
You can do regular expression
try posting the code
Bastien
From: Miguel Guirao [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Strange problem!
Date: Wed, 23 Aug 2006 09:41:05 -0500
Hello everybody out here and there,
I'm experiencing a weird problem with one of my scripts, I'm using
ob_start() in order
not as sucj, but you could consider a sub-select (providiing your version of
mysql supports it)
something like this might also work
$query = select id from table where somefield [in|=|like] (.
in_array(row,'$user_area').);
Bastien
From: Kevin Murphy [EMAIL PROTECTED]
To:
use mysql_result
mysql_result ( $result, 0, 2 )
where 2 is the offset of the fields in the row
Bastien
From: Peter Beckman [EMAIL PROTECTED]
To: PHP-DB Mailing List php-db@lists.php.net
Subject: [PHP-DB] Direct Access to an Array Item?
Date: Tue, 8 Aug 2006 22:34:55 -0400 (EDT)
I want to
SELECT count( * )
FROM `bsp_area`
GROUP BY boroughID ORDER BY count(*) DESC LIMIT 1
Bastien
From: [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], php-db@lists.php.net
Subject: RE: [PHP-DB] Using MAX with COUNT?
Date: Sat, 22 Jul 2006 20:25:57 -0600 (MDT)
Hi
Order the query by the category, when the category changes echo out the new
category like a heading
?php
...
echo tabletr;
$old_cat = '';
while ($rows = mysql_fetch_array($result))
{
if ($rows['cat'] != $old_cat)
{
echo td . $rows['cat'] . /td;
echo /trtr;
$old_cat =
SELECT count(*) FROM `bsp_area` GROUP BY boroughID
Bastien
From: Skip Evans [EMAIL PROTECTED]
To: Php-Db php-db@lists.php.net
Subject: [PHP-DB] Using MAX with COUNT?
Date: Sat, 22 Jul 2006 13:48:43 -0600
Hey all,
I have a table like this:
boroughID Area
=
1
http://ca3.php.net/manual/en/function.substr.php is the function you want
bastien
From: Benjamin Adams [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Only a section from the database result
Date: Tue, 18 Jul 2006 13:24:51 -0400
I have articles in a MySQL database and I
You can't...best to zip the files and let the user decide where they need to
go
Bastien
From: Skip Evans [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Getting directory from local machine?
Date: Thu, 13 Jul 2006 13:27:03 -0600
Hey all,
I have looked but been unable to find a
101 - 200 of 720 matches
Mail list logo