PHP - Help Integrating Php, Mysql And Javascript

Hello everybody, I have found a lot of amazing advises and codes to improve on my existing codes. It seems to be an awesome site. I actually came from a background of Application programming, however I have just recently pick up a project in php. The project is about database integration, where I have to integrate 5 supplier's existing data who have different attributes into one. (each suppliers have about 30k data)  I really need help and advises on how should I do the script.

Here's the details, All the suppliers uses different data file, such as CSV and .xls. I am finding a way to integrate all the 5 files into one database(mysql/phpmyadmin) so it could be listed out in a shopping cart or catalog in future. However, I am unfamiliar with php, so please advice on how can i go about fixing this problem. The first problem is that each individual suppliers uses a different attributes name, for example

Supplier 1 uses : SupplierName, SupplierID, SupplierAddress, Status

Inside the status, the supplier uses data such as, Good, Excellent, Great

while Supplier 2 uses : SName, SID, SAddress, Status
and inside this supplier, the status data that are being uses is G, Ex, Gr.

How can I set a consistancy on the data and converting all the properties into one so I can import this data into a proper database such as mysql/phpmyadmin. Please help, thanks in advance

I am taking a form that has been created and now trying to incorporate it into WP. The form is filled out multiple times per session. The form when filled out will generate an ID that is used to track the form submissions until completed. The problem that I'm running into is that the code is using a URL structure that breaks on the install. I'm not sure what to tell the code to look for as the URL. I hope I'm making sense. This is my first dive into WP dev. Thanks for the help.

<?php
/*
Template Name: Form
*/
?>
<?php
/**
 * The template for displaying all pages
 *
 * This is the template that displays all pages by default.
 * Please note that this is the WordPress construct of pages and that
 * other 'pages' on your WordPress site will use a different template.
 *
 * @package WordPress
 * @subpackage Twenty_Thirteen
 * @since Twenty Thirteen 1.0
 */

get_header(); ?>

