Re: Re: newbie lost on data import... part 3
| From: | jsWalter | Date: | Sun, 10 Aug 2003 05:31:56 +0000 |
| Subject: | Re: Re: newbie lost on data import... part 3 | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29786@lists.php.net to get a copy of this message | ||
"John W. Holmes" <holmes072000@charter.net> wrote in message
news:3F35D72F.4090306@charter.net...
> jsWalter wrote:
> > // Spit it out to double check what I've got
> > echo '>' . $strDate . '< - >' . $strNum . '< -
> > >' . $strName . '< <p
/>';
>
> So does this echo display anything?
It spits out...
>1974-01-09< - >4< - >Lost Dog<
Just what it is supposed to spit out.
> What does the Date class do?
A class to ease database work...
http://pear.php.net/manual/en/package.database.db.intro-auto.php
BTW: A straight SQL call gives the same (lack of) results as well...
$strSql = 'INSERT INTO cbs_eps ( eps_id , eps_name , eps_num ,
eps_air_date ) ';
$strSql .= "VALUES ( ";
$strSql .= "'" . $x . "'"; // eps_id
$strSql .= ",'" . $strName . "'"; // eps_name
$strSql .= ",'" . $strNum . "'"; // eps_num
$strSql .= ",'" . $strDate . "'"; // eps_air_date
$strSql .= ");";
echo $strSql . '<p />';
$objResult = $db->query($strSql);
And the SQL generated...
INSERT INTO cbs_eps ( eps_id , eps_name , eps_num , eps_air_date )
VALUES ( '4','Lost Dog','102','1974-01-09');
Now, if I paste this into phpmyAdmin it works! :(
Walter