Search Results

Search found 14784 results on 592 pages for 'mysql replication'.

Page 307/592 | < Previous Page | 303 304 305 306 307 308 309 310 311 312 313 314  | Next Page >

• How Assigning query return value to local a variable, and how to use that in where condition?

  - by Ayyappan.Anbalagan

  I am using mysql stored procedure; I need to assign query retuned value to local variable. And i have to check the condition using the local variable..... or It my query Select Meterial_Id from hemaepdb.transaction where CustId=1; Instead of Meterial_Id i need to get the Meterial_name from Material table.....

  Read the article

• what does select @@identity do?

  - by every_answer_gets_a_point

  i am connecting to a mysql database through excel using odbc what does this line do? Set rs = oConn.Execute("SELECT @@identity", , adCmdText) i am having trouble updating the database: With rs .AddNew ' create a new record ' add values to each field in the record .Fields("datapath") = dpath .Fields("analysistime") = atime .Fields("reporttime") = rtime .Fields("lastcalib") = lcalib .Fields("analystname") = aname .Fields("reportname") = rname .Fields("batchstate") = "bstate" .Fields("instrument") = "NA" .Update ' stores the new record End With it is ONLY updating .Fields("instrument") = "NA", but for all other fields it is putting NULL values

  Read the article

• give preference to print array values in php

  - by Bharanikumar

  Hi , I have country table, i fetch all values and moved into array , these value i like to populate into combo/dropdown list , here i want to do some magic things, that is , for my site most of the users coming from uk,us,Australia,Romain and few, So i like to populate by my preference , is there any array will do this magic work, else is it possible mysql query , So final question is , Populate country name into combo based on my prefernce , Thanks

  Read the article

• Online booking system with php

  - by Felicita

  Im looking for any tutorial for online booking and reservation using php and mysql. I cant find so much from google.

  Read the article

• InnoDB - Two foreign keys on the same column from one table

  - by makeflo

  Hey Guys, i have a project table which has a image_id field and a newsimage_id field. Both are linked to the image table. But InnoDB doesn't allow me to set a foreign key for both fields to the same column (id). Is there a way I can do this or is it not possible? I'm using MySQL through MAMP. Thanks in advance!!

  Read the article

• how to get latest entry of a item when item have multiple rows?

  - by I Like PHP

  i have an table tbl_exp id| exp_id|qnty| last_update 1 | 12 | 10|2010-05-18 19:34:29 2 | 13 | 50|2010-05-19 19:34:29 3 | 12 | 50|2010-05-19 19:34:29 4 | 15 | 50|2010-05-18 19:34:29 5 | 18 | 50|2010-05-20 19:34:29 6 | 13 | 70|2010-05-20 19:34:29 now i need only latest entry of each exp_id id| exp_id|qnty| last_update 3 | 12 | 50|2010-05-19 19:34:29 6 | 13 | 70|2010-05-20 19:34:29 4 | 15 | 50|2010-05-18 19:34:29 5 | 18 | 50|2010-05-20 19:34:29 please suggest me the mysql query to retrive above result?? thanks!

  Read the article

• What is the efficient way to make a permission system?

  - by WEBProject

  Currently im just using something like: in the DB Table: access: home,register,login and then in each page: if(!Functions::has_rights('content')) { Functions::noAccess(); } is there more efficient way to do it, php & MySQL? i may want to gain access even to several parts a page, for example: user can read a page, but doesnt comment to it, and I dont want to build a separate system to each module. Thanks in advanced, Tal.

  Read the article

• How can i fetch all data from any table of a test DB and DUMP it on the production db in same tablen

  - by Parth

  How can i fetch all data from any table of a test DB and DUMP it on the production db in same tablename(structure)? in Mysql using PHP code? Please help me..

  Read the article

• Foreign keys - temporarily bypass?

  - by Industrial

  Hi, I have just started to learn about the pros of foreign keys in database design (mySQL / innoDB) and I wonder if there's any way to temporarily bypass the foreign key when doing a specific delete query, to just delete in the parent table, and not from the linked child tables. Thanks

  Read the article

• From Now() to Current_timestamp in Postgresql

  - by xRobot

  In mysql I am able to do this: SELECT * FROM table WHERE auth_user.lastactivity > NOW() - 100 now in postgresql I am using this query: SELECT * FROM table WHERE auth_user.lastactivity > CURRENT_TIMESTAMP - 100 but I get this error: operator does not exist: timestamp with time zone - integer How can I resolve ?

  Read the article

• how to write a bat file to execute the .sql fiel

  - by ganuke

  I want to execute query in side the db.sql file using MySQL 5.1 in windows environment. Can any one help me to this. I want to do this by runing a bat file.

  Read the article

