Re: mysql & dreamweaver

[Michael She]

Did you setup MySQL yet?

Can you log into to the mySQL server using your command line utilities?


At 10:40 PM 12/17/2002 -0800, Is98 wrote:

hello, i have access to mysql db i created, using a client app even on a
remote pc (adding tables, fields, values) but when i try to connect with
dreamweaver i get an unknown error, or unexpected. what do i need to do to
us dreamweaver on my development machine to access an mysql db on my server?
i have the pages hosted on my server but when i develop i use my dev
machine,


--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql & dreamweaver

[Is98]

hello, i have access to mysql db i created, using a client app even on a
remote pc (adding tables, fields, values) but when i try to connect with
dreamweaver i get an unknown error, or unexpected. what do i need to do to
us dreamweaver on my development machine to access an mysql db on my server?
i have the pages hosted on my server but when i develop i use my dev
machine,

newbie
charles r



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL, Dreamweaver MX, PHP

[John Chang]

What I am trying to do is on the first webpage. There is a Studio dropdown 
(information from the MySQL database) menu.  When someone picks a studio 
the results go to a different webpage showing just the movies in that 
studio.  How do I get the results onto the second page?

How can I do it in dreamweaver?


This is from the first page that has the dropdown menu.  Is the method=post 
or get?


mysql_select_db($database_videodb, $videodb);
$query_Recordset1 = "SELECT * FROM studios ORDER BY studios.StudioName ASC";
$Recordset1 = mysql_query($query_Recordset1, $videodb) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

mysql_select_db($database_videodb, $videodb);
$query_Recordset2 = "SELECT * FROM titles";
$Recordset2 = mysql_query($query_Recordset2, $videodb) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
?>
"; ?>

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
http://www.w3.org/1999/xhtml";>

Untitled Document






  
>Studios

do {
?>
>

} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
  $rows = mysql_num_rows($Recordset1);
  if($rows > 0) {
  mysql_data_seek($Recordset1, 0);
  $row_Recordset1 = mysql_fetch_assoc($Recordset1);
  }
?>
  




mysql_free_result($Recordset1);

mysql_free_result($Recordset2);
?>



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php