Has anyone got some code to display the first say 15 records from a query
then get the next 15 then next for a mysql database
--
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
doh, you need to include the database as well:
int mysql_db_query (string database, string query [, int link_identifier])
so mysql_db_query("databasename", "delete from foo where bar = $foobar");
try that
Sean
-Original Message-
From: Ken Jansons [mailto:[EMAIL PROTECTED]]
Sent: Mond
Hi
This is probably a question for a core PHP developers working on ODBC
I have compiled my php 4.0.4 against IBM DB2 libs and all is well untill i
do something like
odbc_exec($cid,"CALL ('arg1','arg2','arg3')";
Call fails saying it could not find certain library.mentioning
SQLExecDirec
I'm sorry for bugging everyone, I just created a new PHP script, and used
the following code:
mysql_query ("DELETE FROM events
WHERE event_id = $event_id");
And it worked!
I must've have something wrong in the original script.
-Ken
- Original Message -
From: "Ken
I tried that code, but now it gives me the following error:
Warning: Wrong parameter count for mysql_db_query() in
/usr/bus/events/delete.php on line 29
when I send delete.php?event_id=5
(Which is a valid value for the event_id field). Any more ideas anyone?
and line 29 is that code that I pu
Try:
mysql_db_query ("DELETE FROM events WHERE event_id = " . $event_id);
I have had better luck with "mysql_db_query".
Sean
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 15, 2001 3:50 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] DELETE FROM..
Hello, I am new to the list, so please bear with me! I am creating a database system
that will use PHP4 and MySQL 3.22. I've got things working excellent now... I can add,
list, and modify records from the PHP scripts I have created, but I can't delete them.
I can do them manually by going into
Of course you can make a database dynamic combobox. You can fill up the
first one with table names and the second with the table fields the user had
chosen. I know two ways of doing this :
1st) Only php code - You fill the tables combobox and link a call to a php
script to fill up the fields combo
store the value in a named variable, then call the variable with the
stripslashes() function before inserting it into the DB.
a la:
$event = "St. Patrick's Day";
$event = stripslashes($event);
insert table values('$event');
At 02:13 PM 1/15/2001 -0500, Timothy Wright wrote:
>Hello -
>
>I
Hello -
I have set up a calendar database with MySQL and PHP that uses simple text
and tinytext fields for events and event descriptions. The problem is,
whenever I enter an event that uses an apostrophe ( St. Patrick's Day) or a
description (4 o'clock) it stores and returns ( St. Patrick\'s Day
Generically speaking, when faced with the option of putting graphics in a
Blob field or putting a pointer to them and storing them on the file system,
I have always chosen to store a pointer in the database and store the image
on the file system.
Cal
http://www.calevans.com
-Original Messag
Currently working on a site that will enable a paintball (or other type)
team to have there own site on the net.
They will all follow the same format and was thinking about putting there
images into a database table. I'm not asking how to do it, just should i do
it and what performance impact wil
Greetings, Cahyo!
At 15.01.01, 18:47, you wrote:
CSA> I don't know what is the benefit if we use ENUM type.
CSA> can everybody explain it?
It is an ugly crutch.
Well, you see, most RDBMSes will allow you to make a 'lookup
table' or 'dictionary' or something (dunno its official name).
Something
Hey,
I would like to create 2 dynamic ComboBox, but I would like to take into account the
user choice,i.e:
1 - in my first combobox appears the information about tables available in certain
database(db);
2 - the user should select one table name and automatically the respective fields of
that t
Hello, "Ian"!
You wrote:
> Case 1:
> Now, I would like to display all data from Test table
> where my due_date is
> before the current date.
due_date LESS THAN now()
> Case 2:
> Same as case 1, I
> would like to display all data from Test table where
> expired_day plus
> posting_date is befor
Hello, sajid jamal!
You wrote:
> can anyone help me out ,in how to export my oracle
> databse i.e sql to mysql database.
Use Oracle Export tool to produce a text datafile, then
load it to MySQL with its import command. Look docs for
syntax of both commands.
--
Piloteers do it on the road
-
Hello, "Marko Perich"!
You wrote:
> I need to make a transaction over several pages and
> commit it after
> validating the last one.
Insert line on the first page, update on next, mark as
commited on the last. Each hour drop uncommited lines. You
may also provide current time of transaction s
At 9:49 PM +0700 1/15/01, Cahyo S. Aji wrote:
>I don't know what is the benefit if we use ENUM type.
>can everybody explain it?
Examples:
It looks like a character column, but it's represented as an integer,
so operations on it can be quite fast. The numeric representation
also takes less space
You got to have 2 tables: SubAreas (list of your areas) and
Names, each having a link to SubAreas. First select
subarea(s) from the 1st table, then select all corresponding
names from the 2nd. No excessive operations.
--
Piloteers do it on the road
--
PHP Database Mailing List (http://www.
Hello, Justin Smith!
You wrote:
> It's definitely a security issue, not allowing access to
> the linked tables
> in a database with its own security even though the
> database I'm connected
> to via ODBC has full access. Any tips on how to get
> around this? Any help
> would be greatly appre
I don't know what is the benefit if we use ENUM type.
can everybody explain it?
_Ajik_
--
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 administrators, e-mail: [EMAIL PROTECTED
The server (that is running the actual Oracle Database) has to have the listener
running.
If you can connect with SQL*Plus (the Oracle provided SQL interpreter) then you should
be able to connect with PHP.
Not sure what the error you are receiving is though as I don't have a reference here.
>From my Apache config:
LoadModule php4_module d:/php/sapi/php4apache.dll
AddType application/x-httpd-php .php .php4
I have 1.3.14 running on NT4, but this should work for you too. Change the
path in the first line to point to wherever your dll is.
HTH
Jon
| -Original Message-
| From
Hi,
I have problems to configure Apache 1.3.12 to work with php4.0.2 on winnt4.0
workstation. In Readme.txt I found instructions only for IIS and PWS.
Could you tell me what shpuld I need to add to httpd.conf?
Thanx,
Andris Jancevskis
--
PHP Database Mailing List (http://www.php.net/)
Hi Sebastian,
you don't have the mssql.dll loaded (no SQL-Support!)
Just have a look with the PHP_INFO() -function.
You have to enable the mssql-support in your php.ini -file.
If you don't have the appropriate Library, you can get it
at: http://www.php4win.de/
Hope this helps.
Greetinx,
M
Stefan,
can you connect with oracles SQL*Plus tool?
Steve Farmer
At 8:05 AM +0100 15/1/01, Stefan Fokuhl wrote:
>Hi,
>
>i've compiled my php modul with oci8.But I can't connect to my db. It
>tells me the error ORA-12162. In the documentation there is no such
>error mentioned.
>
>Do I need to s
Dear Friends & Future Millionaire:=20
AS SEEN ON NATIONAL TV:=20
Making over half million dollars every 4 to 5 months from your home for=20
an investment of only $25 U.S. Dollars expense one time=20
THANK'S TO THE COMPUTER AGE AND THE INTERNET !=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
27 matches
Mail list logo
