There may be a better way, but in migrating from Filemaker to MySQL, I
encountered similar problems. My solution was to pass the data through Excel
and use that to convert the dates into the required format (CTRL-1, Custom,
-mm-dd). Of course, you ned to watch out for those nasty ' "' ' that
E
Rich, thanks. I got the dynamic sql to work (i had a syntax problem), now my problem
is what's the most efficient way to loop it through all the form fields that are
passed to the processor? This is my current sql statement which handles 1 field:
$sql_update = "UPDATE md_users SET ".$formName."
Have you tried it? I've done this sort of thing before, and it works
just fine. By the time the query string is executed, the variables have
been interpreted.
So, if $colName = "id", and $id = 12, then your query variable looks
something like "select * from myTable where $colName = $id". By
Hi,
I have a sample data like below in text file (policy.txt).
"PolicyNo","DateOfBirth","PaidToDate"
"0003573607"," 9/25/1973"," 8/27/2001"
"708802","11/26/1959"," 5/25/1998"
"0002776507"," 3/19/1973","11/18/1999"
"0002776703"," 3/13/1969","11/18/1999"
Policy table structure:
+-
Is it possible to do a sort of dynamic sql. For instance, if I have a form with a
bunch of field/data variables and I send them to a php processor, can I just create a
loop to have it update all the fields without having to specify each field.
In scratch code, I guess I'm looking for something
Hi,
You need to recompile PHP with support for Interbase.
I would recommend reading the instructions on linux PHP installations on the PHP
website.
I imagine the conifgure option is something like
--with-interbase=path_to_interbase
but definately don't quote me on that.
Cheers,
db
Paulu van
Thank you everyone. The "COUNT(*) AS c" worked great.
---Original Message---
From: Kai Voigt
Date: Friday, 25
January 2002 11:11:06 a.
To: Barry Rumsey
Cc: [EMAIL PROTECTED]
Subject: Re:
Count(*)
Try the following:
$sql = "select count(*) as c from your_table" ;
$result = mysql_query(your_db, $sql, your_connection_identifier) ;
$row_count = mysql_result($result, 0, 'c') ;
Now $row_count contains the number of rows in your table named "your_table"
HTH
--Sam Masiello
"Andy" <[EMAIL PR
Hi Group,
im encountering a problem with safemode and pers. links:
Running unsafe mode everything is fine, when i turn on safemode the call
to mysql-db with mysql_pconnect fails with "cant connect to mysql thru
socket /tmp/mysql.sock".
This will only hasppend if i use persistent connect - norma
SELECT count(*) AS ctr FROM mytable;
-Original Message-
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 10:36 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] How to find out the number of rows in a table?
Hi there,
I am trying to find out the number of rows in a table
Hi there,
I am trying to find out the number of rows in a table. The mysql docu says
there is a mysql_num_rows statement but it requiers a sql statement in
front. How could I do this more efficiently? Can anybody make an example,
please? I am sure that there is an more easy way.
Cheers Andy
-
You are incorrect regarding my appreciation of the help I receive from the
list. I very much value the help received from everyone who is a contributor
to the list. This is one of the reasons (of many) I chose to develop with
PHP/MySQL. At this point in time I mainly receive help, however, when my
http://www.php.net/pdf
You'll need Thomas Mertz' PDFlib, which is free for personal/not-for-profit
use, but requires a license fee for commercial use:
http://www.pdflib.com/pdflib/index.html
-Andy
> -Original Message-
> From: Mihail Bota [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, J
Thanks a lot guys! This really helps a lot.
MySql is not installed on my machine, so it would take a while to install
all the necessary libraries. I'll stick with the material given by Daniel,
for the moment.
Mihai
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [E
Hi,
I am trying to load a multi-dimensional array to my mysql database and am
having difficulty reading the array.
I created the array in a script, and sent it to another script through a
form. One of the variables that gets passed is "$home_team[][]. with the
outer array being the week #, and th
Hi there all!
I've got a slight problem. I developed a web site using php4, apache 1.3
and Interbase 6 on a Win2000 platform. Now the web page needs to be moved
to a linux server. The server is running Suse Linux 7.2 with apache and
php4 already installed and is working fine. But now how do I
Have you tried to replace the tnsname with its exact definition ? not the
best thing to do, but it could be a workaround.
Example : something like :
$oracletns = "(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host =
Mihai,
There is a php class that can generate pdf documents without the
dll's/libraries required by other methods:
http://ros.co.nz/pdf/
You can definitely use the results of a database query to create a pdf!
Enjoy!
Daniel Ems
On Wed, 23 Jan 2002, Mihail Bota wrote:
> Hello,
>
> I was w
Agreed, i think you'll find aan easy way of doing this is to name each image
after the primary key to your table (ie 1.jpg, 2.jpg, 3.jpg etc if the
primary key is an autonumber. and store them all in a certain file, then
when you fetch the record from the table, you can run a simple check to see
i
Re the PLS. Nope, replies to private email are contrary to spirit of the list.
Storing inages in a database is not a good practice. Fetches are slow and
the database becomes incredibly bloated. Most people store the images on
disk and a reference to their location in the database and have found
Hello,
I would like to create database with many pictures.
I have problem with inserting pictures to table in MySQL. I created table where one of
the name of column is "image". The type of this column is LONGBLOB. How can I insert
picture into this column? I tried insert a file (e.g. picture.jp
Hello,
in order to be able to use the replication features of MySQL we recently
gave version 4.0.1alpha a try, since these features are reportedly more
reliable in this version - although it is still alpha.
Unfortunately the disadvantages - at least on our machines - don't seem
to make up for the
> Help, i'm trying to connect to a remote oracle database from
> win98/apache/php4 and win2k/iis/php4 but it always gives me tns
> error. Other
> apps however, works fine with the tns configuration. the php oracle module
> was loaded successfully on both platforms.
> I've tried all sorts of possi
Help, i'm trying to connect to a remote oracle database from
win98/apache/php4 and win2k/iis/php4 but it always gives me tns error. Other
apps however, works fine with the tns configuration. the php oracle module
was loaded successfully on both platforms.
I've tried all sorts of possibilities. pat
Zach,
On the subject of sharing information we differ big-time: have you heard the story
about the three blind men
attempting to describe an elephant?
Apparently you have failed to appreciate the self-help nature of the list. No one is
paid to help you. However
your behavior demands/evidences
On Thursday 24 January 2002 15:52, Mihail Bota wrote:
> Hello,
>
> I was wondering if I could save the result of a query in a pdf document. I
> looked for any functions that might help, but I got confused because I
> could not see how/where exactly to insert the necessary .dll's.
First read the
26 matches
Mail list logo
