7,368 Topics
 | |
| | I am trying to create a plan for users based on their top 3 choices. I want to display results all together on a results page. I have database populated and form (check boxes) created. I cannot seem to put the two together. I want them to choose 3 choices … |
| | Safari can’t open the page because the server unexpectedly dropped the connection. This sometimes occurs when the server is busy. Wait for a few minutes, and then try again. When I try to post the form with Firefox i just get a black page. This problems started when i changed … |
| | hi, i have the following table: +------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+----------------+ | IpAddressesID | int(11) | NO | PRI | NULL | auto_increment | | PhysicalServerID | int(11) | NO | | NULL | | | VmID | int(11) | … |
| | Hi i just did some codoing and heres the error i get when i try to use my register forum [code] Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/rpimager/public_html/RPImager/register.php on line 32 Account created. [/code] Here's the docs that i use it for. why i … |
| | Hi Does Anyone know how to display a table based on user selected fields? In my search box, once the user searches lets say all the female students, all the female students will show with all the fields of that particular table. then if need to print a report i … |
| | I was looking to make a VERY simple PHP/MySQL loginish username site, as an exercise, when I came across the problem of storing info on the users. I am very new at this (hence the need for an exercise), so I was wondering if anyone could direct in the right … |
| | Hi is it possible to count days between columns, something like [CODE]datediff(date_finished-date_started) as 'days'[/CODE] only datediff works just with actual dates, and I'd like to have the days number for every row counted automatically with the rsults in a new temporary column'days'; I hope it makes sense. Please could you … |
| | A new site that I have to work with requires me to use putty to connect to the site if I want to work remotely as opposed to logging in to their phpMyAdmin to manipulate my data.. I am unfamiliar; please read that has having no knowledge of how to … |
| | # Query_time: 6.081227 Lock_time: 0.000085 Rows_sent: 1 Rows_examined: 1339 SELECT COUNT(id) FROM `article` WHERE `category` = 'shkrime-te-perkthyera' Is there a way to speed it up. Should I index the category column? Or what do you suggest? I use this query to get the number of articles on that category! |
| | Hi, I am trying to set up a section on a site where the results that are shown come from a table. I want to get the number of the 'current_round' then subtract 1 from it and use that value. I have looked up MySQL dev site, and assume that … |
| | Hi, I am trying to display some results where one column is equal to another column in a table. End goal: display all the results where the round and current round are the same number for every team in the table. the number of teams will change as the number … |
| | hey i have two tables in a database that i will like to join in the below code, but i cant. i can only use one table at a time. $result = mysql_query("SELECT name,price from products WHERE itemid = '$id'",$cxn) or die ("Unable to retrieve information from database"); if i … |
| | Hi, I want a MySQL stored procedure which can parse an excel file and save it in the csv format,after which the values in the file can be imported into a table. Kindly help me with a solution for this asap. Thanks, Narayana  |
| | hi all im looking to use a select mysql query - but im trying to query the database against a users logged in sessions. I have the sessions working correctly but I am unsure how to included the session data in my sql select query. here is my users session …  |
| | I am getting the following error Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\valid.php on line 4 Using php and my sql on localhost |
| | hello. is there a way which i am able to cast/ convert my substrings into integer? This is what i have been trying to do, apparently, it does not work. SELECT campaignmonth CAST(campaignmonth, substring(campaignmonth,1,1)as Jan) FROM campaign a; thanks |
| | Hi all ! I 'm a newbie in SQL and has just install the Oracle 10g Express Edition. When using its SQL Command in the Web-interface, I took an error with the GROUP BY, as follow : First, I create a table DEPARTMENT, here 's the code : [CODE] CREATE … |
| | Hi, i'm not really sure how to explain this. I have a table with a lot of places sorted by date, all connected to a MySQL database. I'd like the table to update automatically everyday and remove the top ones where the date has passed so that the table only … |
| | Doing a system in drupal using php and mysql. Want to integrate a function for reporting - that is print out watever search result in the search page which displays in tabular form. please help. i have only heard of jasper reports. is there something simpler? if so wat n … |
| | Doing a System in Drupal - coding with php and mysql - want to know how i can integrate jasper reports to it so i can generate reports at the click of a button.. does anyone know? please help.. |
| | Hi folks, [COLOR="Green"] I have a MySql table...which has 4 columns say sid pid tid data 1 abc 2 def 3 ghi 4 jkl - - 10 xyz 1 dfsf 2 sdfs [/COLOR] I want to convert column name 'data' into multiple rows i.e. 1 2 3 4 5 --- … |
| | I have a table and I want to start the select with the 20th row. How do I do this? Does conditionals work on "limit" |
| | 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 … |
 | |
| | 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`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 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 …  |
The End.