Which database do you use ?
I don´t know mySql ... but I know Sybase very well and there you have
something called Triggers ...
[Cite SybaseDoc]
A trigger is a stored procedure that goes into effect when you insert,
delete, or update data in a table
[/CITE]
You could say for example
Create
There is no need to use transactions if you are dealing with 1 table.
Have a version column in the table which is numeric. When you first
select/edit the record, store the version number.
When you update, use:
update table set version = version + 1, data = ... where key=$id and
version =
Hi,
Are there any error messages?
Just a guess - may be this will work
Select $tbl_virtual.thumb1,$tbl_descriptions.short_desc FROM $tbl_virtual
left join $tbl_descriptions on
$tbl_virtual.id_property=$tbl_descriptions.id_property WHERE
$tbl_virtual.id_property=$link
Dobromir Velev
I get the following error when I try the statement below. Through
elimination I know it is the dates that are causing the problem. I have
set the date format to this: alter session set NLS_DATE_FORMAT =
'-MM-DD';
$sql_season: insert into season (id, code, start_date, end_date) values
(16,
This is a one-time mailing only. You are receiving this message because you recently
submitted to one of our websites -- this is simply an attempt to update our files by
verifying your email address [EMAIL PROTECTED] at 206.43.192.76
Hello,
I am builing a microsoft access database.
Now wants the compagny I created it for me to use it to make dynamic
webpages. The problem is that I am new at this.
Can somebody please explain the basics of integrating a MS Access databse
with php into a webpage?
I thank you in advance,
I think that by using ODBC you can connect to the MS Access server.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: user [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 31, 2001 4:33 PM
Subject: [PHP-DB] PHP and ms
Boy, as a list, I _sure_ think it'd be fun to subscribe to this
Abundant Living Online, don't you? I mean, I only thought you lived in
the biological world, and had to log in to get online - if we can live
online, that would really save a lot of time! And cut down on travel
expenses.
Sorry,
Yikes - not sure what everyone else is smoking. That's the hard way. I
thought he was just asking if he could a variable that is an array inside a
database and retrieve it later as an array. If this is the case, you can use
the serialize() function to convert the array to data that can be stored
Any specific type of image? Look at the function and user comments on this
PHP manual page. They have some good examples of resizing.
http://www.php.net/manual/en/function.imagecopyresized.php
- Jonathan
Andrius Jakutis [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
Hi,
You need to retreive data using a query script and just put them in a page
:)
It's as easy as that...
Anyway if you precise your question we'll be able to give a more precise
answer
-Message d'origine-
De : user [EMAIL PROTECTED]
À : [EMAIL PROTECTED] [EMAIL PROTECTED]
Date :
How easy is to connect MSSQL server from PHP , running in Linux? I already
have Php installed but I dont think I complied it --with-odbc(?). Do i
have to recompile? Is there any way to test it?
Any help will be great. thanks
-Sharif
)
((
||-.
| :|/'
-`--'-
--
PHP Database
I would like users to be able to request to have their password
sent to their email address if they forget it. I would also like it
encrypted in the database though. How is this best handled?
The security isn't real important. But I let users choose their
own password and if they use a password
Have a registration screen that inserts their names, email etc *and* their choice of
username +
password:
$sql = INSERT INTO table (username,realname,password,email) VALUES
('$username',$realname',password('$password'),'$email');
$result = mysql_query($sql,$connect);
//and do a check if the
Sorry it should have read:
if ($check != 0)
echo this username already exists, select another.;
}
else {
echo continue!;
}
Cheers.
Russ
On Fri, 31 Aug 2001 17:43:59 +0100 (GMT Daylight Time) Russ Michell
[EMAIL PROTECTED] wrote:
Have a registration screen
Ugh, need to proof-read... Let me repost:
Jeff,
In order to maintain a strong encryption of passwords, you should probably
use an MD5 hash. Unfortunately, this is a one-way street. What I would
suggest doing however, is not actually attempt to give the user their
password, but allow them to
I like the new password idea. How do I make sure it's them who's creating
a new password so that someone else doesn't maliciously change their
password? If someone knew someone's username and e-mail address
I would think they could change it. Thanks.
Jeff
This doesn't seem to solve his problem
Don't let them change it to whatever they want - have your program/system
create a new, random password and e-mail it to the user's account. Unless
the malicious person has a way to intercept the e-mail - which is possible -
it's kind of useless. But how else are you going to get that information
I think you both (Jeff and Jon) misunderstood what I meant... Of course, I
probably didn't explain very well either :-)
I will describe the process again and then address each of your concerns...
- Create a form named lostpass.php or something similar. This form should
take the user's email
Hello,
I'm building an application that uses odbc_fetch_row with a row
number (odbc_fetch_row($cx, 0)).
This works fine in MS-SQL7.0, but the PHP manual explains that
using odbc_fetch_row with a row number (second argument) might not
work with some drivers.
Does anyone of you have an
hello phpNuke uses this process and i have used the code in my own applications and
works fine
- Original Message -
From: Alexandre Santos
To: Andrius Jakutis
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 1:52 AM
Subject: [PHP-DB] Re: example of making Next 10
I have pruned down my changes to the interbase module to just 2 bug fixes
and then my blob insert patch.
Where do I send these?
Please give me the name of someone that will add these to CVS and not just
blow me off.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
I would like to get the first 5 random entries out of my mysql database,
what would be the correct SELECT option?
I adjusted this line
$result = mysql_db_query ($DBName,select * from Contacts LIMIT 0,5 );
which works correctly. :)
$result = mysql_db_query ($DBName,select * from Contacts order
Sorry but I'm just not getting this. I'm not sure how to get the order
of the pics in the first place or what do with the picnumber
column. If someone deletes a pic wouldn't the picnumbers higher than
it also need to be changed? I'm understanding everything else, even
the password stuff but this
hi,
i am trying to build a message board in php with mysql as back end;
what i want to do is to query the database in a certain way that the result
is returned in the correct order for php to display the discussion thread
properly
here is my table structure:
mysql show fields from posts
- ;
Hello!!!
Now that I have found a better link to understand and use the code for
next/previous...here it is...
http://www.onlamp.com/pub/a/php/2000/11/02/next_previous.html
I use this idea with every database.
This also teaches you...mysql_fetch_object
PhPBuilder is OK but this one better
I was sure there was a syntax error in that SELECT statement, but
according tho the description at
http://www.mysql.com/doc/M/a/Mathematical_functions.html, that looks
right on to me. I know this doesn't help a lot, but at least you've had
a second set of eyes confirm that your code looks
I bet there are some shopping carts and or catalogs using PHP and MySql
out there that I can use for my project rather than start from scratch
links please
thanks in advance
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
php.net has loads of such links - don't be so lazy! ;-)
-Original Message-
From: Larry RedCobra Linthicum [mailto:[EMAIL PROTECTED]]
Sent: 31 August 2001 20:57
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP / MySql / catalogs / carts
I bet there are some shopping carts and or catalogs
according tho the description at
http://www.mysql.com/doc/M/a/Mathematical_functions.html, that looks
$result = mysql_db_query ($DBName,select * from Contacts order by rand()
LIMIT 5 );
Doesn't work at all. :(
What version of MySQL are you using? I remember something about ordering by
I know it's documented as rand() but you might want to try random() just in
case... I'm sure I read that somewhere
- seb
-Original Message-
From: John Hurleston [mailto:[EMAIL PROTECTED]]
Sent: 31 August 2001 19:18
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Random
I would like to
I don't know of a way to do the insert in a single query (anyone?!?) with
this... but
assuming the fields in pic are
id int PRI
location varchar(30)
picnumber int
user varchar(20)
$query = Select max(picnumber) from pics where user=\$user\;
$dbq = mysql_query($query,$dblink) or
OK, I see what you're saying and the O'Reilly link from someone
else was very helpful, however I think there still must be a simpler way to
do it. I don't need to have the reorder picture function. Each picture record
has an id field which is linked to their username (in another table) and a
Hey all
I can connect with $conn =
mysql_connect(IP_Address,username,password);
but I can't connect with
$host = IP_Address;
$user = username;
$pass = password;
$conn = mysql_connect($host,$user,$pass);
Any ideas? All I get is Can't connect to MySQL Server on 'localhost',
yeah - everything's fine! All the variables are being stored, but
they're not getting passed to mysql_connect() for some really strange
reason!
:-(
I've done a temporary fix - moved the entire database connection
function to a separate file, and required that from the first required
file (!),
Yeah I just tried myself and it didn't work...
localhost works as hostnameBut no IP number...hm..
Maybe it's the . in the variable...hm.
Dan
Anybody else have a idea?!!??!
--
From: Dave Watkinson
Sent: Friday, August 31, 2001 3:25 PM
To:
You mean you had all this inside a function? Like:
function dbConnect ()
{
$link = mysql_connect($host,$user,$pass);
}
?
If so, did you pass $host, $user, and $pass to the function by global-ing
them like:
function dbConnect ()
{
global $host;
global $user;
global $pass;
$link =
Remember that the timestamp/default feature is only available to the
1st timestamp column in the table.
This caught me a bit .. makes sense but if you don't know .. G
DSig
On Fri, 31 Aug 2001 09:20:50 -0500, [EMAIL PROTECTED] (Rick Emery)
wrote:
You can use a TIMESTAMP field in the the
err... neither!
Originally I had
function dbConnect (){
$link =
mysql_connect(ipaddress,username,password);
}
And what I tried to do was
require('somefile');
who's contents were:
?
$host = ipaddress;
JH has it right - your function has no idea what $host, $user, and $pass
are, because they're out of scope. Add the global statements that
Jonathan suggested inside your dbConnect function, and all will be well.
Dave Watkinson wrote:
function dbConnect (){
$link =
Hello,
Again question about resizing image with PHP. What is the quality of the
image after this process?
I am about standart GIF or JPG image.
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
imagecopyresized: crap
imagecopyresampled: good but requires gd 2.0
- seb
-Original Message-
From: Andrius Jakutis [mailto:[EMAIL PROTECTED]]
Sent: 01 September 2001 09:07
To: [EMAIL PROTECTED]
Subject: [PHP-DB] resizing image with php - what is the quality?
Hello,
Again question
Dear [EMAIL PROTECTED],
EMAIL PROCESSING COMPANY LOOKING FOR
EMAIL PROCESSORS IMMEDIATELY, TO SUSTAIN
EXPLOSIVE GROWTH. EARN $2,000-$6,000
(PART-TIME) AND $5,000-$10,000 (FULL TIME)
MONTHLY. FREE START-UP, NOT MLM, NO
EXPERIENCE NECESSARY.
SEND AN EMAIL TO: [EMAIL PROTECTED]
WITH
Hi guys
I had a question. How do you drop a table in a database in MySQL that has
spaces in it's name. I created some tables in M$ Access and then exported
them using MyODBC to MySQL. One of the tables had whitespaces in the name.
Now MySQL is all screwed up. I want to drop the table but nothing
44 matches
Mail list logo