The following is a portion of the code I have in my php script.
elseif ($submit=="Update categories")
{
if (is_array($Cat_ID))
{
while (list($key,$value) = each($Cat_ID))
{
print "Updated entry #$value\n";
$query = "update $table2 set CatName = '$CatNam
Hi,
what about other possibilities to do this ?
Tom
U¿ytkownik "Manuel Lemos" <[EMAIL PROTECTED]> napisa³ w wiadomo¶ci
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello Pranot,
>
> On 16-Jul-01 06:09:33, you wrote:
>
>
> >hi.. friends
>
> >i have a database (mysql) in which their r many recor
Hi,
On my website I want to display some articles, in Slashdot style. The
main page should only display the first 20 words of the article, and
users should be able to click on a link to view the entire article.
The articles are stored in a MySQL database, the body of the article in a
blob-field.
Hi!
I'm trying to authenticate members by using php and MySQL.
This is what I've come to so far:
How do I make the authentication to go to site:
members.php?charnick=$charnick
Where $charnick is brung from the DB line who was authenticated?
So that Peter won't end up at John 's membersite?
"Piotr Dubla" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> I have a script which accessed a database (MySQL) and reads and wrties
> things to it. The first time I run the script everything runs 100% but
> then if I re-run it it gives me
>
> Fatal error: Unsupported operand typ
Manuel Lemos wrote:
>
> Hello André,
>
> On 03-Aug-01 10:31:30, you wrote:
>
> >But what other issues are there? Should there not be a part of the PHP
> >documentation dedicated to describing all the things you should worry about
> >if you want to write portable code? Shouldn't there be a "port
One way to do it is to:
loop through the list of articles;
explode the body of article ==> $words = explode(" ", $body, 21);
$words is now an array of 21 elements, the first 20 elements contain the
first 20 words in the body, the 21st element contains the rest of the body;
--
Jason Wong
Gremli
hi,
[...]
> My question is this: how can I select only those first 20 words in the
> PHP code?
SELECT LEFT(YourBlobFiekd, 20) FROM YourTable;
hope it helps
Johannes
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
Hi,
> Any ideas as to what the problem is?
What error do you get? Is the query not working?
Put a mysql_error() into your "or die("The category...")" to get
the exact error message. And try putting quotes around CAtID = '$value'.
> print "Return to the
print "Return to CatIndex";
looks much ni
Yes, thank you, this works!
Ian.
Paul Burney <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> on 8/10/01 7:50 AM, Ian Grant at [EMAIL PROTECTED] wrote:
>
> > I've got a simply search form, on my site using PHP and MySQL.
> > It writes a SELECT query using WHER
NO! This will return the first 20 characters from the field not the first 20
words. To do that you need to use a regexp in the SQL or explode the result
in php and use the first 20 elements of the array!
Regards
Jon Farmer
Systems Programmer
Entanet International Ltd www.enta.net
Tel 01952 4289
i use this script with apache/php/mysql
then you can always reach the userid with $PHP_AUTH_USER
/Mattias Aka BoNzO
http://bonzo.sineleven.nu
-- Original Message --
From: Cato Larsen <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Send: 01:47 AM
Subject: [PHP-DB] Member authentication with PHP a
Hi i have a problem printing a lob field containing an image.
The database i use is Interbase 6.0
I have a blob/lob field with a gif image inside an i like to print this image on the
web.
Can you help me?
Bye Alessandro
I would use either cookies or sessions for this.
First Check for the cookie, and verify its contents.
If there isn't a cookie then do the login prompt like you
are doing now.
Here's some pseudocode to give you a quick idea of what I mean
if (isset($cookie)
{
if (CheckCookie())
{
SiteCo
Thanks a mill Sheridan!
This was accually what I was looking for, but gave up since the other
tutorials and script examples where too complicated for me to grasp.
One question to the code on the site:
Is it possible to insert info to be grabbed on other sites?
Like
email
password
name
So you ca
"Jon Farmer" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>> From: Johannes Janson [mailto:[EMAIL PROTECTED]]
>> Sent: 13 August 2001 12:15
>> To: [EMAIL PROTECTED]
>> Subject: [PHP-DB] Re: Show abbreviated article
>> > My question is this: how can I select o
I am trying to caregorize to group at the same time, but its not working.
Any hints?
Here's my code:
$temp="Dummy";
while ($row = mysql_fetch_array($result))
{
if($temp !=$row["group_name"]){
$temp=$row["group_name"] ;
echo "Group:$temp";
}
$temp1="blah";
if($temp1 !=$row["service_cat"]){
$te
"Alex.Tesi" <[EMAIL PROTECTED]> wrote in message
003901c123fa$1ff2da50$[EMAIL PROTECTED]">news:003901c123fa$1ff2da50$[EMAIL PROTECTED]...
>Hi i have a problem printing a lob field containing an image.
>The database i use is Interbase 6.0
>I have a blob/lob field with a gif image inside an i like
Hi,
If I do a select from multiple tables like so
SELECT * FROM,
candidates,
clients,
jobs
WHERE
candidates.ID = clients.candidate_ID
etc etc
i then do
$row = mysql_f
One more thing...
When I've set up the script and run it on my local server I get this error:
"Sheridan Saint-Michel" <[EMAIL PROTECTED]> wrote in message
00df01c12400$ad2a1220$[EMAIL PROTECTED]">news:00df01c12400$ad2a1220$[EMAIL PROTECTED]...
> I would use either cookies or sessions for this.
>
"Sharif Islam" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am trying to caregorize to group at the same time, but its not working.
> Any hints?
> Here's my code:
> $temp="Dummy";
> while ($row = mysql_fetch_array($result))
> {
> if($temp !=$row["group_na
Arg...
I get this error:
Unable to update database. Please contact [EMAIL PROTECTED]
Am I missing something in my DB?
Fields in DB:
id, email, password, name, loc, aim, icq, msn, yahoo, charname ,charsname,
charnick, tit, lvl, picurl, born, appearance, charac, streng, bio, breed,
prof, pos
"Cato Larsen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "Sheridan Saint-Michel" <[EMAIL PROTECTED]> wrote in message
> 00df01c12400$ad2a1220$[EMAIL PROTECTED]">news:00df01c12400$ad2a1220$[EMAIL PROTECTED]...
>
> > From: Cato Larsen <[EMAIL PROTECTED]>
> >
If you note the part of the script where the cookie is set
//make unique session id and store it in Database
$timer = md5(time());
$sid = $UserID . "+" . $timer;
SetCookie("Cookiename",$sid,time()+2592000); file://Set Cookie for 30 days
$query = "update members set sid=\"$timer\" where Us
My Script uses a Session ID Variable when verifying the user
You don't have a field setup for this. So either change the code
in this section
$timer = md5(time());
$sid = $email . "+" . $timer;
SetCookie("ElectrocutedClanRemains",$sid,time()+2592000);
$query = "update members set sid=\"$time
Thanks for your reply
>
> You don't show your SQL, but I assume it's something like
> SELECT grp,svc,mach FROM table ORDER BY grp,svc,mach
>
Thats right.
But its displaying the same as my code:
---
Group:Desktop
Service:BACKUP
AITSBKUP
Service:E-Mail
AITSMAIL
Service:E-Mail
JEEVES
Group:Unix
Se
- Original Message -
From: "Sharif Islam" <[EMAIL PROTECTED]>
To: "Hugh Bothwell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, August 13, 2001 11:50 AM
Subject: Re: [PHP-DB] Re: Group By problem
> But its displaying the same as my code:
The SQL was just for reference, to
Thx Alnisa,
I had tried your suggested approach earlier.
I just tried it again I got the following from SQL*Plus:
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
JServer Release 8.1.6.3.0 - Production
SQL> select cat.id, cat.name, count(faq_cat.cat_id) as num_id
2
Sorry Hugh.
But I accedently hit Ctrl + Enter.
If you had red the next message from me, you'd seen what error and so on.
Cato
--
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 a
Thx Again Alnisa,
You were very close, and instrumental in solving this seemingly simple
query problem.
The actual query that worked looks like this:
SQL> select cat.id, cat.name, count(faq_cat.cat_id) as num
2 from mdfaq_faq_cat faq_cat, mdfaq_category cat
3 where faq_cat.cat_id (+) = c
At 9:29 AM -0700 8/13/01, Barry Prentiss wrote:
>Thx Alnisa,
> I had tried your suggested approach earlier.
> I just tried it again I got the following from SQL*Plus:
Wow, Oracle, what a pain. (Actually, it's probably pure laziness that
MySQL doesn't check for this, but anyway). Anyway, I look
At 10:31 AM -0700 8/13/01, Barry Prentiss wrote:
>Thx Again Alnisa,
> You were very close, and instrumental in solving this seemingly simple
>query problem.
> The actual query that worked looks like this:
>
> SQL> select cat.id, cat.name, count(faq_cat.cat_id) as num
> 2 from mdfaq_faq_cat f
Hi people,
I have a site that is made up of a number of different images that are all
created on the fly with GD. The site works fine on a stable UNIX
environment, but I have tried to transfer it to a regular Windows box for
development, and I am having some troubles.
MOST of the images will work
Good Afternoon Everyone,
I am a fellow PHP developer that has run into a project where I need to know if
anyone has created anything like this.
I need to do Pearson Corilations on Data from MySQL to do a top 10 match that
compares DNA numerical image data(grayscale(0-255) and creates an image
I previously posted that GD was giving me grief after a while, once I had
moved the development of my site over to a Windows machine running Apache. I
believe I now know why there were problems. After a while, I began receiving
error messages and they would output in the middle of the image code,
Opening multiple databases on the same database machine
seems unsupported. While you CAN do it, it has a tendency
to "reuse" the last connection even in lieu of a specific database.
Right now we're using mysql_db_query() to get around it, but
with that becoming deprecated, we need to find anothe
Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to
all that helped! The problem I'm now experiencing is when I try to
interface with MySQL via PHP. MySQL seems to work fine by logging into
MySQL directly and through a MySQL GUI Client. I get the following error...
Warning:
Whats up everybody? I am setting up a PHP script that has a text file, but in the actual text file it has a % tag before each item in the list
due to a way this database is setup.
What i am trying to do is have this txt file display on one of my subpages, but have
PHP force the removal of the
on 8/13/01 1:56 PM, Szii ([EMAIL PROTECTED]) wrote:
> Opening multiple databases on the same database machine
> seems unsupported. While you CAN do it, it has a tendency
> to "reuse" the last connection even in lieu of a specific database.
> Right now we're using mysql_db_query() to get around i
Done both.
In fact, I create an object which has 2 database objects in it.
If I dump the objects, I can WATCH as they "merge" and point
at the same database.
I go back to using mysql_db_query() and everything's fine.
It would appear that the mysql_select_db() is not persisting.
If you call it o
I can't think of a simple way to do it off of an include, but off the top of
my head:
--
phill
"Brian Tegtmeier" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Whats up everybody? I am setting up a PHP script that has a text file, but in the actual text file
I have created a form which I cannot duplicate the error which is coming up
only sometimes. An affiliate to my client had received emails regarding the
following error:
"The requested method POST is not allowed for the URL/index.html"
The page this is running on is called "maxout.php" and it is
Hi,
Can anyone help me to understand the OCIBindByName/OCIDefineByName
functionality when used with the Oracle 'returning' clause? These two
functions are seriously under-documented at PHP.net.
I need the sequence-generated ID created during an insert for further
manipulation.
I tried sequence-
Quoting Barry Prentiss <[EMAIL PROTECTED]>:
> Hi,
> Can anyone help me to understand the OCIBindByName/OCIDefineByName
> functionality when used with the Oracle 'returning' clause? These two
> functions are seriously under-documented at PHP.net.
> I need the sequence-generated ID created during
Quoting Barry Prentiss <[EMAIL PROTECTED]>:
> Hi,
> Can anyone help me to understand the OCIBindByName/OCIDefineByName
> functionality when used with the Oracle 'returning' clause? These two
> functions are seriously under-documented at PHP.net.
> I need the sequence-generated ID created during
hi all,
I cant seem to get my mail function to work. OK so i am a noob, that might
have something to do with it. I am using a script I found called the HTML
Mime Mail Class, which does everything i need except actually send the mail.
I am guessing that there is some config problems, but i am not
Try using MySQL to do that right in the query itself (and save the
overhead of retreiving the whole blob then PHP'ing the blob too).
From the MySQL Doc's ;-) RTFM once at least
--
SUBSTRING(str,pos,len)
SUBSTRING(str FROM pos FOR len)
MID(str,pos,
How can I run through a database like I am trying to do here? It seems like
at the end of the first I need to start over in order to start reading from
the beggining of the database on the second.
I hope that I hace explained my problem well if not please reply with your
questions. Thank you
> How can I run through a database like I am trying to do here? It seems
like
> at the end of the first I need to start over in order to start reading
from
> the beggining of the database on the second.
> I hope that I hace explained my problem well if not please reply with your
> questions. Tha
To run with less overhead, I would advice to only access the database when
absolutely nessary. Therefor I would approach the problem with pasting the
database result into an array and then doing the work from here - an array
is much faster to work with rather than db.
An approach could be
/ La
On Mon, Aug 13, 2001 at 03:38:50PM -0700, John Telesh wrote:
> I have created a form which I cannot duplicate the error which is coming up
> only sometimes. An affiliate to my client had received emails regarding the
> following error:
>
> "The requested method POST is not allowed for the URL/in
51 matches
Mail list logo
