Are there any people who know the way to display results on multiple pages
if using Oracle database (preferrably using PHP Oracle finctions and not
Oracle8 functions)?
Best Regards,
Maxim Bubnov
Richard Emery [EMAIL PROTECTED]:
Why don't you let mysql sort and limit the records for you?
I am attempting to build a Web site that will allow users to create simple
text documents that will be stored in a database. I had been assuming I
could use a textarea form and have PHP pass it to a mySQL database.
However, when I attempted to send a 393 word (2,216 characters) text block,
the
Hello,
I have to make a loginprocedure for our intranet at my work.
I have to create a userdatabase with users and usergroups ( like Windows
NT/2000 User Manager and Novell).
Before I start with this job I wonder if maybe somebody created already
something like this in PHP/MySQL and I can just
could you perhaps save the contents directly into a file, then read the file
into the database?
I know for a fact (http://www.dentedreality.com.au/webpad/) that you can use
a textarea to pump more info than that into a file, but haven't tried doing
it straight into a database.
HTH
Beau
//
This may be a stupid question but I am a complete newbie.
I am trying to automatically drop events from a noticeboard when the date
has passed. I have stored the date of the event in the database in the form
-MM-DD and wish to SELECT From the database WHERE date = todays date.
Is this
Hi,
I am trying to do this:
- I have an image stored in database 'A'
- a php script should load this image, and stamp it with a watermark
- then the php script should save the new image (with the watermark)
in database 'B' ...
How can I do this? I guess somehow I have to buffer the output,
Hi DrTebi,
fetch the image from database A and put it into a buffer then
I guess somehow I have to buffer the output, manipulate
the buffer by adding the watermark, and then insert the image into the
database B
^^
Regards,
Ruprecht
--
E-Mail:
Manuel,
Prepared queries in practice are the same as what John Lim calls in this
document http://php.weblogs.com/portable_sql as binding, except that
he doesn't seem to be aware that it is the same thing, so he says that
only some database can use it! :-) Metabase handles prepared queries
Hi Alex Francis,
SELECT From the database WHERE date = todays date.
^ somethink like now() or date()
an other method you put the date in a variable that you get by the
datecommand and make
SELECT From table WHERE date = datevar (variable with current
Hi Alex,
Got my select statement to work as follows:
$query = ' SELECT * FROM notices WHERE TO_DAYS(eventdate) =
TO_DAYS(now())
order by eventdate';
=well done!
However the TO-DAYS calls do seem a bit OTT.
Please post the schema for tbl:notices - specifically the datatype for
eventdate.
Hi Pedro,
There is the PL/SQL SQL%ROWCOUNT variable. Bind a PHP variable to it.
Pedro Garre [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
OCIRowCount does not seem to work when inserts are made in
Hi Manuel,
Manuel Lemos [EMAIL PROTECTED] wrote
Most of the popular database abstraction packages support prepared
queries, except for your PHP ADODb. So, think about this before you keep
throwing sand to the eyes of the users that do not know better, may be
you understand the point of
On Thursday 18 April 2002 00:08, Joel Colombo wrote:
i was wondering about a PHP function like mysql_fetch_array
but that would select all the ROW values of one FIELD
rather the mysql_fetch_array selecting all FIELDS of ONE row.
does PHP have that function ?
Not yet.
basically y do i
On Wed, Apr 17, 2002 at 01:03:49PM -0500, Pedro Garre wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
OCIRowCount does not seem to work when inserts are made in a block:
BEGIN insert ...; insert ...; insert ...; END;
It returns 1, but 3 rows have
ok i thought the SUM only worked with GROUP BY
shit...
that makes me feel stupid but smarter now
thanx
Joel
Jason Wong [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
On Thursday 18 April 2002 00:08, Joel Colombo wrote:
i was wondering about a PHP function like
I have a website which has, among other things, virtual items. The items
are stored in table items, the different types of items in item_types. I
use the following query to get a user's items:
SELECT DISTINCT t1.id,t1.itemtype,t2.name FROM items as t1,item_types as t2
WHERE (t1.itemtype = t2.id
Hi Leif,
Anytime you get an MySQL error code number use perror program to see what it
is..
[root@atsiz /root]# perror 28
Error code 28: No space left on device
It seems like you don't have enough space to write to your table.
Gurhan
-Original Message-
From: Leif K-Brooks
There must be people on this list that have ported their web apps from
different databases and could share their experiences.
mysql - postesql
mysql - ms sql server
ms sql server - oracle
-Original Message-
From: John Lim [mailto:[EMAIL PROTECTED]]
Sent: April 17, 2002
Tried the following as suggested - Still no dates showing
$query = ' SELECT id, eventheading, DATE_FORMAT(eventdate, %D %M %Y)as
evdt FROM notices WHERE TO_DAYS(eventdate) = TO_DAYS(now()) order by
eventdate';
$result=mysql_db_query($dbname, $query, $link);
if (!$result) { echo(
Alex,
enterdate text NOT NULL
eventdate text NOT NULL
First, I think I would change the above to a date or datetime or one of the
other date time fields used by mysql instead of text fields.
Second I don't think you really need to use TO DAYS and now. This is what I
do.
Hi. I'm looking at compiling one of the odbc function sets into php on
my Mac OSX machine (I eventually want to be able to talk to MAS90 on a
Windows machine -- if that's feasible). I'm finding the ODBC situation a
bit confusing though. Should I use iodbc or unixodbc? Any suggestions?
And
Or if that is not available for you to edit you could always try just
executing a statement to alter the session once a database connection
is established. This method is a little slower.
How slower? Very very slower? Can you give me an aproximation in seconds?
As you will have to
execute
Mike,
I have just tried it again (that was the first way I tried to do the query)
and get the error
Unknown column '$todaysdate' in 'where clause'
--
Alex Francis
Cameron Design
35, Drumillan Hill
Greenock PA16 0XD
Tel 01475 798106
[EMAIL PROTECTED]
http://www.camerondesign.co.uk
This
I have the following to pages( just testing them at the moment ):
? mysql_connect(host,,);
mysql_select_db(music);
echo form name='add_album' method='post' action='test-album-add.php';
$getlist = mysql_query(SELECT * FROM music_artist ORDER BY
artist_name ASC);
echo Artist Name
Hi Barry,
First of all,
$query_id = mysql_query(INSERT INTO...); is wrong. That line will just
assign the resultset of the whatever mysql_query() function returns to the
variable $query_id .. Get rid of $query_id and just have mysql_query(INSERt
INTO ); See:
The $music_artist.id is the id from the first page. ( database = music ,
table = music_artist id ). This is what I need, a drop down list of the
artists in table 'music_artist'( I've got this), I want the id of the
artist they selected in the drop list to be inserted into the
table
26 matches
Mail list logo