Re: [PHP-DB] PHP + Interbase / Firebird extensions

Dear Andrew You can download the source from: http://packages.debian.org/unstable/web/php4-interbase.html Cheers Tibor - Original Message - From: "Andrew Neillans" <[EMAIL PROTECTED]> To: "'Koleszár Tibor'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, March 08, 2003 4:41

[PHP-DB] table relationship

Hi, I am creating a web site which will have different types of users: Administrators, clients and staff. Is it possible/good practice to have 3 tables related to one table i.e. USER user_id (PK) |

[PHP-DB] content management

I would really appreciate some advice from anyone who has worked with or developed their own content management system. This is my scenario, when i have finished creating a site, i want to be able to add in the CMS with a minimum amount of fuss. I want to be able to get the CMS to recognize all th

Fwd: Re: [PHP-DB] need help with foreach()

Here is the complete function I am using. I returned, for testing i commented out the foreach loop and returned $staff, then $tips both arrays returned NULL when i did a var_dump(pointvalue($startdate)); can anyone see how this could be solved? Cheers, dave =

Re: [PHP-DB] table relationship

Yes. You have to use the "subtype" relational design: USER user_id (PK) | | | || | |

Re: Fwd: Re: [PHP-DB] need help with foreach()

On Monday 10 March 2003 17:56, David Rice wrote: > Here is the complete function I am using. > I returned, for testing i commented out the foreach loop and returned > $staff, then $tips both arrays returned NULL when i did a > var_dump(pointvalue($startdate)); I haven't been following this thr

RE: [PHP-DB] Passing value in URL to Form

If I understand your question correctly, you are interested in finding a way to pull values from the URL and insert them into a form using just HTML, no PHP. Going on that assumption, I'm pretty sure the answer is no. I think the only way you can pull that off is with SOME kind of scripting langua

[PHP-DB] Help with file upload

I am trying to upload a file but the problem i am having is that i get no value if i used $HTTP_POST_FILES['userfile']['name'] i have my register globals on and everything but i just can't see what am i doing wrong. here is my code: /* -$dir = ".\Apache\htdoc\ "; -$dir .= $_POST['img1'];

Re: [PHP-DB] table relationship

Three tables seems wasteful, and could mean that you have to do three queries when looking for someone. Why not approach it this way. Users table - info on all users, regardless of category Levels table - sets different access levels, e.g. clients, staff, administrators User_levels table - ass

[PHP-DB] Re:PHP + Interbase / Firebird extensions

Any idea where I can download the interbase module?? Here : -- Philippe Makowski Firebird serveur SQL open-source en français http://firebird-fr.eu.org Ma clé PGP : http://makowski.eu.org/pgpkey.html -- PHP Database Mailing List

[PHP-DB] Database design

Hi, I am creating a database for a web application. The idea for the application is for a company administrator to be able to log into the site and allocate staff to a project which will be a clinical trial at a particular practice. Staff will be able to log in and update the status of the project

[PHP-DB] Prepare Sql statement

Hi: I am working with php 4.1.1, in a linux i386. How i prepare a sql statement with odbc_prepare ? How create parameters for a sql, to use in odbc_execute ? Alejandro Michelin Salomon PROBrax e-Tech, Brasil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

[PHP-DB] Query Help...

I am having a lot of trouble with a query that works fine from a basic SQL command line, but fails in my web script. Here is the portion of code including the query: mysql_select_db($database, $Prod); $query_groups = "SELECT name FROM group"; $groups = mysql_query($query_groups, $Prod) or

RE: [PHP-DB] Query Help...

Scott, 'Group' is a reserved word so you can't use it for a column name. try changing it to 'groups' or soething else that makes sense but is safe. George > -Original Message- > From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] > Sent: 10 March 2003 5:24 pm > To: '[EMAIL PROTECTED]'

Re: [PHP-DB] Query Help...

- Original Message - From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 10, 2003 9:23 AM Subject: [PHP-DB] Query Help... > I am having a lot of trouble with a query that works fine from a > basic SQL command line, but fails in my web script. Her

RE: [PHP-DB] Query Help...

Thanks for all the advice, I thought it might have something to do with being a reserved word. I changed the table name from group to grps, and everything works fine now. -Original Message- From: Rob Bryant [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 11:39 AM To: [EMAIL

[PHP-DB] adding to an array variable using a loop...?

I want to create an array from results returned from a mysql query. I want it to go through each row in the returned result, and if the variable in the array staff exists add 1 to the total, if it doesnt exist, set it as one and carry on. But when i run this and do var_dump, it just returns "1"

RE: [PHP-DB] Database design

Shaun, I took a quick look at your database layout and noticed that Practice_ID and Clinical_Trial_ID are repeated in the Booking table. This isn't necessary because the Booking table links to the Project table which contains this information. In the Project table, Practice_ID and Clinical_Trial

[PHP-DB] Date in a dropbox box

Hi there everyone, I have a form which displays 3 dropdowns, day, month and year, I have it displaying the default of the dropdown for month no problem, but how can I get it to select the current date (day) in the dropdown, but show 31 days nomatter how many days are in the month? This is impo

RE: [PHP-DB] Date in a dropbox box

> I have a form which displays 3 dropdowns, day, month and year, I have it > displaying the default of the dropdown for month no problem, but how can I > get it to select the current date (day) in the dropdown, but show 31 days > nomatter how many days are in the month? This is important even thou

Re: [PHP-DB] Date in a dropbox box

Hi there, Thank you John, you are a lifesaver :-) Chris > > I have a form which displays 3 dropdowns, day, month and year, I have > it > > displaying the default of the dropdown for month no problem, but how > can I > > get it to select the current date (day) in the dropdown, but show 31 > days

[PHP-DB] Re: adding to an array variable using a loop...?

I assume the field 'date' in your database is a date field, and in your code you are trying to do a date + 1, but you are not specifying *what* you are adding to the date (ie. 1 day, 1 week, 1 month), therefore the whole variable is being replaced (with a 1). Try looking at the various date functio

[PHP-DB] Picture Upload

Is there a possibility that you can resize an image before uploading to the server? If so, how? Thanks, Dallas Freeman

RE: [PHP-DB] Picture Upload

use the GD Library functions - look up on php.net The GD library is available from http://www.boutell.com/ It is included by default with PHP 4.3.x NOTE: This is a question for [EMAIL PROTECTED] -Original Message- From: Dallas Freeman [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 March 20

[PHP-DB] Output a few tupels of 493033 tupels

Hello, I have got a little problem with my datas. In one table I have got 493033 tupels. A simple Output of all datas is to much for the Browsers (and the intranet-connection) and to ask for all and then only give out a few is also a big problem for the server. Is there any way only to ask for

[PHP-DB] Re: Cannot connect PostgreSQL 7.3.1. Using PHP thru...

-BEGIN PGP SIGNED MESSAGE- I think the problem is the username. you have a user "administrator"? At postresql the administratzor is the user postgres. Perhaps you try first with 'reateuser' to create a new user, peraps with all rights, and then you can try to connect with this usernam