Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
i have query as(in pagination page) codeCode: Select all
$query = "SELECT reserved.book_id,students.name,books.bookname,reserved.date,students.program,reserved.reserved_id FROM reserved,books,students where reserved.book_id=books.book_id and reserved.library=students.library ORDER BY date";
$query_result = mysql_query ($query);
.......................................
..............................
}
echo '</p><br />';
} // End of links section.
// Table header.
echo '<table align="left" cellspacing="2" cellpadding="2">
<tr><td align="left"><b>Reserved Book</b></td><td align="left"><b>Reserved By</b></td><td align="left"><b>Book Name</b></td><td align="left"><b>Reserved Date</b></td>
<td align="left"><b>Program</b></td><td align="left"><b>Delete(click on num)</b></td>
</tr>';
// Fetch and print all the records.
$bg = '#eeeeee'; // Set the background color.
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
$bg = ($bg=='#eeeeee' ? 'cyan' : '#eeeeee'); // Switch the background color.
echo '<tr bgcolor="', $bg, '"><td align="left">', stripslashes($row[0]), '</td><td align="left">', $row[1], '</td><td align="left">', stripslashes($row[2]), '</td><td align="left">', $row[3], '</td><td align="left">', stripslashes($row[4]), '</td>
<a href="delreserve.php?uid=($row[0])"><td align="left">', stripslashes($row[5]), '</td></a></tr>
';
}
echo '</table>';Code: Select all
stripslashes($row[4]), '</td>
<a href="delreserve.php?uid=($row[0])"><td align="left">', stripslashes($row[5]), '</td></a></tr>but it doesnot pass bookid
what is correct syntax for it
please help
thanks
feyd | Please use
Code: Select all
andCode: Select all
tags where appropriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]