Đang Thực Hiện

145323 Tiny PHP / MySql call

Hello programmers,

I'm in need of a tiny little PHP script wich is compatible to PHP 4+5 and MySql 4 and does the following:

1.) connect to a mysql-database

2.) call 1 line of information into an array

3.) close mysql connection

4.) echo $content[1], echo $content[2]

Rules for the MySql call:

1.) Assure that each line of information can be retrieved only "ONCE" every "WEEK"

2.) Assure that only after a minimum of "30" seconds a new line of information can be retrieved

"ONCE", "WEEK" and "30" must be defined as variables.

That's it :)

Info: Mysql contains between 60.000 and 100.000 lines of information in one table.

Script will get hidden (iframe) called by website visitors many thousand times a day and must be written in the most resource friendly way possible. Database must be sorted and indexed in the most suitable way to save ressources.

In other words again: as lean, fast and lightweight ever possible!

The DB design below is just to give you a hint on what's in my mind. You are free to design the

Database like you want.

---------------------------------------------------------------

| ID | headline | subline | datetime |

---------------------------------------------------------------

| 1 | Headline 1 | Subline 1 | timestamplastcall |

---------------------------------------------------------------

| 2 | Headline 2 | Subline 2 | timestamplastcall |

---------------------------------------------------------------

| 3 | Headline 3 | Subline 3 | timestamplastcall |

---------------------------------------------------------------

| 4 | Headline 4 | Subline 4 | timestamplastcall |

---------------------------------------------------------------

| 86400 | Headline 86400 | Subline 86400 | timestamplastcall |

---------------------------------------------------------------

Since I believe an expirienced programmer would not take longer than 30 minutes for this few lines

of PHP, please bid reasonably.

Escrow release after I got the working script.

Thank's.

Kỹ năng: Bất kì công việc gì, MySQL, PHP

Xem thêm: what's escrow, what's an escrow, programmers on line, programmers on call, php programmers for free, php programmer on line, php and mysql connection, on call programmers, new line in php, need php programmer fast, mysql database for free, mind array, lean design, i close escrow website, fast website programmers, echo design, call minutes, mysql free, mysql 5.1, free mysql, db escrow, tiny, mysql 4, call id, php connection

Về Bên Thuê:
( 52 nhận xét ) Hometown, Germany

Mã Dự Án: #1891499