Archive

Posts Tagged ‘mysql script’

Php Mysql Script Adaptation

August 25th, 2011 Comments off

Bidders who have worked with “form mail” from www.tectite.com will be given priority – please advise in your bid message if you have experience with this script?

Full briefing attached, look forward to your bids.

Simple Php Script Install

June 25th, 2011 Comments off

I want to install a php/mysql script to my hosting.

The script can be downloaded from nubuilder.com, and can be installed as per the pdf doc attached.

Simple Php/mysql Script

March 8th, 2010 Comments off

I need a simple script were I can add my domains and information about each domain. I used to do this with microsoft access, but sometimes other people need to add information or modify information for me and not everybody has access. Hope I made it clear enough, otherwise ask any questions.

Thanks

Fix Mysql Script

January 29th, 2010 Comments off

I have a file that is meant to be run via cron jobs, once I get it working right. It is all set up, but there is a problem with the MySQL query. The script works, but only for the first entry it pulls from the database. I want someone to figure out how to make it run for all the entries it pulls from the database.

Should be a very simple job for someone who knows what to look for. I have attached the file so you can view the code yourself.

Mysql Script For Zencart

December 5th, 2009 Comments off

I need a script written to insert a .cvs inventory file into Zencart for multiple product catogories and subcatagories and be able to be ran daily to update inventory availability.

Script Installation

November 29th, 2009 Comments off

I am looking for a programmer to find and install a clone PHP/MYSQL script of http://plrwholesaler.com.

I need a free membership website with a squeeze page as a homepage. Once the buyer subscribes to the free offer they are e-mailed a password to enter the backend of the site. Site will be free, so no payment processing is needed. You do not need to provide design or copy, just the script. If you can use WordPress to accomplish this, even better.

Need A Php Profile Manager

November 9th, 2009 Comments off

I am looking for a PRE BUILT php/mysql script that will allow someone to store their information, like name, address, phone number, email, etc etc.

It should also have the ability to edit the info. There should be some type of admin where the admin can see the list of users.

I should be able to easily add fields to the script. Preferably you can show me the mysql of the script so I can take a look.

Debugg Php Mysql Script

August 26th, 2009 Comments off

I already have a existing script which takes wav file and converts to mp3 using Sox, assigns a random filename, puts the filename in a database, then uploads the file via ftp to the server.

Script was working 6 months ago. Now it is not. Programmer will have admin access.

Short Php/mysql Script & Form

August 11th, 2009 Comments off

Pretty short and simple script to be inserted into website. This is to send a sms message via a http call, loops over for as many names are listed in the text box and inserts the response of the http post to an existing mysql database.

1 Form will have 3 elements
1)TO = Text area = 10 digit numbers separated by comma (FROM will be parsed from page no form piece is needed) strings longer than 10 digits will be discarded
2)A text area (text limiting script provided)
3)Submit Button

Text button will then loop over as many 10 digit strings there are to a http string and replace spaces with % post the result to a mysql database already created, provided

The script will be similar to this format
sendsms.php?username=%(USERNAME)s&password=%(PASSWORD)s&from=+%(FROM)s&to=+%(TO)s&text=%(TEXT)s”"”

The script will have to be formatted using somethign similar to this… (this is part of another python script)
TEXT=TEXT.replace(‘ ‘,’%20′).replace(‘t’,'%20′).replace(‘rn’,'%0D’).replace(‘r’,'%0D’).replace(‘n’,'%0D’)

Responses are

Successfull SMS:
<?xml version=”1.0″ encoding=”utf-8″ ?>
- <SmsResponse>
<version>1</version>
<result>1</result>
<resultstring>success</resultstring>
<description />
<endcause />
</SmsResponse>

Invalid number:
<?xml version=”1.0″ encoding=”utf-8″ ?>
- <SmsResponse>
<version>1</version>
<result>0</result>
<resultstring>failure</resultstring>
<description>Invalid Number</description>
<endcause>19</endcause>
</SmsResponse>

Do not know if should queue this, or post while user is waiting?

Very Simple Php Mysql Script

August 7th, 2009 Comments off

I need a script written that selects a random user from the database of users that are logged into my website, and award them by inserting points into another field. This award needs to select a random person in the morning and a random person in the evening. It must work only when there are at least 5 people logged into the site. It must also keep a database feild of winners and also a page that querys the winners for the week will need to eb created. The script will be activated by cron job unless you know a better way.
Budget is very low for this since it will not take long at all, it’s simple array. But more work will definatly follow this job in the next few weeks if you do good.

