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 :
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 need help about i store the value of my select statement result to an array and stored it to a variable named $fname
Comparing MySql data and arrays. I have a mysql table set up like this: idsubjectbodyuseriddatetimetags1blog subjectblog body111|2
Coefficient of a Restitution Hints Hello. I was wondering if anyone can give me hints on how to write this program... The coeffi
Custom Container in module pool program Hello everyone,
I have created a custom control in my module pool screen. Now I want to s
writing a screen scraper Hello, I'm writing a screen scraper application and want to be able to get absolute addresses
CE 7.1 and External GIS integration Hi All,
We want to develop an application on CE 7.1 which uses GIS features from an exter
Supress some serveroutput but not all Hi,
I have a script I'm working on that uses plsql to create and RMAN script, this uses d
Need help urgant why down my code ony return one item instead of all the items selected. $arr = array($date,$
PHP form authentication Hi guys, what am trying to achieve is this: Whenever a user tries to login to my website, an
difference between datetimes ($row['totime']-$row['fromtime'])/60 this is giving me 0 example of totime and fromtim