jsWalter wrote:
OK, now I am really sure it has to do with the vars I defined from my text
file...
Once I have the text file open, I'm looping through it...
// pull RETURN off the end
$trimmed = rtrim($lines[$x]);
// Pull apart array element
list($strDate,$strNum,$strName) = explode (\t,
Budelak wrote:
This is how I implemented a similar though not exactly the same problem:
$tempdate = gmdate(d-m-Y);
$insertSQL = sprintf(INSERT INTO gennews (newsdate, newsheadline,
country, newsfull) VALUES ($tempdate, %s, %s, %s);
So, you only have to change the format of the gmdate what you
The text are type into an input field by the user who is nonot a
programmer at all. This inputt field updates the database that is later
called up for display.
Bunmi
Andrew D. Luebke wrote:
How are the paragraph breaks represented in the original text? You have
have to detect the paragraph
Budelak wrote:
You guys thanks for the encouragement.
I finally solved it with this:
?php $text= preg_replace(/(\015\012)|(\015)|(\012)/,nbsp;br /,
$rsDailynewsDetail-Fields('newsfull')); echo $text; ?
Help came of course from the link Holmes gave.
You're welcome, I think. Why didn't you just
Hello Merlin,
Have you gone through the mysql manual located in the docs folder of mysql?
Budelak
Merlin wrote:
Hi there,
I have a data file with data seperated by semicolons. It is about 8MB big.
Now I just want to import it into mysql.
I tryed several things. First I took phpmyadmin, which
one thinglooks like you need one more outer set of paren's to tie both
sets of the equation together.
query = SELECT *, ((Year(Now()) - Year(BDAY)) + ((DAYOFYEAR(Now())
-DAYOFYEAR(BDAY))/365)) as AGE FROM Katalog WHERE AGE = 31 AND AGE = 50
AND IS_MEM_EXP = 0 AND IS_OPEN = 1 ORDER BY
Im looking at venturing into working with PHP's ODBC extention.
Does anyone have any recommendations as to a Database, that is easy to
understand/get into from a novice point of view, that installs on
windows 2k,
and is free?
MySQL is kind of free, installs on W2K and is easy to use but it
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 12:59 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Returns Error
Been working on this code all weekend, and I did take
everyone's advice, but
I'm still getting the same error. Error