I would like to print the date and time my database was
last updated but don't know the query for that. Ilooked at
several websites that list MySQL variables but didn't find
any that seemed to be what I want.
Can anyone help?
Thanks.
---
Pete Holsberg
Columbus, NJ
---
When the people
On Wed, 2 Feb 2005, Bastien Koert wrote:
any particular table? or just the db in general?
It has just one table.
---
Pete Holsberg
Columbus, NJ
---
When the people are afraid of the government, that's
tyranny. But when the government is afraid of the people,
that's liberty. -- Thomas
stamps for creation, last updated
and last checked.
Thanks.
---
Pete Holsberg
Columbus, NJ
---
When the people are afraid of the government, that's
tyranny. But when the government is afraid of the people,
that's liberty. -- Thomas Jefferson
--
PHP Database Mailing List (http://www.php.net
-updated information is in A table but not the
table called directory.
Sorry for the confusion.
From: Pete Holsberg [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: RE: [PHP-DB] Update time/date stamp
Date: Wed, 2 Feb 2005 14:06:35 -0500 (EST)
On Wed, 2 Feb 2005, Bastien Koert wrote
On Sun, 19 Sep 2004, David Orlovich wrote:
I think you're just missing some double quotes (which you have to
escape). How about something like this:
echo tda href=\mailto:;, $row['Email'], \, $row['Email'], /a/td;
Cheers, David.
Perfect!!! Many thanks.
Pete
--
PHP Database Mailing
I have a database that has an email field. I would like the
web page that is created dynamically from this database to
have a mailto:; link for each email address but I don't
know what to put in the email field.
I tried replacing
echo td{$row['Email']}/td\n;
with
echo tda
On Mon, 6 Sep 2004, Pete Holsberg wrote:
The following code results in the error message Couldn't
execute query.
$sql = SELECT * FROM $table ;
$sql .= WHERE `LastName` LIKE $search_string ;
$sql .= OR `FirstName` LIKE $search_string ;
$sql .= OR `Spouse` LIKE $search_string ;
$sql
On Mon, 6 Sep 2004, David Robley wrote:
On Mon, 6 Sep 2004 11:09, Pete Holsberg wrote:
Is there a way to program MySQL so that it can find the
name Smyth if the user looks for Smith? And similar
mispellings that are similar in sound.
The SOUNDEX string function in mysql may be what
On Mon, 6 Sep 2004, Zareef Ahmed wrote:
HI ,
Following php functions may be usefull
http://www.php.net/soundex
http://www.php.net/similar_text
Just try to make good algoritham ;)
Zareef Ahmed
Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
The following code results in the error message Couldn't execute query.
---
?php
/* Program: ShowDir.php
* Desc:Displays results of the search.
*/
?
html
headtitleSearch Results/title/head
body topmargin=0 marginheight=0
?php
include(login.inc);
$connection =
On Mon, 6 Sep 2004 [EMAIL PROTECTED] wrote:
you should copy/paste that into a command-line msyql
session and see if that works.
I cut the query back to
SELECT * FROM Directory WHERE `LastName` LIKE Joe ORDER BY Street, HouseNum, LastName
and ran it manually. I got
---
SQL-query :
--- Pete Holsberg [EMAIL PROTECTED] wrote:
On Mon, 6 Sep 2004
[EMAIL PROTECTED] wrote:
you should copy/paste that into a command-line
msyql
session and see if that works.
I cut the query back to
SELECT * FROM Directory WHERE `LastName` LIKE Joe
ORDER BY Street
On Thu, 2 Sep 2004, Torsten Roehr wrote:
mysql_query() will return a result set. There are
different functions to extract the rows from it. I
would recommend mysql_fetch_assoc() - it returns an
associative array of the current row/record set where
the field names of your table become the
On Sun, 5 Sep 2004, Pete Holsberg wrote:
Well, I have this:
$result=mysql_query('SELECT * FROM $table ORDER BY lastname, street, housenum ASC');
while ($row=mysql_fetch_assoc($result))
{
echo $row['lastname'].' '.$row['firstname'].' '.$row['housenum'].'
'.$row['street
On Sun, 5 Sep 2004, Pete Holsberg wrote:
blush I have to learn to keep a 3x5 card with my column
headings nearby!!
But having corrected that, I'm running into another
problem.
Additional blushing CASE-SENSITIVITY, Dummy! ;-) sigh
--
PHP Database Mailing List (http://www.php.net
Is there a way to program MySQL so that it can find the
name Smyth if the user looks for Smith? And similar
mispellings that are similar in sound.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Fri, 3 Sep 2004, Hutchins, Richard wrote:
-Original Message-
From: Pete Holsberg [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 11:59 AM
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Newbie Questions
On Thu, 2 Sep 2004, Torsten Roehr wrote:
I
On Sat, 4 Sep 2004, Torsten Roehr wrote:
SELECT firstname, lastname, address FROM TABLENAME
ORDER BY lastname ASC;
Use ASC or DESC to order your query results. When you
iterate over the result as Torsten indicated,
everything will be in the order you specify.
In the database
On Thu, 2 Sep 2004, Torsten Roehr wrote:
I think I need just a little push in the right
direction. After I send the above SELECT command, how
do I get the result to appear on a web page?
mysql_query() will return a result set. There are
different functions to extract the rows from it. I
On Wed, 1 Sep 2004, Pete Holsberg wrote:
On Wed, 1 Sep 2004, Torsten Roehr wrote:
Pete Holsberg [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I want to set up a directory with the following fields:
surname
firstname
spousename
housenumber
street
phone
.
Can anyone help me get started? It seems like a pretty easy
things to do. Perhaps if someone has already done this,
they might share their stuff with me. I'm much better at
hacking away at other people's stuff than developing my own
from scratch! :-)
Many thanks,
Pete Holsberg
Columbus, NJ
On Wed, 1 Sep 2004, Torsten Roehr wrote:
Hi Peter, please see my comments below:
Pete Holsberg [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I'm just getting started with PHP and MySQL (how do you say
that, my ess kew wll, my sequel, ???).
my ess kew wll is the correct
22 matches
Mail list logo