Hi, I have a MySQL problem but due to small problem of my email I can't subscribe to a
MySQL list so I wonder if someone from you can answer (actually I'm sure about it...)
My problem is that I have a query that fetches all data from a table in alphabetical
order using the "...order by col_name
Hi Dr. Indera,
>
> Is there a way to upload data in a csv file into a mysql table?
Try phpMyadmin.
Regards,
Ruprecht
---
Ruprecht Helms - IT-Service und Softwareentwicklung
Homepage: http://www.rheyn.de
email: [EMAIL PRO
Hi Dr,
try:
LOAD DATA INFILE "myfile.csv" INTO TABLE mytable
FIELDS TERMINATED BY ","
LINES TERMINATED BY "\r\n" ;
of course, the structure of your CSV file must match exactly that of your
table.
hth
- Original Message -
From: "Dr. Indera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
S
Hi this was very helpful to me, just now trying that
what if i have TABLE (id_item, rate1, rate2, rate3, rate4)
and
CSV file like foll
id_item,rate1,rate2
1,250,260
2,270,280
5,290,290
and what exactly mean \r in a TERMINATED BY?
thx kaja
S prátelským pozdravem
Karel Príbramský
AbiaNet, s
Hey all,
I managed to find that if I do:
$MemberID = @mysql_query("SELECT ID FROM SiteMember WHERE Username =
'$valid_user'");
$array = mysql_fetch_assoc($MemberID);
print_r($array);
this will produce:
Array ( [ID] => 3 )
All I want is the value 3 so that I can go ahead and insert that into t
You have to create your CSV by escaping the real data commas (eg
"1\,250\,260") when creating your CSV file - \ usually works, but you can
choose sth else if you have "\" actual data characters (usually not
recommended!).
and add
ESCAPED BY "\" to your LOAD statement
HTH
Ignatius
- Origina
Hey Graeme,
> $MemberID = @mysql_query("SELECT ID FROM SiteMember WHERE Username =
> '$valid_user'");
> $array = mysql_fetch_assoc($MemberID);
> print_r($array);
> this will produce:
> Array ( [ID] => 3 )
>
> All I want is the value 3 so that I can go ahead and insert that into the
> Lookup table
Hi
I am wanting to use the value in a variable as a variable name. I know it is
possible but do not remember how to do it - what function to call.
Example
$section1 = "SECTION 1";
$section2 = "SECTION 2";
// I want to have a for loop that will call these variables.
eg for ($i=1;$i<3;$
how would i go about making a few queries into a transaction - that is, if
one of them fails, the previous queries get rolled back...
cheers
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Choices
1) Use InnoDB
2) If you cannot use innodb than you can write your code in the way you add
in an array
queries that will rollback the change :
if you do
$r1 = mysql_query('insert into some_table (k1,k2) values (4,2);');
$r1 = mysql_query('insert into some_table (k1,k2) values (5,3);');
yo
hello,
You can find syntax description in the documentation (variable variables section)
$myvar1 = "MYVAR1 CONTENT";
$myvar2 = "MYVAR2 CONTENT";
$i = 0;
$myvar = 'myvar'.++$i;
echo "\n";
echo $$myvar;
echo "\n";
$myvar = 'myvar'.++$i;
echo "\n";
echo $$myvar;
echo "\n";
can do it
hth
pa
"Yasuo Ohgaki" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Matthew Newby wrote:
> > I am having trouble with the pg_fetch_result function when trying to
access
> > a boolean field in a PostgreSQL database. Here's the code snippet:
>
> It's a spec.
>
> Postg
i am unfarmillar with InnoDB, i am currently using MyISAM i believe. just
the default one.
i am a complete noobie with InnoDB, do i have to convert my db?
cheers
"Andrey Hristov" <[EMAIL PROTECTED]> wrote in message
014d01c2540b$d309bf40$1601a8c0@andreywin">news:014d01c2540b$d309bf40$1601a8c0@
Hi there,
I'm new to PHP, especially to the db-functions.
I've got a problem querying my PostgreSQL server using pg_query.
The Tables i'm working on contain colume names with uppercase letters.
Working on those tables directly with psql, the client program delivered
with postgresql, works like ex
Hello,
i have a php skript that does some calculations and write the result to
a firebird database. All works fine, but as soon as i put this line into
the skript:
$shmid = shm_attach (12345, 1, 0600);
i get this error message:
Warning: InterBase: attempted update during
On Tue, 20 Aug 2002 18:34:48 -0500
"Shiloh Madsen" <[EMAIL PROTECTED]> wrote:
> I was wondering if there were any good documents out there about
> good database design...I know the basics of creating tables,
> setting data types and such, and now i want to know how to use it
> to the best effect.
Hi, i have a question, it may be dumb, but i´m very new with php and mysql, i need
help.
how can i check a form when i change from one field to another I want make a
condition.if the number i typed is allready in the database, not just when i
finish filling out the hole form...clickin
Hi,
This is not exactly fall in the category of php and mysql, but hopefully
that you can shed a light for me.
My question is how can we write a php ping script to ping some website and
output the ip address of the website automatically on webpage?
It's the same idea that ping www.google.com in c
I just figured out how to retrieve ip but instantly thought of something
more, how do I make it as an href link once I got the ip?
Thanks,
Bo
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi, four questions.
1) Are you using linux ?
2) Will this I.P that you want to ping be stored in the script internally or
fed to it at time of running?
3) Does it have to be in Php ?
4) Will this script be run on the same server as your webserver ?
-Original Message-
From: bo [mailto:[EM
20 matches
Mail list logo
