On 22 September 2004 18:45, Stuart Felenstein wrote:
Just to confirm,
This is what I'm going to start with:
Yeah, I'd say you've pretty much got it, except...
//base sql statement
$sql = select * from jobs where record_deleted = 'NO' ;
if (isset($_POST['states'])){
Your SQL is going to
On 23 September 2004 07:47, Ed Lazor wrote:
I keep looking at the following code and thinking there's
gotta be a better
way. I've been in front of the computer all day tho and I'm drawing
a blank. Any ideas?
Seems to me we've just answered a very similar question to this (and I'd be
On 22 September 2004 18:45, Stuart Felenstein wrote:
Given the conditions you want your WHERE phrase to test, you're going to
need more parentheses to force the ORs to be evaluated before the ANDs;
this is where the IN syntax, IMO, is more readable. So you want either:
$sql .=
Or you could use a more flexible way, allowing you to easily add other
filters to the query.
$sql = select ID from products;
if ($webpage-parameter_isset(CategoryID))
$sql = addFilter($sql,CategoryID,$webpage-CategoryID);
if ($webpage-parameter_isset(CompanyID))
$sql =
Hello,
On 09/23/2004 03:46 AM, Ed Lazor wrote:
I keep looking at the following code and thinking there's gotta be a better
way. I've been in front of the computer all day tho and I'm drawing a
blank. Any ideas?
You may want to consider a Data Access Objects (DAO) class generator.
DAO classes
I've looked around for a while, does anyone know of a PHP function
already built in to the install that gets the Mime type of a file on
the server?
thanks,
--
Jasper Howard - Database Administration
ApexEleven.com
530 559 0107
I've looked around for a while, does anyone know of a PHP function
already built in to the install that gets the Mime type of a file on
the server?
you might try this
http://pear.php.net/package/MIME_Type/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
cool, that's what I was looking at doing, I was just wondering if
there was anything native to php 4.3.8.
On Thu, 23 Sep 2004 11:59:41 -0500, Matt M. [EMAIL PROTECTED] wrote:
I've looked around for a while, does anyone know of a PHP function
already built in to the install that gets the Mime
-Original Message-
Seems to me we've just answered a very similar question to this (and I'd
be
surprised it there weren't several relevant threads in the list archives).
Nonetheless:
I was so tired last night that I don't even remember if I checked the
archives first - my bad.
Hi,
I am trying to get skilled up on postgres and decided to port a little
movie database I wrote for mysql with php to access it.
I used an auto converter for the bulk and then tried to tweak. The
following code does not work but the error message it gives me is
strange. It tells me that the
Could be a scope problem. The connection is declared outside the function
and the attempt to run a query is inside the function...Maybe add the global
command to the connection. Or declare the connection inside the function...
Bastien
From: Antoine [EMAIL PROTECTED]
Reply-To: Antoine [EMAIL
Its because the function cannot access your connection object...
Try passing it to the function..
function makelistboxentries($link, $title, $mytable, $mycolumn, $othertable,
$wherestring)
On Thu, 23 Sep 2004 19:44:51 +0200, Antoine [EMAIL PROTECTED] wrote:
Hi,
I am trying to get skilled up
define the connection object as a global var in ur function
function ( params)
{
global $ur_connection_obj;
...
...
}
On Thu, 23 Sep 2004 14:56:10 -0300, Eduardo Sampaio [EMAIL PROTECTED] wrote:
Its because the function cannot access your connection object...
Try passing it to the
On Thu, 23 Sep 2004 22:27:38 +0400, M Saleh EG [EMAIL PROTECTED] wrote:
define the connection object as a global var in ur function
function ( params)
{
global $ur_connection_obj;
...
...
Damn you guys are quick! I like this list...
declaring it as global didn't seem to work -
global
On Thu, 23 Sep 2004 20:51:52 +0200, Antoine [EMAIL PROTECTED] wrote:
declaring it as global didn't seem to work -
global $link;
/* Connect to database */
$link = pg_connect(dbname=movies host=localhost user=anton
password=password)
The global keyword works a little bit differently
Well don't hate me for coming back here. I am shamed
and embarassed enough.
And while I appreciate all the great code and feedback
received , I've run into a glitch.
(oi) Because I'm using CodeCharge, it's not easy to
just insert custom code anywhere. That is one of
those code generators. I
On Thu, 23 Sep 2004 12:23:32 -0700, Andrew Kreps [EMAIL PROTECTED] wrote:
On Thu, 23 Sep 2004 20:51:52 +0200, Antoine [EMAIL PROTECTED] wrote:
declaring it as global didn't seem to work -
global $link;
/* Connect to database */
$link = pg_connect(dbname=movies host=localhost
Robert Twitty wrote:
Is there anyone here can tell me how to access Matisse DB? Thank you.
Isn't there anyone can help me?
Look at http://www.matisse.com/pdf/developers/php.pdf
I found it by Googling for Matisse PHP
I have. But it doesn't help much. Thanks anyway.
--
PHP Database Mailing List
I was wondering if anyone wants to help me with this project.
I already have a test database we can use, I just need help making the team
pages.
please take a look and reply if interested.
thanks in advance
I'm a noobie in regards of php but I am trying to learn.
19 matches
Mail list logo