$cid=mysql_connect('localhost','moodle_suppl','Lfrn8eD,QBz7YZBV'); if (!IsSet($HTTP_POST_VARS['selected'])) { $error=mysql_error(); echo "$error"; mysql_select_db('users'); $error=mysql_error(); echo "$error"; $query="SELECT * FROM signups"; $result=mysql_query($query); $error=mysql_error(); echo "$error"; $line=mysql_fetch_array($result,MYSQL_ASSOC); $keys=""; $values=""; while (list($key,$value)=each($line)) { $keys.="$key"; $values.="$value"; } echo "$keys$values"; while ($line=mysql_fetch_array($result,MYSQL_ASSOC)) { echo ""; foreach ($line as $col_value) { echo ""; } echo ""; } echo "
$col_value
"; $error=mysql_error(); echo "$error"; echo "
Vybrať iba tých užívateľov, ktorí si svolili kurz:

"; if (mysql_error()==false) { echo "Požiadavka bola úspešne vybraná z databázy...
"; } else { echo "Niečo sa pokazilo ...
"; } } else { $error=mysql_error(); echo "$error"; mysql_select_db('users'); $error=mysql_error(); echo "$error"; $selected=$HTTP_POST_VARS['selected']; $query="SELECT * FROM signups WHERE kurz_1=\"$selected\" OR kurz_2=\"$selected\" OR kurz_3=\"$selected\""; $result=mysql_query($query); $error=mysql_error(); echo "$error"; $line=mysql_fetch_array($result,MYSQL_ASSOC); $error=mysql_error(); echo "$error"; $keys=""; $values=""; while (list($key,$value)=each($line)) { $keys.="$key"; $values.="$value"; } echo "$keys$values"; while ($line=mysql_fetch_array($result,MYSQL_ASSOC)) { echo ""; foreach ($line as $col_value) { echo ""; } echo ""; } echo "
$col_value
"; $error=mysql_error(); echo "$error"; echo "Späť"; } mysql_close($cid); ?>