• difference between cn.execute and rs.update?

  - by every_answer_gets_a_point

  i am connecting to mysql from excel using odbc. the following illustrates how i am updating the rs With rs .AddNew ' create a new record ' add values to each field in the record .Fields("datapath") = dpath .Fields("analysistime") = atime .Fields("reporttime") = rtime .Fields("lastcalib") = lcalib .Fields("analystname") = aname .Fields("reportname") = rname .Fields("batchstate") = "bstate" .Fields("instrument") = "NA" .Update ' stores the new record End With the question is why is there a need to run cn.execute after this? havent i already updated the rs with rs.update?

  Read the article

• How would Sphinx Search index / handle JSON files?

  - by ming yeow

  I have a mysql database that stores mainly JSON objects. I am thinking of using Sphinx to search through it - but i was wondering how would i index and retrieve these json objects?

  Read the article

• What is the best way to send data from Java to PHP?

  - by Daeyun

  I want to access a MySQL database from Java, but remote connection is disabled by the host. So I will send the data to PHP and then PHP will locally access the database. The data is pretty big (about 2~4kb) I've never done this before. What should I do?

  Read the article

• How should I go about adding slashes to only single quotes and ignoring double quotes?

  - by atwellpub

  How should I go about adding slashes to only single quotes and ignoring double quotes? I am using php. I would only like to escape single quotes to prevent my php mysql queries from breaking. Thank you!

  Read the article

• mysql_fetch_row() not a valid result resource

  - by user1717305

  I am confused, I don't know what's wrong. I'm about to transfer all data from my first table to the other. Here is my code: $getdata = mysql_query("SELECT Quantity, Description, Total FROM ordercart"); while($row = mysql_fetch_row($getdata)) { foreach($row as $cell){ $query1 = mysql_query("INSERT INTO ordermem (Quantity, Description, Total) VALUES ($cell)",$connect); } mysql_free_result($getdata); } I get the error: Warning: mysql_fetch_row(): 5 is not a valid MySQL result resource.

  Read the article

• Why is this SQL query throwing Warnings?

  - by user355367

  $resultnx = mysql_query("SELECT * FROM `emails` WHERE `email` = '{$email}'"); $num_rows = mysql_num_rows($resultnx); gets this warning Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ....

  Read the article

• problem in creating a trigger

  - by mohanish

  Hi Bill I am facing a problem in creating a trigger and i am not sure why this is erroring out.can you please help me. I have described the problem in this link below http://forums.mysql.com/read.php?99,365942,365942#msg-365942.

  Read the article

• Using Hidden Iframes to run PHP scripts - good? bad? opinions?

  - by jon

  I am a little bit new to the PHP/MYSQL arena, and had an idea to be able to interact with my Database by using a hidden Iframe to run PHP pages in the background(iframe) on events without having to leave the current page? Good? Bad? Common Practice? Opinions?

  Read the article

• manage user permissions in php

  - by user420528

  i am creating a marks management system using php & mysqlwhere the concerned faculty will be able to login and enter the marks of the students. i can go with a simple table but the problem is there are 288 different subjects for which marks must be entered. So creating a mysql table with so many subjects does not look good for me. please suggest me the best way to manage user permissions so that only the corresponding faculty will be able to enter marks

  Read the article

• How to show only few lines from a body text

  - by saquib

  Hi, I have a mySql database i want to display only 10 words from its body field which contain html codes, How i can do that, is there any php function to do that.

  Read the article

• How to set up a database and API web page to accept POST updates from iPhone?

  - by lionfly

  Hi there, I am developing an iPhone app, which now can update Twitter account with GPS coordinates in real-time, by the Twitter API link: http://username:[email protected]/statuses/update.xml , and I am looking at how to make my own database to accept updates from iPhone, via a similar API page. It seems a .php page can serve as the API, and MySQL can serve as the database. What are the good ways of doing it? Any template code and tutorial please?

  Read the article

• How to lookup data based on the next sunday of the week

  - by sman591

  I need to lookup a row of data from MySQL based on the next Sunday of the week. Anyone know how?

  Read the article

• Looking for a tutorial about dynamic mysql calendar

  - by jasmine

  Im Looking for a tutorial recommendation about dynamic mysql calendar. Thanks in advance

  Read the article

• how to get latet entry of a item when item have multiple rows?

  - by I Like PHP

  i have an table tbl_exp id| exp_id|qnty| last_update 1 | 12 | 10|2010-05-18 19:34:29 2 | 13 | 50|2010-05-19 19:34:29 3 | 12 | 50|2010-05-19 19:34:29 4 | 15 | 50|2010-05-18 19:34:29 5 | 18 | 50|2010-05-20 19:34:29 6 | 13 | 70|2010-05-20 19:34:29 now i need only latest entry of each exp_id id| exp_id|qnty| last_update 3 | 12 | 50|2010-05-19 19:34:29 6 | 13 | 70|2010-05-20 19:34:29 4 | 15 | 50|2010-05-18 19:34:29 5 | 18 | 50|2010-05-20 19:34:29 please suggest me the mysql query to retrive above result?? thanks!

  Read the article

< Previous Page | 303 304 305 306 307 308 309 310 311 312 313 314  | Next Page >