Jump to content

Archived

This topic is now archived and is closed to further replies.

wipeskim

Php mysql statement

Recommended Posts

Hi,

I am doing a script with php and mysql wich i want to list the orders details such as session_id, date, username and id.

To do this i used select distinct session_id from orders

cause i have 2 orders with the same session_id but i also want to list the username, date and id.

Since i used to distinct only the session_id it will only print on the screen the session id's.

I tryed "select Distinct session_id, username, date,id from orders" but in this case since some fields has diferent values even having the same session_id it will list all the results on the table.

Is there anyway of using the select statement to select all the fields and distinguish the session_id so that i can avoid duplicated session id's on the results?

If someone can help me i appreciate

Many thanks to all

Share this post


Link to post
Share on other sites
Do you mean
[code]<?php
$sql = "select session_id, username, date,id
from orders
order by session_id";
$res = mysql_query($sql) or die(mysql_error());

$last_sid = '';
echo '<table border="1">';
while (list($sid, $usr, $dt, $id) = mysql_fetch_row($res)) {
    $sess = ($sid==$last_sid) ? '&nbsp;' : $sid;
    echo "<tr><td>$sess</td>
    <td>$usr</td>
    <td>$dt</td>
    <td>$id</td></tr>\n";
    $last_sid = $sid;
}
echo '</table>';
?>
[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.