<div id="main-content" class="main-content">

  <div id="headertitle">
    <h1>Steam Trap Form Input</h1>
  </div>
  <div id="formtable">
    <form class="form-horizontal" role="form" action="/test/FormHandler.php" method="post">
    <fieldset>
      <div class="form-group">
          <label for="dateSurvey" class="col-sm-2 control-label">Survey Date</label>
          <div class="col-sm-6">
          	<input type="text"<? echo (isset($sd['date']) ? ' value="'.format_date($sd['date']).'"' : '') ?> class="form-control col-sm-6 input-append date" id="dp1" name="dateSurvey" data-date="02-12-2014" data-date-format="mm-dd-yyyy">
          </div>
      </div>

	  <div class="form-group">
          <label for="plantName" class="col-sm-2 control-label">Plant Name</label>
          <div class="col-sm-6">
          	<input type="text" class="form-control col-sm-6" name="plantName"<? echo (isset($sd['plant_name']) ? ' value="'.$sd['plant_name'].'"' : '') ?>>
		  </div>
	  </div>

        <div class="form-group">
          <label for="plantLoc" class="col-sm-2 control-label">Plant Location</label>
          <div class="col-sm-6">
          	<input type="text" class="form-control col-sm-6" name="plantLoc"<? echo (isset($sd['plant_location']) ? ' value="'.$sd['plant_location'].'"' : '') ?>>
		  </div>
        </div>

        <div class="form-group">
          <label for="plantContact" class="col-sm-2 control-label">Plant Contact Name</label>
          <div class="col-sm-6">
          	<input type="text" class="form-control col-sm-6" name="plantContact"<? echo (isset($sd['plant_contact_name']) ? ' value="'.$sd['plant_contact_name'].'"' : '') ?>>
		  </div>
        </div>
        <div class="form-group">
        	<label for="pph" class="col-sm-2 control-label">Pound Per Hour</label>
        	<div class="col-sm-6">
        		<input type="text" class="form-control col-sm-6" name="pph" placeholder="XX.XX"<? echo (isset($sd['pph']) ? ' value="'.$sd['pph'].'"' : '') ?>>
        	</div>
        </div>
        <div class="form-group">
          <label for="area" class="col-sm-2 control-label">Area</label>
          <div class="col-sm-6">
            <input type="text" class="form-control col-sm-6" name="area" placeholder="Boiler Room"<? echo (isset($sd['area']) ? ' value="'.$sd['area'].'"' : '') ?>>
          </div>
        </div>
        <hr>

         <div class="form-group">
          <label for="testDate" class="col-sm-2 control-label">Tested Date</label>
          <div class="col-sm-6">
          <input type="text" class="form-control col-sm-6 input-append date" id="dp2" name="testDate" data-date="02-12-2014" data-date-format="mm-dd-yyyy">
        </div>
         </div>

		<!-- <div class="form-group">
          <label for="direction" class="col-sm-2 control-label">Direction</label>
          <div class="col-sm-6">
          <select class="form-control col-sm-6" name="direction">
            <option value="N">N</option>
            <option value="NE">NE</option>
            <option value="NW">NW</option>
            <option value="S">S</option>
            <option value="SE">SE</option>
            <option value="SW">SW</option>
            <option value="E">E</option>
            <option value="W">W</option>
          </select>
		  </div>
		</div> -->

        <div class="form-group">
          <label for="location" class="col-sm-2 control-label">Location</label>
          <div class="col-sm-6">
          	<input type="text" class="form-control col-sm-6" name="location" placeholder=" 'Detailed as possible'">
		  </div>
        </div>

        <div class="form-group">
          <label for="flrLevel" class="col-sm-2 control-label">Floor Level</label>
          <div class="col-sm-6">
          	<select class="form-control col-sm-6" name="flrLevel">
           	 <option value="GROUND">Ground</option>
		   	 <option value="1st">1st</option>
		   	 <option value="2nd">2nd</option>
		   	 <option value="3rd">3rd</option>
		   	 <option value="4th">4th</option>
		   	 <option value="5th">5th</option>
		   	 <option value="6th">6th</option>
		   	 <option value="7th">7th</option>
		   	 <option value="8th">8th</option>
		   	 <option value="9th">9th</option>
		   	 <option value="10th">10th</option>
		   	 <option value="11th">11th</option>
		   	 <option value="12th">12th</option>
		   	 <option value="13th">13th</option>
		   	 <option value="14th">14th</option>
		   	 <option value="15th">15th</option>
		   	</select>
          </div>
        </div>

        <div class="form-group">
          <label for="elevation" class="col-sm-2 control-label">Elevation</label>
          <div class="col-sm-6">
          	<input type="number" class="form-control col-sm-6" name="elevation" placeholder="in feet">
		  </div>
        </div>

        <div class="form-group">
          <label for="tagNum" class="col-sm-2 control-label">Tag Number</label>
          <div class="col-sm-6">
          	<input type="text" class="form-control col-sm-6" name="tagNum">
		  </div>
        </div>

		<div class="form-group">
		<label for="manufacturer" class="col-sm-2 control-label">Manufacturer</label>
          <? /* <input type="text" name="mmn" size="30"> */ ?>
          <div class="col-sm-6">
          <select name="manufacturer" class="depend col-sm-6 form-control" id="manufacturer">
            <option value="" selected="selected" disabled="disabled">Select Manufacturer</option>
          </select>
          </div>
          <div id="status"></div>
		</div>

        <div class="form-group">
          <label for="model" class="col-sm-2 control-label">Model Number</label>
          <div class="col-sm-6">
          <select name="model" class="depend col-sm-6 form-control" id="model">
            <option value="" selected="selected">Select value</option>
          </select>
        </div>
        </div>

        <div class="form-group">
          <label for="size" class="col-sm-2 control-label">Size</label>
          <div class="col-sm-6">
          <select name="size" class="depend col-sm-6 form-control" id="size">
            <option value="" selected="selected">Select value</option>
          </select>
        </div>
        </div>

        <div class="form-group">
          <label for="pressure" class="col-sm-2 control-label">Pressure</label>
          <div class="col-sm-6">
          <select name="pressure" id="pressure" class="col-sm-6 form-control">
            <option value="" selected="selected">Select value</option>
          </select>
        </div>
        </div>

        <div class="form-group">
          <label for="service" class="col-sm-2 control-label">Service</label>
          <div class="col-sm-6">
          <select class="form-control col-sm-6" name="service" name="service">
          	<option value="TRACER">TRACER</option>
          	<option value="HEATER">HEATER</option>
          	<option value="PROCESS">PROCESS</option>
          	<option value="DRIP">DRIP</option>
          </select>
        </div>
        </div>

        <div class="form-group">
          <label for="trapCond" class="col-sm-2 control-label">Trap Conditions</label>
          <div class="col-sm-6">
          <select class="form-control col-sm-6" name="trapCond">
          <option value="OK">OK</option>
          <option value="BT">BT</option>
          <option value="CP">CP</option>
          <option value="VO">VO</option>
          <option value="RCL">RCL</option>
         </select>
        </div>
        </div>

          <p></p>
        <div class="form-group">
        <div class="col-sm-offset-2 col-sm-6">
          <? if(isset($surveyID)) { echo '<input type="hidden" name="surveyID" value="'.intval($_GET['survey']).'">'; } ?>
          <!-- <? if(isset($areaID)) { echo '<input type="hidden" name="areaID" value="'.intval($_GET['area']).'">'; } ?>
          -->
          <button class="btn btn-default btn-lg" type="submit" name="submit" value="add">Add Trap</button>
           
          <button class="btn btn-primary btn-lg" type="submit" name="submit" value="add_area">Submit Area</button>
          
          <button class="btn btn-danger btn-lg" type="submit" name="submit" value="submit">Submit Survey</button>
        </div>
        </div>
      </fieldset>
    </form>
    </div>
 <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
 	<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
 	<script src="//ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
    <!-- Include all compiled plugins (below), or include individual files as needed -->
	<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
   <!-- <script src="../script/js/script.js"></script> -->
    <script src="../script/js/live.js"></script>
    <script src="../script/js/bootstrap-datepicker.js"></script>
    <script type="text/javascript">

