MySQL Forums
Forum List  »  Quality Assurance

Hiding the last column of text
Posted by: J B
Date: September 12, 2012 06:07AM

Hello all, I have a PHP page that reads a mysql database. I want to display the first name, email country, and time. I need to use the ID as part of a link to another page, but I don't want the ID to populate in the table. Is there a way to make it invisble?

**I realise that by "not selecting" the ID is one way, but if I do that then it breaks $row[4]. So I need to select the ID, but I just don't want it to be visible in the table.

Thanks!


$result = mysql_query("SELECT concat(first_name, ' ', last_name), email, country, TimeStamp, id noprint FROM {$table} order by id desc LIMIT $startrow, {$records_per_page}") or
die(mysql_error());

while($row = mysql_fetch_row($result))

foreach($row as $cell)

echo "<td><a href=../ui/edit_customer.php&id=$row[4]>$cell</a></td>";
echo $result;

echo "</tr>\n";
$c++;

Options: ReplyQuote


Subject
Views
Written By
Posted
Hiding the last column of text
2814
J B
September 12, 2012 06:07AM
1228
J B
September 12, 2012 06:28AM
1026
J B
September 12, 2012 08:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.