10,932 Topics
 | |
| | I have the following PHP MySql query: [CODE=php]$query="SELECT * FROM hosts WHERE php='$isphp' AND asp='$isasp' ORDER BY asp $sort";[/CODE] The variable $sort is as follows: [CODE=php]$sort = "DESC";[/CODE] can anyone tell me where i am going wrong with the above query ? i know its somthing to do with the … |
| | I'm not a python programmer, I'm mostly a hobbist that lately is developing a project in php/Mysql. Now I find myself in need of sending two python variables to one mysql table. I found the wonderful MySQLdb module but unfortunately only supports 2.3-2.5, while to run this specific python script … |
| | Poor database design I suppose, but never the less I need to retrieve FIELD -this-, -that-, -the other- from TABLE foo and FIELD -pphone- from TABLE -bar-. For example a record set of McDonalds restaurants in different cities. Where a particular restaurants phone# is not known, I pull the corporate …  |
| | i want the best php class to work with mysql hi i want the best and the simple php class to work with the mysql thanks |
| | I need a mysql user authentication class with only 3 user "levels" 1. Admin 2. Registered (or normal) user 3. Guest I tried phpclasses.org but couldn't find a good one (maybe i didn't try hard enough :-O ) So any suggestion is welcome! :)  |
| | Ok so I have two separate AJAX function that I want to combine but have no idea how. The first 2 files are to call up a table with cells in the form of text-boxes, and the last 2 files are linked dropboxes. What I want to do is to … |
| | some body help me.I want to know how to put the dropdown list from database at my textbox cursor. full problem definition is like this. I want to create a Hint system for SQL which will give the structure of of Query. for example if user enters trigger he will … |
| | I have a joke script which currently displays a new joke each day and I want to change it to where it displays one every week. I keep getting the SQL error below but when I run it in phpMyAdmin it works just fine. Most likely some little thing which … |
| | hi all ..how are u? i have a problem and i need ur help plz ...i downloaded Apache2.2 server and php 5.3 and now i'm downloading mysql5.1.37 ...but there is a problem ..when i start the Mysql Server Instance Configuration wizard it tells me to choose between 2 version ..and … |
| | Hello! everyone out there! I am having a table that looks like this in phpmyadmin ....................................................................................................... . id . fname . lname . user_id . trackdate . country . ....................................................................................................... . 1 . Jonh . Mark . 10 . 21 . USA . . 2 . Frank . Yank . … |
| | Dear All. 1. I need to select all related information from a table (lesson) that fulfill certain conditions. 2. the output (some of the fields from lesson table)are then need to be referred to several lookup tables.(a table for each field) 3. the lookup tables have three main fields, which … |
| | Hi all, I have downloaded mysql, please tell me how to create database, and tables in mysql, .. just forward me the queries for how to create table, database, and how to make database connection in my jsp code...........reply me soon pls.......... give me example code,,,, i wil try to … |
| | Hello all. I have a small db, that has news. I want to update the field "content" to add the phraze "<br>Aproved by Admin" for every row in the database. A better explanation, i have table news, with 1 table that is defined : create table news (id int, creator … |
| | Hi, I'm using Cron Jobs to set up an automated script which checks for jobs which were posted 7 days ago, which will then delete the record and send the customer out an email. I've got a bit of knowledge using php and mysql however i'm not sure on how … |
| | I am trying to link one variable in the search results to its corresponding variable which is in the same row but on a different field result. For Example [B]title || lyrics[/B] father || am i so proud to be your son... If I search for father, I get father …  |
| | Hi, I have the following dates, either: - 07-09-09 (which is 7th September 2009) or - 07/09/2009 (which is again 7th September 2009) I need to reformat whichever one of these formats comes up so it is correctly inserted into myql db via php. Have tried strpos to find - … |
| | Hi, I have installed "MySQL-python-1.2.2" in my CentOS 5.3 server using "python setup.py install" command. It is giving me the error as : Traceback (most recent call last): File "setup.py", line 5, in <module> import ez_setup; ez_setup.use_setuptools() File "/home/installars/MySQL-python-1.2.2/ez_setup.py", line 85, in use_setuptools import setuptools; setuptools.bootstrap_install_from = egg zipimport.ZipImportError: can't … |
| | Hey; I'm hoping some database wizards could help me out with this question. I have been trying to decide between MYSQL or MYSQLI. I would appreciate as much info from experienced database developers/deployers on which database offers the most security. |
| | I had a rather short question, doesn't OOP Programming make you increase the amount of executed queries? [code=PHP] class Guild{ private $members[]; private $sName; private $iLevel; function __construct($guildId) { // get all information from db using the guildid // also get all memberid's from the db and pass these trough … |
| | Hi, I've got the following type of date string parsed from an OFX file: 20090902000000[-5:EST] How can I get this into my mysql db via php - formatted as d-m-Y I've tried : [code]$ofxdate = strtotime("20090902000000[-5:EST]"); $stmtdate = date("d-m-Y",$ofxdate); [/code] Obviously wrong! ... Any assistance appreciated! How would I do … |
| | |
| | How do I store checkbox values in mysql database using java :-)?  |
| | Hi all, I am New to jsp, i want to create database,, i have ms access, but it does not store more data, so i want to mysql database , give me the link , which version wil be better for my jsp application ......reply soon pls...and tel how to … |
| | I wish to develop a program which used to play the sound file. The problem I face now is I wish can play the sound file when select the userID from mysql database. For example, when I select one of the userID from combobox, then the sound file can automatically … |
| | Apologies for the vagueness of the title but I cannot see a way to sum this up in a title... I have a table storing the individual words of sentences. Think one column is for a sentence id, the other is for a word in that sentence. So there are … |
| | hi I have database with charest " latin1_swedish_ci " where data is represnted like " ÇáÚÇÈ ÇßÔä action game ÇßÔä ÇáÚÇÈ " as u see the strange chars is arabic I've tried everything, i mean i thought i was really good at converting charests i know it .. but never … |
| | hello, i am new to php and i am problem whie installing classifieds my database is hitech_classifieds and username is hitech_admin Please tell me how should i write that info in the following code so the errror doesn;t come <?php $haserrors=FALSE; function print_sql_error(){ global $haserrors; $haserrors=TRUE; print('<font color="#FF0000">' . mysql_error() …  |
 | HI guys, I am working on my end year project that involves replcaing use of SMS to chat on TV. i.e. instead of sending an SMS when asked for views, you just open my Midlet and write the comment. THe ricky part coes in when I need to maintain the … |
| | Hey. I've got this code, [CODE] // query article $query1 = "SELECT * FROM (articles LEFT JOIN authorisation ON articles.page_id = authorisation.page_id LEFT JOIN authors ON articles.author_id = authors.author_id) WHERE articles.page_id NOT IN (authorisation.page_id) ORDER BY issue ASC"; $mysql_result1 = mysql_query ($query1) or die ("Query '$query1' failed with error message: … |
| | Hey all :) I am currently working on a database and stuck on a question regarding SQL. I know the basics of SQL although this question has me stumped A list is required of dogs that have career winnings better than that of the average dog. List the dog_id, dog … |
The End.