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
Hello everyone!
In my mySQL DB I have the tables:
| po_product | and | products|
|--| | -|
| po_id | | product_id |
| product_id | | product_name |
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 SuSE
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
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
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 -
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 /p
pbSorry
?php
mysql_connect ('dbhost','user','pass');
mysql_select_db ('db');
$ircname2 = htmlspecialchars($ircname);
mysql_query (select ircname from members);
print ($ircname2);
?
--
Hi, i have tried this php script to view my table db,
but when i browse it over the net i couldn't see
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)
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
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
George,
When you use:
pre
OPTION value=$prd$prd/OPTION
/pre
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
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
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-
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
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++)
{
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
?php
mysql_connect ('dbhost','user','pass');
mysql_select_db ('db');
$ircname2 = htmlspecialchars($ircname);
$result = mysql_query (select ircname from members);
while( $row = mysql_fetch_array($result) )
{
print $row['ircname'].BR;
}
?
Don't forget all other HTML tags you need to
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);
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 not,
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 DISTINCT
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
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
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
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
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
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 die
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:
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
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
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,
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:
32 matches
Mail list logo