first id from db not showing
Posted on
16th Feb 2014 07:03 pm by
admin
I have a php script which displays the content of a mysql table as a html table with sorting, delete/update button, etc. the problem is I can't make it show the first value inserted in the db, it only shows from the second id onwards, example:
instead of :
Did you know? Explore Trending and Topic pages for more stories like this.
ID Surname Name
1 Test John
2 Test Anna
it shows:
ID Surname Name
2 Test Anna
3 Test Jorge
omitting the first id in the db
"index.php"
Code: <?php
include("connect.php");
$result = mysql_query("SELECT * FROM contact");
$id = mysql_result($result,$i,"id");
echo "<table border='1' class='rowstyle-alternate'>
<tr>
<th> </th>
<th> </th>
<th class='sortable-numeric'>ID</th>
<th class='sortable-text'>Surname</th>
<th class='sortable-text'>Name</th>
<th class='sortable-numeric'>Phone1</th>
<th class='sortable-numeric'>Phone2</th>
<th class='sortable-text'>Location</th>
</tr>";
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . "<a href="delete.php?id=$id">Delete</a>" . "</td>";
echo "<td>" . "<a href="update.php?id=$id">Update</a>" . "</td>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['surname'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['phone1'] . "</td>";
echo "<td>" . $row['phone2'] . "</td>";
echo "<td>" . $row['location'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close();
?>
"delete.php"
Code: <?php
$id = $_GET['id'];
?>
<html>
<head>
<title>Do you want to delete this?</title>
</head>
<body>
<div align="center">
<h2>Do you want to delete this?</h2>
<h2><a href="deleted.php?id=<?php echo "$id" ?>">Yes</a> - <a href="index.php">No</a></h2>
</div>
</body>
</html>
No comments posted yet
Your Answer:
Login to answer
154 45
Other forums dinamic "textboxes"? Ey all, my first post here, i hope its not a hard one I display mysql results in a table
Character Sets/Collations Stuff Can someone please give me a check list of things I must do to setup all the charset stuff for my ph
Help with Contact Form I have this Form on an html page and the associated code on page.php (below). I keep getting the
SQL Query/echo not working Hey all, I'm trying to run (what I thought) was a simple operation and it isn't working. I h
I face problems to extract data from one table and insert it in another one Hi,
For modifications, I have to extract data from one table and insert it in another one
First root of a number Hi, I can't find any function in php to give me the first root of a number. Is there any
SCO Unix I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built
MII Netweaver Server stopped due to CPIC connection Problem Dear Experts,
We have SAP XMII 12.0 setup running on Netweaver 2004s,7.0, Java Stack only.
Onclick problem in Firefox Hi, I am using a . It doesn't seem to
login box shows up again after logging in 2nd login works Hello, I am having trouble on my site Lockerz.rack111.com where when you login the login box