hi guys,
i wanna make a news letter as follows:
i sell items within certain categories,so whenever a buyer is registered he choose
some categories to contribute to my newsletter with:
whenever a new item is added within this category i send him an email with that.
i'm storing the mails in da
hi, is here anyone how haves a solution for following problem:
$SQL = "select * from [ReferencesComplete]";
$result = mssql_query($SQL,$IDconnection); // this simple code let crash the
php.exe...
i've with a mysql no problems with this code but with MS-SQL comes this
error!!
i hope someone has
Hi Alex,
You seem to be struggling with both MySQL and PHP at the same time! Must
be generating high frustration levels. Have you got yourself a
tutorial/book to work from?
I'll go with Mike's suggestion, although I'd go for a 'one stop shop' in
MySQL - as long as we get the required result it's
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 'music_alb
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: http://www.php.net/manual/en/func
I have the following to pages( just testing them at the moment ):
";
$getlist = mysql_query("SELECT * FROM music_artist ORDER BY
artist_name ASC");
echo " Artist Name : \n";
while ($row = mysql_fetch_array($getlist)) {
echo ''.$row["artist_name"]."\n";
}
echo " \n";
echo "Album Name : ";
echo
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 messag
>
> 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
> exe
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 will
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
d
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( mysql_e
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,
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 [mailto:[EMA
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
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 li
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
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 d
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" ar
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 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
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 WHERE date >= datevar (variable with current da
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 quer
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:
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 possib
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
//
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 u
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, ma
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 br
28 matches
Mail list logo