Создание БД
mysql_query ("CREATE TABLE IF NOT EXISTS proxy_tb(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
proxy_type int,
proxy varchar(100),
proxy_login varchar(100),
proxy_pass varchar(100),
status BOOL
)") ;
mysql_query ("INSERT INTO `proxy_tb`(proxy_type ,proxy,proxy_login,proxy_pass,status) VALUES (1,'199.3036.3737','logADM','pass1234',1)");
mysql_query ("INSERT INTO `proxy_tb`(proxy_type ,proxy,proxy_login,proxy_pass,status) VALUES (1,'109.3036.3737','logADM','pass1234',1)");
mysql_query ("INSERT INTO `proxy_tb`(proxy_type ,proxy,proxy_login,proxy_pass,status) VALUES (1,'299.3036.3737','logADM','pass1234',1)");
mysql_query ("INSERT INTO `proxy_tb`(proxy_type ,proxy,proxy_login,proxy_pass,status) VALUES (1,'499.3036.3737','logADM','pass1234',1)");
Поочередная выборка прокси
$sql_query_result = mysql_query("SELECT `id`, `proxy` FROM `proxy_tb` WHERE `status` = 1");
if(mysql_num_rows($sql_query_result) == 0){
mysql_query("UPDATE `proxy_tb` SET `status` = 1");
$sql_query_result = mysql_query("SELECT `id`, `proxy` FROM `proxy_tb` WHERE `status` = 1");
}
$mysql_result = mysql_fetch_assoc($sql_query_result);
$id = $mysql_result["id"];
echo $proxy = $mysql_result["proxy"];
mysql_query("UPDATE `proxy_tb` SET `status` = 0 WHERE `id` = $id");