Bidders MUST have yahoo messaner, and have a good understanding of English.

Short Php/mysql Script & Form

August 7th, 2009 Comments off

Pretty short and simple script to be inserted into website. This is to send a sms message to a group of people.

1 Form will have 3 elements
1)TO = Text area = 10 digit numbers separated by comma (FROM will be parsed from page no form piece is needed) strings longer than 10 digits will be discarded
2)A text area (text limiting script provided)
3)Submit Button

Text button will then loop over as many 10 digit strings there are to a http string and replace spaces with % post the result to a mysql database already created, provided

Responses are

Successfull SMS:
<?xml version=”1.0″ encoding=”utf-8″ ?>
- <SmsResponse>
<version>1</version>
<result>1</result>
<resultstring>success</resultstring>
<description />
<endcause />
</SmsResponse>

Invalid number:
<?xml version=”1.0″ encoding=”utf-8″ ?>
- <SmsResponse>
<version>1</version>
<result>0</result>
<resultstring>failure</resultstring>
<description>Invalid Number</description>
<endcause>19</endcause>
</SmsResponse>

Do not know if should queue this, or post while user is waiting?

Php/mysql Script Upgrade

August 6th, 2009 Comments off

Marketplace Script upgrade PHP MYSQL

This Marketplace Digital downlaodable product selling site is Already live and there are 100s of Sellers/members in the database.

I am looking a professional php/MYSQL programmer with experience and work with commitment and on time with out any problems.

Features Required

1- Need to charge fee per sale in % percentage: For the following Memberships

Free:
Pro:
Premium:

For above feature requires

For Members Area:
One summary in Members area (will show monthly)
Date – Product – Price – Admin Fee

Total Sale:
Total Fee:

Admin Area
One summary in Admin Area (will show monthly)
S.no – Date- Member/Seller – Product – Sale – Admin Fee – Remove/Edit

In admin For every member will show payable balance i.e.

Total Sale:
Total Fee:

End of month Seller/Member will receive Fee invoice bill with paypal link to pay.
after payment members and admin area will show paid with date and balance will
go to 0.

- Required Cron Job for
i- To Send Invoice Automatically every end of every month
ii- For Sellers Product Subscription – Once a week script will send list of a new products added by the seller to all their subscribers.

All sumaries must requird paging.

2- FTP Upload for Digital Products for Pro and Premium Members only

- Pro/Premium Sellers/Members should be able to access our server their own specific area and upload their own products
and all for every product download link show in the members area so they can take that download
links to ad when post new product.

- Admin msut be able to control Maximum uplaod file plus Total Web Space Allocation per pro/Premium Member.

3- Need To Add Google Checkout Payment Processor for Members
So Members can choose which feature they want to use.

4- Mass Pay Feature Required for Admin To Pay commission
via paypal to all affiliate. Following Summary required.

- Affiliate Username – Paypal Email – Commissions – Paid/Unpaid
- CSV OR TEXT File downloadable Required

5- Stats Required For Admin:
How many products are posted on the site:
How Many Total Prodcuts Sold (Monthly):
Total That Months Sale on the Entire Site:

6- 3 Existing forms needs Captcha code for form security.

Please also PMB

——————

It will be your responsibility that when you add new upgraded features site wroks perfectly ok.

You msut be available on msn, yahoo or gtalk

Give comments for every feature so members and admin know how to use those features.

Work must be completed on time.
Work must be complete Error free.
You must test complete script.
You msut inform us about the progress on a regular base.

Fix Mysql Script

July 16th, 2009 Comments off

The data from my MySQL db is not displaying correctly on my real estate listing site. Users are unable to update their property listings.

I need that fixed and also the feed from the Multiple Listing Service is not updating. That should be just a minor adjustment of changing a url in script.

Also I need to make certain all security holes are closed,

There was a virus on the site that may have destroyed some of the code. I don’t have a full backup.

Php/mysql Script For Crontab

July 13th, 2009 Comments off

**********************************************************************
!+++ this is an adult website +++! – you must be 18 or older and agree to work on an adult content website.
- no gay content, basically you be looking at adult dvd box covers.
**********************************************************************

