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
> -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.
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
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_
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
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
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:
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
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
