Dear all
i'm a newbie in mysql, but there is one question about LOAD Data command in
mysql, let say if i had a CSV file in client side and i want to load this
file's data into particular table , so do i need to copy this CSV file into
Web server side where the Mysql is or i will be able to load
On Tuesday 30 April 2002 14:33, Jack wrote:
Dear all
i'm a newbie in mysql, but there is one question about LOAD Data command in
mysql, let say if i had a CSV file in client side and i want to load this
file's data into particular table , so do i need to copy this CSV file into
Web server
Hello!
I would to ask/report a problem i am facing in setting a value in the
option: LDAP_OPT_SIZELIMIT, using the ldap_set_option function.
I want to restrict the results returned by the LDAP server (it is an
iPlanet) before an ldap_list and check afterwards the ldap_errno expecting
it to
Hi Jennifer,
if($searchword = $iname)
try it with a double equals sign
if($searchword == $iname)
{
echo TABLE BORDER='0' WIDTH='95%' CELLPADDING='0'
CELLSPACING='0'TR;
echo TD width=20%a href='usershop.php?user=$user'$user/a/TD;
echo TD width=40%font
Hi Ryan,
It's not true that this can happen to any product. PHP is a fantastic
language, but
there are well-known ways to manage QA. All it needs is to include ODBC
in the standard php regression test suite (and run the suite regularly!)
Regards, John
Ryan Jameson [EMAIL PROTECTED] wrote in
Dear Jason
Thx for the reply, but do you know where i should copy that file to in
serverside?
is it got to be the same directory of mysql?
Thx a lot!
Jack
[EMAIL PROTECTED]
- Original Message -
From: Jason Wong [EMAIL PROTECTED]
Newsgroups: php.db
To: [EMAIL PROTECTED]
Sent: Tuesday,
Hello,
John Lim wrote:
Hi Ryan,
It's not true that this can happen to any product. PHP is a fantastic
language, but
there are well-known ways to manage QA. All it needs is to include ODBC
in the standard php regression test suite (and run the suite regularly!)
This is not the case of a
On Tuesday 30 April 2002 16:56, Jack wrote:
Dear Jason
Thx for the reply, but do you know where i should copy that file to in
serverside?
is it got to be the same directory of mysql?
It doesn't matter where as long as it is readable by the process running PHP
(ie the process running your
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
Hi all,
It's Monday, it's probably something stupid, but I have poured over this all
day and cannot find the problem.
This is a simple search engine based on one table. It is suppose to return
the results of the search word. Instead
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
Dear all
I had a problem to get the php to load a csv file into mysql.
I had a csv file which located at my HDD, and i had tried to Import the data
from this CSV file into mysql using MYCC which is a console program for
mysql, it
What a good question.
I've just had a quick look around the API and I think the only way would
be to write a stored function to return the value.
I could not find any functions to bind to those types of values without
the stored functions.
Have you had any other ideas on how to achieve this?
We will agree to disagree. I've experienced many testers who thought things that you
think. They were often the most cocky and least effective of the hundreds I've worked
with on projects, and again every product I've worked with from Microsoft to Oracle to
Java have had similar issues arise.
why not just use a mailing list manager (i.e. majordomo, ezmlm, etc.)?
writing a web interface for users to subscribe/unsubscribe would be no big
deal.
-Original Message-
From: Al [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 11:37 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
At 07:39 30-04-02 -0700, Liam Gibbs wrote:
I'm just seeking a database duplication that I can
throw away after I'm done.
Sounds like you want to use temporary tables.
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
Eugene
--
TEMPORARY tables would require that he create and fill ALL the tables each
time. Too much work for what he needs.
mysqldump is your friend here
- Original Message -
From: Eugene Mah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 10:08 AM
Subject: [PHP-DB] Re:
majordomo and ezmlm would provide more power and cause more headaches than
he needs.
What he describes is very basic and can be done in less than 5 hours.
- 1 hour to create sign-up screen with db update, including test
- 30 minutes to create un-register screen with db update, including testing
I have approx 160 rows in a table with an ID column set to auto increment.
I have not changed anything suddenly one day the auto increment went from
162 to 2,145,694,203
I am running a Win 2000 box with IIS 5.
any ideas?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
I don't know if this is what you are looking for but it will open a new
browser window. You may have to play with it to get it the way you want.
a href=\#\
onClick=\MyWindow=window.open('yourscript.php?id=$id','MyWindow','toolbar=n
Thanks all for your help.
I knew it was somathing stupid and I knew it was because it was Monday.
Now that it is Tues I have found the problem and it was somethin very
stupid.
I forgot
echo /FORM;
Now it work as it should.
Again thanks
Jennifer.
Jennifer Downey [EMAIL PROTECTED] wrote in
Hi,
i have the following problem: (database Oracle 8.1.7)
we got a package ACCESSLIST with a function GETRIGHTS.
this function returns a cursor. So what i want now is calling this function
and walk through the returned cursor:
this is what i have so far, but it brings me some errors:
$query =
ok, i found the answer for using cursors in the description for
ocinewcursor. so it should be:
$query = BEGIN :result := ACCESSLIST.GETRIGHTS(:in_val); END;;
$curs = ocinewcursor($conn);
$stmt = ociparse ($conn, $query);
ocibindbyname($stmt, :result, $cursor, -1, OCI_B_CURSOR);
I need a tutorial or example on how to take a result from an mysql query and
place it into a session variable. Please help?
Thanks in advance,
Jas
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 30 Apr 2002 at 11:56, Jas wrote:
I need a tutorial or example on how to take a result from an mysql
query and place it into a session variable. Please help? Thanks in
advance, Jas
This is what I use...
while ($res = mysql_fetch_assoc($query))
{
$retval[] = $res;
}
$retval is then
Hi Ryan,
Don't be hasty. What i'm simply saying is that QA is a process and you
need to build feedback into the loop. Developers come and go in an
Open Source development process and you need to build in regression
tests so that when new developers with new ideas come along, they
don't break
CJ,
I am fairly new to PHP and MySQL but there are 2 functions that can do this.
PHP has a function called mysql_insert_id to retreive the last ID and Mysql
also has last_insert_id() which you can use in your query. I have used
last_insert_id() with pretty good success but I would still
I have a problem writing form data to a table in MySQL. I have an action.php file
that it called when the information is submitted and it looks something like this:
?php
$connection = mysql_connect(localhost,root, password)
or die (The DataBase is Down!);
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I'm working on an intranet accounting application using php and posgresql.
When I select a reord from a list for editing, I transfer the necessary
variables using the 'METHOD=POST' and similarly when the update scripts are
run after
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
I have a problem writing form data to a table in MySQL. I have an action.php file
that it called when the information is submitted and it looks something like this:
?php
$connection = mysql_connect(@localhost,root, password)
Hi, I need a favour from you guys 'n girls :
If I have records like this
ID Content
1 John have a red book, and a yellow book. He give a yellow book to Tina.
2 Luke doesn't have any book at all, he always borrow it from John.
3 John like swimming.
Can I search this records (table) for a
29 matches
Mail list logo