Hi all,
Im having trouble to get the beneath script to work the thing i can't seem to get workin is the following.
The page requests the data from a mysql table using mysql array so there are mutliple row's every row has 3 data
colloms 1 id (auto increment) 2 Module name 3 status. after every row the is a submit button so you can submit data from that row (basilcy a on and off button) when i have more than 1 row it doesnt work.
With 1 row it works but have to press the submitt buton twice.
Any help will be appreciated
Regards Djunity
<div class="content">
<br />
<a href="?page=view">Module overzicht</a> <br />
<br / >
<p><a href="?page=add" class="button"><span class="ui-icon ui-icon-plusthick"> </span>Module toevoegen </a></p>
<table id="myTable" class="tablesorter" style="width: 100%;" border="0" cellpadding="0" cellspacing="1" > <thead>
<tr>
<td height="25px" width="120"><b> Module naam:</b></td>
<td height="25px" width="60"><b> Status:</b></td>
<td height="25px"width="70"><b> Actie:</b></td>
</tr>
</thead>
<?
// get results from database
$result = mysql_query("SELECT * FROM Wefact_Modules ORDER BY id")
or die(mysql_error());
while($row = mysql_fetch_array( $result )) {
$form = $row['module'];
$id = $row['id'];
?>
<tbody>
<form method="post" name="form" action="?page=view">
<input type="hidden" name="id" value="<?php echo $id; ?>"/>
<input type="hidden" name="action2" value="action">
<tr class="hover">
<td height="35px"><? echo $row['module']; ?></td>
<td height="35px"><? if ($row['status'] == 1) {
echo "<font color='#00FF00'>Online</font>";
}else if ($row['status'] == 0){
echo "<font color='#FF0000'>Offline</font>"; } ?></td>
<td height="35px">
<? if ($row['status'] == 1) { ?>
<input type="hidden" name="status" value="0" /><a href="javascript: document.form.submit();" class="button"><span class="ui-icon ui-icon-minusthick"> </span>Offline</a> <?
}else if ($row['status'] == 0){ ?>
<input type="hidden" name="status" value="1" /><a href="javascript: document.form.submit();" class="button"><span class="ui-icon ui-icon-plusthick"> </span>Online</a> <? } ?> </td>
</form>
</tbody>
<? } ?>
<?
$status = $_POST['status'];
if($_REQUEST['action2'] == 'action') {
$sql = "UPDATE Wefact_Modules SET status='$status' WHERE id='$id'";
$result = mysql_query($sql);
} ?>
</table>
</td>
</tr>
</table>
</div>
</body>
</html>
Include a php
Hello, I'm trying to include a function that shows the recent searches. Example I have index.html-------------------------------------------------------------------------
How could I do this?
Ive got a simple lottery game, and am using an sql database to keep track of the numbers bought. But, when the person comes to buy the ticket, I have to replay to my process page which ticket they
Post PHP form to non-existing page
The company that I work for host their PHP code on IIS on a Windows server, no Apache, so no mod_rewrite. I recently wrote a custom framewok that is loosely based on Codeigniter. To get SEF URL's 'n
Spaghetti Code
So.I've pretty much reached the point where I have so many isset s on one page that I can't tell what the page is supposed to do. In other words: spaghetti code. I just read a few tutorials on OOP,
problems with script
I made a small script wich exchanges points in my website: <?phpsession_start();include_once"config.php";$username = $_SESSION['username']; if(isset($_POST['exchange'])){$spoints =
Adding Different Numbers From MySQL
Basically I have a mysql database with a couple prices as the following:9.999.999.9949.9924.5024.50How can I add these numbers and display the total from a mysql database?
Error querying database.
I get the above error when trying to insert some values to a datatable.Here's the code :Code: $dbc = mysqli_connect('127.0.0.1:3306', 'root', 'xxxx', 'aliendatabase') or die('Error connecting to
server trace logs
could any one tell me from where do i get error logs in xMII??I want to check the reason for dtabase connection failure
Simple Variable Question
Hi everyone.... again,I am really getting into php still. Learning more every day. I love it.But I have run into a problem I cannot solve.From what I understand, you can only "echo
php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecutive pattern.For example, I might have the table "eggs" with the values "1",