10,940 Topics
 | |
| | Hello All. Is there any syntax for [COLOR="Red"]getting fields in a column in an alphabetical order[/COLOR] in mysql? See, for example... I have a two column with "NAME & NUM". NAME NUM BHANU 6 KIRAN 3 ADAPA 8 CHANDU 7 I need to get the names in alphabetical order. There … |
 | this code isnt workin: [CODE]$newer = mysql_query("DELETE FROM messages WHERE id = '$rawr', user = '$rew', read = '$roll'"); [/CODE] this code works: [CODE]$newer = mysql_query("DELETE FROM messages WHERE id = '$rawr' AND user = '$rew'");[/CODE] the variable is the same that is included in the first, so its not … |
| | its a mess. i dont know why it would be doing this. considering the message it says its in the inbox in the mysql database and then its not. i dont know what to do. its php and mysql database. is there a posiblitily its showing up on the webpage … |
| | [code] <?php require("config.php"); if(isset($_GET['id']) == TRUE) { if(is_numeric($_GET['id']) == FALSE) { $error = 1; } if($error == 1) { header("Location: " . $config_basedir); } else { $validtopic = $_GET['id']; } } else { header("Location: " . $config_basedir); } require("header.php"); $topicsql = "SELECT topics.subject, topics.forum_id, forums.name FROM topics, forums WHERE topics.forum_id …  |
| | i m using ORANGEHRM, for dis first of all i installed basi package of XAMPP,i have created my account on the site of orangehrm.The account run on localhost i.e it runs on single system.My problem is i have to RUN IT ON D ANOTHER SYSTEM,is it possible to run d … |
| | Hey guys/gals, I literally just started teaching myself MySQL today and have started to write a email list script for mass emails. Ive got the adding emails and sending mail scripts working but i cannot figure out for the life of me what is wrong with the deleting script. I … |
| | Hope this is the most suitable forum for this question if it is not let me know. I've had this error on my computer for a while and have been unable to find a solution, which I think it is the result of some xampp and sql software I tried … |
| | Hi all, Goodday...! Im delevoping a struts project of my own. Having doubt in database connection. Actually where i have to write code for connection, there itself my doubt starts.... whether i hv to write a connection code in (1) execute method in Action class, OR in (2) servlets, OR …  |
| | I have been unable to figure out how to insert data into My database. I am just learning PHP so please ignore comments [CODE] <?php if (isset($_POST['submit'])) { if (isset($_POST['question'])) { $DBhost = "localhost"; $DBuser = "root"; $DBpass = ""; $DBName = "exit_poll"; $table = "exit_reason"; mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to …  |
| | Hello can someone please help me, I am trying to add information to a database with checkbox. I have every thing working expect for the checkbox. I am fairly new to the php/sql side of web coding. Anyway I want to add information to the one field of a database, … |
| | can sombody give me a great example to make a connection php - mysql ( oop - best practice ) ? [ICODE]<?php /* Database Connection */ class db { private $db['host']='localhost'; private $db['user']='root'; private $db['pass']=''; private $db['name']='build'; public function connect($db['host'],$db['user'],$db['pass']) { $db['connect'] = mysql_connect($db['host'],$db['user'],$db['pass']); if (!$db['connect']) { printf("Cannot connect to … |
| | i have this code, im using jquery which im not very familiar and i need help please:D [code] <html> <head> <title>Select and drag?</title> <style type='text/css'> body,html { color:#333; font-family:Calibri; font-size:11px; } .panel {float:left;width:200px;margin:20px;} ul { list-style-type:none; border:1px solid #999; background:#ccc; padding:20px; min-height:150px; width:100px; } li { display:block; border:1px solid #999; … |
| | Hi all, I have a web app that is used in a number of countries, including ones such as Brazil, where the comma is used as a decimal separator. This is causing problems with my SQL queries, as it is trying to update a number field with "0,013" when it … |
| | import java.awt.BasicStroke; import java.awt.Color; import java.awt.Dimension; import java.awt.*; import java.sql.*; import java.util.*; import java.util.Date; import java.lang.*; import javax.swing.JApplet; import org.jfree.chart.ChartFactory; import org.jfree.chart.ChartPanel; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.NumberAxis; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.plot.PlotOrientation; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.data.category.CategoryDataset; import org.jfree.data.category.DefaultCategoryDataset; import org.jfree.ui.ApplicationFrame; import org.jfree.ui.RefineryUtilities; //import org.jfree.chart.demo.Time; /** * A simple demonstration application showing how …  |
| | Anyhelp with code below would be greatly appreciated Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/home/rconn/domains/dadpop.net/htdocs/online-bookmarks/register.php on line 44 you have been successfully registered. Read your email and click the link to activate your account. [code=language] <?php require_once ("./header.php"); $secret = "dDWUc72sCcs20cXskcw"; $reg_register = set_post_bool_var … |
| | Hi all, I am fairly new when it comes to SQL... and i would like some help I would like to run 2 select statements in the same time...in order to get my results in a table with 2 columns and 2 rows that shows me the result of my … |
 | Hi All, I was trying to research my problem, but wasn't getting any results to satisfy me. The problem is: I am storing data in a mysql database (the server time is stored as well), I am also uploading data into this database from a file that was downloaded from … |
| | could u pls help me out to create one databse inside another databse using PHP , MySQL. is it possible?? |
| | Hi, I am new to MYSQL stored procedure. Getting problem in SP execution through PHP. How can we execute multiple procedures using mysql and php. I made connection using mysql_pconnect("host", "user", "pwd", 1, 131072); and have 3 procedures one for select, insert and update. If i am going to execute … |
| | hi how can access romote Mysql database from local mysql database. like oracle dblinks will also work in mysql. |
| | ho do i store information to a mysql database? what i am trying to do is to fill out some students information and when i try to click save it should be saved to a mysql database.... here is my code but every time i click save it couldn't connect … |
| | Hi guys, A few months ago i installed a version (5.0 i believe) of MySQL on my machine with no problems at all. Two weeks ago i had to format my hard drive and reinstall my OS. I have successfully installed Visual Studio 2005 and tried to install MySQL last … |
| | Hello, I have a php script. there is user and admin sections. The information is displayed in the user side (displaying adding new article) when added from admin side. But when I add a new article and refresh page. it does not come but after 2-3 refreshes It comes. same … |
| | Hello. I have a MYSQL database and I receive CSV files throughout the day. At present I have to open up my database and import the CSV file. Is there a exe file that can run so the CSV file can be imported as and when it arrives on the … |
| | Hello I am trying to run an exit survey when people leave my website. I really have no Idea how to got about it, so I have been piecing together PHP code and HTML. Hear is what I got so far. [CODE]<p>Thank you for visiting Niland's Place Campsite today. I … |
| | Ok..here's a challenge (maybe not if you're really good I guess) for you PHP/MySQL gurus out there (may need javascript perhaps?) If you can point me to a solution that exists for this, that would be good. If you can implement one, I'd love to learn from it, tweak it, … |
| | Hi, I need to fetch 5th top and 6th max from my database table... asssume everything are integer datatype. Thanks |
| | but I NEED to learn. I am a graphic designer and I am working on my first website.... I must find a php/mysql picture uploader with contact form to place on my web page. I have tried many from this site but I think I am illiterate when it comes …  |
| | Hi Everyone I am working through a book called Dreamweaver PHP Web Development. It has a tutorial for creating a booking system for a hotel. The because went out of publication in 2002 and there isn't a errata on the Glasshaus site for it . When creating the search page … |
| | Hi, I am trying to use MySQL full text search in my application, but surprisingly the query doesn't seem to be working for keywords like 'ASP.net','Vb.net' The query is given below, [CODE] SELECT * FROM tbl_postedjobs WHERE MATCH (keySkills) AGAINST ('ASP.net') [/CODE] |
The End.