I have a ‘products’ table in mysql that contains a memo field that contains list of actors in comma separated value format.

e.g:
John Smith, John Doe, Hank Johnson, Jason, Frank Thomas, etc

What I need is a script that I can run via shell/crontab that will make make a list of all the individual actors and dump them into a new table.

Basically ‘table1′ contains thousands of movies with the actors in that movie in a memo field in CSV format. I need the script create a list of all the actors in every movie within the table, remove any duplicates within that list, then create/add the list of actors to a new table; ‘table2′. Once the script runs again via crontab, it should compare all of the actors in table1 with table2 and add any new actors it finds. that’s it

This is what the script should do exactly:

1) do a query within that table/column and find all of the actors and break them up individually – (the comma determines a new value).

2) remove all of the duplicates it finds.

3) dumps the new actors list into a new table, since there will be multiple movies with the same actor, we only want the actors to show up once in the new table.

4) the script must be able to run via crontab/shell

5) once the script reruns via crontab, it must look at table1 and table2 and add any new actors it finds, if it doesn’t find any new actors.. it doesn’t add anymore to the list in table2.

Basically what I’m trying to do is create an index listing page for all the available actors that are on the site

Custom Php/ Mysql Script

July 12th, 2009 Comments off

OK, here goes. I need a custom PHP/ MySQL “work order” script.
I’m swamped with work, and I need this done ASAP, preferably by Wednesday, at the latest.
You will receive full CPanel access to an empty site on my server to complete the project.
Work and testing MUST be done on my server – no exceptions.
Low bids with verifiable experience will be given preference.
By bidding, you agree that I own all rights to the script, and may use, modify, or sell it,
as I see fit.
I will pay immediately via PayPal upon acceptance of the script,
after testing as admin, agent, and user. No deposits, no escrow, no exceptions.
I will give a feedback rating of 10, if this is done to specifications and on time.

The MySQL database will have 4 tables and about 50 fields, total.
You will have full CPanel access, including Legacy File Manager and phpMyAdmin.
The tables are only suggestions – if you can use fewer tables, that’s fine.
Details:

Table 1:
users

Fields:
username
password
(note: users may only view their submitted work orders, updates, images, and docs)

Table 2:
admins

Fields:
username
password
priveleges
(note: admin has full access; agents may view work orders, add updates, images, and docs, but may not delete data)

Table 3:
uploads – admin and agents may upload photos of the work performed for users, as well as other documents. These documents will be written to an images folder and a docs folder. Users may upload images or docs with signup form

Table 4:
user_data – 27 unique fields, including the id field, which will be auto-incremented. actual fields will be provided to the winning bidder – several are date fields

The PHP files:
login.php – login for admins, agents, and users –
when a user logs in, user will be directed to index.php
when an admin or agent logs in, he will be redirected to admin/index.php

signup.php – signup form for users – I will provide a mostly-completed form. You will add uploads and change form as needed.
This form will write the 27 fields of user data, including the username and password, plus any uploads to the database and the appropriate folder.

index.php – when logged in, a user will be able to see his work order, updates, and images (with captions) that pertain to his work order.
user will be able to download docs that are attached to the work order
user will never be able to see other users’ work orders or information.
If user has multiple work orders, user will be able to select one from the group, via dropdown menu.

admin folder – accessed only by admin and agents.
index.php – admin/ agent will be able to view id number, completion status, username, and address for all work orders. admin/ agent can select a property to update and is taken to update.php

update.php – admin/ agent can view work order, write a text description of work done and upload unlimited “before” and “after” photos with captions, and documents with captions.
Information will be dated with date and time values.
admin/ agent can add more data to the update by accessing this page again -
old data is retained and not overwritten

delete.php – only admin can access – use javascript alert to confirm before deleting work order

admin.php – only admin can access – may create new agents or delete agents

Important: All files MUST have include statements for header.php and footer.php.
I will place a generic header and footer on the server in the public_html directory.
That’s it. Not too hard if you’re well-versed in PHP/ MySQL.
I hope to choose a winner this later evening, so bid soon.
P.S. I’m a provider on SL, with excellent feedback. Nothing recent, though, as I’ve been too busy.
Please only bid if you agree to the terms as stated and can complete this within 3 days.
I’m not interested in an open-source or pre-made script. This must be custom.
If you have any questions, please ask.

