PHP - Remove Duplicated Content!

What am I doing wrong?


<?PHP
echo preg_replace('#(<td class="results" style="border-width: 0px 0px 1px;">).*?(</td>)#', 'test', $raw_data);
?>


If the contents of $raw_data has:
Code: [Select]
<td class="results" style="border-width: 0px 0px 1px;">THERE IS SOME CONTENT HERE</td>

should it not be replaced as so? :
Code: [Select]
<td class="results" style="border-width: 0px 0px 1px;">test</td>

Hello, I'm trying to code a private message system and got stuck (yup, again) on this part:

At the page where the messages are read, I'd like to display all the messages where the same sender and the receiver participate, like this:

Code: [Select]
SELECT * FROM messages WHERE sender = 1 AND receiver = 2 OR sender = 2 AND receiver = 1 ORDER BY date LIMIT 0,10;
Is there anyway to do something like that?
Thank you.

(Again, sorry for the weird Subject, I gave my best)

Hello. I have here a php code getting information from mysql but when printing the result is duplicated, or more.

Code: [Select]
<?php 
$query = "SELECT SUM(amount) FROM user_detail"; 
 
$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){
echo "<p align=\"left\">Total ".$row['SUM(amount)']."</p>";

}

?>
and then I get result like this:



you can see there are 3 result and I need to print only one time. I use for sql connection other file with :

include_once("./includes/config.php");

Need help to solve this Thanks in advance

Hi guys,

I am currently stuck in a situation.

I have duplicated names in my form. View duplicated.jpg for a reference.

What exactly went wrong? Any help will be greatly appreciate! How do I eliminate the duplicated names. Thanks!!

And my $count is currently not working as well, it is supposed to be 5 columns per row.

Code: [Select]
<?php
/***Pre-School Level***/
echo '<input name="level[]" type="checkbox" id="level_1" value="1">';
echo '<span class="zone_text_enlarge"><label for="level_1">Pre-School</label></span><br/>';

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
or die(mysqli_error($dbc));

$query = "SELECT sl.subject_level_id, sl.level_id, sl.subject_id, tl.level_name AS level_name, ts.subject_name AS subject_name " .
        "FROM tutor_subject_level AS sl " .
        "INNER JOIN tutor_level AS tl USING (level_id) " .
        "INNER JOIN tutor_subject AS ts USING (subject_id) " .
"ORDER BY subject_level_id ASC LIMIT 7";

    $sql = mysqli_query($dbc, $query)
or die(mysqli_error($dbc));


$query1 = "SELECT subject_level_id FROM tutor_overall_level_subject WHERE tutor_id = '" . $_GET['tutor_id'] . "'";

$sql1 = mysqli_query($dbc, $query1)
or die(mysqli_error($dbc));

$selected_subjects = array();
while ($row = mysqli_fetch_array($sql1)) {
array_push($selected_subjects, $row['subject_level_id']);
}

echo'<table><tr>'; // Start your table outside the loop... and your first row
$count = 0; // Start your counter
while($data = mysqli_fetch_array($sql)) {
/*  Check to see whether or not this is a *new* row
If it is, then end the previous and start the next and restart the counter.
*/
if ($count % 5 == 0) { 
echo "</tr><tr>"; $count = 0;
}
foreach($selected_subjects as $selected_subject) {
if ($data['subject_level_id'] == $selected_subject) {
echo '<td><input name="subject_level[]" class="subject_a" type="checkbox" checked="checked" id="subject_level_'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
echo '<label for="subject_level_'.$data['subject_level_id'].'" class="subject_1">'.$data['subject_name'].'</label></td>';
$count++; //Increment the count
}
else {
echo '<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
echo '<label for="subject_level_'.$data['subject_level_id'].'" class="subject_1">'.$data['subject_name'].'</label></td>';
$count++; //Increment the count
}
}

} 
echo '</tr></table><br/>'; //Close your last row and your table, outside the loop
?>

This is the end result of the HTML code, through 'view page source' in web browser
Code: [Select]
<input name="level[]" type="checkbox" id="level_1" value="1">

<span class="zone_text_enlarge"><label for="level_1">Pre-School</label></span><br/>

<table><tr></tr>

<tr>
<td><input name="subject_level[]" class="subject_a" type="checkbox" checked="checked" id="subject_level_1" value="1"/>
<label for="subject_level_1" class="subject_1">Mathematics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_1" value="1"/>
<label for="subject_level_1" class="subject_1">Mathematics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_2" value="2"/>
<label for="subject_level_2" class="subject_1">English</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_2" value="2"/>
<label for="subject_level_2" class="subject_1">English</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_3" value="3"/>
<label for="subject_level_3" class="subject_1">Chinese</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_3" value="3"/>
<label for="subject_level_3" class="subject_1">Chinese</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_4" value="4"/>
<label for="subject_level_4" class="subject_1">Tamil</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_4" value="4"/>
<label for="subject_level_4" class="subject_1">Tamil</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_5" value="5"/>
<label for="subject_level_5" class="subject_1">Malay</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_5" value="5"/>
<label for="subject_level_5" class="subject_1">Malay</label></td>
</tr>

<tr>
<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_6" value="6"/>
<label for="subject_level_6" class="subject_1">Phonics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" checked="checked" id="subject_level_6" value="6"/>
<label for="subject_level_6" class="subject_1">Phonics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_7" value="7"/>
<label for="subject_level_7" class="subject_1">Creative Writing</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_7" value="7"/>
<label for="subject_level_7" class="subject_1">Creative Writing</label></td></tr>

</table><br/>

Hello, I have 3 tables for clients, orders and the products they ordered.   Here are the tables...

Clients
CLIENT_ID
CLIENT_NAME

Orders
o_id client_id
o_number
o_date o_notes   Products
o_id
qty
name   I am getting the results I need with this query...

SELECT
    clients.CLIENT_ID, clients.CLIENT_NAME,
    orders.o_id, orders.client_id, orders.o_date, orders.o_number, orders.o_notes,
    products.o_id, products.qty, products.name
    FROM clients, orders, products
    WHERE clients.CLIENT_ID = orders.client_id
    AND orders.o_id = products.o_id
    AND orders.o_id = $theOrder

..and this is the php I use to display it...

while ($row = $result->fetch_assoc()) {

    echo "<h2>$row[CLIENT_NAME]</h2>";
    echo '<label>Date</label><input type="text" value="'.timechange($row['o_date']).'" readonly><br>';
    echo '<label>Order No.</label><input type="text" value="'.$row['o_number'].'" readonly><br>';
    echo '<label>Notes</label><input type="text" value="'.$row['o_notes'].'" readonly>';
    echo '<label>Product Qty.</label><input type="text" value="'.$row['qty'].'" readonly><br>';
    echo '<label>Product Name</label><input type="text" value="'.$row['name'].'" readonly><br>';
}

However - rather predictably I am getting three forms printed out as the results from MySQL look like this...  mysql0.jpg   33.47KB   0 downloads   Is it possible to somehow get my form to display the results, like this...  mysql1.jpg   22.54KB   0 downloads   I hope I'm explaining myself well enough - and thank you for reading.
Edited by tHud, 04 July 2014 - 11:06 AM.