Hi there,
I am trying to figure out how to write a sql statement for mysql with php that
returns the next possible data set. For example I do have the ID number of a
current data set, now I would like to retrieve the next data set with the next
higher ID number. Sometimes there are deleted Ids,
Merlin wrote:
Hi there,
I am trying to figure out how to write a sql statement for mysql with
php that returns the next possible data set. For example I do have the
ID number of a current data set, now I would like to retrieve the next
data set with the next higher ID number. Sometimes there are
Hi all, I have this really strange problem. Apache 2.0.50, MySQL 4.1.4a,
and PHP 5.0.2.
I have about 7000 records in a table called mailinglist, I will show you
the sql to build the table:
CREATE TABLE `mailinglist` (
`id` int(20) NOT NULL auto_increment,
`active` char(1) NOT NULL default '
My guess (and it will be correct) is that you've got a not visible
character on the end of your email address in the database. Such a
character could be a space, newline, tab or other similar character.
Make sure you use trim($email_address) to create the field to insert into
the database !
Ch
Brilliant, nice one. You've just given me the opportunity to run my
counter-spam signup script. I wa swaiting for a good opportunity like this,
as it's a little difficult to test on myself !You have now been
automatically subscribed to 14,500 newsletter distribution lists and
opt-out mailings.
Hie guys,
Does anyone have any idea how I can make my php pages to work with MS SQL
Server..
regards
Noel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
hi,
i am trying to delete an item from inventory
management system done by using php on sqlite...
i had created a button 'delete' and when i submit a
value to be deleted from the table it is giving an error,i think there is some
problem
with delete logic ...
i am attaching the following codes:
hi
i had created an inventory management system..using
php on sqlitei can successfully insert the values
in it..but when i try to delete an item it is giving
me an error...i think there is some logical problem in
delete statement...
can anyone help me in figure out this error..
thanks in adv
what mysql version are you running? versions under 4.1 DON"T support
subqueries
bastien
From: GH <[EMAIL PROTECTED]>
Reply-To: GH <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Problem with an insert query
Date: Sat, 13 Nov 2004 01:29:58 -0500
In my mySQL database I have the followi
Try the manual
www.php.net/mssql
From: "Noel Simela" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] MSSQL Server Integration
Date: Sat, 13 Nov 2004 19:15:48 +0200
Hie guys,
Does anyone have any idea how I can make my php pages to work with MS SQL
Server..
regards
Noel
--
PHP Databa
You also appear to have a quote in the value that contains the word
members'
You will need to escape this or use bind vars.
Simon
On Saturday 13 November 2004 06:29, GH wrote:
> In my mySQL database I have the following tables:
> +-+
>
> | Tables_in_AHRC |
>
> +-+
Explain Bind Vars please... Thanks
On Sat, 13 Nov 2004 19:08:59 +, Simon Rees <[EMAIL PROTECTED]> wrote:
> You also appear to have a quote in the value that contains the word
> members'
> You will need to escape this or use bind vars.
>
> Simon
>
>
>
> On Saturday 13 November 2004 06:29,
Hi guys:
I am a very newby in this php stuff and I need a huge
help from you:
I am looking for the way to make a kind of nested form
(in the sense of the access subforms), to insert
information of a one to many relationaship.
For example, I have to tables:
tblProjects: with information abou
either use a join in the sql syntax to access the data or consider an iframe
bastien
From: Alvaro Cobo <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Nested forms in php (subform)
Date: Sun, 14 Nov 2004 01:35:59 + (GMT)
Hi guys:
I am a very newby in this php stuff and I need a huge
14 matches
Mail list logo