10,946 Topics
 | |
| | Hey I am trying to run this in php: [code]// Retrieve data from table where row that match this passkey $sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'"; $result1=mysql_query($sql1) or die(mysql_error())[/code] and I get this error: [code]You have an error in your SQL syntax; check the manual that corresponds to your … |
| | Please see this: [CODE]WARNING [1024] Error while executing query: select event_type, EventId, VenueId, Price, Schedule, ev.startDate, ev.endDate, events.name eventname, movies.name moviename from `eventvenue` ev, `events` left join (movies) on (movies.ID = ev.EventId) where events.ID = ev.EventId and VenueId = '493' and ((ev.startDate >= '2010-04-25' or ev.endDate >= '2010-04-25') or event_type … |
| | Anyone, please help me here. I created a view in mysql but when I use it in my code in php, an error appears that the view doesn't exist. What can I do? Here is my code. [CODE] $count = mysql_query("SELECT COUNT(*) FROM ViewName where ftTimeIn != '' AND ftTimeOut … |
| | Hi Everyone, I have a page that displays information from a mysql database. The information is taken from the members table where the id is in the url e.g. [url]http://www.clancorner.net/tounament.php?go=MW2&[/url][B]id=2[/B]. And that works perfectly, pulls ou all the information i asked for. Unfortunatley i now need to just echo "Invalid … |
 | Hello, I'm trying to pull data from multiple tables in a single mysql_query and I'm having trouble displaying the data that's pulled. Here's what I've got so far.. the highlighted code is the part that doesn't work. (sorry in advanced for the sloppy code.. i've been copying/pasting stuff all over … |
 | |
| | hello, I need to have in ONE request clients who just like apple AND banana : clients id name relations_like id id_client id_like like_fruits id title a same client can have a few differents like_fruits if I made a classic SELECT FROM relations_like WHERE id_like IN (idapple, idbanana) I will … |
| | hi, I need php mysql image upload and resizer. The image uploaded through a uploading page should be resized and should kept in mysql server. and we need to retrieve it to another page. help me. thanks,  |
| | Hi, I`ve started doing PHP and MYSQL for a few months now and I am working on a project for a friend. Basically I had the code written down in mysql format and decided to change my code too mysqli. Everything was working fine except for one function. I keep … |
| | Hi, I have written the following code to download a file from a MySql database using a Servlet.The problem i have is that i havnt done it right. Can someone please point me in the right direction. Any help will be greatly appreciated. Thank you for your help. [code=java] import … |
| | Hi all. I've been having this problem and I was hoping someone could catch something I didn't. So here it goes: I have developed a registration system using PHP and mySQL, with usernames and passwords being encrypted by salt and md5 (and display names getting no encryption) on PHP's end … |
| | I'm coding a simple forum, for a user system that I'm making. By simple I mean very simple - viewing categories, threads, and topics, as well as posting, editing, and reporting to a moderator. Moderators can also delete, sticky, or lock threads, or delete posts. Now, I'm doing quite well … |
| | Hello all. Am new to the forums and this is my first post and I am in need of a little help. I am in the planning stages of building a pretty involved web application. This question needs some background info first. This is for a direct mail company (a …  |
| | 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 …  |
| | I'm trying to build a room booking web application with php+mysql. I'm close, but something keeps going wrong. The way it works is this: 1. User logs in 2. User redirects to "booking" page, where they can choose from 1 of 2 rooms to book 3. there are drop downs … |
| | [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 … |
| | code to link database selected through dropdownlist with corresponding database in mysql.Plz reply as soon as possible. Dropdownlist will list all database names inserted in a particular table |
| | 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 … |
| | 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 … |
The End.