I couldn't aggree more. I is a tragedy when so much innocent people dies,
and leaves families,children and friends behind.
But make no mistake... NATO and smart bombs have killed much more innocent
people all around the world in the name of freedom
and republic.
I think whois responsible must be
I am having a problem using CHAR(0) fields. I am not able to differenciate
between NULL and NOT NULL while retriving these fields although I can SELECT
these fields if I mention it in my query to MySQL.
Krishnakumar
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
Hi.
I am migrating part of a big database of MSSQL to MySQL . The tables are migrated and
data is ok but I need the views that I used on MSSQL . I tried this , I replaced the
name of the view used with the sql statement , a very big select statement. I have
checked SQL syntax with MySQL
hi,
i am currently scouring the web for a solution to this but thought i
would try here as well ..
i have a text field in a mysql database
the textfield contains an array written out as
//
$array[0][1]=one;
$array[0][2]=two;
$array[0][3]=thre;
$array[1][1]=four;
Hi,
I think you can use the eval() function to execute the stored info. The code
will look something like this
$res=mysql_query(...)
eval($row_from_query);
If you want to change the name of the array you could use
eval(str_replace($array,$newarray,$row_from_query));
HTH
Dobromir Velev
thanks dobromir,
unfortunately that doesnt seem to work ...
although looking at the php manual you seem to be on the right track..
could the way the textfield is parsed passed back affect the array?
cheers!
brendan
Dobromir Velev wrote:
Hi,
I think you can use the eval() function to
scratch that, i had a syntax error in the array..
you were completely right dobromir eval() works perfectly..
thanks!
Brendan wrote:
thanks dobromir,
unfortunately that doesnt seem to work ...
although looking at the php manual you seem to be on the right track..
could the way the
Hi,
I have a perfectly fine piece of code that takes a form input and stores it
as a CLOB, but when I try to store it in an NCLOB with the same piece of
code I get an error:
Warning: OCILobWrite: ORA-24806: LOB form mismatch in
c:\apache\htdocs\working_clob.php on line 24
$sql = insert into
Thanks Leo, i solved the problem using $HTTP_GET_VARS[].
--
==
Victor Espina
Caracas, Venezuela
http://mitrompo.com/vespina
[EMAIL PROTECTED]
(Quite el 'nospam' para responder)
(Remove 'nospam' to reply)
Leo G. Divinagracia III [EMAIL PROTECTED] wrote in message
Oops, damn profile :
please reply to group or [EMAIL PROTECTED]
Many thanks
--
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]
Hello Justin,
Thursday, September 13, 2001, 11:07:26 AM, you wrote:
JB On Thu, 13 Sep 2001, Jacob Singh wrote:
Hello,
main
--
ID autonumber
content_ID enum('artist','song','album',user function','genre', etc.)
name char
img char
des char
etc. etc.
songs
CHAR(0) allocates no space to the variable, ther than house-keeping space.
Why are you dong that?
You say you can SELECT but cannot retrieve. SELECTing is retrieving.
Please elaborate.
-Original Message-
From: Krishnakumar S [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001
Hi all:
The few php/MySQL apps I've developed that required username/password access, have
simply been a
means of comparing usernames and hashes of passwords in a DB. My next application
needs to be
slightly more secure but nothing like the needs of protecting online banking or
vulnerable
When I use pconnect to connect to a db2 back end, I get the expected faster
connection times. However, when the site is under any sort of load (6 or
more concurrent accesses), we have noted that the time spent preparing
statements increases greatly (execution time remains fairly consistent
Hello *
trying to output mysql content into a table, but the
table is designed to use 3 Trows to display info for
ONE product (table also has to have 5 columns):
row1 sku1|sku2|sku3|sku4|sku5
row2 img1|img2|img3|img4|img5
row3 nam1|nam2|nam3|nam4|nam5
-
What does you mysql table look like?
What does your SELECT statements look like?
What does function p() do?
What does function f() do?
Need more info
-Original Message-
From: Adv. Systems Design [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 11:09 AM
To: PHP List
A common way to identify a client is to use the challange-response
algorithm. It works like this:
Ps is the password stored on the server
Pc is the password entered by the client
H is a hash-function (md5 for example)
V is a 'random' value
Server calculates H(V + Ps) and save this in a session
I'm running Win2k server, with MSSQL 2k, PHP 4.0.6. Every time I try
to connect to the SQL sesrver within the script I get the following
output:
X-Powered-By: PHP/4.0.6
Content-type: text/html
Warning: MS SQL message: Login failed for user 'tu'. Reason: Not
associated with a trusted SQL
I have The following
A Sun Ultra2 Running the Oracle Client talking to a Oracle Instance 8.1.7 on
another server.
sqlplus scott@rhinodb works greate. I do have to be in $ORACLE_HOME for
some reason.
When I issue the following command I get an error
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0
Is it possible to find and replace a data in the table using phpMyAdmin ?
If yes, how to do that ?
I want to change http://something.com/; to http://www.something.com/target;
thanks folks
_
www.kaskus.com - FREE EMAIL SERVICE
--
PHP
- Original Message -
From: Adv. Systems Design [EMAIL PROTECTED]
To: PHP List [EMAIL PROTECTED]
Sent: Friday, September 14, 2001 12:09 AM
Subject: [PHP-DB] Table display Driving me Crazy!
Hello *
trying to output mysql content into a table, but the
table is designed to use 3 Trows to
Hello all ...
I'm having a problem uploading large files (3MBytes for examples)
and inserting it onto a MySQL database. No problem with smaller files.
The code is basically this:
?php
$data = addslashes(fread(fopen($form_data, rb), filesize($form_data)));
$result=MYSQL_QUERY(INSERT INTO
Looking at your code for the first row (I've cleaned it up a bit to make it
readable!):
?php
$numcols = 5;
for ($l = 1; $l = $numcols; ++$l) {
?
td width=139 class=ModNo bordercolor=#00
?php
echo $db-f(product_sku);
?
/td
?php
}
?
It
You might want to check php.ini - if memory serves the maximum filesize
you can upload over HTTP by default is 2MB. Bump that number up and
restart Apache (or whatever webserver you use) and see if that fixes the
problem.
Justin Buist
Trident Technology, Inc.
4700 60th St. SW, Suite 102
Grand
The whole block is wraped in a while ($db-next_record()) { ...} loop
actually. Now, I'm not sure if the next_record() method is setting an
internal member to the current record and returning TRUE/FALSE for
success, or if it's actually supposed to be returning a row.
It should be the former.
Does anyone have a solution for the following problem.
I use dbwired.com for hosting (great service). They do not, however,
for obviously reasons allow the system() command from a php script.
So, when I switched to this server I had to switch from a system(mv
file1 file2); command to a
Does any one have any ideas how Quickbooks data can be synced with an Access
database? I want to use PHP to post some account information live from my
accounting system and can't seem to figure out a way.
If anyone else also has a need to extract information from Quickbooks and
has any ideas as
You need to split the value into an array using php, then list it out.
Lots of ways to do that, here's one.
$result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID =
'$user_ID');
$DCD = mysql_fetch_array ( $result4 );
print td width='6%' valign=top\n
div align='center'\n
I also facing this problem yesterday.
Do you want to know what i did ?
I open the file with notepad then copy paste it.
And it's works
--- Justin Buist [EMAIL PROTECTED]
wrote:
You might want to check php.ini - if memory serves the maximum filesize
you can upload over HTTP by default is
How about:
copy(path1,path2);
unlink(path1);
On Thu, 13 Sep 2001 16:07:14 -0400
Jon Mormino [EMAIL PROTECTED] wrote:
Does anyone have a solution for the following problem.
I use dbwired.com for hosting (great service). They do not, however,
for obviously reasons allow the system()
Beau Lebens wrote:
// err.. please correct me if I'm wrong, but isn't pkzip
// exactly that? or more
// exactly, winzip is a windows interface to it? it certainly
// uses the same
// compression
nope - you're right, i forgot about pkzip, but i was just saying that it's
pretty
Is it possible to find and replace a data in the table using phpMyAdmin ?
If yes, how to do that ?
I want to change http://something.com/; to
http://www.something.com/target;
Run an UPDATE query?
UPDATE table SET url='http://something.com/' WHERE
url='http://www.something.com/target'
hth
Hi!
I am trying to find a compiled dBase library (php_dbase.dll) for PHP4;
found many hints, but nothing useful.
Thanks for your help!
Thomas
--
Thomas Kaeser
[EMAIL PROTECTED]
***
Courage is not the absence of fear, but rather the judgement that something
else is more important than fear.
Hello,
I'm trying to use:
passthru(mysqlimport --replace --fields-terminated-by=\| --user=testuser
--password=testpassword testdb /home/testdomain/www/Admin/test_mysqltable.txt,
$output);
The mysqlimport command works perfectly at the telnet command prompt, but never
through Php.
When I
its not working because it's not a variable (url)
it's a text field
'url' is the name of the field which contains http://something.com/;.
Replace it with the name of the field in *your* table which contains
http://something.com/;.
BTW as Terry pointed out (I misread your question) the
www.php.net shows the proper format for EREG and EREGI is:
int ereg (string pattern, string string [, array regs])
My question is this; I want to be able to compare 2 or more strings to the EREG(I)
STRING PATTERN... without having to create two separate EREG(I) IF...THEN statements...
If I
36 matches
Mail list logo