Mysql Script

July 8th, 2009 Comments off

I have 2 tables :

Table 1 :

EAP PRODUCT
50 10
50 11
50 12
50 13
51 10
51 11
51 12
51 13

Table 2 :
EAP_ PRODUCT_
50 10
50 11
50 13
51 10
51 11
51 12

I would like a sql script that will identify that on table 1, the line “EAP = 50 and PRODUCT = 12″ is not showing on table 2
Same for “EAP = 51 and PRODUCT = 13″.

I want this script to show the missing lines for table 2.

Php/mysql Script For Gift Card

June 15th, 2009 Comments off

I need a php app that will allow a visitor to my site to enter in a “gift card code” that will send the user to a page if the code is valid and to another if the code is not valid.
I would like to have the code entry page and an admin section.

admin section:
- provide the ability to generate as many random codes as needed, and allow me to export them as a .csv file for use on gift cards.
- provide the ability to setup the DB for those codes.
- provide the ability to have several gift cards, which means that a set of codes will only apply per type of card (card=product)
- each product will be able to configure a different success page and failure page.

Simple Php/mysql Script

June 14th, 2009 Comments off

I need a simple php/mysql script which calculates an amount using a few vars and queries. The page should have a preloader and should only be displayed when opened from a specific domain. It should also have a password field – if password does match the calculated value should be inserted into db. You will get detailed instructions – I prefer a fast delivery – urgent and needed asap!

Php & Mysql Script

June 13th, 2009 Comments off

NEEDS TO BE SECURE
PSD needs to coded

DESIGN: http://img41.imageshack.us/img41/7207/27877574.png

Main Features
- RSS Feeds for Lyrics &amp; Spotify Playlist
- Displays YouTube video based on (Artist/Song title) using YouTube API (e.g. http://www.ibm.com/developerworks/xml/library/x-youtubeapi/)
- Display YouTube video image thumbnail
- Stores YouTube url in database so it doesn’t need to query for it in future (faster loading times)
- Search for Lyrics, Spotify Playlist
- Browse Lyrics &amp; Spotify Playlist
- Browse Lyrics by alphabet letters
- Most viewed Lyrics/ Spotfy Playlist
- Display Most popular, newest added, top rated (in AJAX tab)
- Users register (captcha needed)
- SEO friendly URL’s

User Features
- Submit Lyrics
- Submit Spotify playlist URL (Title, Description, members name)
- Rate Lyrics &amp; Spotify URL’s
- Comment on Lyrics and Spotify playlist
- Show user contribution next to their name e.g. (John Lyrics (500) Playlist (3) )
- Ability to add Lyrics &amp; Spotify playlist to their own ‘favorites’

Admin Features
- Add/Edit/Delete Lyrics
- Add/Edit/Delete Spotify Playlist
- Add/Edit/Delete Users
- Edit/Delete Comments
- Add/Edit/Delete news to home page ability for users to comment
- Add/Edit/Delete Featured Lyrics/ Spotify Playlist to main page (shows latest added)

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

Customize Our Php/mysql Script

May 24th, 2009 Comments off

We have a Lead Generation Script written in PHP with mysql.

Please DO NOT bid unless you have excellent feedback rating and have experience working with PHP Scripts.

Project details:

1) Create Custom Form for our lead generation script. We can provide you with a snapshot of what the form needs to look like. Integrate this script into our Existing Database and backend system.

2) We have a SSL certificate installed you will also need to modify the script so it is SSL without the problems of having any Popups saying ‘this pages contains secure and non-secure items’.

Please DO NOT bid on this unless you have experience. Project needs completed As Soon As Possible.

Simple Php&mysql Script Quick

May 6th, 2009 Comments off

Hi all, I need a script in a hurry (within the next 2 or 3 hours of posting this).

Sorry if this is not clear, feel free to ask me questions!

It does not need to be pretty it does not need to be complex, it just needs to be functional!

I need a simple system with 3 tables in a MySQL database, the first table will house the details of a customer, the second table will house the details of an event and the third table will link them via a customer id and appointment id to form an appointment card if you will. The user will need to add, remove, edit and view records from each table, the user does not need to be able to query the database but I will need a function so that customers with booked appointments can be listed with the event and appointment details.

The customer table will need custID, title, first name, last name, address 1, address 2, address 3, postal code, telephone number fields

