7,368 Topics
| |
[B] [I]please [/I][/B]I need to how tow [B]MySQL databases synchronize [/B]each to other . thanks for everything . mostafa | |
Hi, I have the following table: Name Row(number) Nico 1 Marko 2 Peter 3 Joy 4 Kimi 5 I delete Nico and Joy: Marko 2 Peter 3 Kimi 5 And how to make a table would look as follows: Marko 1 Peter 2 Kimi 3 How to automatically re-arranged in … | |
Hi! I'm looking to update a field in a table via PHP, basically asking it to change a fields contents to 'foo' if it currently contains the word 'bar', or to change its contents to 'key' if it currently contains the word 'board'. I can't seem to get the syntax … | |
I ran this query on my database: [code=sql]select O.ORDER_NUM, O.ORDER_DATE, O.CUSTOMER_NUM, C.CUSTOMER_NAME, C.STREET, C.CITY, C.STATE, C.ZIP from CUSTOMER C, ORDERS O where O.CUSTOMER_NUM =148 and C.CUSTOMER_NUM = 148;[/code] +-----------+------------+--------------+--------------------------+----------------+----------+-------+-------+ | ORDER_NUM | ORDER_DATE | CUSTOMER_NUM | CUSTOMER_NAME | STREET | CITY | STATE | ZIP | +-----------+------------+--------------+--------------------------+----------------+----------+-------+-------+ | 21608 | … | |
Hello, I'm having an issue with a MySQL/PHP site I'm working on. I'm new to both. I've seen several posts that were similar or same but was unable to derive a solution based on my code. I have a form that will submit HTML code to a database. I know … | |
Hi, I wonder if there is a solution to my query; I need to be able to produce a weekly report that will display all daily totals for that week or any previous week. I have toyed around with the weekday() function and the Week() function, but I don't know … | |
I have 3 tables. Company, phone, companyPhone. The company table has an auto_increment companyID primaryKey The phone table has an auto_increment phoneID primaryKey The companyPhone table row is made up the companyID, and the phoneID. On my form the user will enter company information and the company phone number. After … | |
Hi, Does anyone know of any simple to use software for bulk uploading products to an ecommerce website database? I dont know enough PHP or MYSQL to write my own scripts, so I was hoping there is a program to do it for me. I will have to use a … | |
Pardon this post here as I didn't see any Postgres forum. I have a table with a 16 length bit value. Can someone please help me how I do the where clause on my select? example data for that field 0000000000000001 0000000000000011 0000000000000010 how would I select one of the … | |
In this days, I am making dictionary site with PHP & Mysql. I write SQL like this [CODE]select * from dblist where `Word`='A' Union select * from dblist where `Word`like 'A%' Union select * from dblist where `Word`='%A%' Union select * from dblist where `Word`='%A'[/CODE] I don't use [CODE]`Word`='A' OR … | |
ok so i am doin a table that has info on all 44 presidents. i have to show the state the produces the biggest number of presidents...i am not sure how to do it. here is a lil bit of the table for you . I want it to show … | |
How can I monitor my MYSQL database and the number number of threads and connections it has from a remote computer. my database is running on a ubuntu box and I would like to monitor the database from any of the three major platforms (windows, mac, linux) | |
ok so i am working on a program that has a table of all the presidents and info on each of them. i tried to insert the date of their birthdays and deaths, but just got 0000-00-00 for a result when i went to see what the outcome looked like. … | |
[B]AUTO INCREMENT definition mismatch for Timestamp Datatype.[/B] Please explain what is the cause for this? | |
I want to find the percentage for each question’s answer and how many user response to that question The answer either yes , no, escaped (null) Table structure :[CODE] CREATE TABLE useranswers ( userAnswerID int(10) unsigned NOT NULL auto_increment, answer varchar(45) default NULL, userType varchar(45) default NULL, ques_tesxt varchar(300) default … | |
When I fetch the records from the LIKE the query returns no results but when I fetch records from the equal to (=) then the query returns results. Following user name are stored in the database: (1) `~@#$%'\|/?.><^&%@()-_+-: (2) (){}[]|\/?"*&^%$#@sujeet` I am searching the records from the LIKE operator as … | |
hello can any 1 give me the idea if we use single web page for both admin and user then how to hide admin priviliges from user?? | |
Hi, I have 3 sentences in table. These are the sentences. [code] Spatio-temporal tracking and phylodynamics prm. These are prM based values. All MR values are greater intensity than PRM vales. Values specified are equal to PRm values and PRM-lacZ. [/code] If user specifies the query like this: prm* i … | |
Ok help please , cant get my head around this .... i need to build a database that will hold the following : width x drop = price what i actually want to do is a quotation form for my website where the costumer will input the width and the … | |
Hi all, I have a table in which i have 2 columns.i.e. name and ID number as Table1 -------------------------- Name || ID number -------------------------- Mark || 204 Roger || 207 Ronny || 209 Robert || 309 mac || 390 black || Mark || Roger || Mac || Mark || Ronny … | |
Hello. I am trying to understand how to solve a problem I have run across involving self-referential tables. The table stores the name and various relevant details about musical artists. One detail I want to be able to list is the artist's influences. The artist's influences are themselves artists. And, … | |
Hello I would like to know how to display orders placed on a certain day. For e.g. I would like to display orders placed today. My MySQL database contains the following tables: 1). orders 2). orders_statuses Under [B]orders[/B], I have the following fields: 1). orders_id 2). orders_placed_date Under [B]orders_statuses[/B], I … | |
Is it possible that select records for example 20 records from the table randomly, but in addition 1 certain record for example 3rd record. Let me explain: SELECT * from table limit 1, 20 rand(); In this way I will get 20 randomly records but I want that one certain … | |
Hi all I've been trying to find a way of doing this and have come up dry. Is this possible? If so could someone tell me how to go about this? Much appreciated Venom Rush | |
Hello, I am making some progress on this database I am building for practice...I am new to programming...and was wondering if there is any way to add navigation functionality using buttons or links under the fields being displayed to go to the next or previous record. I Also am trying … | |
Hi, I'm not entirely sure which forum to post this question because I cannot determine whether it's a MySQL, Joomla, or PHP issue. But I will post it here, as some of you may know about this. I am using a custom built "user" table in my MySQL database, and … | |
I have recently taken over the running of an e-commerce website. Once in a while i will need to increase the prices of certain products by any given percenatge. The products all have a code starting with 3 letters and then digits. for instance: ffc1234, ffc1245, dcc4544, dcc5799, vff300, and … | |
hi there, help anyone..i have problem in my query..i need to query with multiple values. for example..in where patientid could be one or more values like this where element = 'element a' or 'element b' or 'element c'...the values are dependent on what the user inputs in his search list.. … |
The End.