[PHP-DB] Re: NEXTVAL(serial)
nextval is a function found in postgres databases and is used to seed the value of a serial(auto increment) that is normally used as a key. other uses are select currval(serial) to get the current value and select setval(serial,value) to set the vlaue on the fly. much more info can be found in the postgresql docs at http://www.postgresql.org/idocs/ Steve "Ric Manalac" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > hello. > i've seen DEFAULT NEXTVAL(serial) being used > in some examples but i have not seen an explanation > of what it exactly does. can anyone please explain > what it is and how it can be used? > i have some idea but i want to make sure by asking > other people. thanks! > > ric > > -- > > == > Note: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of > this message is not the intended recipient,or an employee or agent > responsible for delivering this to the intended recipient,you are > hereby notified that any dissemination, distribution or copying of > this communication is strictly prohibited. If you have received > this communication in error, please notify us immediately by > replying to the message and deleting it from your computer. > Thank you. > == > > -- 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-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Hellllp DBF
if phpdbase.dll is disabled, then you can't use dbase_open()
-Original Message-
From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 8:55 AM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Hep DBF
Using PHP 4 installed and the phpdbase.dll disable.
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Marcelo Ramos Souza'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, September 27, 2001 10:41 AM
Subject: RE: [PHP-DB] Hep DBF
You need to talk to the server's owner to ask that PHP be installed with the
database capabilities you need.
Does your company own the server; if so, speak to the admin. If you are
using web-hosting, talk to them.
-Original Message-
From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 8:39 AM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Hep DBF
Who I do ?
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Marcelo Ramos Souza'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, September 27, 2001 10:27 AM
Subject: RE: [PHP-DB] Hep DBF
sounds like database manipulation was not compiled into PHP when it was
installed on your server.
-Original Message-
From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 8:25 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Hep DBF
I need HELP, I can´t open a DBF, I using this:
$dbf = dbase_open('/public/dados/clientes.dbf',0);
$drec = dbase_get_record_with_names($dbf,1);
// ITEM must be in all caps, otherwise
// you get nothing
echo $drec['ITEM'];
But result this error:
Fatal error: Call to undefined function: dbase_open() in
Please, help me
--
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-mail: [EMAIL PROTECTED]
--
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-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Hellllp DBF
Using PHP 4 installed and the phpdbase.dll disable.
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Marcelo Ramos Souza'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, September 27, 2001 10:41 AM
Subject: RE: [PHP-DB] Hep DBF
You need to talk to the server's owner to ask that PHP be installed with the
database capabilities you need.
Does your company own the server; if so, speak to the admin. If you are
using web-hosting, talk to them.
-Original Message-
From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 8:39 AM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Hep DBF
Who I do ?
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Marcelo Ramos Souza'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, September 27, 2001 10:27 AM
Subject: RE: [PHP-DB] Hep DBF
sounds like database manipulation was not compiled into PHP when it was
installed on your server.
-Original Message-
From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 8:25 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Hep DBF
I need HELP, I can´t open a DBF, I using this:
$dbf = dbase_open('/public/dados/clientes.dbf',0);
$drec = dbase_get_record_with_names($dbf,1);
// ITEM must be in all caps, otherwise
// you get nothing
echo $drec['ITEM'];
But result this error:
Fatal error: Call to undefined function: dbase_open() in
Please, help me
--
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-mail: [EMAIL PROTECTED]
--
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-mail: [EMAIL PROTECTED]
[PHP-DB] (poss OT) mail() function
hi all
We have a web based employment site, running on PHP and MySQL (to all
those didn't know!). Whenever a candidate sees a job they're interested
in they click a button and an email is sent to our consultants for them
to act on.
The problem, little as it is, is that I've written a function to send
the email (copied below) and sometimes (more often than not) the email
is fine (I get a copy), but other times it's all plain text and the
formatting isn't there.
Does anyone know why this would happen?
Cheers in advance
Dave
// start copy of function
function send_email($whoto,$whofrom,$subject,$message) {
$subject = "[AUTOMATED NOTIFICATION] - $subject";
$mailheaders = "Content-Type: text/html;
charset=iso-8859-1"; // Mime type
mail($whoto, $subject, $message, $mailheaders);
}
// end copy of function
--
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-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Hellllp DBF
You need to talk to the server's owner to ask that PHP be installed with the
database capabilities you need.
Does your company own the server; if so, speak to the admin. If you are
using web-hosting, talk to them.
-Original Message-
From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 8:39 AM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Hep DBF
Who I do ?
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Marcelo Ramos Souza'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, September 27, 2001 10:27 AM
Subject: RE: [PHP-DB] Hep DBF
sounds like database manipulation was not compiled into PHP when it was
installed on your server.
-Original Message-
From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 8:25 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Hep DBF
I need HELP, I can´t open a DBF, I using this:
$dbf = dbase_open('/public/dados/clientes.dbf',0);
$drec = dbase_get_record_with_names($dbf,1);
// ITEM must be in all caps, otherwise
// you get nothing
echo $drec['ITEM'];
But result this error:
Fatal error: Call to undefined function: dbase_open() in
Please, help me
--
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-mail: [EMAIL PROTECTED]
--
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-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Hellllp DBF
Who I do ?
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Marcelo Ramos Souza'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, September 27, 2001 10:27 AM
Subject: RE: [PHP-DB] Hep DBF
sounds like database manipulation was not compiled into PHP when it was
installed on your server.
-Original Message-
From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 8:25 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Hep DBF
I need HELP, I can´t open a DBF, I using this:
$dbf = dbase_open('/public/dados/clientes.dbf',0);
$drec = dbase_get_record_with_names($dbf,1);
// ITEM must be in all caps, otherwise
// you get nothing
echo $drec['ITEM'];
But result this error:
Fatal error: Call to undefined function: dbase_open() in
Please, help me
--
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-mail: [EMAIL PROTECTED]
--
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-mail: [EMAIL PROTECTED]
RE: [PHP-DB] attach file
Follow this link which describes how to create attachments for email: http://www.phpbuilder.com/columns/kartic2807.php3 Use these techniques after retrieving the data from the database to be formed into an attachment -Original Message- From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 1:35 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] attach file Hi, How I retrieve data from DB and make it to mail attachment? I've been read PHP function about mailto but It did not contain any suggestion. SF -- 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-mail: [EMAIL PROTECTED] -- 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-mail: [EMAIL PROTECTED]
[PHP-DB] Re: how do I update fields in a mysql database with php?
Try something like this ...
$sql_query = "SELECT newscat_id,newscategory,newscat_status FROM
dvd.news_categories WHERE newscat_id='$newsid' "
$res = mysql_query( $sql_query) or
DIE ("MySQL gave error: " . mysql_errno() . "MySQL Error
String: " . mysql_error()
. "Query: " . $sql_query);
This should give you a good idea what the error is ..
When ever you are creating new scripts with db queries it is a handy
idea to see what the server is putting our during error conditions.
DTSig
David Tod Sigafoos
On Wed, 26 Sep 2001 18:09:36 +0200, [EMAIL PROTECTED] (Tommy
Nilsson) wrote:
>I got a bit of a problem:
>$result1 = mysql_query ("SELECT
>newscat_id,newscategory,newscat_status FROM dvd.news_categories WHERE
>newscat_id='$newsid'")
>
>shouldn't that work?
>Or what is wrong with it?
>Im running apache/mysql om windows XP.
--
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-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Hellllp DBF
sounds like database manipulation was not compiled into PHP when it was
installed on your server.
-Original Message-
From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 8:25 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Hep DBF
I need HELP, I can´t open a DBF, I using this:
$dbf = dbase_open('/public/dados/clientes.dbf',0);
$drec = dbase_get_record_with_names($dbf,1);
// ITEM must be in all caps, otherwise
// you get nothing
echo $drec['ITEM'];
But result this error:
Fatal error: Call to undefined function: dbase_open() in
Please, help me
--
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-mail: [EMAIL PROTECTED]
--
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-mail: [EMAIL PROTECTED]
[PHP-DB] Hellllp DBF
I need HELP, I can´t open a DBF, I using this:
$dbf = dbase_open('/public/dados/clientes.dbf',0);
$drec = dbase_get_record_with_names($dbf,1);
// ITEM must be in all caps, otherwise
// you get nothing
echo $drec['ITEM'];
But result this error:
Fatal error: Call to undefined function: dbase_open() in
Please, help me
--
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-mail: [EMAIL PROTECTED]
[PHP-DB] Re: delete multiple entries from a database using PHP
A little more info would be helpful .. Is this one table or multiple tables .. what are the columns and relationships .. DTSig David Tod Sigafoos On Wed, 26 Sep 2001 21:36:39 +0545, [EMAIL PROTECTED] wrote: >how can I delete multiple entries from a database using PHP . I need to make >a webbased admin tool for a program I'm doing which must have insert, edit, >update and delete facilities I have done all the others except the delete >part. i can do it one by one but its time consuming so I was looking for a >better way.. Help anyone -- 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-mail: [EMAIL PROTECTED]
RE: [PHP-DB] create data array
the following assumes you've opened database.
$query = "SELECT TextVal,Val1,Val2,Val3 FROM mytable WHERE some_condition";
$result = mysql_query($query) or die(mysql_error());
$mycmd = "\$data_array = array (";
while( $row = mysql_fetch_array($result) )
{
$mycmd .=
"array(\"".$row['TextVal']."\",".$row['Val1'].",".$row['Val2'].",".$row['Val
3']."),";
}
$mycmd = substr($mycmd,0,-1).");";
print $mycmd;\\ sanity check...display $mycmd
eval($mycmd);\\ execute the command. $data_array is created
mysql_free_result($result);
-Original Message-
From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 27, 2001 2:14 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] create data array
Hi,
If I need to use data array like this
$data_array = array (
array("text",1,2,3),
array("text",4,5,6),
array("text",7,8,9)
);
all array element are contain in my database. How could I write PHP
code
to make this command on the fly?
SF
--
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-mail: [EMAIL PROTECTED]
--
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-mail: [EMAIL PROTECTED]
RE: [PHP-DB] mysql_fetch_array() doesn't work
change coding to (note, each line is enclosed in quotes and ends withn "."):
$query="select user_id, user_name, time, status, comment from users".
"where sign=1".
"order by user_name".
"limit $offset, $step";
print $query; //sanity check...contents of $query
$res=mysql_query($query) or die(mysql_error()); //note the die() clause
-Original Message-
From: Web user [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2001 05:48
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_fetch_array() doesn't work
System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32 + Win98
When PHP is running at the line: $arr=mysql_fetch_array($res);
The IE always show info as below:
"Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or
`T_NUM_STRING' in c:\program files\apache
group\apache\htdocs\web\site1\list.php on line --[the number of line]"
What's the problem wiht mysql_fetch_array() or other?
What does the T_STRING' or `T_VARIABLE' or `T_NUM_STRING' mean?
THANKS
Mike
The full code below:
-
User
Added timeStatus";
$num=mysql_num_rows($res);
for($i=0; $i<$num; $i++) {
$arr=mysql_fetch_array($res); /* HERE is line where the error
occurs!!!
*/
echo "
$arr['user_name']>";
echo "$arr['time']";
echo "$arr['status']";
echo "$arr['comment']";
}
echo "";
echo ""; /* show others in multi-pages */
for($i=0; $i<$pages; $i++){
echo "
echo ($i+1)."";
echo " ";
}
echo "";
?>
-
create table users (
user_id int not null auto_increment primary key,
user_name varchar(30),
time datetime,
status tinyint(1),
comment text,
sign tinyint(1) default '1'
);
--
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-mail: [EMAIL PROTECTED]
--
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-mail: [EMAIL PROTECTED]
--
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-mail: [EMAIL PROTECTED]
Re: [PHP-DB] php and Oracle database
Georgina: Based on your 2 enclosures, it appears that you have an html file called search1.html. When the user hits the submit button, it calls search1.php4. My question, therefore, is do you have output from search1.php4? Do you see any error messages? Thanks, Anthony Carlos > From: GEORGINA ELAINE BAILEY <[EMAIL PROTECTED]> > Date: Thu, 27 Sep 2001 12:20:17 +0100 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] php and Oracle database > > I am very new to PHP and databases and have not really had very much > programming practice. However, I am trying to create a Web page that > retrieves data from an Oracle database and uses php to display the content > in a HTML format. For some reason though my script just doesn't seem to > work, despite the fact that I know there is data in teh database that > matches the criteria, and only prints the final three HTML links at the > bottom of the script. > > Any ideas? But please make them easy enough for a 3 year old to understand. > > Georgina Bailey > > > > > -- > 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-mail: [EMAIL PROTECTED] -- 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-mail: [EMAIL PROTECTED]
[PHP-DB] php and Oracle database
I am very new to PHP and databases and have not really had very much
programming practice. However, I am trying to create a Web page that
retrieves data from an Oracle database and uses php to display the content
in a HTML format. For some reason though my script just doesn't seem to
work, despite the fact that I know there is data in teh database that
matches the criteria, and only prints the final three HTML links at the
bottom of the script.
Any ideas? But please make them easy enough for a 3 year old to understand.
Georgina Bailey
Project Database - Project Search
Project Search
http://users.aber.ac.uk/geb97/search1.php4"; method="POST">
Please select the relevant module and then check the area(s) that
may interest you
If, for example, you would like to see all projects that involve
Java,
check the Java box. If you would like only those that involve both Java and databases,
check both boxes.
You must check at least one box
CS39030
CS39110
CS49060
CSM9060
CSM9260
Java
Telematics
Artificial
Intelligence
Databases
68HC11 Assembly
Language
Web Development
Other Programming
Languages
http://www.aber.ac.uk";>Return to UWA Home Page
http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page
Return to Project Database Main Menu
Project Database - Search Results
";
//echo " ORIGINATORTITLEPROJECT
NUMBERAVAILABILITYSPECIAL //SKILLS
//retrieve the results of the query statement and present them in the
following way
while (ocifetch($qry_statement))
{
echo "The Originator is:" .OCIresult($qry_statement, 'ORIGINATOR');
echo "The title is:" .OCIresult($qry_statement, 'TITLE');
echo "The projectID is: ". OCIresult($qry_statement, 'PROJECTID');
echo "The availabilty is: ". OCIresult($qry_statement, 'AVAILABILITY');
echo "The special skills are: ". OCIresult($qry_statement,
'SPECIALSKILLS');
//echo "" .OCIresult($qry_statement,
'ORIGINATOR'). "";
//echo "" .OCIresult($qry_statement,
'TITLE'). "";
//echo "" .OCIresult($qry_statement,
'PROJECTID'). "";
//echo "" .OCIresult($qry_statement,
'AVAILABILITY'). "";
//echo "" .OCIresult($qry_statement,
'SPECIALSKILLS'). "";
}
//log off the database
OCILogoff ($connection);
}
?>
http://www.aber.ac.uk";>Return to UWA Home Page
http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page
Return to Project Database Main Menu
--
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-mail: [EMAIL PROTECTED]
[PHP-DB] MSSQL and BLOBs
Hi! Does anybody get it working to extract/insert BLOBs from/into a MSSQL (7 or 2000) database with PHP4? What is the best way to do it? COM objects and ADO, mssql functions or ODBC functions? I tried it with the ODBC functions. It works but there's the 1MB limit and I need to access BLOBs with a size >1MB. I tried it with ADO (GetChunk) but failed with an "Unsupported variant type". Any help greatly appreciated. Guido -- 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-mail: [EMAIL PROTECTED]
[PHP-DB] howto craete a stored procedure in DB2?
hi, i'm working on "OUT" paramter support in the ODBC module when calling stored procedures. to start playing with it i need to create a stored procedure in DB2 (this is the db my customer is using). me -the stupid oracle guy- does not know how to load a stored procedure into DB2. could anybody give me a tiny example how to load such a beast into DB2? re, tc -- 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-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP and ms Access
www.phpbuilder.com has a few decent articles on this that will help you. olinux -Original Message- From: François PERROT [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 10:19 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP and ms Access Hi, You need to retreive data using a query script and just put them in a page :) It's as easy as that... Anyway if you precise your question we'll be able to give a more precise answer -Message d'origine- De : user <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date : vendredi 31 août 2001 15:33 Objet : [PHP-DB] PHP and ms Access >Hello, > >I am builing a microsoft access database. > >Now wants the compagny I created it for me to use it to make dynamic >webpages. The problem is that I am new at this. > >Can somebody please explain the basics of integrating a MS Access databse >with php into a webpage? > >I thank you in advance, > >TheB'Oss > >//Could you please mail the answer to [EMAIL PROTECTED] > >Thx > > > >-- >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-mail: [EMAIL PROTECTED] -- 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-mail: [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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-mail: [EMAIL PROTECTED]
RE: [PHP-DB] mail() - is there a limit?
olinux: I do not know the answer to your question. However, I would alternatively suggest that you send the email to each person individually. That is to say, loop through your recipient array and use mail() to send the message to each recipient, as opposed to creating a bcc array and then sending one email. This solution will take longer to execute -- you may in fact need to adjust the maximum program execution time via set_time_limit() -- but each recipient will receive an individual email, which, I think, will make your message look more personal. Plus, you no longer need to consider the number of addresses in the bcc field. Let me know if you have any questions! -luke Luke Muszkiewicz Pure Development, LLC http://puredev.com > I am using a script that grabs about 100 emails from a > database, loops thru and writes them to $bcc > > Then I use a single mail() to send a msg to everyone > in the $bcc > > Is there a maximum nuber of emails that i can mail to > this way? > > Thanks, > olinux -- 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-mail: [EMAIL PROTECTED]
