hey I've been getting this error: [COLOR=Red]Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource [/COLOR] This is what it said that is causing the problem: [B]$stafflist=mysql_query("SELECT id,name,sn,email,title FROM staff WHERE man='Yes' ORDER BY id");[/B] Can you please tell me what is worng ASAP. Thank you

Member Avatar
Member Avatar
+0 forum 2

HI all (Battled with the WORD – (probably wrong in these terms)) I have a field in an access database (DateInserted) and want to get a (DateID) field out of it. To get the DateID field I use – [B]Day(DateInserted)&Month(DateInserted)&Year(DateInserted)[/B] - (Unique key for date outputs as 21102004) my problem is that the [B][I]&[/I][/B] function does not work in MySQL. The job I am busy with at the moment requires that I have this (newspaper’s website [url]http://www.zoutnet.co.za[/url] news articles on a weekly basis – DATE IMPORTANT) Question: how can I turn Day(DateInserted)&Month(DateInserted)&Year(DateInserted) as DateID into MySQL savy SQL ANYONE THAT …

Member Avatar
Member Avatar
+0 forum 1

[B]How many clients can access a PHP script at a time from a MySQL server?[/B] thanks in detail.

Member Avatar
Member Avatar
+0 forum 1

hi, i am thinking of designing a customised GUI frontend for mysql. i would like to know which of the programming languages Perl or Python can be used. my preference would ease of use and cross platform compatibility. i have already used off the shelf GUI's for mysql and i dont wish to use php or any other proprietery software. also i do not need web access for my database.

Member Avatar
+0 forum 0

A project that I've been working on (and getting help on [URL=http://www.daniweb.com/techtalkforums/thread10421.html]here[/URL]) is just about complete, but I've had to develop it locally on MySQL 4.1 for it's support of nested queries - I'm [B]rubbish[/B] with joined queries. However, the project is going to be running on my host, who runs MySQL 3.x, which doesn't support nested queries. Therefore I'm looking for help on converting the query below, to not use any subqueries so it'll work on my host. [CODE]SELECT nickname, count( * ) , sum( score ) , max( score ) , min( score ) , avg( score ) …

Member Avatar
Member Avatar
-1 forum 3

I am trying to create an INNODB table with a foreign key, and it doesnt seem to be working. Can someone give me an example on how to use a foreign key. Here is an example of what i have: FOREIGN KEY (client_id) REFERENCES CLIENT (client_id) This line is preventing me from creating the table. It works without this line. Someone please help me :sad:

Member Avatar
+0 forum 0

I am looking for this file: [B]libmysqld[/B] Anyone knows where I could download it? You can reply or email me at [email]pat@pgtour.net[/email] Thanks a lot.

Member Avatar
Member Avatar
+0 forum 2

I am extremely new to MySQL and web databse programming. I am runnning an Invision Board forum and have had numerous problems when installing mods (I know, install at my own risk, blah blah blah). My question is this: I am restoring the SQL database (I did make a backup; I'm not completely stupid), and I am trying to restore it (all the table are in parts). I came to the ibf_posts table (name of table is irrelevant) and am trying to make it create the table on my new database. [FONT=Courier New]CREATE TABLE ibf_posts ( pid int(10) NOT NULL …

Member Avatar
+0 forum 0

I am having difficulty uploading text files to mysql database through phpmyadmin. Here is the feedback from the hosting company: The problem is in the inappropriate input file format (the txt file) - there are spaces before and after the comas. To solve the problem - strip the spaces arround the comas. Can I do this within the webpage code? Any feedback is appreciated.. ;)

Member Avatar
Member Avatar
+0 forum 4

i need to know the format to search for a user name in the database, im using PHP to submit the data so far this is what ive got [php] @mysql_select_db("$DBName") or die("Unable to select database $DBName"); $sqlquery = "INSERT INTO $table VALUES('$id','$name','$email','$opinion')"; $results = mysql_query($sqlquery); mysql_close(); [/php] im using that to insert the data into the database, but i need to know the format to search the database to make sure that the username isnt already in use. $sqlquery = "SEARCH * FROM table WHERE name =(username user wants)"; but i dont know how to tell it to output …

Member Avatar
Member Avatar
+0 forum 5

Finally, there's a book that will help you prepare for the MySQL certification exams. Learn more about it here: [url="http://www.amazon.com/exec/obidos/tg/detail/-/0672326329/qid=1087361084/sr=1-1/ref=sr_1_1/002-7750886-2407247?v=glance&s=books"]http://www.amazon.com/exec/obidos/tg/detail/-/0672326329/qid=1087361084/sr=1-1/ref=sr_1_1/002-7750886-2407247?v=glance&s=books[/url]

Member Avatar
+0 forum 0

Hy, I have a PHP raport and I'm using a MySQL database. That raport have to show me information from database. These information from database I only can see them with Internet Explorer (I'm using it to show me the output from my PHP program). If I want to see information from my database with Mozilla or Opera or Netscape or other browser...the browser doesn't show me those information from MySQL database. Can anyone tell me why? Thanks.

