10,938 Topics
 | |
| | 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, fairly new to mysql. i have been working on a site which would have say 100 + agents. basically the agents clients are their own so i thought the best way would be to get a dedicated server and create a mysql database for each agents company. the database … |
| | Hi, im working on some project on php with mysql, and I'm only actually a beginner in programming with php and mysql. I created a table in mysql which contains several records. I have like 10 records in it. Now what I want to do is I only want to … |
| | Is it possible to use PHP and a mysql query combined to allow a whole database backup file to be downloaded? For example, I'm currently backup up my database by using the export tool in phpmyadmin, but what if I wanted to add a button or link on my site … |
| | Hello Today is the first of february and I noticed a bug in my coding. I use the php date function to give me todays date in an european style: 010210 I then insert this date to a mysql table. The problem is that the date after being inserted is … |
| | 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 … |
| | Hi everybody, I'm having some difficulties with mysql_num_rows( ) on line 26. I keep getting a warning that the supplied argument is not a valid MySQL result resource. What does that even mean!? I get the same warning on line 51. Can somebody fill me in on why this comes … |
| | 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 … |
| | Hey guys, I have a question: So... I want to do a product page with new product, edit product and delete product feature. While I'm on the modify or the deletion page, I would like to and [B]categorise [/B]by [B]date[/B]-desc, asc ; by [B]category [/B]and [B]alphabeticaly[/B]-desc, asc the retrieved content … |
| | 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, I'm pretty new to php and MySQL. I am trying to use a form to update a the database. However it just doesn't seem to actually work. I also am getting this error from printing out errors: You have an error in your SQL syntax; check the manual that … |
| | Hi all! I am still new at PHP and mysql and am having a little difficult time figuring out how to get my "Trainee Name" link to switch my info list from ascending to descending order and vice versa. Right now, you will see it defaults to ASC. Any help … |
| | I have a tab delimeted file that I want to convert into a mysql table. there are 25 tab delimeted fields in the text file. I can get the values in when I construct the SQL statement word by word and get each value individually stated in the VALUES part … |
| | Hi, I need help for this problem that i'm trying to solve for a while (i'm Using ASP.net and C#). How do i submit the values from selected checkbox lists into database using c#.... Here's the code: .......................................................................... [code] <asp:CheckBoxList ID="CheckBoxList1" runat="server" Font-Bold="False" Font-Names="Vrinda" Width="338px" style="text-align: left"> <asp:ListItem>Public Tap</asp:ListItem> <asp:ListItem>Well … |
| | 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 … |
| | I am looking for a platform to build a manual and function reference for my open source software-in-development. Something that is easily organized. I spotted a very nice and simple solution here: [url]http://mpdf1.com/manual/index.php[/url] But contacting the author has not resulted in information what that software is and by the look … |
 | 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 everybody, I'm having trouble with my query on line 19. I'm supposed to search for a name and return the balance and credit limit. I'm not sure why I keep getting a parse error. Thanks in advance! [CODE=php] <?php $find=$_POST['find']; $name=trim($_POST['name']); if (!$name) { echo 'You have not entered …  |
| | 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 Im getting this error message with a script im trying to use. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/rideron1/public_html/join_form.php on line 67 No database selected The script im using works on my local server but as soon as I upload it to … |
| | 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 … |
The End.