10,939 Topics
| |
Hi, I'm confused right now about mysql statement I have four tables : form1 | form2 | form3 | form4 | ----------------------------------------------------- k8regNo | form2_ID| k9regNo | form4_ID | consignee | goods | out_date| k9regNo | moveDt | k8regNo | | form2_ID | can i join this four tables..? | |
I am running a chemistry and I sell drugs at differet prices depending on where a member belongs .e gold,silver,diamond. these are membership levels and for any given drug,the price depends on membership levels. look here DrugIg MemberLevel price 1000 gold 1200.00 1000 silver 1000.00 1000 Diamond 1050.00 When entering … | |
Hi, I have a table and I want to create a field to show whether it's the first occurrence (has the oldest date) of the id in that table. the table looks something like this and it's the last field I need help with creating a update code for. ----id----date_of_trans------custom_id--------cust_type----- … | |
I'm testing my script in PHP 5.5, works perfectly until I switch from MySQL to MySQLi. Error: Stack trace: #0 C:\xampp\htdocs\url_rewrite.php(52): tep_db_fetch_array(NULL) #1 C:\xampp\htdocs\url_rewrite.php(106): transform_uri(Array) #2 [internal function]: wrap_href(Array) #3 C:\xampp\htdocs\url_rewrite.php(12): preg_replace_callback('/(<[Aa][ ???]{1...', 'wrap_href', '<!DOCTYPE html>...') #4 [internal function]: callback('<!DOCTYPE html>...', 9) #5 {main} Line 52 of url_rewrite: $cat_Q = … | |
Hi i m just starting learning jquery,javascript ajax and json.. 1-can i import my data from mysql and use it in json the data is nearly 3000 records and it is growing.. 2-if i want to add a new record into my json file how i can do this please … | |
The main issue is that vb net does not pass \ sign into my sql for saving so just trick it to replace the single "\" with double "\\" this will eliminate only one "\" while saving e.g the text box will display d:\\images\\image1.jpeg but mysql table will save it … | |
I have a table that looks like this room date price 128 02-09-2013 15 128 03-09-2013 17 128 04-09-2013 19 If I want to update the field price depending on the dates, First I have the form with the data: while($rows=mysql_fetch_array($listprices)) <? $date[]=$rows[date]; ?> <p style="width:100px;float:left;text-align:center;"><input name="price[]" type="text" value="<? echo … | |
Hey! I am a newbie to php, but very interested in. I am currently on highschool and i am trying to make an appointment SQL table that could be managed, in a simple way, via browser that my sister could use. I was getting some results but then i messed … | |
Hey All, I think I messed up.. I went to PhpMyAdmin and clicked export and exported all my databases with the default options to a sql file. And I downloaded a bzip file with my sql file in it. If I open the sql file it looks like BZh41AY&SYò)É<91>^@B"_<80>P^Pz÷ÿúÿÿÿðÿÿßð`4^^òPÇ»w^Fç-îä»o11ãwÞ|ú^AÜ^Aëo¨ú½Ðî^Nï:.Ó§;Såñݱèó¦ô<9b>ÓÎÞe·<92>ó»7×Ú;<98>£§Nɤ)lÓFP<94>^Tå<8b>Û^T'<86>Çܦî°:n±@÷Þ=öõôût[Àûî÷¼>D<94>}5D7¸ÏyÕ^]zâªR<90><<9c>$P@Ð^H^B50§<94>{Th&Ò<£F<9a>^L^SLF^F<99>^@¢<9a>(hh^Y^@^F<9a>^@^@Ð^@^@^BA$^R<9e><89>詵=ªm4<99>4^Y^@^OPô<9a>h^Z^@^@^Rz©(ÔÊz£ÔñA£&<8d>© ^M^@È^M^@^@^@^H<92>^P #!4ÒzL<9a><9b>Q<99>SÄ<8d>1<88><9b>@<9e><8d>C@ … | |
The below code displays correctly, I need an "IF" statement that prevents displaying rows with 0% in the percent column and I've tried several conditions. None are working. I only want to display rows that has at least 1% in the percent column. Here is the code: $result = mysql_query("SELECT … | |
I need to develop Feedback module in PHP/MySQL. **I would like to know the database design and flow to manage this system.** > There are questions for 2 tools which i need to store in my databse and need to create report like %of Positive Response, % of Negative Response, … | |
Hello , everyone ! I have a question about XML & MySQL . So .. First , what I want to do : I have a Excel file ( .xml saved ) and I want to create a script that insert the XML file in MYSQL Database without any CPanel … | |
Hello everyone! Is it possible to write a query which does the following : UPDATE db.table SET col1 = 1 WHERE col2='something' AND col3 IN ('a','b','c') ELSE SET col1 = 0 Meaning that the rows that don't match the where conditions will also be updated to another value. Note that … | |
hi guys , i am buliding the application using vb.net vs2010 ,mysql server workbench 5.2 . it works fine about the database connection and inserting and all sql operation with the mysql but now the problem is that unable to make the crystal report using that mysql it not supporting … | |
so i have followed this tutorial and i stuck into the activate section of this here's the tutorial. what went wrong? http://youhack.me/2010/04/01/building-a-registration-system-with-email-verification-in-php/comment-page-3/ | |
Hi Master, I cant unlink or update my uploaded image. I can successfully upload image bt i cant use unlink function or Any body help me how can i remove / Update uploaded image. Here is my Controller: public function addProfileLogo() { $data = array(); $errors = ''; if ($_FILES['logo_image']['name'] … | |
| I have this following question about different behaviour of result set for SELECT command and INSERT,UPDATE,DELETE command. My Script: //Part 1: $query="Insert into student values($roll,'$name')" ; $result=mysqli_query($con,$query) or die(mysqli_error($con)); if ($result) { $num=mysqli_affected_rows($con); var_dump($num); echo $num." rows affected."; } //Part 2: $query1="select * from student"; $result=mysqli_query($con,$query1) or die(mysqli_error($con)); if ($result) … |
Dear All, I have 2 tables one tblAssociate and tblData. The link between them is one to many. My search will be based on date time range where if I find even one data in tblData between the set range then I want to show the tblAssociate data. So I … | |
I have a MySQL database with a table that has a field/column labled "user8" (which is the field for users' state). I have this PHP call and its working fine if I call all states individually and I only want numbers of rows. <?PHP mysql_select_db("freeskat_promail") or die(mysql_error()); $result = mysql_query("SELECT … | |
Hi I have written a shell script to execute my data base query mysql -uroot -pshruti2 -B -e "use WebNmsDB;select HEADERINDEX from tekelec_meas_headers where CLLI=$clli and IVALSTART>="$ivalstart" and IVALSTART<"$ivalend" and RPTTYPE="$rpttype";" > win.txt But the output in win.txt is /mysql Ver 14.12 Distrib 5.0.44, for unknown-linux-gnu (x86_64) using EditLine wrapper … | |
Hi can somebody tell me how to delete a table space? Some days ago I deleted a table because I thought I didn't need it anymore. When I tried to recreate it I got this error: ERROR 1813(HY000): Tablespace for table 'test','employees' exists.PLEADE DISCARD the table space before import; I … | |
hi everyone, need to get some advice, when opening mysql connection what is the way using Imports MySql.Data.MySqlClient (use in my current vb.ney proj) or ado connection? (use in my current vb6) thx in advance. | |
In MySQL I have created database "[B][COLOR="Red"]mydata[/COLOR][/B]" with the table "[B][COLOR="red"]contacts[/COLOR][/B]". The fields are as follow: [B][COLOR="green"]ID[/COLOR][/B] (Primary Key) (INT(10) [B][COLOR="green"]Name[/COLOR][/B] VARCHAR(45) [B][COLOR="green"]Title[/COLOR][/B] VARCHAR(45) [B][COLOR="green"]Address[/COLOR][/B] VARCHAR(45) [B][COLOR="Green"]Comments[/COLOR][/B] TEXT Based on info at [url]http://www.webmasterforums.com/php-development/1683-php-form-entering-data-mysql-database.html[/url] I have created following two files: [B][COLOR="green"][COLOR="Red"]new_record.php[/COLOR][/COLOR][/B] [CODE]<? $usr = "myusername"; $pwd = "mypassword"; $db = "mydata"; … | |
Let's use the basic example.. I have a table for tree representation with just 3 columns: ID, PARENT_ID,NAME. If I delete a record X, how can I delete all recursive records that refer as PARENT_ID of deleted record? | |
I am trying to DELETE multiple checkbox values in my database but these values are being retrieved from the database and checkboxes are added here is the code [code] <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name … | |
I have a form that looks something like this: <input name="company" value="company1" /> <input name="company" value="company2" /> <input name="company" value="company3" /> I need to come up with a way to search a mysql table based off what checkboxes a user checks. Keep in mind there can be multiple companies selected. … | |
| A simple insert query works as : INSERT INTO <table-name> VALUES(val1,val2,val3); and DONE. Suppose I wanted to insert only into last two columns I will do as : INSERT INTO <table-name>(col2,col3) VALUES(val2,val3); For less no of columns its not a big deal but what if i have 10 columns and … |
Hello, I have a problem with my php script. Everything works fine except when i will write the data to the database. I get a error Warning: **Wrong parameter count for mysql_query()** Here is my code: <?php include('../sec/inc_mysql_connect.php'); include 'googledistance.class.php'; $sql = "SELECT VVBnummer, Adres, Postcode FROM tblscheidsrechters";// echo($sql); $result … | |
Hi need some help.I am creating a small hotel booking system.I have a mysql Db whith tables rooms, clients, bookings,prices,supplements, supplements booked. I have a search form. Clicking on a calendar img will display a calendar.Clicking on the calendar will insert the date in the box.Also I can select n.persons, … | |
| Hello, i want to search date greater than particular date but my date column datatype in text, How could i do,i used following query SELECT * from $table Where postedDate>='21-August-2013' and postedDate<='22-August-2013' ORDER BY modified_date DESC this not working properly |
The End.