I need to figure out how to format the date format: year-month-day
(2005-12-06). It is a date(8) field in a mysql table that i pulled out of
the table with php 5.0.5. I need it in the format: Tue December 6, 2005 (or
in mysql's formatting: 6-12-2005). I am using the reformatting for display
only.
I have a table with the fields:
CREATE TABLE `journal` (
`Date` date NOT NULL,
`subject` varchar(100) NOT NULL,
`entry` longtext NOT NULL
) TYPE=MyISAM COMMENT='Journal table';
I was wondering if I should get the rows out by an ID field of some kind or
maybe do a select on the subject? what
Ron Piggott wrote:
What is the correct $_SERVER that tells me what page is currently being
displayed? Ron
http://www.php.net/reserved.variables
Never used it, but I'm going to guess script_filename or script_name ?
HTH,
Roger
--
PHP Database Mailing List (http://www.php.net/)
To
I'm getting an error using the
mysql_num_rows($result)
Warning: mysql_num_rows(): supplied argument is not a
valid MySQL result resource in
/home/lurkkcom/public_html/lurktivate.php on line 7
Did you happen to remember to change fields in the query string to your
table column names, and
There just seems to be times when non-normalized table structures are
easier
to work with.
There are times when de-normalizing is acceptable. One of the more common
uses of denormalized data is in data warehousing. Such as pre-summing
sales, and storing pre-calculated aggregate information to
Hi:
My name is Sergio Barreira, i want to know if there are any method (in
PHP) for to convert any .DOC to PDF on line and show it.
Thank You!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi:
How i obtain inmediatly the id of last insert ?
For example i have a forum, when the user post a question, i send a mail
to administrator, but i want to refer the id from this insert, how i do this
?
Well i think to make a select max(id) inmediatly but i beliebe that must
have any
Hi:
I understand that this list is about PHP but, may be, any webmaster can
help me.
Linux Suse 8.2.
I was installed apache, php and mysql, all working fine.
from prompt i write mysql and run correctly, i create the database, tables
and grant permisions to users. all right.
but, when i run
PLEASE HELP !!!
HOW I CAN GET CONNETCTION TO REMOTE HOST IN OTHER SERVER WITH
mysql_connect();
e.g.
my php file is in www.abc.com/index.php
mysql server is localhost on cgi.xyz.com
can i do something like this
mysql_connect(http://cgi.xyz.com:localhost:3306;, username, password);
PLEASE
PLEASE HELP !!!
HOW I CAN GET CONNETCTION TO REMOTE HOST IN OTHER SERVER WITH
mysql_connect();
e.g.
my php file is in www.abc.com/index.php
mysql server is in cgi.xyz.com on localhost
PLEASE ANSWER to [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
I need a script that produces a top 5 list of the visited pages at my
website..
$result = mysql_query(
SELECT artikel, count(*)
from artikel_vist
group by artikel
ORDER BY artikel DESC
LIMIT 5
, $link);
$num_rows = mysql_num_rows($result);
I have a form and based off of this form if my user selects option a then I
want them to be redirected to another page. If they select option B then I
want to continue with my php scrips as it does now.
Does any one have any ideas on how I can accomplish this?
--
PHP Database Mailing List
How can I request a persistant cookie from the clients computer (to make a autologin)
this doesnt work :echo $HTTP_COOKIE_VARS[nameCookie]
code to set cookie: setcookie(newsLogin,$value,time()+ 3348000);
if i ask from the same page I get the values I need but not from a different page...
thx
What I've done is I set up an INPUT box on the site, where you type in your
e-mail address. Upon hitting submit, I query the database looking for the
persons e-mail address. If it's there, I send it to them, if not I inform
them that they aren't in the database. This is the code I use for
Hey,
I'm trying to figure out how to make a custom message. What I have is a
form with a TEXTAREA named MAILFROM. I want to be able to write an e-mail
in that section like so:
Dear $username.
When I press submit, I want the query to cycle through a list of names (got
this part) and where it
Hey,
I'm trying to figure out how to make a custom message. What I have is a
form with a TEXTAREA named MAILFROM. I want to be able to write an e-mail
in that section like so:
Dear $username.
When I press submit, I want the query to cycle through a list of names (got
this part) and where it
I've written a Content Publishing Tool for my site.
http://www.sohh.com
Steven
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 1:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Web based adminisration
Are there any other web based administration
I assume that the username field is text. You need to add single quotes
around the field.
$validate = mysql_query("SELECT username, user_password FROM users
WHERE username='".$uname."'",$db);
Actually, it did help, and it didn't ;p
It would seem there is a scoping issue with the $db
18 matches
Mail list logo