look in php.ini (or whatever the Linux equivalent is) for
session.cache_limiter and set it to session.cache_limiter = nocache
HTH 8^D
Dave
-Original Message-
From: olinux o [mailto:[EMAIL PROTECTED]]
Sent: 03 September 2001 19:34
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Warning: Pag
Checkout:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
the function DATE_FORMAT(date,format) does what you want...
> -Ursprungligt meddelande-
> Från: Eric J Schwinder [mailto:[EMAIL PROTECTED]]
> Skickat: den 3 september 2001 21:39
> Till: [EMAIL PROTECTED]
> Ämne: [PHP-DB]
Hi all,
I am hoping someone can help me from my hair pulling.
I am using a class called graphite.php (which I have attached) to generate a
graph,
It pulls the last seven days of hits to a web site from the db and graphs
these as;
Hits (y-axis) vs Day (x-axis) as a line graph.
Unfortunately I am
$searchCategory="Company";[insert html code for drop down box instead of
this line]
$searchKey="IBM";
$result = mysql_query("SELECT * from $table WHERE
($searchCategory='$searchKey')");
or something like that anyway
- seb
-Original Message-
From: Devon [mailto:[EMAIL PROTECTE
I have a database in mysql that only has one table, that table has approx 25
fields . I need to be able to search for data under each of these
fields.
Field examples: Company, TechContact, AdminContact, Mobile etc etc
I need I guess a pull down menu that would select a field (c above) then
This may be a dumb question but here goes:
I have a mySQL database that I am using PHP to interface with. I have
fields in the database that are DATE and TIME types. Can I format these
values so that the user sees "September 15, 2001" or "2:00 PM" instead of
"2001-09-15" and "14:00:00" when
I have the same troubles. I believe that the only
solution is to use GET rather than POST as your FORM
METHOD. There may be another way, but this may work
fine, as long as you are not working with
passwords/sensitive info.
olinux
--- Mad Nas <[EMAIL PROTECTED]> wrote:
> Hi All
>
> I'm using PH
--->How To Make It *BIG* on the Net...QUICKLY...with NO Money!
This is NEW and INCREDIBLY EXCITING!! Join Free, WORLD-WIDE!
(Zero investment!) No hassles, no selling, no pressure.
Like NOTHING you have ever seen on the net today! No limits...
You can join for FREE and MAKE MONEY!! W
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
021701c13489$245b1f40$[EMAIL PROTECTED]">news:021701c13489$245b1f40$[EMAIL PROTECTED]...
> - Original Message -
> From: Jack <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, September 03, 2001 10:35 PM
> S
- Original Message -
From: George Pitcher <[EMAIL PROTECTED]>
To: Torgil Zechel <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, September 03, 2001 11:19 PM
Subject: Re: [PHP-DB] newbie having problem
> > if( $result == FALSE )
> > {
> > echo mysql_error();
> > }
> Yes - progress
> if( $result == FALSE )
> {
> echo mysql_error();
> }
Yes - progress - its telling me that no database was selected.
My code again:
> > > mysql_connect ('pingu','root@localhost','');
> > mysql_select_db ('Bizplanes');
> > if ($Serial == "")
> > {$Serial = '%';}
> > if ($Type == "")
> > {$Type
- Original Message -
From: Jack <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, September 03, 2001 10:35 PM
Subject: [PHP-DB] Use the User Input Critia as part of Query! (Mysql)
> Dear all
> I had a form which ask user to input the Staff Number to be as par
Dear all
I had a form which ask user to input the Staff Number to be as part of the
query, but when i execute it, it seems not working at all
here is what i wrote in php
The user input box is : $StaffNum
$query="select name,department,Leave_From,Leave_To,Leave_Total,Reason from
leaverequest wher
Thanks very much Marcus. It worked like a charm.
Dennis
On Mon, 3 Sep 2001 14:02:07 +0200, [EMAIL PROTECTED] (Marcus Tobias) wrote:
> Hi Dennis!
>
> You can add the parameter "LIMIT" to your SQL query.
> Syntax: LIMIT $start_record,$record_count
> Example: $query_string = "select * from $table
hi
...and to be able to know the exact number of pages
do
$result = mysql_query("select count(*)");
$nb_pages = $result/$nb_records_per_page;
et voila! add this to marcus's suggestion and you have a full paging script,
if you want some inspiration check out http://phpclasses.upperdesign.com i
Hi Ali!
- export the database into a dump file.
- strip the table from the dump.
- drop the database
- import the new dump
bye Marcus
"Ali Nayeri" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi guys
>
> I had a question. How do you drop a table in
Hi Michael!
You can put all passwords and loging into one settings file.
This file will included by all scripts using this datas.
this include file you can put in an seperate directory on the
webserver. this directory you can protect by the webserver.
with apache with .htaccess files with IIS in
Hi Devon!
Take a look in the PHP documentation in the function reference for mysql
function.
There you'll find a set of function for connecting to the database and doing
SQL - Querys over the database. If you are not famular with SQL (SELECT -
Statements)
you have to learn :)
bye Marcus
"Devon"
Hi Dennis!
You can add the parameter "LIMIT" to your SQL query.
Syntax: LIMIT $start_record,$record_count
Example: $query_string = "select * from $table where keywords like
'%$keyword%' limit 5,3";
This will return 3 records started with the 5. found record.
The startrecord has to increase on ne
I did this directly into MySQL on the LinuxPPC box:
mysql> select * from biz where
-> ID LIKE '%AXD%' AND
-> Type LIKE '%' AND
-> Con LIKE '%'
-> ORDER BY ID;
and this is the response:
++-+-+--+-+---+
| ID | Type
Check if mysql_query returns false. If it does (and im pretty sure it do),
use mysql_error to check whats wrong... (Another way is to echo the query
and paste it into the mysql command line client..)
$result = mysql_query("...");
if( $result == FALSE )
{
echo mysql_error();
}
> I'm doin
Hi All
I'm using PHP 4 and MySQL in W2K .
When i submit a form and call a php file, i get this message :
__
Warning: Page has Expired
The page you requested was created using information you submitted in a
form. This page is no longer available. As a
security
Hi all,
I'm doing some basic php/MySQL stuff (LinuxPPC on Mac7100). I'm gettin g the
following error when I search for somthing.
Supplied argument is not a valid MySQL result resource in
/usr/local/apache/htdocs/bizflyer/Bizflyer_R1.php on line 32
Here's my relevant code:
==
Try:
$result = mysql_db_query ("$DBName","select * from Contacts order by rand()
LIMIT 0,5 ");
As your first example had the '0' and then the '5' after the LIMIT clause, the second
didn't have
th any '0'.
Cheers.
Russ
On Fri, 31 Aug 2001 20:59:16 +0100 Seb Frost <[EMAIL PROTECTED]> wrote:
>
24 matches
Mail list logo