error with standard backquotes and how to
fix this??? I'd really like to know what is going on there.
http://www.mysql.com/doc/L/e/Legal_names.html tells backquotes really must
be there.
Thanks,
Pekka Saarinen
http://photogr
At 8/11/2002, you wrote:
>MySQL queries.. tables... design.
>
>http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
>
>There you will see a rough draft of what I am trying to do.
>
>Perhaps you will see some places that I will need to use a table_map?
>
>Or you can advise me of how to arrange my keys
ng focus too long on one subject is not good
for the reading process. Who knows. But it is not hard to normalize, and
actually the further you go the more clearly you'll see the real data in
your database.
Pekka
-
Pekka Saarinen
http://photography-on-the.net
---
ot;) and then wait that all SQL processes
are finished (SHOW PROCESSLIST may help here), then flush, lock, update,
unlock and open clients again.
-
Pekka Saarinen
http://photography-on-the.net
-
---
;
exit;
}
$frm = mysql_fetch_array($qid);
or
$qid = mysql_query("
SELECT *
FROM 1_nodedata
WHERE id = '$edit_id'
");
if (!$qid ) {
print mysql_error();
}
if ($qid ) {
$frm = mysql_fetch_array($qid);
}
-
Pekka Saarinen
http://photography-on-the.net
Hi,
Is there a way convert result of
SELECT NOW()
or
SELECT SYSDATE()
or
SELECT CURRENT_TIMESTAMP
to GMT, in a query?
Thanks,
Pekka
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
t;) TYPE=MyISAM;
>
>Any Ideas??
>Thanks in advance
Try
OPTIMIZE TABLE `e_genlogmatergroup`
This should get indexes running (you need to have a couple of rows of data
there first).
-
Pekka Saarinen
http://photography-on-the.net
--
-+
>| alio.zinutes | repair | error| The handler for the table doesn't
>support check/repair |
>+--++--++
>1 row in set (0.00 sec)
REPAIR T
I get is:
Name of Song
Artist
What I want is:
Name of Song (Artist)
while ($line = mysql_fetch_array($result)) {
print "$line["title"] . " (" . $line["artist"] . ")";
}
-
Pekka Saarinen
http://photography-o
