7,368 Topics
 | |
| | i would really like to automate something like ... login to mysql cmd followed by creating a database following by creating tables... with one bat script here is my try: [code] mysql -u root password password; [/code] however it returned me this: [code] C:\Documents and Settings\lih>mysql -u root password root … |
| | Hi, I want to create some kind of AJAX script or call that continuously will check a MySQL database if any new messages has arrived. When there is a new message in the database, the AJAX script should invoke a kind of alert box or message box. I’m not quite …  |
| | [code]<?php mysql_connect("localhost", "Master", "pword"); mysql_select_db("db"); $official2 = mysql_query("SELECT * FROM Contribute WHERE stack LIKE '%comic%' ORDER BY points DESC")or die (mysql_error()); while($row = mysql_fetch_array($official2)) { $officaluser = $row['username']; $officalpoints = $row['points']; echo "<table><tr><td align='center'><font face='Arial' size='3px' color='#D99C29'><strong><a href='ustack.php?search=$officialuser' style='text-decoration: none'>$officialuser</a></strong></font></td><td align='center'><font face='Arial' size='3px' color='#FFFFFF'><strong>$officialpoints</strong></font></td></tr></table>"; } ?>[/code] the page is coming … |
| | How am I going to create a relationship from one table to another in phpmyadmin? Like a one to many relationship?  |
 | When I do `mysql> show status like '%qcache%';` it returns: mysql> show status like '%qcache%'; +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Qcache_queries_in_cache | 19817 | | Qcache_inserts | 299528 | | Qcache_hits | 687127 | | Qcache_lowmem_prunes | 6702 | | Qcache_not_cached | 3171 | | Qcache_free_memory | … |
| | Hi, I was looking for some help with how i would go about setting up my commission table. Basically i have currently: Users Table UserID Username Password Email Clients Table: ClientId Client_UserID FirstName LastName Address PostCode Tel Email Insurance Table: InsuranceID Clients_ClientID Provider Commission DatePaid CarInsurance Table: CarInsuranceID Clients_ClientID Provider …  |
| | I have a strange problem when making a backup of my mysql databases. In order to do so I have a 2TB external hard disk mounted when needed under /backup. Before making the backup I stop mysql (with /etc/rc.d/mysqld stop) and use rsync to copy all the data to the … |
| | Hi, I changed my table to InnoDB so one table can be used as foreign key. To do that i had to DELETE the content in my child table. I exported and saved the data on my computer. 1, Now that im trying to import all the data with phpMyAdmin … |
| | i know this is about MySQL, but there is no 4GL forum, so i'm hoping one of you experts might know: we have an application that uses Progress (on a unix system) that imports data from .csv files and writes the various fields to the database. one particular type of … |
| | I am attaching a word document I put together with screen snapshots on how to connect to MySQL on a remote server using putty. I hope it helps those of you how have questions. |
| | Hi, Fairly new to MYSQL, still learning. I have create basic web databases before but the project i am working on just now is slightly more complex than before and need some advice. i have had some help qith queries which has been great however i need some advice from … |
| | Hi everyone. I'm currently working on a project whereby I'm creating a small client/server website. For the server side programming, I have no ideas to how to upload and download images. I'm am using Xampp and Mysql database. I really need your help. Please help. Thanks in anticipation. |
| | Hi, I have managed to upload images to a table in mysql, however, i am having problems with displaying the image, all i get is a box with a red cross in it and i'm not sure what i'm doing wrong. Here is the code i am using to view … |
 | What the hell is up with [URL="http://www.oracle.com"]Oracle[/URL] lately? First, they stopped giving away the Solaris operating system and now they have some big announcement planned for next week at the [URL="http://en.oreilly.com/mysql2010"]MySQL Conference[/URL]. Should we hide our wallets before we listen? To me, Oracle has morphed into [URL="http://www.microsoft.com"]Microsoft[/URL] II with all …  |
