Rosenberg, PhD [mailto:erosenb...@hygeiabiomedical.com]
Enviado el: domingo, junio 23, 2013 4:38 PM
Para: php-db@lists.php.net; Jim Giner
Asunto: [PHP-DB] Re: Problem with query
On 6/23/2013 2:31 PM, Ethan Rosenberg, PhD wrote:
Dear List -
There is an error in my query, and I cannot find
What Jim means is here in the manual:
http://www.php.net/manual/en/language.types.array.php#language.types.array.donts
In a nutshell:
Always use quotes around a string literal array index. For example,
/$foo['bar']/ is correct, while /$foo[bar]/ is not.
The reason is that without the
I'm sorry I've not been following the last three responses. In a nutshell,
what EXACTLY does the poster of this issue want?
On 25 June 2013 11:06, Toby Hart Dyke t...@hartdyke.com wrote:
What Jim means is here in the manual:
http://www.php.net/manual/en/**language.types.array.php#**
On 6/25/2013 6:06 AM, Toby Hart Dyke wrote:
What Jim means is here in the manual:
http://www.php.net/manual/en/language.types.array.php#language.types.array.donts
In a nutshell:
Always use quotes around a string literal array index. For example,
/$foo['bar']/ is correct, while /$foo[bar]/
The original post is here:
http://news.php.net/php.db/48751
On 6/25/2013 1:02 PM, Michael Oki wrote:
I'm sorry I've not been following the last three responses. In a nutshell,
what EXACTLY does the poster of this issue want?
On 25 June 2013 11:06, Toby Hart Dyke t...@hartdyke.com wrote:
On 6/25/2013 2:32 AM, OJFR wrote:
Yeah, Jim, please explain what u mean by Per the manual, associative arrays
using string indices should always use ' ' around them. They work (as
mentioned in the manual) but are wrong. As long as I remember I could use
associative arrays in that way (ex.
On 6/23/2013 2:31 PM, Ethan Rosenberg, PhD wrote:
Dear List -
There is an error in my query, and I cannot find it.
This fails:
$_SESSION['Cust_Num'] = $_REQUEST['cnum'];
$_SESSION['CustNum'] = $_REQUEST['cnum'];
echo sessionbr /; //this has the proper values
print_r($_SESSION);
$sql10 =
On 6/23/2013 2:31 PM, Ethan Rosenberg, PhD wrote:
Dear List -
There is an error in my query, and I cannot find it.
This fails:
$_SESSION['Cust_Num'] = $_REQUEST['cnum'];
$_SESSION['CustNum'] = $_REQUEST['cnum'];
echo sessionbr /; //this has the proper values
print_r($_SESSION);
$sql10 =
On 23 June 2013 21:37, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com
wrote:
On 6/23/2013 2:31 PM, Ethan Rosenberg, PhD wrote:
Dear List -
There is an error in my query, and I cannot find it.
This fails:
$_SESSION['Cust_Num'] = $_REQUEST['cnum'];
$_SESSION['CustNum'] =
Sounds to me like you really need to study database design. 30 years of
doing it professionally, never heard of a design that involved what you are
suggesting. Good luck!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Jason Pruim wrote:
Given the following 2 queries:
SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}';
SELECT DISTINCT areacode FROM main;
The second displays ALOT faster Like by minutes... the first one is
what I really want though Currently working with a
Any help?
On Mon, Jun 13, 2011 at 5:38 PM, C0mf0rtably Numb 08.kus...@gmail.comwrote:
Hello everyone,
I am in the process of learning php and I was trying to connect to a mysql
database on my own computer(localhost). I have done the following as
prerequisites:
copied the dll files in
On 13 June 2011 14:12, C0mf0rtably Numb 08.kus...@gmail.com wrote:
Any help?
On Mon, Jun 13, 2011 at 5:38 PM, C0mf0rtably Numb 08.kus...@gmail.comwrote:
Hello everyone,
I am in the process of learning php and I was trying to connect to a mysql
database on my own computer(localhost). I have
On 13 June 2011 15:28, C0mf0rtably Numb 08.kus...@gmail.com wrote:
My php and apache are working fine together. I was doing good with php and
apache until I decided to work with mysql. I will have a look at all the
links you provided and see if gives me a solution. Thanks.
On Mon, Jun 13,
Neil Smith [MVP, Digital media] wrote:
When you create your DB connection $db, follow the connection line
directly after with this :
$db-setAttribute(PDO::ATTR_ERRMODE , PDO::ERRMODE_EXCEPTION);
The default is I believe PDO::ERRMODE_SILENT which is confusing to most
people the first time.
Message-ID: 49b2ce8f.1090...@theingots.org
Date: Sat, 07 Mar 2009 20:44:15 +0100
From: Daniel Carrera daniel.carr...@theingots.org
Hello,
I have MySQL 5.1 and PHP 5.2. For some reason PDO is not throwing
exceptions when I give it a broken SQL query. For example:
try {
$stmt =
JavaScript issue? I would assume it is an issue with JavaScript,
because PHP doesn't care what browser asks for data, unless your program
is hanging somewhere on a browser-specific issue.
-Logan
-Original Message-
From: Imran [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 11, 2007
Hi Mr.Logan,
If i had a problem with Javascript it shouldn't have worked with Firefox
right ? But it works fine with firefox.
Anyway iam checking with javascript code.
Best Regards,
Imran Khan
- Original Message -
From: Buesching, Logan J [EMAIL PROTECTED]
To: Imran [EMAIL
Well, JavaScript interpreters are much different from IE to Firefox to
Opera, but as far as PHP goes, PHP outputs the same thing weather you
use Firefox, Opera, IE etc...
If you didn't have any browser specific PHP code, it would seem it is a
JavaScript problem.
-Logan
-Original
Hi Logan,
Iam just looking at the javascript code. Will update you soon.
Best Regards,
Imran Khan
- Original Message -
From: Buesching, Logan J [EMAIL PROTECTED]
To: Imran [EMAIL PROTECTED]; php-db@lists.php.net
Sent: Wednesday, April 11, 2007 12:42 PM
Subject: RE: Problem with Opera
Hello,
if you add your ENV variables for the oracle user (for example
ORACLE_HOME, ORACLE_SID) in the Apache startup script, your problem will be
solved.:) . You can create your your own Apache startup script
/etc/rc.d/init.d folder after this step. You should create a link file. You
can
mssql has a dependency on mysql. Go figure.
MySQL has some dependencies, also, although they are a little easier to
find info on and do not require installing other extensions. If you
have the PHPRC system path set to your Windows PHP directory, you should
be OK. Otherwise you may have to
The MSSQL extension does not rely on MySQL in any way. The only required
DLL is ntwdblib.dll.
It would help if you could post any error messages or some sample code
that shows your problem.
The 'correct' installation is to copy ntwdblib.dll to windows\system32 on
the system that runs the PHP
Mohamed Yusuf wrote:
I am transmitting variable from one of my pages and I would like to match
that variable into mysql data. it won't return data.
my code is this.
?php for ($j=A; $j = Z; $j++) {
echo | ba href='alpha.php?artist=$j'$j/a/b |;
if ($j == Z) {
break;
}
} ?
this code
PROTECTED]
Sent: Monday, September 19, 2005 2:19 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: Problem with mysql_connect(...)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Hello.
I'm trying to connect to my MySQL server with mysql_connect(...). The
server is up and running,
and I'm
.
-Original Message-
From: viraj [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 20, 2005 12:14 AM
To: Dan
Cc: Michael Louie Loria; php-db@lists.php.net
Subject: Re: [PHP-DB] Re: Problem with mysql_connect(...)
this is a dll issue; if you are running php5 on windows!
read this..
http
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Hello.
I'm trying to connect to my MySQL server with mysql_connect(...). The server
is up and running,
and I'm running Apache with PHP properly installed. The code:
$hleServer = mysql_connect($host, $user, $password)
or die(Error: Database.
other.
-Original Message-
From: Michael Louie Loria [mailto:[EMAIL PROTECTED]
Sent: Monday, September 19, 2005 2:19 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: Problem with mysql_connect(...)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Hello.
I'm trying to connect to my MySQL
TEST your connection :
if ($c=OCILogon(user, password, db)) {
echo Successfully connected to Oracle.\n;
} else {
$err = OCIError();
echo Oracle Connect Error . $err[text];
}
if you have an error try to add other putenv() as :
putenv(ORACLE_BASE=/home/oracle);
Jeffrey Baumgartner [EMAIL PROTECTED] schreef in bericht
news:[EMAIL PROTECTED]
I've made a little programme that deletes expired records from database
tables. The troublesome bit looks like this...
$query = SELECT ic FROM ic_ic WHERE date = CURDATE();
$result =
Steve McGill wrote:
Jeffrey Baumgartner [EMAIL PROTECTED] schreef in bericht
news:[EMAIL PROTECTED]
I've made a little programme that deletes expired records from database
tables. The troublesome bit looks like this...
$query = SELECT ic FROM ic_ic WHERE date = CURDATE();
$result =
That was indeed the problem and of course I should have seen it myself!
Thanks very much, Jochem.
Jeffrey
Jochem Maas wrote:
Steve McGill wrote:
Jeffrey Baumgartner [EMAIL PROTECTED] schreef in bericht
news:[EMAIL PROTECTED]
I've made a little programme that deletes expired records from database
It would make things easier if you could determine the error, so try to
use mysql_error after all your mysql_queries, not just after the first one.
Stefan
[EMAIL PROTECTED] wrote:
I'm having trouble with having trouble with doing an update after doing an
insert on and a select on a table. The
Well - after much experimentation, hair-pulling, and chasing of red herrings
I have discovered the error of my ways. :oD
Despite my 4 PHP reference books I eventually turned to the PHP Manual (in
.chm form) and it seems that the dba_open() function was modified for PHP
4.3.0 et seq, to
Sascha Noethen wrote:
Hi,
I am trying to compile PHP 5 with mysqli support:
./configure --with-mysqli
The result is an error message and I cannot find out how to avoid this
error message:
checking for MySQLi support... yes
checking whether to enable embedded MySQLi support... no
checking for
Sukanto Kho [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi All,
I've created an function for update record in database's table.
the function can handle all the record update from any table... with
parameter passed in .. like this :
function update($table,$values,$condition)
{
Well, your query looked confusing to me, but break it up like this
First :
select
Then, name your coloumns, seperate with commas, or use wildcard for all
*
Define from what table you need to select
FROM database_table
Add some select statements with WHERE
WHERE
and the statements
Kim,
Won't redefining the variable destroy the MySQL Resource, resulting in a
resource invalid error, like he has?
$pic = mysql_query($sql,$connection); //Defines variable
$pic //Redefining variable, dumps old contents = //calling on an invalid MySQL Resource, because it doesn't exist
Ciao..hi, i would suggest to embed the html code in php like this:
?php
$_your_variable=$row[imgid];
echo
a href=\../images/image.php?img=$_your_variable\
target=\_blank\
onClick=\window.open(this.href, this.target,
\'width=200,height=250\');
return false;\img
tests under 4.3.4 and 4.3.3
Yannig Beyet [EMAIL PROTECTED] a écrit dans le message
de news:[EMAIL PROTECTED]
Hi,
I'am currently migrating my servers from nt4/IIS4 to Windows server
2003/IIS6, my db is under NT4/SQL7 Secondary domain controller,
from iis4 no problem to access (guest user for
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi all:
Well, when i bring out the page with the drop down list it was able to
display
all tutors' names from tutor_name column. Anyway here's a review of my
code
(snip) again before i continue:
I was able to get rid of the parse error, but what I saw causing the
error was a little strange. All I did was delete the spaces between
your if statement and the bracket that follows ie. if( not if (
The next thing that I did was rewrote the line that says 'echo
tdOpen/td;' although I didnt
From: Jeremy Shovan [EMAIL PROTECTED]
All I did was rewrite it exactly the same as it was and the
parse error disappeared. I have never seen anything quite
like this before.
Seen this before. It's either the editor or a copy and paste operation
adding weird invisible characters. Major pain in
It can be set up in php.ini file Find the appropriate section and uncomment
it
Shadow
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
You cannot write anything out before the session_start() call.
The error tells you that you have written something at:
output started at c:\inetpub\wwwroot\ads4u\data_valid_fns.php:25
Check for any echo, print or html output before session_start()
Hope that helps,
Ben
Ahmed Abdelaliem [EMAIL
Funny you should ask. I actually didn't try it on anything else. So I went back and
tried a simple script and got the same message. Thanks for the idea. I haven't gotten
any other feedback on this.
Ryan
-Original Message-
From: Jacob Marble [mailto:[EMAIL PROTECTED]
Sent: Friday,
Interesting. They say the ISAPI module isn't production quality yet... we
use it, though, w/o problems. We're running IIS on Win2000 and php 4.3.2.
Does it work besides the phpinfo() problem?
Jake
LandEZ
Ryan Jameson [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
More info... I
More info... I only get that message in ISAPI mode. :-\
Ryan
-Original Message-
From: Ryan Jameson (USA)
Sent: Thursday, June 12, 2003 11:10 AM
To: [EMAIL PROTECTED]
Subject: Problem with 4.3.2
When I change over to 4.3.2 I get this message from phpinfo();
The operating system
Does not sound like a PHP problem to me, more like IIS. Try and find
some system messages that relate to the link between the servers.
Edwin
Kiswa wrote:
Ok here is the problem.
At home i run an Apache server with php4
and the server its supposed to be run on is NT5 and iis with php4
The site
that means the result is not right,
it happen when your query is failed,check your query,
mysql_error() can help
Ruprecht Helms writes:
Hi Bayu Susiloadhy,
thanks for your answer.
function select_price($product_id,$quantity) {
--cut--
return True;
}
--cut--
in the
Hi Bayu Susiloadhy,
thanks for your answer.
function select_price($product_id,$quantity) {
--cut--
return True;
}
--cut--
in the meentime I change the code that not a boolevalue
was returned by the function.
$q is my querystring and $db is the selected database.
I insert the
Ruprecht Helms writes:
function select_price($product_id,$quantity) {
--cut--
return True;
}
--cut--
$price=$ps_product_price-select_price($cart[$i][product_id],$cart[$i][quanti
ty]);
//printf(%.2f, $price[product_price]);
printf(%.2f,$price);
you set the
Hermanto Kurniawan [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
i have a problem with this flash actionscript :
loadVariablesNum
(GuestBook.php?NumLow=+NumLow+NumHigh=+NumHigh+R=+random(999), 0);
when i run this script i got an error message like this :
Gian Michele wrote:
I have installed on my computer :
Apache 1.3
Php 4.1.2
Postgresql
the rpm of odbc and the unixODBC.
I tried to connect to my database after done all configurations; I used
the function odbc_pconnect('name_of_my_database','','') and the system
gives me this error
-Original Message-
From: Marten Lehmann [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 4:59 AM
To: Nick Gorham
Cc: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: problem with php and unixODBC
Hello,
I know its a little late, but I have only just been pointed to your
posting, I
Hello,
I know its a little late, but I have only just been pointed to your
posting, I would guess the error you are getting database not found is
coming from the sybase driver, not the driver manager.
I solved the problem a week ago. It was just when I wanted to try iODBC
when I saw some
Marten Lehmann wrote:
Hello,
my unixODBC-2.2.2 installation works fine. I tested the configuration
with a local and a remote ressource to a Sybase Adaptive Server Anywhere
database with isql (a testing tool of unixODBC). Thus the settings in
the odbc.ini and odbcinst.ini should be
php, is probably resolving localhost, to its' bound external ip,
or something other than 127.0.0.1 (in your hosts file, make
sure that localhost is in it.) or change the user's host in the
mysql.user table to localhost.localdomain, which will work too.
--
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
Dear all
Two Question :
1.
I know that the 'LOAD DATA' command loads a bulk of data into a table, but
what happen if i only want to load the data into specifc fields on a table
instead of whole table.
eg.
Let say i had a file
What I meant is there is I think the problem is with the mySQL privilege
system or rather the way your permissions are setup I suggested you first
go through the part of the mySQL manual with the PRIVILEGE SYSTEM then once
you set up you permissions well run the sql queries from the mysql
it without attaching
smarmy editorials. Lets help each other...
Happy new year.
-Original Message-
From: Ian Ferger [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 3:47 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Problem with buttons
if you look closely at your code (instead
If you are using PostgreSQL module, do not use PostgreSQL for now.
I'll work on conflict issue later, but I don't think it will be
fixed any time soon
No, I don't use PostgreSQL module.. so what's wrong? Sometimes, when I
reboot machine, it works for a while..?
--
PHP Database Mailing
just add LIMIT N,R to your SELECT statement where N is the row you want to
start with and R is the number of rows you want to fetch.
The first row is 0 so if you want to fetch 10 cars per page make R 10 and
make N a variable. Pass 0 to N on the first pass, then put links on your
page for NEXT
I have code at work that encodes and decodes escape chars when inserted into
mysql or displayed as html.
Can't remember the syntax exactly but I did use htmlentities and then
array_flip on the way out. There is an example in the php help file.
Found it. I love it when PHP can do stuff like this
Hi,
disregard this post - i found the error - a little mistyping :-(
Michael
Michael J. Eisner [EMAIL PROTECTED] schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi,
I have a form with two dropdown fields. When ever one of them is changed,
a
javascript function is
Michael - could seem to reply to your email address... here's the code
where $res is a valid result_id (I've tested it without the
odbc_next_result):
do {
while ($odbc_get_into($res,$row)) {
print $row[0]br;
}
} while ($odbc_next_result($res));
Seems to crash on the first call
PS - Ignore the $'s in front of odbc - typo!
Daniel Bennett [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Michael - could seem to reply to your email address... here's the code
where $res is a valid result_id (I've tested it without the
odbc_next_result):
of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Data Integration Technology Providers
-Original Message-
From: Daniel Bennett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 12, 2001 11:47 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Problem
ok .
i've had this problem and fixed it thus:
--with-pgsql=/path/to/unzipped/files
e.g. --with-pgsql=/usr/src/postgresql7.1.1/
and it works, and has done for the last seven months.
rasmus bit my head off though when i suggested it though so sh.
Steve
Matt Williams [EMAIL PROTECTED]
So what is actually the problem with running sp in mssql?
Mike
-Original Message-
From: Carpe Diem Support [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 3:32 PM
To: Hugh Bothwell; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: problem running stored MsSQL
Hi,
hope anyone has an idea on how to fix this...
form
input type=submit name=Submit value=Submit Request
OnClick=submit.php class=button
input type=submit name=Edit value=Edit Request OnClick=edit.php
class=button
/form
you could give the form one action and then check on the following
Try setting form.action and using form.submit() to send it ('edit.php' is
not valid javascript).
Here:
htmlheadscript!--
function submitTo(form, url) {
form.action = url;
form.submit();
}
--/script/headbody
form name=f action=submit.php
input type=submit
72 matches
Mail list logo