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", $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 y
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 bre
Budelak wrote:
You guys thanks for the encouragement.
I finally solved it with this:
",
$rsDailynewsDetail->Fields('newsfull')); echo $text; ?>
Help came of course from the link Holmes gave.
You're welcome, I think. Why didn't you just use nl2br()?
If you must use a method like you're using now
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 resul
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 INPUT_
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
does
> -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.
G'day all,
I have a problem with an insert which is proving infuriating. When I run
the following code everything seems to work (no errors) except the database
remains empty. When I echo $query and run it from a command line it inserts
fine. I don't get any connection errors - in fact when I ech