Problems with adding a link to one position in a 'foreach' loop, please help

Posted on 16th Feb 2014 07:03 pm by admin

Hello!

Iam pretty new to programming and I wanna create a table with users from an array. It works just fine but in one table row I wanna add a link to it so I can click on the username to edit it later. This is my code right now:

Code: $keys = mysql_query("SELECT * FROM users", $connection);
confirm_query($keys);
$result = mysql_query("SELECT * FROM users", $connection);
if (!$result)
confirm_query($keys);

echo "<table id="usertable">";
echo "<tr id="usertablemain">";
$a = array_keys(mysql_fetch_assoc($keys));
foreach($a as $b) { echo "<td>" . $b . "</td>";}
echo "</tr>";
while ($rows = mysql_fetch_assoc($result))
{
echo "<tr>";
foreach ($rows as $row)
{

echo "<td>".$row."</a>"."</td>";
}
echo "</tr>";
}
echo "</tr>";
echo "</table>";

I tried to nest a IF statement but it always give in some way true and all positions in the table get a <a href> tag. The array contains a position called 'username' which is in the second row. Please help me out

Your Answer:

Login to answer

Other forums

how to make database item unique
Hey guys,

is it possible to do this:

I have the database item $title being pulled for

Add "width" check when upload
Hi!

Can someone add a function that is checking if picture witdh is bigger then 800px whwn up

Need help making a blockquote and line items conditional
I have some code I bought a few years ago that allows my clients to update content on their site usi

Deleting a record php
Attempting to setup delete a record page. The below code I put together doesn't seem to work.

Update Database
Hi All,


I have a problem with this:

Code: [Select]<?php
session_start();

Delete all files in folder except with certain name
I have a script that I want to delete all files in a folder (taken from a database) except for one n

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

please hep to get values from a table row
can anyone tel me how I can select and get data from one row by pressing an Edit button in that row

Fatal error: Call to a member function fetchrow() on a non-object in C:xamppht
okay i have this query and everytime i add `item_id`=? to it... it gives me the error in the title..

PHP Search Issue
Hi, I am using the following code to search and return flights from a database. The user searches by