[RESOLVED] Check if cell has data, and do something?

[gszauer]

<?php

$current = $_POST["current"];

$ip = $_SERVER['REMOTE_ADDR'];
print("$ip")

// Basic Variables For Connection
$server = "localhost";
$user = "program";  

$pass = "e387985";
$database = "program_program";
$tableName = "vexour";


$result = mysql_query("SELECT s1,s2,s3,s4,s5,s6,s7,s8,s9,s10,s11,s12,s13,s14,s15,s16,s17,s18,s19,s20 FROM vexour WHERE ip='$ip'");
list ($s1,$s2,$s3,$s4,$s5,$s6,$s7,$s8,$s9,$s10,$s11,$s12,$s13,$s14,$s15,$s16,$s17,$s18,$s19,$s20) = mysql_fetch_array($result);


$conn = @mysql_connect($server,$user,$pass); 
$database = @mysql_select_db($database,$conn); 
?>

as you can see, my code takes the values in s1-s20 and turns them into variables... this is where i got stuck

What i want to do is basically have s1-s20 filled with true or false. every time the scritp is executed i need it to check if s1 is false, if it is make it true, and quit. if s1 is true move on to s2 check if it is false..... i think you get the point....

Can anyone help me out, im not eaven shure i took the right approach.....
Thank you for your time,
~Gabor Szauer

[laserlight]

I suggest that you restructure your table instead.
Currently you have at least 21 fields. One for the ip, and 20 sN fields, N = [1, 20].

Effectively, you are using 20 boolean fields as a counter. Why not make them into one integer field?

$result = mysql_query("SELECT s FROM vexour WHERE ip='$ip'");
// ... do what you want with the result returned ...

// now update s
mysql_query("UPDATE vexour SET s=s+1 WHERE ip='$ip'");