Converting PostgreSQL into MySQL

[lpxxfaintxx]

Hello,

I am not very familiar with PostgreSQL. I tried to convert the following into MySQL, but failed. Can someone experienced please help me out?

Thanks

<?php
 $connection = pg_pconnect( "dbname=knowledge_base user=kevin host=localhost" );

 if ( ! $connection ) {
 print( "Cannot connect to database" );
 exit;
 }

 $value = "";
 if ( isset( $_POST[ 'category' ] ) ) {
 $value = $_POST[ 'category' ];
 }
 ?>
<script language="JavaScript">
 function resubmit()
 {
 document.myform.action="add_article.php";
 document.myform.submit();
 }
 function process()
 {
 document.myform.action="process.php";
 document.myform.submit();
 }
 </script>
 <b>Add New KB Article</b><br /><br />

 <form name="myform" method="post" action="process.php">
 <input type="hidden" name="action" value="add_article" />

 Category: <select name="category" onChange="resubmit()">
 <?php
 $query_result = pg_exec( $connection, "SELECT * FROM category" );

 for ( $count = 0; $count < pg_numrows( $query_result ); $count++ )
 {
 $category = pg_result( $query_result, $count, 1 );
 if ( $count == 0 )
 {
 $init_cat = $category;
 }
 if ( $category == $value )
 {
 print( "<option selected>$category</option>\n" );
 $selected = $category;
 }
 else
 {
 print( "<option>$category</option>\n" );
 }
 }
 ?>
 </select>

 Sub Category: <select name="subcat">
 <?php
 if ( $value == "" )
 {
 $query_result = pg_exec( $connection,
 "SELECT * FROM sub_category WHERE category = '$init_cat'" );

 for ( $count = 0; $count < pg_numrows( $query_result ); $count++ )
 {
 $subcat = pg_result( $query_result, $count, 3 );
 print( "<option>$subcat</option>\n" );
 }
 } else {
 $query_result = pg_exec( $connection,
 "SELECT * FROM sub_category WHERE category = '$selected'" );

 for ( $count = 0; $count < pg_numrows( $query_result ); $count++ )
 {
 $subcat = pg_result( $query_result, $count, 3 );
 print( "<option>$subcat</option>\n" );
 }
 }
 ?>
 </select>
 <br /><br />
 <!-- OTHER FORM ITEMS HERE -->
 <input type="button" name="post_data" value="Add It!" onClick="process()" />
 </form>
 </body> 

CONVERT ATTEMPT!

<?php
include 'config.php';

 $value = "";
 if ( isset( $_POST[ 'category' ] ) ) {
 $value = $_POST[ 'category' ];
 }
 ?>
<script language="JavaScript">
 function resubmit()
 {
 document.myform.action="submit.php";
 document.myform.submit();
 }
 function process()
 {
 document.myform.action="submit2.php";
 document.myform.submit();
 }
 </script>

 <form name="myform" method="post" action="submit2.php">
 <input type="hidden" name="action" value="add_article" />

 Category: <select name="category" onchange="resubmit()">
 <?php
 $query_result = mysql_query("SELECT * FROM categories");

 for ( $count = 0; $count < numrows( $query_result ); $count++ )
 {
 $category = result( $query_result, $count, 1 );
 if ( $count == 0 )
 {
 $init_cat = $category;
 }
 if ( $category == $value )
 {
 print( "<option selected>$category</option>\n" );
 $selected = $category;
 }
 else
 {
 print( "<option>$category</option>\n" );
 }
 }
 ?>
 </select>

 Sub Category: <select name="subcat">
 <?php
 if ( $value == "" )
{
$query_result = mysql_query("SELECT * FROM subcategories WHERE category = '$init_cat'" );

 for ( $count = 0; $count < numrows( $query_result ); $count++ )
 {
 $subcat = result( $query_result, $count, 3 );
 print( "<option>$subcat</option>\n" );
 }
 } else {
 $query_result = mysql_query("SELECT * FROM subcategories WHERE categories = '$selected'" );

 for ( $count = 0; $count < pg_numrows( $query_result ); $count++ )
 {
 $subcat = pg_result( $query_result, $count, 3 );
 print( "<option>$subcat</option>\n" );
 }
 }
 ?>
 </select>
 <br /><br />
 <input type="button" name="post_data" value="Add It!" onclick="process()" />

[kakki]

maybe this?

<?php
 $connection = mysql_pconnect( "" );

 if ( ! $connection ) {
 print( "Cannot connect to database" );
 exit;
 }

 $value = "";
 if ( isset( $_POST[ 'category' ] ) ) {
 $value = $_POST[ 'category' ];
 }
 ?>
<script language="JavaScript">
 function resubmit()
 {
 document.myform.action="add_article.php";
 document.myform.submit();
 }
 function process()
 {
 document.myform.action="process.php";
 document.myform.submit();
 }
 </script>
 <b>Add New KB Article</b><br /><br />

 <form name="myform" method="post" action="process.php">
 <input type="hidden" name="action" value="add_article" />

 Category: <select name="category" onChange="resubmit()">
 <?php
 $query_result = mysql_exec( $connection, "SELECT * FROM category" );

 while( $line=mysql_fetch_array( $query_result ) )
 {
 $category = $line[ 'category_name' ]; /// whatever the db is called
 if ( $count == 0 )
 {
 $init_cat = $category;
 }
 if ( $category == $value )
 {
 print( "<option selected>$category</option>\n" );
 $selected = $category;
 }
 else
 {
 print( "<option>$category</option>\n" );
 }
 }
 ?>
 </select>

 Sub Category: <select name="subcat">
 <?php
 if ( $value == "" )
 {
 $query_result = mysql_exec( "SELECT * FROM sub_category WHERE category = '$init_cat'" );

 while( $line=mysql_fetch_array( $query_result ) )
 {
 $subcat = $line[ 'category_name' ]; /// whatever the db is called
 print( "<option>$subcat</option>\n" );
 }
 } else {
 $query_result = mysql_exec( "SELECT * FROM sub_category WHERE category = '$selected'" );

while( $line=mysql_fetch_array( $query_result ) )
 {
 $subcat = $line[ 'category_name' ]; /// whatever the db is called
 print( "<option>$subcat</option>\n" );
 }
 }
 ?>
 </select>
 <br /><br />
 <!-- OTHER FORM ITEMS HERE -->
 <input type="button" name="post_data" value="Add It!" onClick="process()" />
 </form>
 </body>