Member Avatar
Member Avatar
+0 forum 1

Hi, i'm making a database on mysql for a uni assignment. In the write up of the report i've been told to put in a logical model which can be done by identifying the relationships from a conceptual model. I know what a conceptual model is and have identified the relationships between entities, but I don't know what a logical model is and what it looks like! Can anyone help?

Member Avatar
Member Avatar
+0 forum 1

[size=2]By: Jeff Johnston MySQL is set to announce some exciting new features at its User Conference in Orlando April 14-16 ([url]http://www.mysql.com/[/url]). The wildly popular free database server is expanding its functionality in attempts to keep up with the competition, PostgreSQL, and Firebird. The two new features are MySQL Cluster and stored procedures. MySQL Cluster will allow more than one instance of a database to take over if another fails. The software is based on NDB cluster made by Ericsson, who sold the software to MySQL in October. The Software, which can be applied to anything from Operating Systems to individual …

Member Avatar
Member Avatar
+0 forum 4

What Is MySQL? A friend told me it was free as long as i didn't sell it. is this true? if so where can I get it and what does it do exactly? thanks

Member Avatar
Member Avatar
+0 forum 1

Hi, I'm having a problem of starting mySQL.. well I'm actually forgot what did I do a long time ago that mess the mySQL up in my server. Well now when I'm trying to execute this command from the terminal such as: /etc/init.d/mysql start .. instead of starting the terminal give me an error said Can't execute /usr/local/mysql/bin/mysqld_safe from dir /usr/local/mysql. Well I have no clue how to fix it. Is anyone can help me with this problem? Please help ... By the way i'm running mysql on redhat 9.0 and mysql version is 3.23.54

Member Avatar
Member Avatar
+0 forum 3

[url]http://staging.infoworld.com/articles/hn/xml/02/10/21/021021hnnovellmysql.xml?Template=/storypages/printfriendly.html[/url]

Member Avatar
Member Avatar
+0 forum 6

Okay, so this forum uses PHP with MySQL... I have access to PHPMyAdmin on a remote server. I have been making periodic back-ups (dumps of the tables) but I'm always afraid that when I need them most, they'll fail on me. There isn't by any chance an easier way to back-up an sql database in linux, right? I have ssh access.

Member Avatar
Member Avatar
+0 forum 1

[url]http://builder.com.com/article.jhtml?id=u00320020624gcn01.htm[/url] From article: [ When to use MySQL] Why would you use MySQL over PostgreSQL? First, we need to consider the needs of the applications in terms of database requirements. If I want to create a Web application and performance is an issue, MySQL will be my choice because it

Member Avatar
+0 forum 0

This is a great tool to use when creating DBs in MySQL. Better than the one it comes with. If you're about to embark on an app using MySQL, I recommend it. [url]http://www.anse.de/mysqlfront/[/url]

Member Avatar
+0 forum 0

The End.