Get a Freelance Job

My ASP programmer is moving, and currently has no access to a computer

Sooooo i need a programmer to make some small changes to a site.

attached is file for update outline.

Preform good and i have some more work…

Upon request, i’ll send you .asp files decussed in outline

I have a custom developed back end that uses multi-dimensional associative arrays. The project is to create an interface that allows a user to add an inventory item (line in MySQL) in to our database.

Send PMB to get specifications, I will only accept bids if you have seen the specs and I have communicated with you any questions you have prior to bidding.

My ASP programmer is moving, and currently has no access to a computer

Sooooo i need a programmer to make some small changes to a site.

attached is file for update outline.

Preform good and i have some more work…

Upon request, i’ll send you .asp files decussed in outline

Basically I have a current working website php/mysql
and I need someone to tell me the code I need to add extra info to the summary sheet

Example; summary shows name of entry I may want the code to display time of entry (all stored in database)

$4 per working query ?

I have a php/mysql database which collects my info from forms submitted to it. But I need to add to my website differnt info from the database.

It currently tells me how many entrys are marked level 5
I this recreating to tell me how many level 4,3,2,1 I have

Pm for more details

I am posting this for the 2nd time – i am in a hurry so only bid if can do this in the next hour.

I am looking for a simple bit of code that will insert some values in a empty table called dt_newsletter.

The insert will be based on two queries.

Query 1

I want to extract 3 fields (member_id, name, email) from a table called dt_profile where the field “lastlogin” > 1209902443

Query 2

I want to extract 3 fields (id, name, email) from a table called dt_memebrs where the field “unlimited” = 1

Note that id and member_id are the same data.

The above query results should be inserted into dt_newsletter, but there needs to be a check that duplicates are not being entered as the two queries may overlap for some values.

I will be executing this code from a php script.

This is a very simple bit of code – so first to post some code to PMB will get the job.

Thanks in advance,
GPS

I am looking for a simple bit of code that will insert some values in a empty table called dt_newsletter.

The insert will be based on two queries.

Query 1

I want to extract 3 fields (member_id, name, email) from a table called dt_profile where the field “lastlogin” > 1209902443

Query 2

I want to extract 3 fields (id, name, email) from a table called dt_memebrs where the field “unlimited” = 1

The above query results should be inserted into dt_newsletter, but there needs to be a check that duplicates are not being entered as the two queries may overlap for some values.

I will be executing this code from a php script.

This is a very simple bit of code – so first to post to PMB will get the job.

Thanks in advance,
GPS

Hello,

I need this code repaired.

What it does is delete ads that are older than one day. That works great. The second part is suppose to delete the viewed record. In other words every time the ad got viewed the information was stored in the viewed table. If the ad gets deleted all records pertaining to the deleted ad should also be removed from the viewed table.

[code]
//first clear the database of expired ads.
$onedayago = strtotime("-1 day");
$querys="select * from post where posted < '".$onedayago."'";
$results=mysql_query($querys);
//now build the query.....

while ($lines = mysql_fetch_array($results)) {
$postid = $lines["postid"];

if ($counter==0) {
$queryv.= "delete from viewed where id=".$postid." ";
}
else {
$queryv.= " and id=".$postid." ";
}
$counter=$counter+1;
}
if ($query<>"") {
$resultv=mysql_query($queryv);
}

////////////////

CREATE TABLE `viewed` (
`id` int(11) NOT NULL auto_increment,
`postid` int(11) NOT NULL default '0',
`userid` varchar(30) NOT NULL default '',
`paid` tinyint(1) NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=466286 ;

[/code]