The event table will need eventID, event name, event length and price fields.

the appointment table will need apptID, date, time, location1, location2, location2, postal code, custID(booking the event) and eventID(what the customer has booked).

Php Mysql Script Installer

April 29th, 2009 Comments off

Looking for a coder to develope a sight from a script that I have in mind The end user demo is located here: http://demos.kubelabs.com/kubelance and the administrator back-end demo here: http://demos.kubelabs.com/kubelance/adm (USER: demo PWD: demo)
I will need the script slightly altered to add afew features and the home page layout to look like Craigs list
Once the site is completed, I don’t mind apying a monthly fee for extra tweeks and bugs that may be in the site work

Xml Php/mysql Script

March 27th, 2009 No comments

I need a script which reads a xml api and compares the values with a mysql database and makes in some steps certain updates in the mysql database.

I need that script asap.

Before I select the bid, I`ll provide the exact manual of the project for the programmer to be sure that it can be done.

Fix My Php/mysql Script

March 23rd, 2009 No comments

I have a script that loads any table, puts all fields and values of a defined row in an associative array, applies an array of changes then writes the data back to the DB as a new record.

It works great except it doesn’t handle null values of Blob fields. It inserts them back in as empty or 0 instead of null. So instead of [BLOB - NULL] It gets copied as: [BLOB - 0 B].

Here’s the current code:

&lt;?

define ( “EW_CONN_HOST”, “localhost”);
define ( “EW_CONN_USER”, “root”);
define ( “EW_CONN_PASS”, “”);
define ( “EW_CONN_DB”, “sl_nulls”);

* ==[ Note: This is where I define the table on which to copy records, the record ID to copy from, and the fields to change

// Which record to select
$whereStmt = ' SiteUserID="43"';
// Which fields to change
$replaceArray = array( "SiteUserID" =&gt; 44 );

copyRecord($whereStmt, $replaceArray, "sitesettings" );

function copyRecord( $whereStmt, $replaceArray, $tableName )
{

$mysql_link = mysql_connect( EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS );
mysql_select_db( EW_CONN_DB, $mysql_link );

$sql = "select * from $tableName where ".$whereStmt. " ;";
$result = mysql_query($sql, $mysql_link)
or die('Query failed:[$sql]&lt;br&gt;Error is: ‘ . mysql_error( $mysql_link ) );

if ($result)
{

// the next row should have the at symbol in front of mysql but I can’t put it because of scriptlance rules.
if ( mysql_num_rows($result) &gt; 0)
{
$row = mysql_fetch_assoc($result); // get the (1st) row as an associative array

foreach ( $row as $key_ =&gt; $value )
{
$slashedrow[ $key_ ] = addslashes( is_null( $row[ $key_ ] ) ? “{[i_am_Null]}” : $row[ $key_ ] );
}

// Run down the passed list of fields we want to modify in the record.
// Replace any existing value with the new value.
// Only fields in the passed array ‘$namesAndValues’ will be affected
foreach ( $replaceArray as $theName =&gt; $theValue )
{
$slashedrow [ $theName ] = addslashes( $theValue );
}

// Rebuild the field list and the value list for the insert
$fieldList = implode(“,”, array_keys($slashedrow) );
$valueList = “‘” . implode(“‘,’”, $slashedrow) . “‘”;
$valueList = preg_replace( “~’{[i_am_Null]}’~msi”,”NULL”,$valueList );

// Run the query
// echo (“Trying to insert into $tableName ( $fieldList ) values (‘$valueList’)”);
// echo $sql

mysql_select_db( EW_CONN_DB, $mysql_link );
$sql =”insert into $tableName ( $fieldList ) values ( $valueList ) ;”;
$result = mysql_query( $sql, $mysql_link )
or die( ‘Query failed:[$sql]&lt;br&gt;Error is: ‘ . mysql_error( $mysql_link ) );
}
}
}

?&gt;

Please make sure you can fix the problem with the data given in the project description. To successfully complete this project, the blob fields shouild be copied exactly including NULL if they are NULL.

This needs to be done within 24 hours of awarding the project.

Fix My Php/mysql Script

March 21st, 2009 No comments

I have a script that loads a table, puts all fields and values of a defined row in an associative array, applies an array of changes then writes the data back to the DB as a new record.

It works great except it doesn’t handle null values well. It inserts them back in as empty or 0 instead of null.

I need someone to fix it tonight.

Here’s the code:

// This is where I define the table on which to copy records, the record ID to copy from, and the fields to change

$whereStmt = ‘ SiteUserID=”43″‘;
$replaceArray = array( “SiteUserID” =&gt; $conn-&gt;Insert_ID() );
copyRecord($whereStmt, $replaceArray, “sitesettings” );

function copyRecord($whereStmt,$replaceArray,$tableName){

$link = mysql_connect(EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS);
mysql_select_db(EW_CONN_DB, $link);
$sql =”select * from $tableName where “.$whereStmt;
$result = mysql_query($sql) or die(‘Query failed: ‘ . mysql_error());

if ($result) {

// the next row should have the at symbol in front of mysql but I can’t put it because of scriptlance rules.
if ( mysql_num_rows($result) &gt; 0) {
$row = mysql_fetch_assoc($result); // get the (1st) row as an associative array

foreach ($row as $key =&gt; $value) {
$slashedrow[$key] = addslashes($row[$key]); }

// Run down the passed list of fields we want to modify in the record.
// Replace any existing value with the new value.
// Only fields in the passed array ‘$namesAndValues’ will be affected
foreach ($replaceArray as $theName =&gt; $theValue) {
$slashedrow [$theName] = addslashes($theValue);}

// Rebuild the field list and the value list for the insert
$fieldList = implode(“,”, array_keys($slashedrow) );
$valueList = implode(“‘,’”, $slashedrow);

// Run the query
// echo (“Trying to insert into $tableName ( $fieldList ) values (‘$valueList’)”);

$link = mysql_connect(EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS);
mysql_select_db(EW_CONN_DB, $link);
$sql =”insert into $tableName ( $fieldList ) values (‘$valueList’)”;
$result = mysql_query($sql) or die(‘Query failed: ‘ . mysql_error());

}
}
}

This code should work with any database where the table has a UserID field as the key. I will not provide a connection to the actual database as it is not needed.

Corrected code shoud be delivered within 24 hours of being awarded the project.

Fix My Php/mysql Script

March 19th, 2009 No comments

I have a script that loads a table, puts all fields and values of a defined row in an associative array, applies an array of changes then writes the data back to the DB as a new record.

It works great except it doesn’t handle null values well. It inserts them back in as empty or 0 instead of null.

I need someone to fix it tonight.

Here’s the code:

[code]

function copyRecord($whereStmt,$replaceArray,$tableName){

$link = mysql_connect(EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS);
mysql_select_db(EW_CONN_DB, $link);
$sql ="select * from $tableName where ".$whereStmt;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());

if ($result) {

// the next row should have the at symbol in front of mysql but I can't put it because of scriptlance rules.
if ( mysql_num_rows($result) > 0) {
$row = mysql_fetch_assoc($result); // get the (1st) row as an associative array

foreach ($row as $key => $value) {
$slashedrow[$key] = addslashes($row[$key]); }

// Run down the passed list of fields we want to modify in the record.
// Replace any existing value with the new value.
// Only fields in the passed array '$namesAndValues' will be affected
foreach ($replaceArray as $theName => $theValue) {
$slashedrow [$theName] = addslashes($theValue);}

// Rebuild the field list and the value list for the insert
$fieldList = implode(",", array_keys($slashedrow) );
$valueList = implode("','", $slashedrow);

// Run the query
// echo ("Trying to insert into $tableName ( $fieldList ) values ('$valueList')");

$link = mysql_connect(EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS);
mysql_select_db(EW_CONN_DB, $link);
$sql ="insert into $tableName ( $fieldList ) values ('$valueList')";
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());

}
}
}

// This is where I define the table, record ID and fields to change

$whereStmt = ' SiteUserID="43"';
$replaceArray = array( "SiteUserID" => $conn->Insert_ID() );
copyRecord($whereStmt, $replaceArray, "sitesettings" );

[/code]

Simple Php/mysql Script

March 18th, 2009 No comments

This is what I’m looking for:

I want a MySQL database with the following fields:

Cgi-perl/mysql Script Mod

March 16th, 2009 No comments

I have an autoresponder app. On a post submit it will add info to a user account and send an email out through a perl script. I need the script to be altered to be able to add the user post submit to multiple accounts between 1 to 5 if possible.

Bear