10,939 Topics

Member Avatar for
Member Avatar for sagisgirl

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..?

Member Avatar for sagisgirl
0
465
Member Avatar for mwenyenia07

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 …

Member Avatar for LastMitch
0
147
Member Avatar for adishardis

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----- …

Member Avatar for broj1
0
185
Member Avatar for dfaulted

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 = …

Member Avatar for dfaulted
0
420
Member Avatar for asaidi

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 …

Member Avatar for IIM
0
134
Member Avatar for wesh09

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 …

Member Avatar for Begginnerdev
0
198
Member Avatar for milan.sabic

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 …

Member Avatar for milan.sabic
0
294
Member Avatar for jotapx

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 …

Member Avatar for EvolutionFallen
0
530
Member Avatar for woodenduck

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@ …

Member Avatar for woodenduck
0
240
Member Avatar for ourloop

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 …

Member Avatar for minitauros
0
181
Member Avatar for PriteshP23

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, …

Member Avatar for broj1
0
1K
Member Avatar for MWEB

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 …

Member Avatar for minitauros
0
160
Member Avatar for ktsangop

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 …

Member Avatar for ktsangop
0
236
Member Avatar for shashikumar s g

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 …

Member Avatar for Begginnerdev
0
906
Member Avatar for andreiviziru

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/

Member Avatar for andreiviziru
0
444
Member Avatar for rjony321

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'] …

Member Avatar for cereal
0
6K
Member Avatar for Rahul47

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) …

Member Avatar for Rahul47
0
2K
Member Avatar for newbie14

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 …

Member Avatar for 1stDAN
0
228
Member Avatar for ourloop

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 …

Member Avatar for ourloop
0
19K
Member Avatar for leghorn

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 …

Member Avatar for 1stDAN
0
419
Member Avatar for Fiorentino01^

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 …

Member Avatar for Fiorentino01^
0
461
Member Avatar for jaasaria

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.

Member Avatar for Rahul47
0
147
Member Avatar for leokuz

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"; …

Member Avatar for Rahul47
0
289
Member Avatar for Stju

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?

Member Avatar for Rahul47
0
126
Member Avatar for davisliwo

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 …

Member Avatar for Rahul47
0
179
Member Avatar for gomedigap

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. …

Member Avatar for Rahul47
0
121
Member Avatar for Rahul47

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 …

Member Avatar for Rahul47
0
202
Member Avatar for jenthevb

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 …

Member Avatar for Atli
0
510
Member Avatar for Fiorentino01^

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, …

Member Avatar for Fiorentino01^
0
152
Member Avatar for angiesavio

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

Member Avatar for angiesavio
0
149

The End.