10,938 Topics

Member Avatar for
Member Avatar for Dani

Certain graphical elements in this forum (such as user's avatars and file attachments) are actually stored in the database instead of in the file system. Is there a way to back these up along with the database? For example, when I make an sql dump file, it obviously doesn't export …

Member Avatar for igotdreams
0
430
Member Avatar for Wealth_Builderz

Hi, I have come up with a project to design a web-based Complaints and Suggestion System for a local estate agents in my area and I am going to use PHP with a MySQL database and at the moment I am doing all my Process and Data Analysis before moving …

Member Avatar for mikeSQL
0
153
Member Avatar for AlPhA

So... what is better, SQL, MYSQL, MSQL, POSTRESQL, and etc for a fast database that must be used in conjunction with asp and php. For now, i'm looking for the easiest database to be used in conjunction with ASP. Any suggestions? [flash]http://www.geocities.com/cyberpitstop/footer.swf[/flash]

Member Avatar for mikeSQL
0
615
Member Avatar for innersmile

Hi, I just built mysql from source on Solaris. It's installed in my own space since I have no root access on that solaris server. The problem is I always get following error when trying to run mysql. sand:163% ./mysql ERROR 2002: Can't connect to local MySQL server through socket …

Member Avatar for mikeSQL
0
178
Member Avatar for mikeSQL

I just feel like posting this today because I had several people asking me on how to use this Desktop Applicaiton called MySQL Maestro. Below is a self tip to help get you started and squared away for the most part. The rest once you get into it, youll pretty …

0
74
Member Avatar for indiefi33

Here is the error I am getting: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/movethem/.panel/web/portal/73/includes/sql_layer.php on line 286 This is in correlation to a calendar that I installed. Would anyone have any idea how I can fix this? My main config file is working as …

Member Avatar for mikeSQL
0
126
Member Avatar for ShemR

We've recently developed a complicated relational MYSQL database which, on a data storage level, is working really well. Unfortunately, in terms of being able to sort and edit sometimes very large data reports, our front end interface (a custom built work in progress) often scores a relatively unimpressive "C-". Complicating …

Member Avatar for mikeSQL
0
126
Member Avatar for paradox814

is there a way to check the exsistance of a table? I want something similar to this: SELECT COUNT(*) FROM table1 but for a table (in a given database), not rows within a table I know of another line command: check table table1 quick but this gives back too much …

Member Avatar for paradox814
0
83
Member Avatar for mikeps

I am getting a syntax error report from an UPDATE using two tables in a MYSQL db. :cry: This must be my mistake but I can't see it and have changed around many times now. Any ideas to help me resolve this welcome. Statement: UPDATE hole,tee SET hole.hx=tee.tnx where hole.hid=tee.hid; …

Member Avatar for mikeps
0
148
Member Avatar for serfurj

has anyone used embedded mysql in their app? please share your experiences. i'm contemplating whether or not to do it. i may just use XML. i know it's improper, but a lot of commercial apps do it!

0
102
Member Avatar for whatsgoin'on

I'm new to SQL and was wondering how exactly do i use the join in a query. i have 3 tables, with the primary keys from the first two tables acting as keys for the third table. I have to get information from the first and third tables but need …

Member Avatar for starsunited
0
113
Member Avatar for jyothicm

Hello, I am very new to the world of Linux. Could someone tell me if I were to setup one machine with Linux, Apache, MySQL and PHP and dual boot it with Windows 2000 Professional, what would the ideal hardware requirements be. Also, what is the ideal size of a …

Member Avatar for DMR
0
185
Member Avatar for hexstar

Well first some background, this hasn't happened before but last night I had some trouble installing a shoutbox mod so I undid all the steps I had performed I have also installed a search engine friendly mod successfuly which makes php links html links even though I know ipb supposedly …

Member Avatar for hexstar
0
202
Member Avatar for jrworks

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 for jrworks
0
204
Member Avatar for AwSDesigns

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 …

Member Avatar for AwSDesigns
0
149
Member Avatar for vexer007

Hi, I've run into absolute brickwall and am really desprate for your help please. I have a MYSQL Database with two Tables called user_comment and the second user_table. When a user register with the site, their details are kept in the user_table. the second table user_comment is so that users …

Member Avatar for Roberdin
0
151
Member Avatar for billah_norm
Member Avatar for Roberdin
0
124
Member Avatar for typedef

Hi, im new to the forums and i hope you wont mind me launching in with a big question! Ii am currently prototyping a multimedia information system which holds wakeboarding images and videos, along with a comprehensive set of meta-data about the multimedia data. Users can query the metadata in …

Member Avatar for fpepito
0
428
Member Avatar for jcolome

I have a portal site [url]www.localmiamiguide.com[/url] that needs to be transfered to mysql. Anyone have any idea how much that would run me? :cry: Please advise. Jcolome [QUOTE=fsn812]I have worked on large scale projects using Oracle, medium sized projects using MySQL, and some small projects using Access. All have worked …

Member Avatar for kc0arf
0
154
Member Avatar for jyothicm

I have created a small application in PHP and MySQL. Could someone tell me what I need to do to add the appln. on an Apache Web server? Is there anything I need to take care of in the application to be a web app?

Member Avatar for jyothicm
0
123
Member Avatar for vnnguy

:cry: I downloaded MySQL 4.0 then clicked on Setup file but ... (oops!)The followin' message appear [IMG]http://img94.exs.cx/img94/8826/error2.jpg[/IMG] Just tell me how could i solve this pro??? Thank u a lot!!!

Member Avatar for eddie5659
0
207
Member Avatar for phneoix

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 …

0
100
Member Avatar for TimmyRaa

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 …

Member Avatar for TimmyRaa
-1
424
Member Avatar for tomcdit
Member Avatar for vnnguy

hey ya , i get some problems and hope u can help me to solve it first, i'm using Window XP , Laptop - service pack1 , uhm .... i tried to install mySQL on my computer but it didnt work ... some1 can help me to install MySQL , …

Member Avatar for Banderson
0
146
Member Avatar for phpnovice

Hi, I have apache, php, phpmyadmin, and mysql in my computer. I could connect to mysql and manipulate database well before. But for an unknown reason, I can't do it now. Each time when I tried to do this, it gave an error message as "Can't create TCP/IP socket (10091)". …

Member Avatar for Killer_Typo
0
113
Member Avatar for ecashwell

I'm trying to get started in ASP.NET, but I just don't understand the errors being returned to me. I'm trying to connect to my MySQL database. I have followed several examples from books and the internet with no success. Could someone look at my code and see if I'm screwing …

Member Avatar for ecashwell
0
142
Member Avatar for csc Mindy

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 …

0
128
Member Avatar for TelKennedy

Hello I have just bought a book on php, MySQL and Apache server which came with an installation disk. I have installed all three on my laptop computer running MS XP Professional. All three seem to work ok independantly but when I try to run any code examples through IT …

Member Avatar for Roberdin
0
243
Member Avatar for [Pat]

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 for [Pat]
0
176

The End.