1.301 views
Deleted
aan.php:
zoiets
<?
$link = mysql_connect('localhost','***','***');
mysql_select_db('***',$link);
$sql = SELECT status FROM testje WHERE id = '1' ";
$result = mysql_num_rows(mysql_query($sql));
$num = count($result);
if($num>0)
{
echo "is al aan";
}
else
{
$sql = "UPDATE testje SET status = '1' WHERE id =1 LIMIT 1 ";
$res = mysql_query($sql,$link);
echo " is nu aan";
}
?>
zoiets
Deleted
ow, alsie al aan is moetie meteen uit?
die had je zelf ook kunnen bedenken
<?
$link = mysql_connect('localhost','***','***');
mysql_select_db('***',$link);
$sql = "SELECT status FROM testje WHERE id = '1' ";
$result = mysql_num_rows(mysql_query($sql));
$num= count($result);
if($num>0)
{
echo "is al aan";
$sql = "UPDATE testje SET status = '0' WHERE id = '1'";
$result = mysql_query($sql);
echo "staat nu uit";
}
else
{
$sql = "UPDATE testje SET status = '1' WHERE id =0 LIMIT 1 ";
$res = mysql_query($sql,$link);
echo " is nu aan";
}
?>
die had je zelf ook kunnen bedenken
Als je nou de eerste query ook nog aanpast, dan maak je een kans.
$sql = "SELECT status FROM testje WHERE id = '1' ";
=> WHERE status = 1
$sql = "SELECT status FROM testje WHERE id = '1' ";
=> WHERE status = 1
Deleted