|
|
|
Home » Network Pages
A D V E R T I S E M E N T
Resource Directory
MYSQL Questions and Answers Page
- MySQL resources
While the MySQL documentation is quite extensive it may not explain things in a way that is completely comfortab...
- MySQL 5 is latest version. Please read if your version is older than 4.1
The lastest full production release of MySQL is version 5.Some hosts do not support version 5 yet but most shoul...
- base 64 decode in mysql
You'll need to wait for the SQL guys to comment on a fix for this, but it appears to me that its simply a charse...
- Using a value to select table in PDO DBH
Hi, I'm trying to use a PHP variable to select my table ($currentFile gets the folder the page is in) except i k...
- SUM() AND COUNT() in same recordset
I have a darts league. I have one table in the database that stores the total scores (results) and one table tha...
- Help with Query
I have a table that has Name,PickID,Week.I want to run 1 query that will pull into 1 result set the followingNam...
- Update table from query
I have a query (MySQL) which pulls data from 4 tables within the same database. What I would like to do is run ...
- Add column to table in mysql
hi. guys i use mybb as the group creator for my site.i want to add a column named xuid in the mybb_users table s...
- SELECT DISTINCT returning duplicates
Hello. I have a table title_views with each row being a "view" with a user_id, title_id, prog_id, date, and id. ...
- MySQL - Select Count help
Hi All,I was wondering if someone could help me on the following issue im having.I have imported a .csv into a m...
- Returning only 1 row
Hello all,I'm running an sql query that joins 2 tables for stock information.Table 1 has user id's and stock ids...
- Access Error
Please help with this connection problem.Warning: mysql_connect() [function.mysql-connect]: Access denied for us...
- Stop automatic rounding of numbers
I have a row called "price" and each time i add numbers like "14.99" it is automatically rounded to "15"How do i...
- Problem with mysql_connect()
I'm getting the all-too-familiar error: Code: Warning: mysql_connect() [function.mysql-connect]: Access denied f...
- Capturing checkbox value of a string and moving to another table.
Why move them to another table at all? Why not merely have a Confirmed column in the one table? ...
- Delete query syntax not right
Hianyone see why this query doesn't work? PHP Code: $sql?=?"DELETE?FROM?`Check`?WHERE?`url`?=?'$url'?AND?`t...
- Trying to export Joomla database without phpmyadmin
Hi,I am trying to export my Joomla 1.5.23 mysql database. I have no phpmyadmin. I used several ways like this (h...
- A Join that exlcudes if data does exist
I have two tables that I want to use a join to exclude data if it exists in the other table. I basically want a...
- SQL syntax
I'm moving a site over from another hosting company but when i'm uploading sql file i get the following error: Q...
- ReOS mySQL Issues
I get the following error while trying to install, i have tried changing "type = innodb" strings with "engine = ...
- column can not be null
Code: 'f` INT(10) UNSIGNED NULL DEFAULT NULL Code: update tset f = nullwhere f = 0--> err 1048 column f can no...
- Data truncated for column ...
Only want to add 'date_observation_for_exact_id_galery' column to index. Code: ALTER TABLE `tezaver_place_date` ...
- Database table data not being displayed in right format on browser
The contents of a mysql database table are being displayed as one continuous story without paragraphing (i.e. no...
- Doubt with SQL syntax, but same result
Hello,I'm new in the forums. Well, I'm learning SQL and I got a doubt when I do these two requests: Code: SELECT...
- Correct syntax for getting information from two tables
I know this is possible and I've done it quite often in the past. But I haven't used MySQL in months(been doing ...
- Limit not working for avg query
Hi, trying to limit avg, to last 10 entry's only, my query's do not work,Limit I thought is just the starting an...
- log queryies from stored proc
How to do that ?I have: Code: set @@long_query_time=0;show variables like ' long_query_time ';and things are get...
- Resolved using data from mysql_fetch_array
Hi,I have taken data from MySQL in the standard way and have $row['datefield'] etc to use in a table. Depending...
- Back Up MySQL Databases
Hi - how do you guys backup your MySQL databases?I have a few programs that have an auto-back up that make an .s...
- Tracking Watched Videos
I am in need of some help here, I designed a website for a company that does temporary jobs for the medical fiel...
- php mysql int default syntax error
I've tried every variation I can find for this and still get errors.I'm creating a table that has a 'ItmNum' whi...
- Resolved Problem trying to Update a mysql record
Hi everyone,I am a complete beginner when it comes to coding, i cobbled my results system from varying websites,...
- Primary keys, indexes and auto deleting rows from multiple tables
I have about 4 tables in my MySql InnoDB database (members, stories, characters, comments). In my site people ca...
- Mysql query newest entry for each idproduct?
PHP Code: ???????????$query?=????????("SELECT?*?????????????????????????FROM?operators????????????????????...
- Resolved Average page display from field query
Hi, hope everyone is having a nice holiday weekendcolumn type is (double), storing a microtime valueI am trying ...
- please let me know where i am wrong in this query.
Hi,I am new user and also new programmer in my sql I will highly appreciate if someone will help me on follwing ...
- Multiple keywords search in multiple columns
Hi folks,I don't know if what I want is feasible and how. Hope you can help me find the right direction.I have a...
- Drawing an ER diagram for an implemented database
I have created a simple database with several tables and am trying to back track and create an E-R diagram of it...
- Negative values become high integers
Query I'm executing Code: UPDATE players SET points = ((wins * 5) + (kills * 2) + assists + (deaths * -2) + (mi...
- Resolved proper field for microtime
Hi, What is the ideal MySQL field setting formicrotime(true);round(($end_time - $start_time),2)storing something...
- How to reset ID when deleting row?
I have a table where the user can add events. The ID field is set to auto-increment, so every time an event is a...
- DB input form design
Hello all, not sure if this is the right forum as the question involves both MySQL, php and maybe js. I have bee...
- PHP Database Abstraction Layer
I am seeking a good Database Abstraction Layer for PHP I can use. My main requirements is it to be fast, compati...
- error in shoppingcart
i found some error in shopping cart data retrieve for my order listi need to retrieve item_name form my order_ta...
- Updating data in a MySQL database
Hey guys, I'm trying to update the "hours" and "minutes" of an accounts row.I'm sure I am doing this wrong, and ...
- MySql database file import problem
When ever i try to import this file in phpmyadmin it gives an error : Code: SQL query:CREATE TABLE `sbprj_additi...
- Adjacency List model recursive deletion
I have a table with Adjacency List model. Code: id cop title pid10 1 four 99 1 three 88 1 two 77 1 ...
- How to use data generated from form?
Hello, I'm somewhat new to PHP, so perhaps what I'm trying to accomplish is a little too over the top of my head...
- Create a "Search Engine" of a MySQL Database
Hi,I'm not new to SQL or PHP, or basic queries of SQL databases, but I'm creating a site that's going to be depe...
- Union Order By Question
Hi All,Im trying to order my query in two places, the first select, and the second select.I dont wish to order m...
- Split A Folder Path
Hello,I am looking at an SQL database table where one thing I have found is I have a Folder path. I would like t...
- How to pull a list....
Hey everyone I've got a question for you that's been stumping me for a while...I have a table of relationships l...
A D V E R T I S E M E N T
|
Subscribe to SourceCodesWorld - Techies Talk |
| |
|
Add to Favorites
Make Home Page
