SV: [PHP-DB] User Defined Function Problem

2003-03-18 Thread Henrik Hornemann
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.

[PHP-DB] Re: sorting results in PHP

2003-03-18 Thread Edwin Boersma
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

Re: [PHP-DB] Define()

2003-03-18 Thread Edwin Boersma
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

[PHP-DB] mysql_affected_rows() question: what was changed?

2003-03-18 Thread Edwin Boersma
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

[PHP-DB] Does Php support Flash files ?

2003-03-18 Thread rajni arya
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

Re: [PHP-DB] Does Php support Flash files ?

2003-03-18 Thread mike karthauser
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

Re: [PHP-DB] Does Php support Flash files ?

2003-03-18 Thread rajni arya
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,

Re: [PHP-DB] Does Php support Flash files ?

2003-03-18 Thread mike karthauser
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

Re: [PHP-DB] Does Php support Flash files ?

2003-03-18 Thread rajni arya
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

AW: [PHP-DB] Performance in MySQL Result Question

2003-03-18 Thread Jan Bro
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

[PHP-DB] storing files in database

2003-03-18 Thread Michiel van Heusden
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

Re: [PHP-DB] Re: sorting results in PHP

2003-03-18 Thread Doug Thompson
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

[PHP-DB] Nested MySQL Query

2003-03-18 Thread shaun
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

RE: [PHP-DB] storing files in database

2003-03-18 Thread Beverly Steiner
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

[PHP-DB] Re: storing files in database

2003-03-18 Thread shaun
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

RE: [PHP-DB] Define()

2003-03-18 Thread Jonathan Villa
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

FW: [PHP-DB] problem connecting w/ODBC

2003-03-18 Thread Beverly Steiner
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

Re: FW: [PHP-DB] problem connecting w/ODBC

2003-03-18 Thread Mark
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

Re: [PHP-DB] Nested MySQL Query

2003-03-18 Thread Mark
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

Re: [PHP-DB] several pointers to records in one field

2003-03-18 Thread Ignatius Reilly
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

[PHP-DB] using checkbox in php to delete

2003-03-18 Thread Mark
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)) {

[PHP-DB] deleting multiple records using a checkbox

2003-03-18 Thread Mark
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)) {

[PHP-DB] deleting records using a checkbox

2003-03-18 Thread Mark
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)) {

[PHP-DB] Really easy question

2003-03-18 Thread Jeremy
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

[PHP-DB] Re: Really easy question

2003-03-18 Thread Foong
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

[PHP-DB] Re: deleting records using a checkbox

2003-03-18 Thread Foong
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

Re: [PHP-DB] Re: Really easy question

2003-03-18 Thread Peter Beckman
$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

RE: [PHP-DB] Creating mySQL database

2003-03-18 Thread Luke Woollard
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:

RE: [PHP-DB] Re: Really easy question

2003-03-18 Thread Luke Woollard
$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

[PHP-DB] MySQL and Cyrillic

2003-03-18 Thread Nikolay Nikolov
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!

[PHP-DB] Problem retrieving/updating data from InterBase

2003-03-18 Thread Vincent Verhoeven
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