7,368 Topics
| |
Hi there, I have a form that collects array values and then posts it to another page.eg [CODE]<form action="page2" method="POST"> <input name = "myid[]" type="text" value="1"> <input name = "myid[]" type="text" value="4"> <input name = "myid[]" type="text" value="6"> </form>[/CODE] the second page then receives the array and implodes the results … | |
Basically I've got a working drop-down menu php/mysql script running using the internet as my guide. But one thing I don't really understand is the significance of the period in [CODE]$options.[/CODE] [CODE]$sql = "SELECT DISTINCT artist FROM hits ORDER BY artist"; $result = mysql_query($sql); while ($row=mysql_fetch_array($result)) { $artist=$row["artist"]; $options.="<option>$artist</option>"; } … | |
I just started learning mysql (today) and I figured out how to insert data into a table and how I am learning how to echo the data. Here is what I have so far: [CODE]$email = mysql_query("SELECT * FROM mail") or die (mysql_error()); $row = mysql_fetch_array($email); echo $row['email'];[/CODE] This does … | |
hi, i was wondering if any you guys knew of a simple way to sync from an access database offline to a mysql online database? currently my system is running on php/mysql. there is another company who have a system that uses an access database behind it. i can access … | |
Hi everyone, If there are multiple hyperlinks in a webpage, How do I recognize them using java script. Also How do I store the content of the hyperlink in a variable , so that the data stored in the variable will be used the query a database and populate results … | |
Hi everyone, I have a web application developed using php. I want to add a new feature in it. When the user searches for some book details, all the book details are displayed. Now when the user clicks on a book name in the search results, He will be redirected … | |
[CODE]select * from Table where data=2.6[/CODE] After running the above query, db returned an empty result set. But Seen from table, there are many rows matching data=2.6 criterion. Here the type of 'data' column is FLOAT. If changing the value to an integer like 'where data=2', the matched result sets … | |
Hi, I have a mysql database for stock records in the pub I work in. The code below displays the list of items and sizes, what I need is to be able to update several rows by subtracting the number in the qty column from the bal column in the … | |
Hi guys, I have a table, the table name is account, its have 2 fields : membersid, and categoryid i want to change the categoryid field content, i run this in phpmyadmin : [QUOTE]update `account` set categoryid = replace (categoryid, '1' , '2');[/QUOTE] but get this error message [QUOTE]#1062 - … | |
Hello. I stored dateFrom & dateTo as String '11/11/2011' and '11/25/2011' [mm/dd/yyyy] format. now when i fired query as below [code] select (case when pp_send_date_to_district between '11/01/2012' and '11/25/2012' then 'Dec/2012' else 0 end ) as Months, sum(case when pp_send_date_to_district between '11/01/2012' and '11/25/2012' then 1 else 0 end ) … | |
Hi, well im working on a project for school but I can't seem to get it to work. Its an app that is connected to a DB with 3 tables, this is my sql syntax of the db: [CODE] Table structure for table `income` CREATE TABLE `income` ( `idincome` int(11) … | |
A table contains results of a match. Each match is a series of 7-9 games (different leagues share same match schedule table and play different best of "x" matches), such as: id teamA game1 game2 . . . game9 Need to calculate average based on game total and number of … | |
This seems like it should be a simple query but I think I have my eyes in backwards... Give me all the users living in Jefferson, Bingham, Butte, Bonneville and Madison counties in the state of Idaho. [code]SELECT * FROM table WHERE county='Jefferson' OR county='Bingham' OR county='Butte' OR county='Bonneville' OR … | |
data does not come at phpmysqladmin. and also shows this warning Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\com\com.php on line 75 Thank you for submission [CODE]<?php if ( isset($_POST['username'])) { $ret = add_to_database(); if (!$ret) { print "Error: Database error"; } else { print "Thank … | |
Hello everone, I am designing a website with php for different users. And I will like to give each user a unique page according to what their input in the form is, I want to MySQL database to save the information and retrieve it each time a user login into … | |
hi every one, equivalent ExtractValue() function to read xml content stored in table in mysql 5.0 version | |
Hello, I have a script that among other things, creates a table with a variable being the table name. This worked fine when i was using the variable "$name". Since then I've realized that i need the table name to be "$merchid" (primary key from previous table. I've used "$newid … | |
Hello, I have two databases in MySql... Master database and child database.. In master database there are two tables...Accountant(Having Primary Key AccountID) and Client(Having Primary Key ClientID)... Now for each client master database remains same and child database is created for each client... In child database,there are several tables related … | |
I am attempting to retrieve records 7 days before the termination date. The code below doesn't seem to work. [CODE] CREATE VIEW vwRenewSubscription AS SELECT c1.id as userId, p1.id subscriptionId, a1.id as advertisementPlanId, c1.companyName, c1.rocNo, a1.description, a1.fees,a1.duration FROM subscription AS p1, subscription AS p2, corporate AS c1, advertisementplan AS a1 … | |
Hi all Not sure if im posting in the right section so sorry if i am. I have been looking for an open source asset/inventory solution for a friend. I came across Free CMMS on sourceforge.net and for ease of installation and testing installed the latest version of XAMPP as … | |
I came again across "http://www.mysqludf.org/lib_mysqludf_str/index.php" and found the library useful but I could not figured out how to install and use them on WAMP Server version 2.0 with MySQL version 5.1.36 on Windows 7. I did followings steps but did not get the work done: 1. Created a directory named … | |
i have a combobox and few textboxes in Form1. i inserted new item into combobox by entering new item in one of the textbox. i manage to add item into combobox in Form 1. But how can i achieve if the item i added in Form1 to be inserted automatically … | |
[CODE]----------------------------------------------------------- chan1 |chan2 |chan3 | captureTime |id ----------------------------------------------------------- 20 |21 |25 | 2011-10-11 00:00:00 |1 ----------------------------------------------------------- 21 |18 |19 | 2011-10-11 00:01:00 |1 ----------------------------------------------------------- .... .... .... ----------------------------------------------------------- 20 |25 |21 | 2011-10-11 00:15:00 |1 ----------------------------------------------------------- 21 |18 |14 | 2011-10-11 00:16:00 |1 .... .... .... ----------------------------------------------------------- 15 |26 |23 … | |
very new to database and mysql, i would like to know if it is possible to create a drop down box using just mysql within the database and if so how is it down. | |
Guys i have a small question.That is i have already developed a Java Desktop Application with interacts with the MySql Database.But i'm using MySql commandline client.Some youtube tutorials,i saw they are using MySql workbench to configure the Dtabase.So i want to know is there any issue if i use commandline … | |
i want to display the auto increment field in mysql database no using php. using the code the output that am getting is zero in the $id field , what could i be missing echo"<table bordercolor='#CCFF99' bgcolor='#FFFFCC'>"; echo "<tr bgcolor='#CCFF99'><td>Order No:</td>"; echo"<td bgcolor='#FFCC66'>$id</td>"; echo "<tr bgcolor='#CCFF99'><td>Topic:</td>"; echo"<td bgcolor='#FFCC66'>$topic</td>"; echo "<tr … | |
I get this error in my Java programme which coded by me according to a tutorial.I coded it to connect my Java App with MySql database.This is the code.[CODE]package Gui; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.sql.SQLException; /** * * */ public class connectionconfig { private connectionconfig() … | |
Guys i'm using MySql commandline client.When i log it just asks the password and it doesn't show username.Please tell me is there any command or any other way to check my username.Plzzzz...... | |
The End.