7,368 Topics
| |
I need an Event Registration Script that allows for payment with Paypal & saves form details and Paypal transaction ID to my MySQL DB After the payment has been finalized. I want to have ppl be able to register for camp, and with that choose if they want to preorder … | |
I have a mysql table full of pictures(their path) that are owned by many different users. I need to run the following query and return the results into a 5 column table. The number of rows will be however many it takes to display all the pictures. My query is … | |
Hello every one… I need help with VB 6 and MySQL. How to format the font in rich text box / text box (like - M3(M to power of3) 6 and also need store and select same text. Kindly help me. For information: I just tried some methods with the … | |
hi, i want to add an end time in my query using my time to call column. at the moment i have a time to call which will be the start time however i want to add timetocall as endtime which is 15 mins after the timetocall column. i am … | |
So I have a basic database of books set up. I am trying to use PHP to query the db and send back the results. I can sort of get it to work, but not working how I would like. The issue is that the search term that queries the … | |
Hi all, Fairly new at SQL, and running into the following problem. I am trying to create a query to count the number of unique fields in a column and display, but can't seem to get it right. For example, each day there are x number of entries from y … | |
Hi There! I have a Ajax Function copied from W3Shools I have modified them as my Requirement but it won able to send the xmlHTTP request to my PHP page for result here the function [CODE] function showUser(str,txtId,mth,url) { if (window.XMLHttpRequest) { xmlhttp=new XMLHttpRequest(); } else { xmlhttp=new ActiveXObject("Microsoft.XMLHTTP"); } … | |
You could say I bit off more than I could chew... However, what's done is done and I'm pulling the rest of my hair out and looking to the DaniWeb community for help... I am building a site that people can log in to and select classes that are owned … | |
Hi There, I am using a sql query to show a row to users. The Problem is in the database there are single as well as duplicate records. My 1st code is – Works good if user has no duplicate records; [CODE] SELECT contacts.forenames, contacts.surname, addresses.postcode, contacts.contact_number FROM contacts LEFT … | |
i had created a function which convert the string in Proper case but i want to modify all the records in a particular table by just providing the table name to the function so the function/procedure will have to update all the records in proper case, in record by record … | |
Alright, so I have been working on building a photographer a website. She requested that she would like a page that would allow users to log in and view their proofs and only allow THEM access to their own pictures. I have successfully created a log in page using sessions … | |
Hi friends I am working on a project where I need to show results based upon user queries.I have created the pages,but results are not showing.as I am new to php I can't figure where the problem is. Here is the code [code=php]<html> <head><title>Showing Results</title></head> <body bgcolor="#666666"> <?php include_once "connection.php"; … | |
Hi ALL THere is a data table from a flower shop which looks like [CODE] CustomerID Flower John peony John lily John Lotus Mary peony Mary lily Mary chrysanthemum Lisa chrysanthemum Lisa peony Lisa kapok [/CODE] I would like to find those customers' ID who buy the same n flowers. … | |
| Hi guy's, I am missing something, what on earth is wrong with this script, I can not get it to insert all my values into a table. [CODE] $host="localhost"; // Host name $username="root"; // Mysql username $password="1234"; // Mysql password $db_name="database"; // Database name $tbl_name="input table"; // Table name $que … |
Ok, so I have 2 tables sales_ppl and potential_clients. I want to assign the clients to the sales people in a round robin fashion to distribute them more evenly by state, etc.. like one client gets assigned to the first salesp_name, the second client ot the second salesp_name, third to … | |
hello guys i have a question bout my sql. I create a system in vb.net using my sql database but the problem when i create a report using microsoft report viewer it does not detect mysql database whether i create a new connection..what is the problem??.. | |
Ok, so I will do my best at explaining this... I have set up a database of our company's Parts Ordered forms. I have created a php form that allows users to inject new POs into the database. Which works successfully. I am working on the search form to allow … | |
Hi I have table consist of [B]ID,name,father & mother[/B]. Id is uniq. Now I want that when anyone enter id, it will give [B]name,father and mother[/B]. what is the easy and small way or script. please help me me | |
I would like to calculated an expected profit. I have got the following table: OrderID productID regionID available_volume price sales_per_day What I would like to have: A table grouped by productID and regionID each with the (expected) profit per product and region. Profit is calculated by price*expected_sales with following conditions: … | |
Thanks to a forum member I have moved a little forward but now I am stumped on how to convert a passed value to a variable so it can be used to search a MySQL database. When I use the passed variable as the value I receive the following error: … | |
Hello. To start off I am pretty bad at MySQL and PHP. I want to set something up that people can enter their cell phone numbers and it would be added to a server. Then I could go and send a message out to all of these numbers. I want … | |
Many of the biggest forum-based online communities, including DaniWeb, are powered by vBulletin software. So it came as something of a shock when the BBC reported that a [URL="http://www.bbc.co.uk/news/technology-10714192"]vBulletin security flaw means that any hacker could "easily access the main administrator username and password for a site"[/URL]. But is the … | |
Hi! I'm looking for a way to search and replace certain strings in a database table I have. Those are the commands I execute now from within phpmyadmin: [CODE]UPDATE `feeds` SET `title` = REPLACE(`title`,"ă","a") UPDATE `feeds` SET `title` = REPLACE(`title`,"î","i") UPDATE `feeds` SET `title` = REPLACE(`title`,"ÅŸ","s") UPDATE `feeds` SET `title` … | |
Hi ok I have a table: "rlbTerms" that contains basically a list of terms and their definitions. I create a page with a query that returns all the terms and definitions in a table layout and are order by terms ASC. What I want is a way to create anchor … | |
Hi There, I do have 2 tables; Contacts table, Communications table Contacts table rows are; contact_number, forename, surname Communications table rows are; contact_number, number (number is used for emails) What I have is a little form to check/find out the contact number by filling; surname forename and email. Once they … | |
Hi All, I am working on a booking system for vacation rental properties. I have two (simplified) tables properties and propertyAvailability: properties:- propID propName propertyAvailability:- propID dayOfTheYear availabilityStatus Rather than use dates for the bookings I convert everything to dayOfTheYear (using ColdFusion) and each DOTY for each property has a … | |
Hey guys, I have a table called 'rank' which contains information about music - more definitively, it stores peoples votes (1 to 5) on a particular song. The table layout is as follows: id | songid | userid | blurb | useful | useless | thetime I have written a … | |
There is an a problem on declaring variables on MYSQL stored procedure.The code I used I used is shown below. [CODE]DELIMITER $$ CREATE /*[DEFINER = { user | CURRENT_USER }]*/ PROCEDURE `emp`.`third_SP`() /*LANGUAGE SQL | [NOT] DETERMINISTIC | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES … |
The End.