Archive

Posts Tagged ‘simple mysql’

Simple Mysql Query

June 23rd, 2011 Comments off

Need php script to query mysql dbase.

Will look in one table for a date range (date in text format), then will take record IDs and query another table and return records from the table with same ID. Each record in the second table corresponds to one of a set number of items and a sum of each item should be given at the end. Any ID which has a record in the second table, which has certain fields that are zero value should be highlighted yellow.

Simple Mysql Db Conversion

March 14th, 2010 Comments off

I have a front and backend of mysql db/php, the front end of which is currently being displaying in flash, I need, this to be changed to
the items will display in generated html pages
see www.casa-baja.com BUY and RENT section for property display

bid 2 hours

Need Simple Mysql Db Created

November 17th, 2009 Comments off

We need simple MYSQL db created from the following:

1. We have purchased a data list from a data company (if needed DUMP FILE for MYSQL is also available). Please see attached technical file from the data company.

2. Page scarpping of couple of websites will also need to be done to add to the MYSQL db created.

We will need this db to be fully searchable from our website. You must also install the MYSQL db on our server when completed.

PLEASE NOTE: Please do not ask for advance payments as our company will not authorize any payment without any work done. We will fund escrow and will release payments as the milestones are completed.

Simple Mysql Import

November 15th, 2009 Comments off

Hiii

i have this simple data set that needs to be imported to a mysql table, with “word_id”, “word” ..

can somebody help meee

Simple Mysql Query

November 14th, 2009 Comments off

I have a MySQL table with address records and I need to be able to send a date variable and have all the records => that date returned. You can return the results into a text query. I also need the fields seperated by a | (pipe) character.

No input screen needed. I will run the script by passing something like this: www.domainname.com/export.php?091114
That would return all the records from 11/14/09

Simple Mysql/php Coding

June 22nd, 2009 Comments off

I am designing a website where I need the following:

On the products page, there are two drop down menus. One is for the product type, and one is for manufacturer. Once the user has chosen product type, the 2nd drop down updates to show all the manufacturers selling that product type.

Then once the user has chosen manufacturer, all the products for that manufacturer show up and the user can purchase.

I will design the layout of the page, all I need is someone to do the database and PHP scripting.

Thanks

Simple Mysql / Php Script

June 2nd, 2009 Comments off

Project Description: Create a script to run on CRON job to preform the following:

1. Create a new field for “autoresponder”
2.Search the database table “accounts” for entries with the value “Discovery – Info” AND no value for “autoresponder”.
3. Post each entry using the commands in PMB
4. Mark the entries for the field “autoresponder” with the value “imported”

See code in PMB.

Thank you,
Peter

Simple Mysql Script

May 27th, 2009 Comments off

Please let me know the price for the following:

1) Create a new table in MySQL called “Sample Requests”.
2) Search another table for entries that have NEW data for specified fields (make, model and year).
3) Pull the new entries and copy them to the table “Sample Requests”
4) Email new sample requests, nightly, to specified email address in specified format

Thank you,
Peter

Simple Mysql Data Export

May 25th, 2009 Comments off

I have a drupal database, running ubercart

I need an SQL statement to export the products from the DB into a txt file for google base.

Bear