I've made a big boo boo when exporting from MS Access to MySql database.
The table name was '16-05' which obviously is not a good name to have in
MySql.
I'm using PhpMyAdmin as I'm not very experienced with sorting out the
databases any other way. Problem is that I can't access the properties
of
Use tablename from mysql command prompt.
Try to use it from phpmyadmin, but I don't know if it works..
And don't post emails with high priority anymore.
- Original Message -
From: Martin E. Koss
To: [EMAIL PROTECTED]
Sent: Monday, May 17, 2004 11:48
Subject: [PHP-DB] Wrong
Hav you tried enclosing the table name with backticks:
SELECT ...
FROM `16-05`
...
Ignatius
_
- Original Message -
From: Martin E. Koss [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 17, 2004 10:48 AM
Subject: [PHP-DB] Wrong table name - can it be
Hi
using phpMyAdmin enter the following into a sql box
ALTER TABLE `16-05` RENAME `newname` ;
HTH
Peter
-Original Message-
From: Viorel Dragomir [mailto:[EMAIL PROTECTED]
Sent: 17 May 2004 09:54
To: Martin E. Koss; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Wrong table name - can
Hello,
I would like to display my news like this:
*10.04.2004.*
- news 1
- news 2
- news 3
*14.04.2004.*
- news 4
*15.04.2004.*
- news 5
...
I'm thinking of some while loop but I'm not sure that it will work nor I
know how to create that query.
TNX
--
PHP Database Mailing List
From: T. H. Grejc [EMAIL PROTECTED]
I would like to display my news like this:
*10.04.2004.*
- news 1
- news 2
- news 3
*14.04.2004.*
- news 4
*15.04.2004.*
- news 5
...
I'm thinking of some while loop but I'm not sure that it will work nor I
know how to create that query.
Hi!
You can use order by date and such method:
code
$result = mysql_query(blablabla);
$date = foo;
while($news = mysql_fetch_array($result)){
if ($date==$news[date]){
echo new date;
}
echo $news[text];
$date = $news[date];
}
Monday, May 17, 2004, 3:50:04 PM, T. wrote:
It appears that you want to extend DB_coomon not DB. The reason is because
$dbh = MyDB::connect( $dsn );
returns an instance of the DB_common class. However, DB_common is the base
class for writing a PEAR DB driver class. And, what is really returned by
DB::connect() is an instance of the
ORDER BY date, text ?
Hi!
You can use order by date and such method:
code
$result = mysql_query(blablabla);
$date = foo;
while($news = mysql_fetch_array($result)){
if ($date==$news[date]){
echo new date;
}
echo $news[text];
$date = $news[date];
}
Monday, May