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 Like 45 Dislike
Previous forums Next forums
Other forums

Setting condidtions for an input box
Hi all,

I would like to set a condition in a txt box that says the number a user enters has t

restricting another login once you logout
Hello,

how can I restrict a page from login authenticating against info in a MySQL DB for a s

Any meaningful project for a new C++ programmer?
I want to do some meaningful program, so I can help myself to learn

Assume I know the fol

Packet Design
Hi All,
Im new about network programming and I want to design a protocol but I have some question

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include

Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out

Does deleting the spmlog directory critical?
Hi Everyone,

Please, hope you could help me. We're having problems with the SAP backup. I

Extracting Long text from message class with parameters
Hi,

I would like to extract the long text from a message class. However, the long text ha

Is this Safe or Unsafe?
Hi i made a few pages with lots of peoples help now i just want to know if they are safe or not can

User input in to variable
Hi all,

I'm sure this is very easy but I'm having another brain freeze!

At the end of

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash