Hi,
It seems as if you use your parameters for check4Entry in the wrong order
when you call it.
In your call you have check4Entry($username, $round, $region); and in your
definition you have
function check4Entry($name, $reg, $rnd). So you might want to switch $region
and $round in yor call.
What about making an array with dates, that you compiled from Year,
Month, Date using mktime(), and sort that?
Edwin
Bill wrote:
I have a query that returns results including the fields Year, Month, and Day
that I want to sort by date.
Because of the nature of the query (it includes a GROUP BY
Where is the $-sign in front of the vars???
Edwin
Jonathan Villa wrote:
Jim,
I don't think that matters. One can escape into PHP in several ways
(depending on the php.ini config of course)
1. ?php
2. ?
3. script language=php
4. %
5. ?= (to echo something right away)
Anyway, I tried that
Hi,
Is there a function to show WHAT fields were changed in the records,
instead of only how many records were changed (with mysql_affected_rows())?
I would like to report to the user which fields were altered, e.g. if he
would change his phone number, to tell him: phone number changed to
Hi,
Does PHP supprots Flash files on Open BSD platform ?
Thanks in advance.
--Rajni
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
on 18/3/03 8:44 am, rajni arya at [EMAIL PROTECTED] wrote:
Does PHP supprots Flash files on Open BSD platform ?
Is that flash as in macromedia? What do you want PHP to do to the files?
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email[EMAIL PROTECTED]
Web
Actually i want to use animated gif file but php doesn't support gif files
so, i thought of replacing it with flash file.
yes, fash is as in macromedia with extenstion of .swf.
if any suggestion or idea...
regards,
rajni
On Tue, 18 Mar 2003, mike karthauser wrote:
on 18/3/03 8:44 am,
on 18/3/03 11:19 am, rajni arya at [EMAIL PROTECTED] wrote:
Actually i want to use animated gif file but php doesn't support gif files
so, i thought of replacing it with flash file.
yes, fash is as in macromedia with extenstion of .swf.
For what though? Are you wanting to create it on the fly
Hi,
This question is not regarding any database. I have one jpeg image on
this image i want to use animated image to point any particular location
this postion coordinate i am getting from database. I am able to do with
normal image but i want to use animated image.
I hope i am clear with
thx folks,
I pretty much thought version 1 to be the best.
I' wouldn't have known how to carry the result to other pages anyway.
Jan
Hi,
I've got a page with lot's of visitors every day and I sure hope to
get more, so I'm already thinking of performance. This is what I've
got.
Users
is there any possibility using PHP 4 to store entire files as a database
field in a MySQL database?
and if so, does anybody know a way, or a tutorial describing this?
thanks
michiel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Without knowing your query, it is hard to say whether mysql can return the results you
want.
However, you can GROUP BY and SORT BY multiple columns in a single query. The
following simple query returns a subset of property owners grouped by lastname,
alpabetized by group, and ordered by
Hi,
I have just found out that I can't use nested queries with MySQL so could
someone tell me how i can transform the following query for use with MySQL?
SELECT * FROM Allocations WHERE (SELECT Project_ID FROM Project WHERE
Project_Name = $_POST[project_name])
thanks for your help
--
PHP
Michiel,
You could try storing them in the longtext (text) or longblob (binary)
fields. Search at www.mysql.com for more information about the differences
between them. Unless you need to search on the data within MySQL, storing
files (especially long ones) in the database usually isn't the
a more prerferable way to do this would be to store a reference to each file
in the database, maybe renaming each file name to the 'files_id' of your
table...
Michiel Van Heusden [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
is there any possibility using PHP 4 to store entire files
Edwin,
There is no $ in front of the vars because it's a constant. $ signifies
a variable. A variable's value can change, a constant's value cannot.
--- Jonathan
-Original Message-
From: Edwin Boersma [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 2:43 AM
To: [EMAIL
Hello again,
Does anyone have suggestions about where I can get an answer to the problems
I'm having with ODBC? I've tried using:
$cursor = odbc_cursor($connection) || die(cannot create cursor);
and get a similar error:
Warning: odbc_cursor(): supplied resource is not a valid ODBC
Use or rather than ||
--- Beverly Steiner [EMAIL PROTECTED] wrote:
Hello again,
Does anyone have suggestions about where I can get an answer to the
problems
I'm having with ODBC? I've tried using:
$cursor = odbc_cursor($connection) || die(cannot create cursor);
and get a similar
Perhaps I'm missing something, but don't you need something to link
the outer query to the nested query? Such as
SELECT * FROM Allocations WHERE Allocations.Project_ID=(SELECT
Project_ID FROM Project WHERE Project_Name = $_POST[project_name])
and if that's the case, can you do a JOIN on
The standard relational way is a relationship table:
children
-
FK_parentID (parent)
FK_childrenID (child)
PRIMARY KEY ( FK_parentID, FK_childrenID )
HTH
Ignatius
- Original Message -
From: Alain Barthélemy [EMAIL PROTECTED]
To: php-db
hello
i have been trying to delete items from a guestbook using multiple checkbox
fields but have had no success
this is the code i have been using to add the checkbox's to the records:
while ($rows = mysql_fetch_array($result)) {
hello
i have been trying to delete items from a guestbook using multiple checkbox
fields but have had no success
this is the code i have been using to add the checkbox's to the records:
while ($rows = mysql_fetch_array($result)) {
hello
i have been trying to delete items from a guestbook using multiple checkbox
fields but have had no success
this is the code i have been using to add the checkbox's to the records:
while ($rows = mysql_fetch_array($result)) {
Hey folks,
Im apologize that this is just a really easy general php question but any help would
be appreciated.
if i have a variable that is = to something like 0 or 1
but I just need it to be 0 or 1. how do i strip the off.
thanks,
Jeremy
try
$with_quote = '0';
$without_quote = str_replace('', '', $with_quote);
Foong
Jeremy [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hey folks,
Im apologize that this is just a really easy general php question but any
help would be appreciated.
if i have a variable that is = to
helo,
make your checkbos name into array:
INPUT TYPE=CHECKBOX NAME=DELETE[?php echo message_id ?] VALUE=Y
you will get an array named DELETE.
check for every element in array DELETE
foreach($_POST['DELETE'] as $message_id = $val) {
if($val ==1) {
// delete record where messahe ID
$str = 'hi';
$newstr = preg_replace(/\/, , $str);
On Wed, 19 Mar 2003, Foong wrote:
try
$with_quote = '0';
$without_quote = str_replace('', '', $with_quote);
Foong
Jeremy [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hey folks,
Im apologize that this is just a really
sure - just pass the mysql query through the mysql_query function.
Make sure you connect using mysql_pconnect() first, then you can start
creating databases..
Luke Woollard
-Original Message-
From: Thomas Tremain [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 19 March 2003 4:36 PM
To:
$str = 'hi';
$newstr = eregi_replace(\, , $str);
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 19 March 2003 4:33 PM
To: Foong
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: Really easy question
$str = 'hi';
$newstr = preg_replace(/\/, , $str);
On
Hello! I have problem with database, where have field with cyrillic char(1). I cant
select by this field, because MySQL dont understand this chars as different.
How can set default charset to win1251 or cp1251? I use MySQL on windows platform.
Thank You!
Hi,
currently I'm working with an Interbase 6.0 database and I want to insert
some text (and eventually a picture) to a blob field. I've found the
following php code:
$bid = ibase_blob_create();
ibase_blob_add($bid, test);
$comments_blob = ibase_blob_close($bid);
$sql = UPDATE tblcontent SET
31 matches
Mail list logo