On Thursday 10 January 2002 06:56, Richard Stringer-Hye wrote:
> Will someone please send me the correct unsubscribed sequence for this
> list? Have tried from phpnet with no success.. Thanks.
Have you tried this?
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail:
thanks guys, I really appreciate it.
first off, Martin your suggestion looks great but I don't think its SQL
syntax is supported by MySQL. It's a good start though - gives me something
to work with :)
I guess I need to clarify a bit more about what needs to happen...
in the MySQL database, ther
Haven't been following and not sure if this is what
you're after, but these are some great data models:
http://www.databaseanswers.com/data_models/index.htm
HTH
olinux
--- Tim Foster <[EMAIL PROTECTED]> wrote:
>
> You wouldn't happen to have a spare ELH diagram (or
> two) lying around
> that one
Hi,
I have a database containing a field of type datetime (-00-00 00:00:00).
The datetime field of each new record is set to the current date and time
when a new record is added. I would like to be able to produce some
statistics on the new records entered within the past 12 hours. I would l
i'm converting Brian's php code into sql - he's looking for scores in Oct,
Nov, Dec and Jan, that's what I'm doing in the sql, and the if's all have
"if score >= 75" which is what I'm doing in the sql too, Brian is getting a
total "$tally++" so am I "count(*)"...
-Original Message-
From:
could you change this
$query2 = ("SELECT Month, Score FROM scores WHERE Username =
'$Username'");
to
$query2 = ("SELECT count(*) FROM scores WHERE Username = '$Username' and
Score >= 75 and Month in ('January', 'December', 'November', 'October')");
$result2 = mysql_query($query2) or
You wouldn't happen to have a spare ELH diagram (or two) lying around
that one could take a look at, would you?
Thanks.
TIM
-When you save for a long time to buy something, then you find
that you can't afford it --- that's inflation.
> -Original Message-
> From: DL Neil [mailto:[EMAIL
Will someone please send me the correct unsubscribed sequence for this list? Have
tried from
phpnet with no success.. Thanks.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list admi
hey folks -
i'm stumped. been working on what i thought would be a simple script to
cycle through users' records and perform a query. But I can't get the loops
right, it seems like only one or two records get updated.
Using MySQL, we have about 2000 students enrolled. each month they take a
tes
Hi,
I hate to simply refer to other sources in a response, but cross-tabulations are a
large and rich subject which are
too large for the time I have to write this email. I would suggest reading this
article:
http://www.devshed.com/Server_Side/MySQL/MySQLWiz
which is a pretty good source o
sorry, as I said Im kinda new, I was downloading the file from my webserver
to my computer, and it downloaded the php file as a php file, non parsed by
the preprocessor. But when other people download it it does only give the
source
sorry :)
"Neil Thomson" <[EMAIL PROTECTED]> wrote in message
00
Markus,
> I have the daunting task of porting an Access database to
> MySQL. It's unbeliveably poorly designed, and columns
> id, name, issn, year, info, volume, numbers and remarks.
> I made another table, names, that's got columns id and name.
>
> I used
>
> INSERT INTO names (name) SELECT DIST
Or you could do something like:
if(!empty($PHP_SELF))
{
if(stristr($PHP_SELF," config.php"))
{
header("Status: 404 Not Found");
}
}
that's assuming you use the register_globals. If n
u can download a php page from a download manager ? i just tryed with
flashget... & it phrased the php page into html first.. ? ?
if you want to protect your say.. variables file from some1 trying in the
address of it. heres a simple way. in the variables file include
@header(status: error 404);
";
}
?>
Don't forget all other HTML tags you need to pack around this
-Original Message-
From: louie miranda [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 6:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Listing select * from table; on PHP
--
Hi, i have tried
Hi, im kinda new to this so be kind :)
Im using mysql and php to create test databases (guestbook etc, basic
stuff), but it doesnt seem so secure, people can just use a download manager
to download the php files and steal the mysql passwords. Is there anyway to
make it so they can see the php fil
I have a simple SELECT statement that returns more than one row.
When I do something like this:
do
{
.
} while (OCIFetch($qryResult) != false);
I get an "Out of sequence" error on OCIFetch. So then I tried this:
$numRows = OCIRowCount($qryResult);
for($i = 0; $i < $numRows; $i++)
{
OCI
try mysql_fetch_array... mysql_fetch_row is a crappy old function.
- Original Message -
From: "Peter Westergaard" <[EMAIL PROTECTED]>
Newsgroups: php.db
To: <[EMAIL PROTECTED]>
Sent: Monday, January 07, 2002 8:32 AM
Subject: Pulling a long list of data stalls PHP
> Hi,
>
> I'm
Just curious, but which version of PHP are you using, the ISAPI or CGI.
I've tried the isapi version before and had problems like this. PHP
would crash and leave orphaned instances of php. If your using the
isapi version try the cgi and see if it works for you.
-Original Message-
It seems like what you're looking for is first to do a "SELECT DISTINCT
.." to find all the unique topic names in the system.
This, in your case, would present you with Billie, Bill, Bret, ... etc.
Then, in a loop as you traverse this result, create a query for the
count of each of these spe
George,
When you use:
$prd
Why not use the Product ID in the VALUE tag, and use the Product
NAME between the OPTION /OPTION tags?
That way, the VALUE is what is selected, and you can then use an
SQL INSERT or UPDATE command to push that into the destination table.
One less check aga
Thanks to Miles!
The problem, for anyone who is going through this themselves lay
(in my case) with my php.ini file - evidently my fat fingers copied
the 'recommended' php.ini file, instead of the 'distro' php.ini file.
The 'Recommended' file contains a few optimizations and security
patches
Hello, all!
I have the daunting task of porting an Access database to
MySQL. It's unbeliveably poorly designed, and columns
id, name, issn, year, info, volume, numbers and remarks.
I made another table, names, that's got columns id and name.
I used
INSERT INTO names (name) SELECT DISTINCT ma
George,
=I was pleased to hear from Miles. There are likely to be as many suggestions for how
things should be done, as
there are developers. I'll be interested to hear from others - personally (cf on the
list) if the comments might
'interfere'/argue a case (and thus risk muddying your waters)
--
Hi, i have tried this php script to view my table db,
but when i browse it over the net i couldn't see anything
just plain blank page.
Hm, Can u help me make this show tables over on php
and post it over.
thanks,
louie...
--
PHP Database Mailing List (http://www.php.net/)
To
I have two tables, the first one I query like :
$query = "SELECT * FROM xp_topics WHERE artist_count='artist' AND topictext LIKE
'B%' ORDER BY artist_count DESC limit 0,5"; $req = mysql_query($query);
$res = mysql_num_rows($req); if ($res == 0) { echo "
Sorry there
Marc Bragg wrote:
> Is there a web interface, like dreamweaver for html, for Php. Am aware
> of phpmyadmin, but am looking for the graphics side of things, i.e, make
> a bod this size, color, and put this date into it?
HI,
There is DreamweaverDev and Phakt extension -
http://www.interakt.ro/pr
I am usng ftp_get function.
ftp_get($ftp,$select_file,$select_file,FTP_BINARY)
even though i give any other dir /file name in place of the temporary file it gives
the error in opening file.
soemtimes it executes the cmmand but when searched no downloaded file founds.
basically my problem is t
David,
> =Prevailing wisdom in system design suggests that the data should be
'designed' first, and 'code'/processing
> only later (relational or structured design philosophy, even
object-oriented design). Accordingly I recommend
> considering which parts of your current files should be converted
hea
AFAIK You can use the ODBC functions to work with MS SQL :
http://www.php.net/manual/en/ref.odbc.php
that's all what i know
gurix
"Shane Peery" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED].
..
> I am looking for compiled libraries for PHP 4.1.1 and
Hello everyone!
In my mySQL DB I have the tables:
| po_product | and | products|
|--| | -|
| po_id | | product_id |
| product_id | | product_name |
|--
hea
a better way is to include your admin pages.
if ($myrow[Admin] == "Y"){
include("admin.php");
}else{
include("user.php") ;
}
so you can also include at the top of this example a general header with
menu's etc.
gurix
"Matt Stewart" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PR
32 matches
Mail list logo
