Get a Freelance Job

I got one script for messages between the users

In inbox the messages shows only the received messages (incoming)
but the counter counts all messages sent and received from the user

So the total messages is not correct

For example I sent 3 messages and received 4 messages
in inbox it shows you have 7 messages which is not correct
how to change the php attached to query to count only mesages received

I think line 83 need to be changed

Regards

I am looking to have our database queried and have the data returned in the 837P format so we can submit this electronically for payment.

I have a mysql database from a legacy CMS that I need imported into WordPress.

I will need some help with field mapping and the getting the data imported.

There are around 10,000 entries to import. Also, we will need to be able to check for duplicate content as some content has already been moved over.

I have a table with 7 fields. Each record is identified by a unique receipt number. I need to be able to pass the receipt number in a url and have the entire record returned.

Need this done ASAP.

Hi,
We use Webgains affiliate system to list our products, we need an XML file produced from a query and written to a file.

We can supply a sample XML file.

The actual query against the X-Cart store is not an issue for us as we have one already used for Google base

This will be written in PHP, the data is drawn from an X-Cart database.

I have kept this simple but feel free to ask any questions.

You will not have access to our server.

Im not a programmer, so I don’t really understand what is involved in this.

What I would like to do is we run a server that holds all the information. I need a program that will pull the information out of the server and put it to a visual display, that updates, there are many tables that need to be pulled and displayed.

We have several forms linked to our MySql database. There is one particular form we would like displayed on the front end for registered users. The table within the database is already linked although it may need to be tweaked slightly.

The table has about 20 lines including name, phone number, address, etc.

i need to be able to auto-populate a text field (warranty number), in a web form, when data is enetered into the “asset tag number” field.

We have a database with news items, we want to publish this on our Socialengine website.
The news is split in different groups.

When customers go to the news page, they should see the latest X news items.

In the right column they should see all groups where they can choose from.

When chosen, messages about this group are displayed in the centre.

Please only bid if you have experience with Socialengine or Smarty Templates.

I want to develop new pages for my dating site. This pages should list users by certain data, e.g. all users that live in USA, California, or all users with religion Christian who live in USA. There should be a pagination system that list 10 users per page. The script already use a pagination system that you could use.

Initially I would be creating pages for
country, state (e.g. all users in USA and California)
country, state, city
country, religion
country, ethnicity

country is USA or Canada.

For each state I would be creating pages for 10-30 cities. I would be researching the most relevant cities for each state. Another option is to use the cities that are already in the db.

This results in at least 630 (50 USA states + 13 Canada regions) pages, plus secondary pages listing more members.

I don’t know if to create those pages automatically, or manually based on a template. The important thing is that those pages need to be search engine friendly. What would be your recommendation?

The script is coded in PHP and MySQL. New pages can be also PHP, or .html, or whatever else that is SE friendly. Each page should have it’s own title and description meta tags, and H1 tags.

Please send me your recommendation on how to implement this project, so I can decide who I should assign this project to.

I have no PHP or MySQL experience.

I need a script to display all data in one row of my MySQL table.

Suppose I have 3 fields; ID, Name & Number:

ID Name Number
1 ABC 777
2 DEF 888
3 GHI 999

I will create my own HTML page with tables, but want to be able to call just the data contained on row 3 (i.e GHI and 999) into a specified cell.

Furthermore, I want the row to be called to be based on the URl,
e.g. index.php?id=1 for row 1
index.php?id=2 for row 2, etc

Data entry is not required, although I will consider higher offers with this included.

I had managed to get the data into the database but can not figure out how to re-populate form for remote printing / download. The form is already created and posting to the database but I need to re-populate the form (PDF)

I have a MySql database and i need an E-R (Entity-Relationship) Diagram made from this.

This diagram should show how all the tables are connected and the attributes for each entity.

Please also let us know the software you will be using.

Here is the SQL File.
socialroots.com/tmp/ERDIAGRAM.sql.zip