7,368 Topics
| |
Hello all, I am designing a website using php and My SQL. It is an educational website which has an administrator... the adminstartor shall have the apility to add, delete or modify a course. I finished a part of the website but i dont know how to begin to implement … | |
hi, I decided to build a quick forum system for my site. nothing too advanced...heres the db setup i have. create table ForumsTopics ( id int auto_increment not null, topic_id varchar(7) not null, title char(100) not null, cat char(1) not null, views char(6) not null, date DATETIME not null, last_mod … | |
[INDENT]I recently bought a piece of software and am having a hard time installing it. The instructions tell me to: 1.create a database on my [URL="http://www.computing.net/dbase/wwwboard/forum/126.html#"][COLOR=green][COLOR=green! important][COLOR=green! important]server[/COLOR][/COLOR][/COLOR][/URL](I have cpanel) 2.create a user 3.Enter this information in dbsetup.php file 4.Create a directory and ftp the files in the public_html folder … | |
How come MS SQl Server 2000 does not have an autonumber datatype as like MS Access does? Any alternative? | |
hello can anyone tell me how to insert the NULL value into a field? | |
I'm real stuck on a php jump script. Basically a value is called from my .html pages; somthing like this: <a href="jump.php?m=c"> which looks at the jump.php page and redirects the user. I track the number of clicks in a MySql database. I want the code to check the database … | |
Hi..plz..help me with the installation of mysql rmp for linux system...the purpose of my download is i am connecting my system to the router and trying to monitor the attach and any pre signature of the attack..plz..tell me the website address to downlaod and the version.. | |
UPDATE: MY COMMENTS POST BUT NOTHING ELSE? I have a form that collects firstname, lastname, email, attachment(file), and comments. I can query from my database, but when i submit data the fields are BLANK? What is going on? Below is sql on export. Table structure for table `clientlist` -- CREATE … | |
Hi all, I am having trouble working out how to pull up shipping options from a table based on two parameters, countryID and productCode. I have the following 2 tables: [B]ECOMMERCE_shipping[/B] shippingID countryID productCode cost1to2 [B]SYSTEM_countries[/B] countryID countryName What I want to do is feed it say, 3 product codes … | |
| ok, well i know sql well but i am new to MySQL, learned that(mysql) few months back. however i have installed a new software called Altova DatabaseSpy to make my work much easier. Its working with all other databases Oracle, MSACCESS and all but not running or connecting with MySQL. … |
Suppose I have this two tables; Modules and Student Modules has the following fields [LIST]Module_Code(Primary Key) [/LIST]Module_Name Student has the following fields [LIST]Stud_Number(primary key) [/LIST]Stud_FullName My problem is that I want to include the Stud_Number on the Modules table to make it a primary key. Can anyone show me the … | |
Is there an open source script of some sort, or can how can I make something that takes a backup of a give MySQL Database and every day it daves a .gz of the database toa directory on my server, so it is backed up automatically every day....:cheesy: Thanks for … | |
I have two tables: tb1: ID USERNAME 1 u11 2 u12 3 u13 tb2: ID USERNAME 2 u12 My question is how to retrieve records from tb1 and exclude one that is in tb2, so the result will be: ID USERNAME 1 u11 3 u13 Any comment? Thanks in advance. | |
I NEED HELP PLEASE PLEASE PLEASE THE PROBLEM IS [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B] [PHP]<? $conn_id; $sql_res; $sql_res2; $sql_query; $HTTP_REFERER=$_SERVER["HTTP_REFERER"]; $REQUEST_METHOD=$_SERVER["REQUEST_METHOD"]; function sql_connect(){ global $conn_id,$sql_host,$sql_user,$sql_pass,$sql_db; $conn_id=mysql_connect($sql_host,$sql_user,$sql_pass); mysql_select_db($sql_db); } function sql_execute($sql_query,$wtr){ global $conn_id; $sql_res=mysql_query($sql_query,$conn_id); if($wtr=='get'){ if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else … | |
why does [code]$sql = 'SELECT userid FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value` LIKE "68104"'; $query = mysql_query($sql);[/code] find 23 records, but [code]$testvalue="68104"; $sql = 'SELECT userid FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value` LIKE "$testvalue"'; $query = mysql_query($sql);[/code] finds none? Shouldn't they be the same? Can I not use … | |
Hi All. I have a very large single-table database of articles that I want to convert to a multi-table, relational database. The existing single-table database contains fields for article author, article source, and article category, where several 'author', 'source', and 'category' IDs repeat dozens of times for hundreds of different … | |
I have a simple database for hockey stats for my son. I can enter data into the db and pull it back, but I wanted to have points, which is goals + assists, displayed without entering into the DB. I enter both Goals and assists into the database and display … | |
hello has anyone installed and uploaded phpadmin through dreamweaver. can anyone explain to me how? im a bit stuck | |
I am new in the forum. Actually i am not sure where to post this tread too. But i am wondering if anyone can kindly help me to understand Microsoft Solution Framework more.(MSF) From what i know, its a software installed in your computer to act as a server. And … | |
Hi everyone, I feel like such a dumb*** because I don't know how to make automatic database backups. I would love to make backups every 3 days or so. Perhaps 3 times a week would be good, not daily though. I'm using MySQL and Windows and my current method of … | |
Hi, Is there any freeware to convert mdb format to mdf format? When converting mdb to mdf, why does it keeping prompting for server name , then user then password. Even thou i'm converting it from local server....without having to use the lans connection. Is there any other way of … | |
MySQL version 4.0.27-standard I want to write selected columns from a table to a file in my web site I've written the following SQL statement, but I'm unsure about the syntax SELECT event, location, eventTime, eventDate FROM commingEvents INTO OUTFILE '/home/_wmevents/public_html/wmEvents.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED … | |
Hello, I have a database in Access, and I know SQL coding for it. So i wrote a query that would get different things from database and put it all together in a nice table.. I update the database, it updates the output from query. I also have a website, … | |
Hi, I need some help here. Can i actually link all my access form to website? How can this be done? Please help. Thanks. | |
How do we go about doing a query under SQL server? And can i actually use the form in access to link to the tables on SQL server? Please advise. Thanks. | |
What is the most popular scripting language on the internet? what is the most popular Database? | |
Problem: I have two tables and those two table have one field in common which is "S_ID" first table have 2 fields: "S_ID", "T_ID" second table have these fields: "S_ID", "First", "Last" ---------------------------------- What i want to do is that i need to extract the the field "S_ID" from the … | |
Hi all, I install mysql 5.0. I create one stored procedure on my local machine. Simply I need to create same stored in Live server. Is there any GUI to access mysql 5.0. like sql server or phpmyadmin. I can access Mysql 5.0 from command prompt only. On mysql prompt, … | |
Hi How can I to access to mySQL data base on my web site from visual basic 6 application. thanks. | |
I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query("CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)") or die(mysql_error()); mysql_query("CREATE TABLE spam_free( … |
The End.