Restore Link
I deleted a comments link in my database, Is there a way to restore it again? I really need to get this back if at all posible?
View Complete Forum Thread with Replies
Related Forum Messages:
Many-to-many Using Link Table And Selecting Only Rows That Have More Than One Link
Okay, I am not 100% sure if I am explaining this correctly, which is why I am having a hard time finding answers via a search. Here is my db structure: tbl_object ---------- object_pk name etc tbl_category ------------ category_pk name tbl_object_category_link ------------------------ object_fk category_fk I have successfully ran queries where I am looking for objects in just one category using: SELECT tbl_object.name FROM tbl_object, tbl_category WHERE object_pk=object_fk AND category_pk="2" However, if I want to only get objects that are in multiple categories, I am stuck. I can either pull ones that are in either/or like this: SELECT tbl_object.name FROM tbl_object, tbl_category WHERE object_pk=object_fk AND (category_pk="2" OR category_pk="1") The next "logical" step for me was to to this: SELECT tbl_object.name FROM tbl_object, tbl_category WHERE object_pk=object_fk AND category_pk="2" AND category_pk="1"
View Replies !
Web Link
I've tried and tried, but I can't seem to find the version history section for their MySQL Administrator program. I've just downloaded v1.0.19, but have no idea what is in this that isn't in v1.0.18.
View Replies !
Set Up A Link
I am having to construct a database by hand from a specification given to us by an outside client. Their table layout examples have: Field, Attribute, Type, Link. In link are (as example) MOD_CODE and MOD_TYPE - both are other tables in the database. Are these foreign keys? And if so what do I need to do to set up those links?
View Replies !
Getting A New Link Id
I have a mysql database and I would like to generate a new link id that has a higher value than the current link id in the database. This is probably a simple question, but how do you make a query to ensure that you get a higher id for the newer items you add in the database?
View Replies !
Link Broken
------=_NextPart_000_004F_01C34CC0.ACC94810 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have problem to download=20 http://www.mysql.com/Downloads/mysq...ic-1.7.5-2.zip= -----=_NextPart_000_004F_01C34CC0.ACC94810--
View Replies !
Cannot Link Tables
I have a visual basic 6 program that I am building connected to a mySQL database to store the recordsets. I have two tables "Client" and "Next of Kin". I want to be able to store the next of kin info in a seperate table to the client information and be able to associate a next of kin to a client and call that information when the form loads. Any ideas? I think somehow using primary keys I need to link the tables so that the next of kin info is pulled with a specific client.
View Replies !
Links Actually Link To
how I could figure out what linked fields in an existing database link to? There are currently something like 20 tables, with up to a couple hundred columns. I know for a fact that a lot of the fields are linked, but I have no idea what the links are. I've got Access, Excel and MySQL Administrator at my disposal. I've looked around for an answer or a program that would help out
View Replies !
How To Link These Two Tables?
I currently have this sql: Code: SELECT name,`total` FROM stats_cache WHERE name IN ( 'replies', 'topics', 'members' ) Which currently gets some stats for me, but say i add a new row "last_member" with an id of the newest member how would i link a members table to that? Usually i would do an inner join but i'm not sure how to do it in this instance.
View Replies !
Link 2 Databases
i have 2 catalogues on line and one of them my partner made a datasinc to sinc the catalogue information to his access databse(pc) so the stock would always be up to date. now i got him a second catalogue for retail sales and we have the same products. my question is since the both databses or on the same server is it possible to link both 2 keep the stock up to date on the other one?
View Replies !
Link To Another Record
if i have several records with the same content, say: Code: id | text ------------------------- 1 | the same text 2 | the same text 3 | the same text is there some way to place al link into the text column of records 2 and 3, so i don't waste disk space storing the same data
View Replies !
Link Problem
i put a link from a webpage to another. of course very simple tag like : <a href="view_date.php?title=$title">Click here</a> is there an FTP site that this is not supported? coz when i transfer this to another FTP site its working. i used to retrieved the variable that i pass through URL.
View Replies !
Image Link
how do I diplay a dynamic image oon a webpage that references a URL in a table within my database?
View Replies !
Link Database
I want to update my database from an old one. The structure of the old one is different of the new one. So I want to do a select in the old one to updtae the new one. I try to use the importing tool but it's don't work.
View Replies !
How To Link Tables?
I would like to link two tables in two different databases together to appear as an identical table. The two databases are running on the same server. So, for example, I have db1 and db2. If I do an INSERT INTO db1.linked_table VALUES (blah, blah, blah) and then later query SELECT FROM db2.linked_table, I'd like to retrieve the results inserted into the db1 table (and vice versa). I've read about Federated tables, but that seems like a bit of overkill geared towards tables on remote servers. Is there some simpler way to create an "alias" for a table in one database to point to a table in another database on the same server, both of which need to be queryable and modifyable with changes in either one being immediately reflected in the other?
View Replies !
Link Table
I am quite new to mysql. And have a many to many relational set up. It is quite confusing tome. Can anyone please answer my questions .if they make sense? I have a manufact table linking to a person table. Basically the person table links to a specific day in the manufact table. When linked it tell us what "person" made what on what day. The link table has 3 fields manufactid personid and linkid. My question is if I wanted to add a new table called assistant (our employees have assistants on certain days) can I simply add another field in the link table and create a new table called assistant? Can a link table have more than four fields?
View Replies !
ODBC Or DDE Link Help
I have a MYSQL database and use PHP to query it as well as display web pages. I have a third party application which has fields I can copy and paste into an excel spreadsheet and using DDE links the excel cells automatically update when refreshed. I would like to apply the same theory to MYSQL or PHP instead of Excel. When a web page is refreshed it queries the third party application and gives updated values, or maybe some way to update a MYSQL table with the data. I have looked up ODBC connectivity, OLE Links and DDE links. I can see that it is possible to have Excel or Access query MYSQL but not sure if MYSQL or PHP can query the third party app.
View Replies !
Link Testprogram Problem
I am trying to compile the test program that comes with the documentation which uses the embedded server. I have run mysql_config --libmysqld-libs command to get the list of shared libraries that must be included in the linking. I use -L/usr/lib and -L/usr/lib/mysql in the gcc command, but /usr/bin/ld says "cannot find -lnss_files" I have all the libraries that mysql_config told me to use, I have a libnss_files.so in /usr/lib.
View Replies !
Link Access Database
I am trying to link my Access Database to MySQL online. Everytime I use a converter I ge the error "Unknown MySQL Server Host" - I am pretty sure that I am typing in the wrong Host name. But I have no idea what the host name is suppose to be.
View Replies !
Link Mysql And Mailman
I have a MYSQL table with emailaddresses from our members, AND a distributionlist with the same emailaddresses in mailman. I would like to retrieve the emailaddresses from the table and create a distribution list from it (with or without mailman) Right now I store the addresses twice, first in the mysql-table, and second in mailman. I would like to circumvent the second.Anyone knows how to do this? I asked the same a few weeks ago, but I didn't get any response.
View Replies !
Communication Link Failure
I've develop a Web application with Hibernate 3.x and mysql-connector-java-5.1.5-bin.jar driver. A problem appears when pass a long time with inactivity. For example, each morning, I need to reboot my tomcat server in order to reset connections. The exception: Code: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException MESSAGE: Communications link failure Last packet sent to the server was 24 ms ago. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Note: I have other web application that runs with the same MySQL database, and it works fine.
View Replies !
Link Keywords To A Page
so my company tasked me with writing an in house search engine. i have to index gigs and gigs of data (~100+) to do just simple keyword searches. the indexing is easy. my problem is i can't think of an efficient way to link the words to the page they appeared on and then store that relation in a database.
View Replies !
Link ODBC Tables
I would like to link MySql to a Informix Unidata ODBC datasource the way that Access lets you link tables with get external data. Is this possible without doing a full import? A full import is out of the question since the data is always changing on the Unidata side. Right now we use Access to run queries off of the Unidata source, but it is extremely choppy and slow since there are 10s of thousands entries.
View Replies !
Link Local DB To Remote Via SSH
I have a SSH connection to a server with a database on it holding all of my application data. I also have local databases with other information that is related to the remote information. E.g. Server has account usage by account number, local database has account number and local contact. I currently .... 1. SSH (with Putty) to the server 2. Run a script to dump the query result to a text file 3. FTP the file to my local machine 4. Open the file in XL, convert to columns 5. Insert vlookups to match the local data to the retrieved data. How can I create a link from my remote database to my local database so I view it as a linked table? I know with Access I can (in theory) connect to an ODBC data source and query it, so then I can run a cross-tab query between my local data and my remote data. Is there any way to link to a remote database via a SSH? What do I need enabled on the server to allow me to do this?
View Replies !
Html Link In Database
I am trying to insert an html link into a mysql database as text, but I keep getting a syntax error. I want my query to return a link with a graphic to be placed on a web page.
View Replies !
Deleting A Record With A Link
i'm trailing to delete a record from my sql databas but he dont post the news_ID my script: <?php $rootdir="../"; include("../top.inc.php"); ?> <table border="0" width="100%" id="table1" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#C0C0C0"><b>U ben ingelogd u bent automatisch uitgelogd als u het venster sluit</b></td> </tr> <tr> <td> <table border="1" width="100%" id="table2"> <tr> <td width="199" bgcolor="#FFFF00"><u><b><a href="news_list.php">Ga naar lijst wis of bewerk</a></b></u></td> <td width="262" bgcolor="#FFFF00"><u><b>Voeg een artikel toe</b></u></td> <td bgcolor="#FFFF00"> </td> <td bgcolor="#FFFF00"></td> </tr> </table> <p> </p>...
View Replies !
Link To Columns In Table
I'm using a php/mysql script where I've got no access to the php source script, but I've got access to the db structure. There's 2 fields in the database table: category and keyword. Is there any way to define in the table that keyword = category.
View Replies !
Form's Link Button
I have form: <form action"page.php" method="post"> <input name="FirstName"> <input name="LastName"> <input type="submit"> <input type="reset"> </form> I want to add another input with type "button" but I want this button to be a hyperlink to another page, how I can do it? I tried: <a href="page.html"><input type="button" value="GoThere"></a>
View Replies !
Can't Open Pdf Link Created In PHP/MySQL
I created a MySQL database with all the pdf papers on my HD. The path to a pdf file is stored e.g. D:DocsPapersBerg2003a.pdf In php I do the query and output the link: echo "<a href='file://" $row->pdf ."'>pdf</a>"; But when the page is generated and I click on it nothing happens. If I do right click, copy link and paste it in the browser field, the pdf file opens though! Looking at the html code, it reads in Firefox: <a href="file://D:%5CDocs%5CPapers%5Cwind03%5Cpdfs%5Berg2003a.pdf">pdf</a> and in IE6 <a href='file://D:DocsPaperswind03pdfsBerg2003a.pdf'>pdf</a> I have also tried .str_replace('','/',$row->pdf) but with the same result.
View Replies !
How To Link Together 2 Tables And Export Into Excel
Can you tell me how to dump data from my online database which contans 2 tables, table1 and 2 using the sql statement to pull them together fields 6,7,8 of table 1 and field 2 of table 2 so that i get 4fields thus: field6, field7, field 8, field 1 I'm using mysqladmin
View Replies !
How Do You Link A Table To Two Tables Using One Column???
l have created 3 tables in mysql, table A, table B and table C. Table B and C have a column - primary key with the same name and data type and length. l have created 2 foreign keys for Table B and C in table A (on the same column (column name = ID) in table A which links to the ID columns in Table B and Table C. The ID columns in Table B and Table C use auto increment and start at different numbers - for distinction purposes. Table B starts from 2 and table B starts from 5000. Both tables A and B have data in them. This works so far. however, when l try to insert data into table A, its only checking if the foreign key exist in table B. How do l make it check table C as well?
View Replies !
Access Link To Mysql Database
I have set up two links in access to two different mysql databases. One allows me to add records and make changes. The other says that I cannot update the file and won't let me make changes of any kind. I have no idea what is different, or what I did different in setting these links up. Anyone know how I can make the database editable?
View Replies !
Varchar To Image Link Path
i am creating an SQL table and one of the fields is going to be a image link path. This will be a varchar. But I am unsure what size I should make that. Any ideas.
View Replies !
Direct Add Cart Url Link Not Working
I am doing a simple shopping cart which works (code below)BUT... when i click on the add item to cart link it works and produces a url: blah/cart.php?action=add_item&id=4&qty=1 Now, what I would like to do is link the url to a button in flash so that people can click directly and add a specific item. I know how to do that but when i try to change the add_item&id=1 to add_item&id=2 or whatever, the thing does not work properly. Code:
View Replies !
Invalid MySQL-Link Resource
I'm getting the error message 'Supplied argument is not a valid MySQL-Link resource' (applies to the 3rd line of code) when the code below executes: $delete_part_no_query = "DELETE FROM prices WHERE part_no == '$part_no_to_delete'"; $delete_part_no_result = mysql_query($delete_part_no_query); $num_delete_part_no_result = mysql_affected_rows($delete_part_no_result); The query works fine and I'm under the impression that 'mysql_affected_rows' should be used to return the number of rows affected by DELETE. However, I keep getting the above error message.
View Replies !
Can I Simplify These Duplicate Link Tables?
For a new application I am drafting the database design for I have many types of relationships to common types of data. Contacts has its unique data set and has many (Addresses, Phones, Files, Comments) Artists has its unique data set and has many (Addresses, Phones, Files, Comments, Contacts) Site has its unique data set and has many (Addresses, Phones, Files, Comments) Agent has its unique data set and has many (Addresses, Phones, Files, Comments) ... has its unique data set has many (Addresses, Phones, Files, Comments) And so on. I will want to be able to an address search for example and have it return all the types of anything linked to the addresses matching my search. I would like to do that with as few queries as possible and in a way that would allow me to add tables that relate to addresses, phones, files, comments in the future without having to update code. Pipe dream maybe but people are clever and I want to be amazed. 1. Should I create tables like contact_address and put the address data in there then duplicate the table structure for artists_address and so on? 2. Or should I create a single address table and then create contact_address as a join/link/many-to-many table then continue to create those tables between all attachable objects? 3. ??? So my question is this. Is one of the ways described above the better of the two or am I over complicating things, not seeing the better way to get this done?
View Replies !
Technical Term For Link/Juction Tables
i have main data table which is 'news'(will have articles ,reports etc) table and i have another meta data table 'countries'(country names) and i have another link table 'news_countries'(news_id,countries_id) which will link news articles with countries. Here my question is which is the correct term for calling these kinds of tables..? 'news' table - Data table is correct or any other term is there..? 'countries' table - Meta Data table is correct or any other term is there..? 'news_countries' table - Link/Relation table is correct or any other term is there..?
View Replies !
Direct Link To Login As Root On Windows
Anyone know a direct link to loging in as root on mysql on Windows 2000, and creating and seting up user permissions for new accounts? :- i try to look at the windows specific info in the manual.html but it freezes up my IE .
View Replies !
HTLM Form Link To Data In Mysql
I have a form that puts data into MySql and then in my website I have a table to display the Data. Everything works just fine at this point. The only thing left for me to do is that when the data is put into the table I want it so that one of the cells has a link, when the user clicks on it he can either see all the details from the data submited on the form in the same page or it is transfered to a new page with all the data submited in the form.
View Replies !
Regarding Database Link In MYSQL Compared To ORACLE
I am looking for some info related to Database Link in MYSQL similar to the one in ORACLE. 1.If I want to transfer data from one server to another server, how do i do it MYSQL 2.In case of a query needs access to other databases, how do i do it in a query. ie (select a.col from table a, table1@dbserver b where a.col = b.col). 3.In Case of transferring the data to the other database server(like From MYSQL database to ORACLE Database), what method should be adopted. ie(insert into tab@dbserver select* from table1;)
View Replies !
Renaming Database, Website Link Problems
I just created a website on a new domain, and created a new database for it. Although I will be modifying the tables, I'm starting off with the same structure and data from the old website, just copied the tables across (export/import). I changed all the references to the old on all the web pages and scripts with the new Username, Password and Database info, but nothing the database info is not coming up, when I run the pages.
View Replies !
Passing Value Of Html Link To SELECT Query
How can I pass the value of a html link to a SELECT query? In the example below I would like the $gallery variable to change depending on the link selected. mysql_query("SELECT COUNT(*) as Num FROM images WHERE image_cat = '$gallery'"),0);
View Replies !
Supplied Argument Is Not A Valid MySQL-Link
I am trying to get php to send an email part of which is a display of a MySQL table. The code below may or may not be correct but I am getting the error message: Warning: Supplied argument is not a valid MySQL-Link resource in /home/mancroft/www/test/emailform.php on line 32 plus two similar messages for other lines. MYSQL_CONNECT(localhost, mancroft, xxxxxx) OR DIE("Unable to connect"); mysql_select_db("mancroft_test",$db); $result = mysql_query("SELECT * FROM cart",$db); if ($result === false) die("failed"); while ($row=mysql_fetch_row($result)) { $RBI=$row[0]; $RUI=$row[1]; $RON=$row[2]; } $serveroutput = "$RBI $RUI $RON";
View Replies !
|
TRACKER
