|
|
Browse by Tags
- 2003
- 5
- 5.0
- 5.0.45
- 5.1
- access
- AJAX
- another
- apache
- asp
- backup
- between
- C#
- centos
- change
- characters
- coldfusion
- column
- command
- connect
- connection
- convert
- count
- create
- csv
- data
- database
- date
- datetime
- Dreamweaver
- dump
- error
- excel
- export
- field
- file
- find
- Firefox
- foreign
- from
- how
- html
- iis
- import
- index
- innodb
- insert
- install
- java
- JavaScript
- join
- joomla
- key
- linux
- load
- local
- multiple
- myisam
- number
- odbc
- one
- optimization
- oracle
- order
- outfile
- password
- perl
- php
- phpmyadmin
- procedure
- queries
- query
- remote
- restore
- root
- row
- rows
- select
- server
- sql
- start
- statement
- stored
- sum
- Sun
- syntax
- table
- tables
- text
- time
- timestamp
- trigger
- update
- user
- using
- value
- varchar
- where
- windows
- wordpress
-
How do I get a user ID from a logged in user and include it in my query
Experts, I have been trying for a week to get this figured out, and am so close I can taste it. Please help me over the hump!!! I am trying to pass value from a user profile (logged in), to an HTML form. The only thing holding me back is this query 1: $query = "SELECT firstname, id, lastname, cb_company... -
php ordering numbers highest to lowest
Hi all Im developing a PHP script pulls lots of results from a quiz out of a database and then works out the average score for each country that a user can choose to play for. So far so good I've got my script down that does all of this. However what i need to do is use these results and order them... -
How would I get mysql to generate a 4 digit number and never use it again
How would I get mysql to generate a 4 digit number and never use it again if it finds it in the db.I need to auto put an invoice number into a form so that once the form is posted into the data base I can run queries for the data on that invoice. I use a random number java script right now but sooner... -
PHP Check if MYSQL table exists
Hi, I have a function that is supposed to check to see if a table exists but it always returns as the else... any ideas as to why? 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: function checkTable($fn) { @ $db = new mysqli('xxx', 'xxx'... -
Sum a count a of multple columns
How do I sum the count of the following queries? Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: Select count(*) from Race_Results where `2` = "55 R" Select count(*) from Race_Results where `3` = "55 R" Select count(*) from Race_Results where `4` = "55 R"... -
PHP with MySQL Code block error
Hi. I have a php website hosted on Windows Server 2k8 and having a problem with my MySQL class on one page. Not sure if it's my code or something to do with my database query. The problem is my php page shows code instead of the actual variables. ( http://www.supportsolutions.co.za/job.php?job_id... -
MySQL sum of two fields multiplied
i want to compute the total $ for records (rows) in a table where each row has a quantity and a (different) unit price. thus if the table contains: (qty) (unit price) 1 10 2 100 3 1000 i want the answer = 3210 how can i do this without a while loop to multiply individually and accumulate with a running... -
PHP script can't connect to MySQL server
I configured my server and allowed my IP to connect remotely. I entered IP of the server, username and password of mysql user in SQLyog (a GUI for managing mysql server). It connects successfully to database and I can manage everything. I also have a PHP script to connect to the database. the code is... -
HTTP 403 Forbidden error in WordPress installation
Ok, I'm totally new to working with WordPress, PHP AND MySQL. That said, PHP 5, PHPMyAdmin and MySQL are all succesfully installed on our server. I have uploaded the WordPress installation folder into a subdirectory of one of the many domains we host on our server. I modified the wp-config.php file... -
How to place a list (set) in a MySQL query variable?
How would I instantiate the variable OrgList in the following query so that I can use it to replace "1,2,3" in the where clause? SET @OrgList = ????????? SELECT `OrgName` FROM `Organizations` WHERE `OrgKey` IN (1,2,3);