jQuery(document).ready(function() {
    jQuery('#dp1').datepicker({
        dateFormat : 'dd-mm-yy'
    });
});

jQuery(document).ready(function() {
    jQuery('#dp2').datepicker({
        dateFormat : 'dd-mm-yy'
    });
});

</script>
  </body>
</html>
		<!-- #content -->
	</div><!-- #primary -->
	<?php get_sidebar( 'content' ); ?>
</div><!-- #main-content -->

<?php
get_sidebar();
get_footer();
?>

<?php require("../test/base.php");

if(isset($_POST['submit']))
{
$url = '../test/form'; // path to form.php

if(!isset($_POST['manufacturer'])) { $_POST['manufacturer'] = NULL; }
if(!isset($_POST['model_number'])) { $_POST['model_number'] = NULL; }
if(!isset($_POST['size'])) { $_POST['size'] = NULL; }
if(!isset($_POST['pressure'])) { $_POST['pressure'] = NULL; }
$data = prep($_POST);

if($data['submit'] == 'add')
{
    if(!isset($data['surveyID'])) {
        $surveyID = save_survey($data);
    }
    else { $surveyID = $data['surveyID']; }

    save_survey_details($surveyID, $data);
    if($surveyID) { header('Location: '.$url.'?survey='.$surveyID); }

}

if($data['submit'] == 'add_area')
{
    if(!isset($data['areaID'])) {
        $areaID = save_survey($data);
    }
    else { $areaID = $data['areaID']; }

    save_survey_details($areaID, $data);
    if($areaID) { header('Location: '.$url.'?survey='.$areaID); }

}
elseif($data['submit'] == 'submit')
{
    if(isset($data['surveyID'])) {
        save_survey_details($data['surveyID'], $data);
    }
    else {
        $surveyID = save_survey($data);
        save_survey_details($surveyID, $data);
    }
    header('Location: '.$url);
}
}

function prep($input) {
$data = array();
if(is_array($input)) {
    foreach ($input as $key => $val) {
        $data[$key] = mysql_real_escape_string($val);
    }
}
return $data;
}

function format_date($date = '') {
if(isset($date) && $date) {
    $tmp = explode('-', $date);
    $d = $tmp[2].'-'.$tmp[0].'-'.$tmp[1];
}
else { $d = NULL; }
return $d;
}

