[PHP-DB] MYSQL DIAGRAM

2001-10-27 Thread pierre . marcandella
Hi everybody, I am looking for scripts able to build diagram of a database (diagram such as the ones made on SQL server). For the ones not familiar with SQL server, it should be a script able to : - collect the data of the structure of a database (names of the tables and of their fields)(php

[PHP-DB] HELP PLEASE!! Get query error when inserting into MySql

2001-10-27 Thread Robby Whiteside
Hi There, I have a query whenever I try to insert something into a mysql table. This is the code I am using: " . mysql_error()); mysql_close(); ?> Thanks, Robby - This message was sent using Endymion MailMan. http://www.endymion.com/products/mailman

Re: [PHP-DB] HELP PLEASE!! Get query error when inserting into MySql

2001-10-27 Thread DL Neil
> I have a query whenever I try to insert something into a mysql table. This is > the code I am using: > > $host1 = gethostbyaddr("$REMOTE_ADDR"); > $date = date("Y-m-d h:i:s"); > $link = mysql_connect("$host", "$user", "$passwd"); > mysql_select_db("$database", $link); > $sql = "INSERT INTO vcst

Re: [PHP-DB] Using MS SQL via FreeTDS with PHP 4.0.6

2001-10-27 Thread indrek siitan
Hi, > I've read the bug report regarding the -lsybtcl errors (as I got > them myself, and did a search through the mailing lists). There's > a patch available for php 4.0.3pl1, however I'm looking for one > that patches php 4.0.6. Is there any out there? Or can I use > the patch for 4.0.3pl1 w

[PHP-DB] PHP

2001-10-27 Thread GEORGINA ELAINE BAILEY
Ok, I have a HTML form, where I can select a module type and a keyword. I then submit this and want a table return with all the projects that fulfil that criteria. However, instead of returning all the projects that fulfil the criteria, it only returns the first one I entered. It doesn't seem to b

[PHP-DB] Oracle developer on linux

2001-10-27 Thread Pedro M. S. Oliveira
Hello all, I'm just sending this email to know if anyone is/was using the Linux oracle developer, if so can you please tell me what is your version and the some of the machine characteristics where it runs. This hell will be much appreciated thanks Pedro ***

[PHP-DB] php command to create table

2001-10-27 Thread Saulius Jankauskas
subj. Plz help. THanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] PHP

2001-10-27 Thread DL Neil
Bring the table processing 'loop' into line with the recordset processing 'loop'. =dn - Original Message - From: "GEORGINA ELAINE BAILEY" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 27 October 2001 15:28 Subject: [PHP-DB] PHP > Ok, I have a HTML form, where I can select a module

[PHP-DB] Application variables

2001-10-27 Thread sharmad
Pls tell me how to implement application variables in PHP like they are supported in ASP else i might have to have the value stored in the database and update every now and then which is simply an overhead. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECT

[PHP-DB] Help in passing multiple HTML form options to SQL query <-- Newbie

2001-10-27 Thread TorrentUK
I am designing a ski web site and am presently trying to put together a resort database. I started the search script tonight and am quite pleased that it works. Where I am struggling is that I would like my visitors to be able to select multiple countries from the drop down list and for my query

Re: [PHP-DB] Help in passing multiple HTML form options to SQL query <-- Newbie

2001-10-27 Thread Richard Chauvaux
first, the select tag in your form should be setup as an array: then the array $country[] will be available to your script on submittal. a simple way to build your sql where clause would be to iterate through the array using a subscript variable: $sql = "select * from tbl where ctry='$country[0]