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. S
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
just a test email
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 unsubsc
> 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,
For some reason I cannot get this to work. I'm trying to use the referrer to
redirect at the end of a form processing script, but it wont recognize the
referrer.
I read that it just wont work with some browsers, isps, and/or security
settings. If this is the case, does anyone know a work aroun
> 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 t
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 c
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 A
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, vis
nd($number,$deciminal_places);
EXAMPLE
$foo = round(1.95583, 2); // $foo == 1.96
Shooter
Webmaster <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have the following
>
> $number=47.7
>
> I need this to be = 47.70
>
> it m
I have the following
$number=47.7
I need this to be = 47.70
it must include the 2 didgets after the . how can i accomplish this
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the lis
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);
wh
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...
t
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
http:
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 f
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 f
t the lenght of it (just an example).
Steven
-Original Message-
From: Mark Roedel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 11:21 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Help Me Fix My User Defined Funtion
> -Original Message-
> From: SOHH.com Webmas
I created a funciton to pass two variables and create a dynamic link. It
doesn't give me an error, but it doesn't give me the results either. What
am I missing in my function? (It's down below)
Steven Samuel
function generatesectionlink($sectionID,$contentID) {
if ($sectionID == 4)
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 t
> 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
Hi all,
I have a website that I am trying to develop a "add news" page for.
Basically people who have the authority to add news for the site can type in
their username, password, the title of the article, and the article itself
and submit it to the site (which then verifies the username and passw
I've installed and correctly configured (I suppose) the binary version of
PHP 4.04 on a Win NT server with Microsoft IIS.
I'm using CGI version of IIS.
when I try to connect my script with Microsoft SQL 7.0 DB I get this error
"Fatal error: Call to undefined function: sybase_pconnect() in
./db/
jeez,
dump it all in a database.
than learn a couple of lines of php.
majordomo is perl... other discussion list.
good luck
# -Mensagem original-
# De: Jason Beebe [mailto:[EMAIL PROTECTED]]
# Enviada em: Wednesday, January 10, 2001 10:49 PM
# Para: [EMAIL PROTECTED]; [EMAIL PROTECTED]
27 matches
Mail list logo
