[PHP-DB] MYSQL DIAGRAM

[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)(phpMyAdmin is fine for that).
- build a diagram showing the structure and the links between the different 
tables (it could be according to a Foreign Key fields naming policy).

Does anyone know such kind of script ?

I think it would be usefull to include such diagram in the documentation of a 
developpement.

Thanks.

Pierre

-- 
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]

[PHP-DB] Oracle developer on linux

[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



***
Pedro Miguel Silva Oliveira
Cell Phone: +351 96 5867227
SMS: [EMAIL PROTECTED]
Email: [EMAIL PROTECTED]



-- 
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]

[PHP-DB] Application variables

[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 PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

[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
to pull back info on all those selected. When I try it it only pulls back
the last one (naturally).

Please advise on what would be the most efficient way of constructing the
query. Please talk in easy speak as I am real new at this and am not a
developer by any stretch of the imagination.

Many Thanks
Torrent

Here is a cut down version of my code, the html form is at the bottom.

?php

if ($search) {

 $sql = SELECT rst_name, cty_name FROM resort_tbl WHERE
cty_name='$country';

 $result = mysql_query($sql);

 if ($row = mysql_fetch_array($result)) {
  echo centertable border=1\n;
echo trtdName/tdtdCountry/td/tr\n;

  do {
 printf(trtd%s/tdtd%s/td\n, $row[rst_name],
$row[cty_name]);
 } while ($myrow = mysql_fetch_array($result));
  echo /table/center\n;
 }
}

?

form name=resort method=post action=?php echo $PHP_SELF?
 p Select country /fontbr
select name=Country size=5 multiple
  option value=AndorraAndorra/option
  option value=AustriaAustria/option
  option value=BulgariaBulgaria/option
  option value=FinlandFinland/option
  option value=FranceFrance/option
  option value=ItalyItaly/option
  option value=North AmericaNorth America/option
  option value=NorwayNorway/option
  option value=RomaniaRomania/option
  option value=SloveniaSlovenia/option
  option value=SpainSpain/option
  option value=SwedenSweden/option
  option value=SwitzerlandSwitzerland/option
/select
br
   input type=submit name=search value=Search
  /p
/form



-- 
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]