11,093 Topics
 | |
| | Ok, so i created a db, with the help of the MYSQL manual ;) and think i'm on the right track (well, i'm on a track at least). this db is for our members area (car club web site). I put 3 tables in there users auto_info auto_mods all 3 … |
| | Hi folks...... I'm a bit new to this... played with DB's on an off for years...... now getting back to programming and web design, learning to play with all the big boy's toys etc. LOL Yet I must admit that I have fallen for the simplicity of access's ability to … |
| | I would like to create a deployment project for my application. And my application need mysql as database, my deployment package will package the mysql installation. How to use VB.net to check whether mysql had been installed in the client PC and if not install, mysql installation will be initiated … |
| | I have a general user account which has all of thr rights and priveleges that I wan all of my users to have. Is there an easy way to copy this account to create new users with the same priveleges? Thanks, Chester  |
| | Hi MySQL Boffs, I have been given resposibility to adminster our my company's website. We use a Content Management System. I would like to add abilities to it such as a Meta Tag & Title field for new pages I create I have started self-teaching myself PHP & MySQL on … |
| | Hi! I hope someone can help me out on this one. I have been trying to get it work since last night. I am making an application where I can add a quiz. The quiz has questions. Each question has a certain number of choices and out of those choices … |
| | hello everyone.. i'm a newby in mysql but i'm trying hard. So i won't lose a minute, and i'll go straight into the heart of the problem. I have the following mysql dumps: DROP TABLE IF EXISTS location_tree; CREATE TABLE location_tree ( id int(11) NOT NULL auto_increment, pid int(11) NOT … |
| | Is there a way I could create a variable that belongs to a table much like a static variable belongs to a class? So it "thing=1, person=2" were variables belonging to the table structure (not each row), then I could do something like this: SELECT * FROM table WHERE type … |
| | Hallo, ich möchte in einer Tabelle die Zahlen einer Spalte nach Grösse sortieren. Das Problem ist, dass das die Zahlen aus bestimmten Gründen Kommazahlen sind, also z.B. 1,3 45,3 etc. Kann mir jemand sagen wie das möglich ist? Ich habe leider nicht so viel Erfahrung in mysql..... Grüsse Kathrina |
 | I have a bit of a problem with my newsletter here is the error I get: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/happy/public_html/newsletter/subscribe.php on line 64 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/happy/public_html/newsletter/sindex.php on line 244 Warning: extract(): … |
| | I am looking to setup a site that searches inventory. Something like AutoTrader (as far as the searching goes). Basically just enter vehicle make, year, etc and the results appear. What language would I write this in? As you already guessed I know nothing about databases, can someone give me … |
| | I have a dual xeon 2.4 with 2gb ram. My repair has been going for over 14 hours now. Is this normal? It's the post table from vB, so there is lots of data. if it is normal, how much longer do I have to wait? this real sucks. :mad: … |
| | Hello please help Total php beginner please help i am going crazy my home-page opens finishes loading but with error's on page and my hitcounter does not display on my site but it's still logging my site I looked through my site files and found this error below. Is this … |
| | I am getting the following error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/champion/public_html/search.php on line 34 when doing a search for text in a description or product name. The error only happens when I do a search for multiple words. Here is the code: … |
| | Hello, I am trying to set up the phpbb forums on my site using MySql and I don't understand how to link MY site to the DATABASE. I also can't seem to figure out where my username, password, and the name of my database as I need them for the …  |
 | Hi there all, I'm about to develop a site with a DB backend & I want to know how one goes about doing organic SEO if most of the site is DB driven. There will be some text on the page, but certain things that are pulled from the DB, …  |
| | i want to generate a unique primary key, something similar to the auto increment feature, but i do not want it to be auto increment. The reasoning for this is: this table will have rows deleted by the hundreds every day, and maybe even thousands in a few years (I … |
| | Hi guys, can anybody help, plase. Is there an instrument to manage .edb file (as far as i know Oracle's Enterprise DB but under free licence)? |
| | please help me when i run my code by using Mysql_num_rows() Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\php\connect to database.php on line 13 this is my code <?php /* declar some relevant variables */ $Host = "localhost"; //location of mySQL on server $Table = "books"; … |
| | Okay, I have been working with MySql for quite a while on Windows and can generally do what I need. I use Navicat to do a lot of the work because it is a lot faster than working it from a prompt. Anyway, I got permission to set up a … |
| | Hi guys, Sorry to make my first post so elaborate, I hope to provide help to others soon... :lol: I'm looking at co-locating a web server, the purpose of which will be to host as many small scale websites as possible. Unfortunetely, I have very little knowledge of webserver hardware … |
| | Hi friends, I have very little knowledge of JOINs. Please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL versios. TABLES IN MY DATABASE: Room (room_ no, room_ type, price) Guest (guest_ no, Fname, Sname, address) Booking (room_no, guest_no, Fname, Sname, arrival_date, departure_date, emp_no, … |
| | Hello Dani PHP Members. My name is Michael, I have been looking online for a place to learn php and at this point I have given up. I am wondering if there is anyone on here that can teach me php and mysql. Or if you know of any places … |
| | This is going to sound crazy - but is there any way to to a search for a phrase of text within my SQL database? (I am obviously not very knowledgeable) except on how to get there! :) Thanks for the help! |
| | i have one table,which maintain daily transactions for each minitute,but i would like to know per day for each 15 minutes interval how many rows are entering into that table |
| | Hi, How can I delete from multiple tables? I'm using this query and its not working: "DELETE FROM table1,table2 WHERE $localTime > table1.Time OR $localTime > table2.Time"; What I hope to achieve is deleting rows from table1 and table2 where their Time Field is less than $localTime. Thanks very much. |
| | |
| | Hello php gurus! i need help with a little script, i have to import a tab delimited files into a mysql db file.tab [CODE] "user1"TAB"pass1"TAB"miscdata1_1"TAB"miscdata1_2"TAB"miscdata1_3"TAB"miscdata1_4"TAB "user2"TAB"pass2"TAB"miscdata2_1"TAB"miscdata2_2"TAB"miscdata2_3"TAB"miscdata2_4"TAB [/CODE] Here is what i have programmed with the help of google [CODE] <? include('config.php'); $conn = mysql_connect($dbserver, $dbuser, $dbpass); if (!$conn) { echo … |
| | I am completely new to phpMyAdmin and relatively new to MySQL, so this may be a dumb question. Please forgive me if it is. I have MySQL running successfully, no problems that I am aware of. I have IIS running on the same server with PHP installed and am successfully … |
| | This has an error way down at the $result=mysql_query($query) line. Anyone knows whats up? Or could it be my login info? Is localhost bad? [PHP] <?php /* grabs the POST variables and puts them into variables that we can use */ $email=$_POST['email']; $city=$_POST['city']; $state=$_POST['state']; //---------VALIDATION--------> if($email){//----> CHECK input } else{ … |
| | I am a student and am developing my knowledge of MySQL and am practicing using it as a backend for some of my apps. I can run MySql on my laptop (Windows XP Pro) and use my apps referring to the local host. We have a wireless network in our … |
| | Hey, I am having a really stupid yet annoying problem. I have a simple database stracture (I'll give an example below) and I want to do a query that will loop through it's elements trying to display the list amount of times each element (trying to make it the most … |
| | I have a form that should write to MyDQL Database but isn't I have been looking at it for hours and it is driving me crazy. [CODE]$sqlquery = "INSERT INTO $table VALUES '$id','$Name','$DoB_Day','$DoB_Month','$DoB_Year','$Address_1','$Address2','$Town','$Postcode','$Telephone','$Mobile','$Email','$6th_Form','$6th_Form_Year','$6th_Form_Institution','$6th_Form_Course_Title','$College','$College_Year','$College_Name','$College_Course','$E2E','$E2E_Provider','$Apprenticeship','$Apprenticeship_Level','$App_Employer_Name','$App_Work_Area','$Employment','$Employment_Basis','$Emp_Employer_Name','$Emp_Job_Title','$Emp_Training','$University','$University_Name','$Uni_Course_Title','$Gap_Year','$Unemployed','$Other')";[/CODE] I have used this method before and it worked fine but it just isn't playing nicely today. … |
| | I bought a book called PHP/MySQL Programming for the absolute beginner by Andy Harris, Premier Press. This book is great for a beginner. It walks you through a refresher on HTML and then goes step by step into PHP and MySQL. Great examples and VERY challenging "homework" assignments. Great for … |
| | Hi, I have installed PHP4 with MySQL4 and APAche2. Apparantly with an API client 3.23.49 I need to upgrade as MySQL is on 48 bit password and not 16...I keep getting " mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in..." How do I … |
 | When attempting to compile PHP 5.0.4 with MySQL 4.0, I received some strange errors from attempting to use --with-mysql and --with-mysqli. After getting it to configure correctly, where it finds mysql and mysqli support, when I run make I get these odd compile errors: == /usr/src/php-5.0.4/ext/mysqli/php_mysqli.h:48: error: syntax error before … |
 | Is it possible to use MS Access as a db with PHP? If so, how? If not, is there a way to convert (for free without buying a program) MS Access file to MySQL? Thanks for your efforts  |
| | .................a script for event booking with that uses PHP and Mysql and links to a third party such as worldpay or paypal for payments? I've had a look and I can't find anything specific to my needs. What I'm really after is something like the track day booking at [url]www.bookatrack.co.uk[/url]. … |
| | I am doing an SQL statement that tries to get the [B]percentage[/B]..but i dont know how to do it in MySQL here is the sample of my code: SELECT count( * ) , rating, percentage.... FROM `acne_prod_rating` WHERE prod_id =5 GROUP BY rating the output should be like this: count(*) … |
| | Hi! I'm building a login system for my application, but I'm having a little problem... It really needs top security, so I'm using both MySQL backend and cookies. Example: [B]LOGIN FORM[/B] > [B]VALIDATION[/B] > [B]INSERT SECURE SESSION ID INTO DATABASE[/B] > [B]STORE COOKIE WITH INFORMATION[/B] That's for the login. For … |
| | I have a link per customer for mrtg graph and remote reboot access. I need to be able to integrate the login to be password protected, connected to ModernBill database where the client can use their MB login info to access the mrtg / remote reboot page as well. How … |
 | Hi! I'm currently learning on my own on PHP(I have some basics on HTML). Anyway, I learnt that I need to download php from [url]http://www.php.net/downloads.php[/url] The first two downloads I saw was this:- * [SIZE=3]PHP 5.0.4 ([COLOR=Blue]tar.bz2[/COLOR]) [4,620Kb] - 03 Apr 2005 md5: fb1aac107870f897d26563a9cc5053c0 * PHP 5.0.4 ([COLOR=Blue]tar.gz[/COLOR]) [5,702Kb] - … |
| | hi! any help given is much much appreciated. i really need to get some work done and my pc is running extremely slow. i've run panda scan, trendmicro, adaware, spybot, stinger, cwshredder, avg!!! here is my hijack this log: thanks in advance!! twoc Logfile of HijackThis v1.99.1 Scan saved at …  |
| | Will a Windows sever with PHP and MySQL run it? Or do I have to have a linex (sp) sever? |
| | Hi, im new at this forum alittle about me, im 24yrs old, live in WA state, im mostly a webdeveloper doing xhtml,css, javascript, but specializing in php,mysql,asp.net and apache server administration. |
| | Hi all. What I want to do is be able to dynamically insert a picture based on a search result. For example, if someone were to search for a movie based on it's title, I would like a picture of the movie to display along with the other info that … |
| | Hi. I want to escape any special characters in the input field before inserting the data into mysql tables in C++. Here is how I am using this function [QUOTE]// Escaping special characters in the Subject field char * S = new char[strlen(m_headerSubject.c_str())*3 +1]; mysql_real_escape_string(conn, S, m_headerSubject.c_str(), m_headerSubject.length()); m_headerSubject = … |
| | Hi I am new here as you can see, well I want to learn PHP, and I don't know where to start. What I want to do is make a game like [url]http://www.racewarkingdoms.com[/url], and you have probable heard of it before, Outwar. If you could point me in the right … |
| | Hi, We have a accounting/inventory program that uses MS SQL as the database, with VB and Access for reporting. We want to make the database available online. ie.. Our clients can search the inventory and make orders from it. We do not want to install a local web server inhouse. … |
| | Please, please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL version: The query should retrive any availble rooms from the database MY ATTEMPTED SUB-QUERY: Select * From Room R Where R.room_no NOT IN( Select B.room_no From R.room_no = B.room_no And R.room_type = ‘single’ … |
The End.