function save_survey($data) {
$result = mysql_query("INSERT INTO surveys (date, plant_name, plant_location,       plant_contact_name, pph, area)
VALUES('".format_date($data['dateSurvey'])."','".$data['plantName']."','".$data['plantLoc']."','".$data['plantContact']."','".$data['pph']."','".$data['area']."')") or die('Error: ' . mysql_error());
$result = mysql_query("INSERT INTO area (date, plant_name, plant_location, plant_contact_name, pph, area)
VALUES('".format_date($data['dateSurvey'])."','".$data['plantName']."','".$data['plantLoc']."','".$data['plantContact']."','".$data['pph']."','".$data['area']."')") or die('Error: ' . mysql_error());
return mysql_insert_id();
}

function save_survey_details($surveyID, $data) {
$result = mysql_query("INSERT INTO survey_details (survey_id, tested_date, direction, location, floor_level, elevation, tag_number, manufacturer, model_number, size, pressure, service, trap_conditions)
VALUES($surveyID, '".format_date($data['testDate'])."','".$data['direction']."','".$data['location']."','".$data['flrLevel']."','".$data['elevation']."','".$data['tagNum']."','".$data['manufacturer']."','".$data['model']."','".$data['size']."','".$data['pressure']."','".$data['service']."','".$data['trapCond']."')");
$result = mysql_query("INSERT INTO area_details (survey_id, tested_date, direction, location, floor_level, elevation, tag_number, manufacturer, model_number, size, pressure, service, trap_conditions)
VALUES($surveyID, '".format_date($data['testDate'])."','".$data['direction']."','".$data['location']."','".$data['flrLevel']."','".$data['elevation']."','".$data['tagNum']."','".$data['manufacturer']."','".$data['model']."','".$data['size']."','".$data['pressure']."','".$data['service']."','".$data['trapCond']."')");
//or die('Error: ' . mysql_error());
}

?>

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=354184.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=355955.0

I am implementing a site that will be pulling data from a MySQL server every 2 seconds and updating the page accordingly. I want to redraw charts using Google Chart API as this is happening. Overall I do not want to have the page refresh for the user.

How should I implement this (generally of course)? I don't think there is a way to do it all in javascript...since I need to access a remote database and all. Please let me know what advice you have.

thanks!

Ok, I consider myself a dabbler in programming so bear with me.

What I need to do sounds fairly simple, but I cannot figure it out.

I have an html page.  Inside is some basic html and some Javascript. 

The javascript basically generates a random value consisting of numbers and characters in:  var = randomToken.

The length of the random value generated is 11 characters on chrome and 19 on FF? I have no idea why the discrepancy between browsers, but that's not a problem.  I'll look into that later.

What I'm having trouble doing is right now,  I need to take that random value  that was generated by a javascript function and save it out to a database, so on the other end, when someone browses

to another page, I need to retrieve the saved value from the database.   I've looked at many examples but they always include a bunch of stuff I don't need, like tables, multiple stuff in the database, etc.

All I need to do is be able to store a variable and later read it out of a database.  The database just needs a field to store the random value.  Nothing else is needed in the database (for now anyway).

I know I need php, but i am super green at using it. 

I have a mysql database/table built with field:  randomVar

So in a nutshell: 

The starting html page needs to:

Generate random value in Javascript. Save it in a variable.  Done. Pass it to php Not Done Update the database randomVar with the random value Not Done Zero out the randomVar field in the database at some point. (when originator hits stop button or closes the page.)  Not Done

Another html page needs to:

PHP Read the  randomVar from the database;  if > 0 use it Not Done If  = 0,  echo back some text to the html page....like "Try Later...  Not Done Pass it to javascript Not Done

I am not looking for the exact code unless you want to supply it?  :)

Thanks,

Ray

 

 

 

This is my website http://www.rahulkadukar.info/

As you can see I have the blue navigation bar on top and on mouse hover you can see a drop down menu. The contents of the drop down menu can change and I wanted to write a script that would populate the contents of the drop down menus.

Which of these is a better option
1. Use JavaScript along with a text file and use JavaScript to populate the drop down
2. Use a SELECT in PHP to populate the drop down menu

I am expecting that the 10 main columns would have at the most 20 entries each.

Hello Everyone,
I think this might be a bit of a challenge but its always worth getting some input for solutions.

I'm using jqplot to create graphs from data held in a database. And im having trouble thinking of a way to lay the data out in an acceptable way.

To plot a line the javascript takes a statement in this form:

line1 = [['x-axis1'],y-axis1],['x-axis2',y-axis2]

I'm running this query to get the data:


<?php
$query2 = "SELECT * FROM tracker WHERE username = '" . mysql_real_escape_string($usera) . "'";
$result = mysql_query($query2) or die('Error, query failed : ' . mysql_error()); 
while($row = mysql_fetch_assoc($result)) {   
$data[] = $row;
}
?>


This returns things like this:
$data[0]['date'], $data[0]['reps']
$data[1]['date'], $data[1]['reps']
etc...

Values are likely to be added or removed so I need to construct a loop of some kind to format it like this,

 line1 = [['{$data[0]['date']}',{$data[0]['reps']}],['{$data[1]['date']}',{$data[1]['reps']}],['{$data[2]['date']}'],{$data[2]['reps']}]];

Can someone point me in the right direction?

Thanks in Advanced

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=347585.0

create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";

$result = mysqli_query($conn, $sql );

$mimi = mysqli_fetch_assoc($result);

$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';

$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?

i want to download pdf or text document after clicking button or link how to do that

Hello everyone,

Sorry if this has been answered but if it has I can't find it anywhere. So, from the begining then.  Lets say I had a member table and in it I wanted to store what their top 3 interests are.  Their$ row has all the usual things to identify them userID and password etc.. and I had a further 3 columns which were labled top3_1 top3_2 & top3_3 to put each of their interests in from a post form.

If instead I wanted to store this data as a PHP Array instead (using 1 column instead of 3) is there a way to store it as readable data when you open the PHPmyadmin?

At the moment all it says is array and when I call it back to the browser (say on a page where they could review and update their interests) it displays 'a' as top3_01 'r' as top3_02 and 'r' as top3_03 (in each putting what would be 'array' as it appears in the table if there were 5 results. Does anyone know what I mean?

For example -

If we had a form which collected the top 3 interests to put in a table called users,

Code: [Select]
<form action="back_to_same_page_for_processing.php" method="post" enctype="multipart/form-data">
   
    <input name="top3_01" type="text" value="enter interest number 1 here" />
    <input name="top3_02" type="text" value="enter interest number 2 here" />
    <input name="top3_03" type="text" value="enter interest number 3 here" />
    <input type="submit" name="update_button" value=" Save and Update! " />

   
    </form> // If my quick code example for this form is not correct dont worry its not the point im getting at :)
And they put 'bowling' in top3_01, 'running' in top3_02 and 'diving' in top3_03 and we catch that on the same page with some PHP at the top -->

Code: [Select]
        if (isset($_POST)['update_button']) {
   
    $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
    $top3_02 = $_POST['top3_02']; // i.e, 'running'
    $top3_03 = $_POST['top3_03']; // i.e, 'diving'

With me so far? If I had a table which had 3 columns (1 for each interest) I could put something like -

  Code: [Select]
   include('connect_msql.php');
   
    mysql_query("Select * FROM users WHERE id='$id' AND blah blah blah");
   
    mysql_query("UPDATE users SET top3_01='$top3_01', top3_02='$top3_02', top3_03='$top3_03' WHERE id='$id'");


And hopefully if ive got it right, it will put them each in their own little column. Easy enough huh? But heres the thing, I want to put all these into an array to be stored in the 1 column (say called 'top3') and whats more have them clearly readable in PHPmyadmin and editable from there yet still be able to be called back an rendered on page when requested.

Continuing the example then, assuming ive changed the table for the 'top3' column instead of individual colums,  I could put something like this -


Code: [Select]
            if (isset($_POST)['update_button']) {
       
        $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
        $top3_02 = $_POST['top3_02']; // i.e, 'running'
        $top3_03 = $_POST['top3_03']; // i.e, 'diving'
   
    $top3_array = array($top3_01,$top3_02,$top3_03);
   
    include('connect_msql.php');
   
    mysql_query("UPDATE members SET top3='$top3_array' WHERE id='$id' AND blah blah blah");
But it will appear in the column as 'Array' and when its called for using a query it will render the literal string. a r r in each field instead.  Now I know you can use the 'serialize()' & 'unserialize()' funtcions but it makes the entry in the database practically unreadable. Is there a way to make it readable and editable without having to create a content management system?

If so please let me know and I'll be your friend forever, lol, ok maybe not but I'd really appreciate the help anyways.  The other thing is, If you can do this or something like it, how am I to add entries to that array to go back into the data base?

I hope ive explained myself enough here, but if not say so and I'll have another go.  Thanks very much people,  L-PLate (P.s if I sort this out on my own ill post it all here)

I have following piece of code below, and I would like to be able to express it pure SQL, something that could go into a .sql file :

$request_string='SELECT topic_forum_id FROM topic_table WHERE topic_id= 2014';
$query=database->prepare($request_string);
$query->execute();
$data=$query->fetch();
$query->closeCursor();
$forum=$data['topic_forum_id'];

$request_string='INSERT INTO post_table
(post_topic,post_forum) VALUES (2014,:forum)';
$query=database->prepare($request_string);
$query->bindValue(':forum',$forum,PDO::PARAM_INT);
$query->execute();
$data=$query->fetch();
$query->closeCursor();

  Is it possible ?

So i have this php as shown below. It should make a list of comments with comment replies below their comment respectively.

The problem is that it only goes through and shows 1 comment and all the comment replies for that one comment. It should be showing all comments i have in the db for that article.

If i remove the second while then it shows all the comments correctly but no comment replies then...

How do i get this script to loop through the db for every comment but also loop through every comment reply for that $row[id]?

If anyone has a better / more efficient way of what I am trying to do, please explain or show example (i am open to anything)...

Code: [Select]
// what article are we showing?
$article_to_show_id = $_GET['article_id'];


$active_is_set_text = "1"; // Active Column text that makes it okay to show

// Finding the article
$search_for_article = mysql_query("SELECT * FROM articles WHERE id = '$article_to_show_id' AND active = '$active_is_set_text'");

while($row = mysql_fetch_array($search_for_article))
{
// format the last updated date right
$update_date_edit = $row[update_date];

$update_date_edit = date('F j, Y \a\t h:ia', $update_date_edit);

$row[update_date] = $update_date_edit;



// format the submit updat date right
$submit_date_edit = $row[submit_date];

$submit_date_edit = date('F j, Y \a\t h:ia', $submit_date_edit);

$row[submit_date] = $submit_date_edit;


echo '
<div>
', $row[title] ,'
</div>


<div>
by: ', $row[author] ,' on ', $row[submit_date] ,'
</div>



<div>
', $row[content] ,'
</div>


<div>
Last Updated: ', $row[update_date] ,'
</div>

<form action="article_reply.php" method="post">
<input type="hidden" name="article_id" value="', $row[id] ,'" />
<button name="article_reply" type="submit" value="submit">Reply</button>
</form>

';

}

$comment_count = 0;
$comment_reply_count = 0;

// Finding all of the comments
$search_for_article = mysql_query("SELECT * FROM article_comments WHERE article_id = '$article_to_show_id' AND reply_id = '0'");

while($row_comment = mysql_fetch_array($search_for_article))
{
// format the submit updat date right
$comment_date_edit = $row_comment[comment_date];

$comment_date_edit = date('F j, Y \a\t h:ia', $comment_date_edit);

$row_comment[comment_date] = $comment_date_edit;

echo '
<br>
<br>
COMMENT:<br>

<div>
By: ', $row_comment[username] ,' on ', $row_comment[comment_date] ,'
</div>

<div>
', $row_comment[comment] ,'
</div>
';
$comment_count++;

// Finding all of the comment replies if any
$search_for_article = mysql_query("SELECT * FROM article_comments WHERE article_id = '$article_to_show_id' AND reply_id = '$row_comment[id]'");

while($row_two = mysql_fetch_array($search_for_article))
{
// format the submit updat date right
$comment_date_edit = $row_two[comment_date];

$comment_date_edit = date('F j, Y \a\t h:ia', $comment_date_edit);

$row_two[comment_date] = $comment_date_edit;

echo '
<br>
<br>
COMMENT REPLY:<br>

<div>
By: ', $row_two[username] ,' on ', $row_two[comment_date] ,'
</div>

<div>
', $row_two[comment] ,'
</div>
';
$comment_reply_count++;
}
}

Need some help I have 2 tables in a database and I need to search the first table and use the results from that search, to search another table, can this be done? and if it can how would you recommend that I go about it?

Thanks For Your Help Guys!