| | |
| | [code] <?php if (isset($_GET['id'])) { $id = abs((int)$_GET['id']); $sql = "SELECT *, ((`hit_head` + `hit_chest` + `hit_stomach` + `hit_leftarm` + `hit_rightarm` + `hit_leftleg` + `hit_rightleg`)/`shoot`) AS 'acc' FROM `zp_weapon_stat` WHERE`id_weapon` = $id"; $r = mysql_query($sql); $row = mysql_fetch_assoc($r); if ($row) { $template = 'weapon.xsl'; $weapon = $root->appendChild($data->createElement('weapon')); foreach ($row as … |
| | Hi Im trying to pull out a list of meetings, and the associated number of comments attached to each meeting. Comments are assigned a category (ie meetings) and a linkid (the uniqe id of the meeting) - Im using this query, buts its cutting out all meetings that don't have …  |
| | I've got a situation with minibus repair database design, where it looks like in the Repair table I could do with a 3-composite primary key: jobID from the JobType table (types of maintenance with price and time), mechanicID (Mechanic table), minibusID(minibus table). This way, I've got type of job performed … |
| | Hi there, I've been having some issues with MYSQL. I have three tables, Blog, which has the fields: [LIST] [*]Id [*]Headline [*]Author [*]Articlebody [/LIST] Tags, with the fields: [LIST] [*]tagId [*]tagName [/LIST] and Lastly, article_tags (which is the relation), with the fields: [LIST] [*]tagId [*]blogId [/LIST] My issue is, I'm … |
| | Ok, I'm new to php and MYSQL aswell. I have a couple programs actually that are getting this error and I don't see what could be causing this at all. Here's the situation. I have a job interview page. The user enters the information from the candidate and submits the … |
| | Hi, I have a query: [CODE=sql]SELECT h.id, h.creator uid, h.haiku, h.title, h.likes, h.approved, cat.name category, count(c.id) comms, h.anonymous, CASE h.anonymous WHEN 1 THEN 'Anonymous' ELSE u.username END username FROM haiku h left join categories cat on cat.id= h.category left join comments c on c.haiku=h.id left join users u on u.id=h.creator … |
| | i have one table, which has three fields and data. Name , Top , total cat 1 10 dog 2 7 cat 3 20 hourse 4 4 cat 5 10 Dog 6 9 i want to select record which has highest value of "total" for each Name so my result … |
| | I'm making some dynamic drop down boxes for a site that get their contents from a database, i belive i have the correct code to do this [CODE]<?php echo "Product Code"; $sql = "SELECT DISTINCT Product_Code FROM product_supplier"; $result = mysql_query($sql, $odbc) or die("could not run"); echo"<select name = Product_Code>"; … |
| | Hi, I'm trying to code a league table system and I was wondering if there's an easy way of doing this: [CODE]$result=mysql_query("UPDATE Championship SET played="++1" WHERE team_name='$home_team'") or die(mysql_error());[/CODE] The problem lies in the played="++1" part, I can set it to be any integer, but that's not much use, I … |
| | Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 … |
| | Hi people, My issue is more of a MySQL issue than php. I am trying to store a 3digit integer value with a leading Zeros in front such as 001 i have a company table , which auto increments the id as 001, 002, 003...and so on... In the company … |
| | Hi peeps... A good day to all of you yea~ as i know, i can retrieve only the first row by using the keyword [B]limit 1[/B]: [CODE]select * from tblTesting limit 1[/CODE] for selecting the first two rows are: [CODE]select * from tblTesting [B]limit 2[/B][/CODE] is there any solution to … |
| | [URL="http://www.mysql.com"]MySQL[/URL] users listened intently Tuesday, April 13 at O'Reilly's MySQL [URL="http://en.oreilly.com/mysql2010"]Conference[/URL] to Edward Screven, [URL="http://www.oracle.com"]Oracle[/URL]'s chief corporate architect, while he announced Oracle's grand plan for MySQL. What they heard was that Oracle is interested in MySQL, will invest in it and nothing should change for the community version of MySQL. … |
 | hello everybody i have a big problem with the connection of mysql connect i want to connect to an other data base with out binding Ip adresse in the host server . i have an application and i want to manage 2 web sites with this appliction because the tow … |
| | Hi Guys , Have you any idea what does mysql.sock used for and where we can find in windows system. rgds |
The End.