On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I wish to accomplish the following with prepared statements:
$stmt = mysqli_stmt_init($cxn);
if($stmt = mysqli_stmt_prepare($stmt, INSERT INTO Intake3 (Site,
MedRec, Fname, Lname,
Ethan Rosenberg, PhD
/Pres/CEO/
*Hygeia Biomedical Research, Inc*
2 Cameo Ridge Road
Monsey, NY 10952
T: 845 352-3908
F: 845 352-7566
erosenb...@hygeiabiomedical.com
On 09/02/2012 08:33 AM, Matijn Woudt wrote:
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I wish to accomplish the following with prepared statements:
$stmt = mysqli_stmt_init($cxn);
if($stmt = mysqli_stmt_prepare($stmt, INSERT INTO Intake3 (Site,
MedRec, Fname, Lname,
On Sun, Sep 2, 2012 at 10:41 PM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I wish to accomplish the following with prepared statements:
$stmt =
Remove the quotes around the variables in all your statements.
For example, this statement:
mysqli_stmt_bind_param($submitadmin, isss, '$numrows', '$admin',
sha1('$password'), '$email');
could be rewritten as:
mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin,
sha1($password), $email);
That worked, thanks!
Remove the quotes around the variables in all your statements.
For example, this statement:
mysqli_stmt_bind_param($submitadmin, isss, '$numrows', '$admin',
sha1('$password'), '$email');
could be rewritten as:
mysqli_stmt_bind_param($submitadmin, isss, $numrows,
kesavan trichy rengarajan wrote:
could be rewritten as:
mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin,
sha1($password), $email);
Turning on E_STRICT in PHP 5.3 will show
PHP Strict Standards: Only variables should be passed by reference
This is also true in earlier
Done. Thanks for letting me know about that.
kesavan trichy rengarajan wrote:
could be rewritten as:
mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin,
sha1($password), $email);
Turning on E_STRICT in PHP 5.3 will show
PHP Strict Standards: Only variables should be
Hi i wanna ask a question. I am trying to create an image on fly, please do
help me , following is the code.
*File Name : Font.php
Code: *
html
head
titleImage Creation/title
script language=javascript
var xmlhttp;
function showPic()
{
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
{
You need to separate the SET arguments with commas, not ANDs...
It's really doing something like this:
UPDATE shop_customer SET eu_vat_number = (SK1234567890 AND vat_amount = 0
AND total_amount = 8.4925) WHERE customer_id = 7 AND hash=dcd5e751
(SK1234567890 AND vat_amount = 0 AND total_amount =
Message-
From: Jenaro Centeno Gómez [mailto:[EMAIL PROTECTED]
Sent: 04 March 2006 17:35
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL update statement problem
Maybe I am wrong, biut isn´this the rigth way to do this:
UPDATE shop_customer SET eu_vat_number = SK1234567890, vat_amount =
0
does your web server, php and db all use the same charset? they all should
match
From: Dominik Fi¹er [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL in PHP5 - problem with charset
Date: Sun, 11 Sep 2005 14:35:44 +0200
I have problem with MySQL in PHP 5.0.4 (WIN XP). I
I think yes. PHP default_charset = win-1250, mysql: def. char. set cp1250,
apahce 2: AddDefaultCharset WINDOWS-1250 (AddCharset WINDOWS-1250 .cp-1250
.win-1250)
With php4 with same configuration apache2 and mysql server is all OK.
Bastien Koert [EMAIL PROTECTED] pí¹e v diskusním pøíspìvku
I could be 100% wrong on this, but I do not think that a command line
statement can be executed through mysql_query() - try exec().
If I remember correctly mysql load data infile ... is not executed from
within mysql, but at the command line.
(Hint: look at the source for phpMyAdmin and copy
You can definitely do a load file from within the mysql client, so I'd
guess you can do it through mysql_query, too. I'm wondering about the
semi-colon within the query. Maybe it needs to be escaped, too.
David
I could be 100% wrong on this, but I do not think that a command line
statement
where you open
the file and read it in, parsing thru it to access the data elements and
running sql statements thru a loop
Bastien
From: [EMAIL PROTECTED]
To: Miles Thompson [EMAIL PROTECTED]
CC: php-db-list php-db@lists.php.net
Subject: Re: [PHP-DB] load data infile -- problem
Date: Thu, 18
Use a real hostname, not 'localhost'.-
--
Atte, Andrés G. Montañez
Técnico en Redes y Telecomunicaciones
Montevideo - Uruguay
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Andrés G. Montañez [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Use a real hostname, not 'localhost'.-
Will give that a try. Thank you.
--
Atte, Andrés G. Montañez
Técnico en Redes y Telecomunicaciones
Montevideo - Uruguay
--
PHP Database Mailing List (http://www.php.net/)
To
try the mktime function
bastien
From: Shay [EMAIL PROTECTED]
Reply-To: Shay [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] strtotime: Last Month problem
Date: Wed, 30 Mar 2005 15:02:27 -0700
Hi, I'm trying to use strtotime(last month), strtotime(-1 month), or
strtotime(1 month ago)
amol patil wrote:
hallo,
i have changed file signup1.php with login1.php, in action fied of form
form name=form1 method=POST action=--
and saved .
but when i run this file and click on submit button, it still shows old sighnup1.php. and data is also not entering in database. while it
There are scores of examples / tutorials on this. Google turned up 6,070
hits on this expression:
add user php mysql example
Here's one of them, although it assumes register globals is on
http://www.php-scripts.com/php_diary/072000.php3
Why don't you pick one, work with it and
On Tue 28 Dec 04, 11:44 AM, Miles Thompson [EMAIL PROTECTED] said:
At 09:25 AM 12/28/2004, amol patil wrote:
hallo,
i have changed file signup1.php with login1.php, in action fied of form
form name=form1 method=POST action=--
and saved .
but when i run this file
To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 30 November 2004 14:45, SCALES, Andrew wrote:
Thanks very much for your help. The main difficulty I was
having really was
unlocking the record again if the user crashed out
though.
Andy
-Original Message-
From: Norland, Martin [mailto:[EMAIL PROTECTED]
Sent: Monday, 29 November 2004 15:36
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Multi-User Update Problem
-Original Message-
Does anyone know a good way of locking out access to a record on a
MySQL
try that.
Thank you both for the advice,
Andy
-Original Message-
From: Gryffyn, Trevor [mailto:[EMAIL PROTECTED]
Sent: Monday, 29 November 2004 15:44
To: [EMAIL PROTECTED]
Cc: Bastien Koert; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Multi-User Update Problem
Yeah, all good thoughts
have issues. :)
Good luck!
-TG
-Original Message-
From: SCALES, Andrew [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 30, 2004 9:45 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Multi-User Update Problem
Thanks very much for your help. The main difficulty I was
having
Its a tough one. My personal fav is to mark the record as locked by changing
a field called 'locked' from 0 to 1. Check for this when extracting the
record and if is present, alert the user this record is locked (if you want
to get fancy you could even track who locked it and the tell the user
-Original Message-
Does anyone know a good way of locking out access to a record on a
MySQL database when someone has the update page open? The problem is
that we have a local intranet site which is accessed by members of
different departments. Now at the moment when someone loads the
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Monday, November 29, 2004 10:22 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Multi-User Update Problem
Its a tough one. My personal fav is to mark the record as
locked by changing
Chris wrote:
Here is the code I use:
[snip]
$sql = $db-prepare(INSERT INTO ExitSurveyAnswers (session_id,
Question_id, answer) VALUES ?,?,?);
[snip]
When I execute it I keep recieving and error message stating:
DB Error: syntax error
Not a MSSQL expert, but shouldn't the ?,?,? in your query have
In article [EMAIL PROTECTED], Jason Wong wrote:
On Friday 16 July 2004 08:05, Justin Patrin wrote:
If you're simply trying to get '@email.com' then use strstr().
Of courseI'm just so used to pregs...
Well the advantage of using a regex is that you can perform some form of
On Friday 16 July 2004 16:01, Tim Van Wassenhove wrote:
In article [EMAIL PROTECTED], Jason Wong wrote:
On Friday 16 July 2004 08:05, Justin Patrin wrote:
If you're simply trying to get '@email.com' then use strstr().
Of courseI'm just so used to pregs...
Well the advantage of
On Friday 16 July 2004 08:05, Justin Patrin wrote:
If you're simply trying to get '@email.com' then use strstr().
Of courseI'm just so used to pregs...
Well the advantage of using a regex is that you can perform some form of
validation on the address.
--
Jason Wong - Gremlins
Justin Patrin wrote:
Charles Morris wrote:
putenv(ORACLE_SID=PROJ);
putenv(ORACLE_HOME=/home/oracle9);
I have tried putenv myself and it doesn't seem to work for Oracle
connections. Putting those in your shell environment, then restarting
apache. Check to see if the env vars are set
]
Subject: Re: [PHP-DB] Load data infile problem
does your server have the post variables set as globals? you might
have to use $_POST['submit'] instead.
On Jun 7, 2004, at 9:17 PM, [EMAIL PROTECTED] wrote:
Hello,
I have a page with a button that when clicked loads a pre-determined
text file
Very odd. I would think it would return every record seeing as the auto_increment ID
field is different for every record.
I use SELECT DISTINCT tip, marca, model FROM modele to select
records without duplicates on the field tip. This works ok, BUT if I
use SELECT DISTINCT tip, marca, model, id
- Original message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Sat, 8 May 2004 23:23:05 +0300
Subject: [PHP-DB] another strange MYSQL problem
Hello,
First, I use this, and all is ok:
SELECT * FROM modele WHERE marca='Aprilia' ORDER BY tip ASC.
Then, I use
Run those queries again and send in the result set. Maybe they're being sorted
but it looks off, also what is the data type for you 'tip' column. Post your db
schema if possible.
R
Quoting Marcjon Louwersheimer [EMAIL PROTECTED]:
- Original message -
From: [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
First, I use this, and all is ok:
SELECT * FROM modele WHERE marca='Aprilia' ORDER BY tip ASC.
Then, I use this:
SELECT * FROM modele WHERE marca='Cagiva' ORDER BY tip ASC
and the records are not ordered ascending by the field tip. In the
first case, the records were
Is there any way to destroy the object in PHP?
http://us2.php.net/manual/en/function.unset.php
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Irin,
First of all, you need to do this instead of what you're doing:
while ($row = mysql_fetch_row($sql))
Second, this value should be storable just as any other values.
i.e.
mysql_query(insert into database (table) values(' .
$_POST['class_code'] . '));
I hope this helps you a bit.
Regards,
.
- Original Message -
From: Doug Thompson [EMAIL PROTECTED]
To: Robin 'Sparky' Kopetzky [EMAIL PROTECTED]
Cc: Erwin Kerk [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, February 27, 2004 1:04 AM
Subject: Re: [PHP-DB] SQL File Import problem (Was: HELP!!!)
On Fri, 27 Feb 2004 01:16:20
Hi all:
I am trying to create a registration form whereby one of the user input is as
follows: (a drop down menu with values retrieved from DB):
-
td class=lighter width=350Class Code:/td
td class=lighter
Try:
OPTION VALUE=\$row['class_code']\ .$row[class_code]. /option;
while ($row = mysql_fetch_array($sql))
{
print OPTION VALUE=\$class_code\ .$row[class_code]. /option;
}
$result = $db-query($sql);
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Fri, 27 Feb 2004 01:16:20 +0100, Erwin Kerk wrote:
Robin 'Sparky' Kopetzky wrote:
Good afternoon!
I used SQLYOG to export the tables and data from a Mysql database. Now, when
i try to re-import the data back into a different database, I get an error
stating Error : MySQL server has gone
Thank you to all who helped. I was able using UltraEdit to chop up the sql
file and created all of the individual INSERT statements. Now, I'm up and
running again. Slow but it worked!
Thanks again!
Robin Kopetzky
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Robin 'Sparky' Kopetzky wrote:
Good afternoon!
I used SQLYOG to export the tables and data from a Mysql database. Now, when
i try to re-import the data back into a different database, I get an error
stating Error : MySQL server has gone away. What is happening and how do I
fix this. I NEED this
Thanks Justin, thats a handy function.
I've been testing my code and found that it works up until I start passing
objects into methods. This is the code I'm using to set up some objects
(they are being passes variables that have been settype()'d):
$sessioniser = new Java('com.SessionManager',
, not the file
itself, try both).
-Original Message-
From: Ruprecht Helms [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 8:15 AM
To: Michael Scappa
Cc: [EMAIL PROTECTED]
Subject: [PHP-DB] RE: [PHP-INSTALL] Problem by running mysql-connection
in php-script
On Thu, 2003-10-02 at 22:28
On Thu, 4 Sep 2003, Balaji H. Kasal wrote:
It is usually better not to use persistenc connections.
So drop the pmysql_connect or if you really need to use
them set set max connections higher for mysql.
Which problem it has?
On a really busy site persistent
On Wed, 3 Sep 2003, Merlin wrote:
After doing some research it looks like this is a problem because I am
using pmysql_connect instead of mysql_connect.
It is usually better not to use persistenc connections.
So drop the pmysql_connect or if you really need to use
them
After doing some research it looks like this is a problem because I am
using pmysql_connect instead of mysql_connect.
It is usually better not to use persistenc connections.
So drop the pmysql_connect or if you really need to use
them set set max connections higher
FYI:
OOPS!!
I dug around in the install.txt file in PHP, and found that php4ts.dll needs to
be relocated to either where apache.exe resides, where
php4apache.dll resides, or in the windows system directory. All now works as
expected.
David
[EMAIL PROTECTED] on 07/14/2003 11:35:42
AM
To:
Hi
Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms:
Hi,
in the meantime I set the value of register_globals = off
the next to on.
I get the same result. The following script I use for testing the
formfieldvalues
?
echo $begriff
?
As I said before, this the wrong way. You
On Thu, 2003-06-19 at 23:30, Thorsten Körner wrote:
Hi
Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms:
Hi,
in the meantime I set the value of register_globals = off
the next to on.
I get the same result. The following script I use for testing the
formfieldvalues
?
HI
Am Donnerstag, 19. Juni 2003 23:54 schrieb Ruprecht Helms:
On Thu, 2003-06-19 at 23:30, Thorsten Körner wrote:
Hi
Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms:
Hi,
in the meantime I set the value of register_globals = off
the next to on.
I get the same
I have an application that is currently working fine under 4.1.2,
and I am in the process of upgrading to 4.2.3. The problem is that after
upgrading PHP the application login no longer works. Additionally, this
same application works fine on another machine running 4.2.3. The only
' - it is only text in this case and it will be part
of the email body.
Thanks anyway,
Martin
-Original Message-
From: John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Thursday, 5 June 2003 3:02 p.m.
To: 'Martin Rajcok'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] I have a problem to add
I have a problem to add a new line to the body of my email when I am
using
'a href=mailto: ... function.
This is my code:
$details[email] //email of the user from the form
$details[contact_name] //name of the user from the form
$email_subject = subject text...;
$email_form = Welcome
PROTECTED]
Sent: Thursday, 5 June 2003 3:02 p.m.
To: 'Martin Rajcok'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] I have a problem to add a new line to the body of
my email when I am using 'a href=mailto: ... function
I have a problem to add a new line to the body of my email when I am
using
'a href
Hi,
Does mysql user has rights to write in this directory or permissions over
this file?
Andrey
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:00 AM
Subject: [PHP-DB] MySQL Database connection Problem
Hello can someone
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob not null,
- primary key (id), unique id (id));
ERROR 3: Error
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob not null,
- primary key (id), unique id (id));
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:11 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some
Hristov
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:11 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give
what about the permissions? are they ok?
Andrey
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:30 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem
Andrey thanks, but I seen that already and theres over 80 gig left
On Friday 03 January 2003 17:11, conbud wrote:
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob
On Saturday 21 December 2002 05:25, Seabird wrote:
Hi everyone,
every time I try to upload a picture I get the same problem in return.
First of all, it's not being uploaded (but this is for later concern I'm
afraid). Trying to display the info of the (not)uploaded file should be
done with:
You have to put the same under [server]
Nikos wrote:
Hello there...
I have a problem with sort order. I use greek and english characters.
The manual says to put the following lines to my.cnf:
[client]
character-sets-dir=/usr/local/mysql/share/mysql/charsets
default-character-set=greek
i restart
:
Subject: RE: [PHP-DB] mssql select db
problem
10/14/2002 11:30
AM
]
10/14/2002 cc: 'Kadir Leblebici'
[EMAIL PROTECTED], [EMAIL PROTECTED]
11:32 AM Subject: RE: [PHP-DB] mssql select db
problem(Document link: Jeff
Dyke
- Original Message -
From: Jason Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 6:45 AM
Subject: Re: [PHP-DB] Global variables, $_GET problem
On Wednesday 24 July 2002 11:38, Ruth Zhai wrote:
We just upgraded our PHP to version 4.2.1. I realized
Ruth,
your reference to $_GET('var') is close, but as you have seen - no cigar :)
using the () after GET makes it refer to a function, but it is actually an
array which is automatically created, so you need to use
$_GET['var'] (note the square brackets
as for point 2 (register_globals) did you
On Wednesday 24 July 2002 11:38, Ruth Zhai wrote:
We just upgraded our PHP to version 4.2.1. I realized that $var is no
longer available from www.url.com/myphp.php?var=3 . As instructed in the
document, we have tried two things:
Good, someone who reads the docs :)
1. I tried to use
:[EMAIL PROTECTED]]
Sent: Tuesday, July 09, 2002 2:50 AM
To: 'Keiran Wynyard'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Form select field problem
Keiran,
A couple possibilities for you;
1. Try referring to the field (in JavaScript) as something like; (might have
to play around
Keiran,
A couple possibilities for you;
1. Try referring to the field (in JavaScript) as something like; (might have
to play around with this)
document.existing[groupchoice[]].selectedIndex
2. Make it so that each selection on the select tag is mirrored into
another hidden input field
From your query, it looks as if you are letting the user select the table that they
can query with $pop-up1. Is that correct?
If so, do all the available choices of tables have the same column names? Other than
that I can't see why this query would fail.
Martin
eat pasta type fasta [EMAIL
Could this be as simple as a typo?
textfield
texfield
Jen Swofford
[EMAIL PROTECTED]
-Original Message-
From: eat pasta type fasta [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 3:27 PM
To: PHP LIST
Subject: [PHP-DB] Strange MySQL Query Problem
I already got some
On Wednesday 03 July 2002 12:42, eat pasta type fasta wrote:
I have a simple form which queries the database based on 2 pop-up menu
choices and keywords entered by the user,
it passes on the variables as follows:
pop-up1=choice1, pop-up2=choice2, textfield=user specified data
the query is
Adam,
Thanks for the assist.
The query works fine without the ( ) arount the conditions.
Now on to the next part.
George
- Original Message -
From: Adam Royle [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 10:03 PM
Subject: [PHP-DB] Re: PHP
You running Windows or *nix? File permissions will play a part in this,
but use PHP's exec() function to execute MySQL's load data infile. The
manual has a number of well annotated examples. The big problem may be that
you'll be executing the command as whatever user the web server is running
On Fri, 23 Nov 2001 14:04:00 -0600
Terry Romine Terry Romine [EMAIL PROTECTED] wrote:
I seem to have run into a strange bug where when I enter text
through a
form, and use the nl2br call in PHP, instead of getting BR I
get
BR / and then my parsing fails on the display side (where I
use
, October 17, 2001 12:13 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: UPDATE table Problem
Dear Sir George Liomis,
But there is still the update command issue why didn't my
update command
work when i tryed it in my php source it didn;t work but in
the mysql shell
it updated it for me
On Wed, Sep 05, 2001 at 10:24:28AM -0500, Brian Mauter wrote:
Are you running out of logons? You should only need the client
libraries on
the machine with the PHP pages. You do not need them anywhere else.
(That's the beauty of the web!)
Make sure you have ocilogoff in your PHP page when
On Mon, 20 Aug 2001, LondonVibe wrote:
new to php so be nice :)
win2k iis5.ms access..
what is the order for adding var's to a access DB ??
code i tried... with data from form don't work...
// connect to system dsn odbc name login and password or die
$connect =
Thanks for your reply
You don't show your SQL, but I assume it's something like
SELECT grp,svc,mach FROM table ORDER BY grp,svc,mach
Thats right.
But its displaying the same as my code:
---
Group:Desktop
Service:BACKUP
AITSBKUP
Service:E-Mail
AITSMAIL
Service:E-Mail
JEEVES
Group:Unix
On Fri, May 18, 2001 at 04:32:51PM +0200, Keith Whyman wrote:
while ($p = mysql_fetch_array($result1)) {
$msg .= $p[s_bereich_name];
$msg .= $p[s_news_text];
$msg .= $p[s_users_real_name];
I'm not sure if this is what you want, but something like this maybe??
?php
while($p =
fixed it.
code is below: (output 1 is screen output 2 is csv).
it seemed to like fetch_row better than fetch_array .. if anyone could
explain i would be really grateful.
there's nothing worse than fixing something and not knowing how you did it
!;-)
for ($x=0; $x$numcdbs; $x++)
{
On 10 Apr 2001, at 13:49, Rob Griffiths wrote:
**50** print "tr bgcolor=#66td{$A["fname"]}/td" .
"td{$A["lname"]}/td" . "
td{$A["dept"]}/td" . " td{$A["manager"]}/td" .
"td{$A["extension"]}/td/tr\n";
Notation with "{" parenthesis is not
That said, (Now on to actual PHP) I've noticed (in my own scripting) and a
few other problems posted here quite a bit of confusion with PHP's single '
and double " quotes. Reading the material I was led to believe that
' ' outputs exactly what is in the quotes and
" " outputs variables
Looks like your PHP installation is not compiled
with interbase support.
Can you guve us some more details ?
What is the OS you're using and the
code the caused you problems.
Meir Kriheli
MKsoft computer systems
'There's someone in my head but it's not me" - Pink Floyd
- Original
With HORA, it is no problem to display the hierarchic structure via the
CONNECT BY clause. I tried the same statement in PHP3 and it
I'm using php4pl1 with Oracle 8.1.6 and this works:
select c.cvsn_id,
c.parent_cvsn_id,
level
from cvsn c
where start with
Can anybody help me about my serious problem to connect to MS SQL 7.0. I
tried to use the freetds-driver but i'm not able to connect with it. They
said that I must define the Serverconnection in the interfaces-file. I
found
one in the freetds-directory but i don't know how to write it
93 matches
Mail list logo