Search Results

Search found 36756 results on 1471 pages for 'mysql real query'.

Page 428/1471 | < Previous Page | 424 425 426 427 428 429 430 431 432 433 434 435  | Next Page >

• Odd PHP Error Message

  - by John

  When I run some php code I've written, I get the following message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition, price, name, email) VALUES('Fake Title', 'Fake Subhead', 'Fake Author' at line 1 I do not see anything wrong with my syntax, however, which is like: mysql_query("INSERT INTO table (x1, x2, x3) VALUES('$y1', '$y2', '$y3')"); Any ideas?

  Read the article

• What kind of index do I need for fast '%term%' lookups?

  - by glebm

  I am using MySQL. I have several lookups like this: SELECT * from users WHERE user_name LIKE '%search_term%' What index do I need to make these lookups fast?

  Read the article

• Application can not run on server in this assembly error

  - by user349953

  Could not load file or assembly 'MySql.Data, Version=5.1.7.0' or one of its dependencies. The system cannot find the file specified.

  Read the article

• How I can set a column value for all my rows that already exist in the database with some sort of my

  - by zeckdude

  I want to set the value of the column 'character_hold' to 'no' for all my rows in my MYSQL database. Is there a SQL statement I can use in phpmyadmin to set them all to 'no'?

  Read the article

• finding the number of 1's in my table in order

  - by bsandrabr

  I have a table of customers with a 1 recorded against their customerid on different dates. I would like to find the sum of the 1's recorded in descending order. I'm using MySQL and php Thanks

  Read the article

• How to read large number of rows efficiently using Zend_Db?

  - by Alex N.

  Is there a simple :) and efficient way or reading very large number of rows sequentially using Zend_Db? Basically I need to process entire table, row by row. Table is large, primary key sequence is not guaranteed(i.e. not an autoincrement, but is UNSIGNED INT). What's the best way to approach this? Environment: PHP 5.2, Zend Framework 1.10, MySQL 5.1

  Read the article

• locking save button for some time

  - by pradeep

  hi, i am using php,mysql,jquery. When a user clicks on save i go to back end and save data and show the response. once show the success i need to disable the save button for say 1 min. how do i do it.?

  Read the article

• What is the most efficient way to keep track of all user traffic inside a database

  - by Brendan

  Currently I am using mysql to log all traffic from all users coming into a website that I manage. The database has grown to almost 11m rows in a month, and queries are getting quite slow. Is there a more efficient way to log user information? All we are storing is their request, useragent, and their ip, and associating it with a certain website.

  Read the article

• How can I add dynamic text from a different table where primary key is a foreign key to adynamic table being shown?

  - by Jethro Tamares Doble

  I have here a dynamic table named tb_user with column region_id and institute_id and both ids are primary key of another table tb_region (with column region_name and region_id) and tb_institute (column institute_id and institute_name). I wanted to see region_name and institute_name instead of the ids. I've used this php script <?php echo $row_institute['institution_name']; ?> and query to collect data for tb_institute mysql_select_db($database_connection_ched, $connection_ched); $query_institution = "SELECT institute_id, institute_name FROM tb_institute"; $institution = mysql_query($query_institution, $connection_ched) or die(mysql_error()); $row_institution = mysql_fetch_assoc($institution); $totalRows_institution = mysql_num_rows($institution); but it seems not to display the correct name of id. query i used to collect data: mysql_select_db($database_connection_ched, $connection_ched); $query_notification = sprintf("SELECT * FROM tb_user WHERE status = 'inactive' ORDER BY date_register ASC", GetSQLValueString($colname_notification, "text")); $query_limit_notification = sprintf("%s LIMIT %d, %d", $query_notification, $startRow_notification, $maxRows_notification); $notification = mysql_query($query_limit_notification, $connection_ched) or die(mysql_error()); $row_notification = mysql_fetch_assoc($notification); if (isset($_GET['totalRows_notification'])) { $totalRows_notification = $_GET['totalRows_notification']; } else { $all_notification = mysql_query($query_notification); $totalRows_notification = mysql_num_rows($all_notification); } $totalPages_notification = ceil($totalRows_notification/$maxRows_notification)-1;

  Read the article

• What do I need to be able to use Joomla as an online application development enbironment

  - by howdyworld

  I develop applications using PHP and MySQL. They're not trivial, though they're not too complex. As an example to that I have written an online application to enable football administrators manage the player, competition and judiciary processes. Separately to that I have used Joomla to create websites for small businesses. I'd like to be able to use Joomla as my online application development environment. Is there a way I can use Joomla for that?

  Read the article

• Socket operation on non-socket

  - by embedded

  I'm running mysql5 on Mac os x 10.5.8 and got this error. How do I solve this? The DB worked fine but stopped working after system update. I think its something related to the socket file which is /tmp/mysql.sock do I need to give it special permissions and owner? Thanks

  Read the article

• Summarize Data with SQL statement

  - by bugbug

  I have CMS table that contain CMS_STARTTIME and CMS_STOPTIME (attachment). I want to create report to summarize exist data by using Date, Time and Year as Parameter (attachment). I don't know how to create sql statement to meet this requirement. I'm using MySQL and MS-SQL. Does one can help? Thank you very much.

  Read the article

• how to organize country data?

  - by fayer

  how do i organize country data (countries, states and cities etc) in mysql? cause every country has 3 tables: countries, states and cities. should i have each country in separate set of tables or should i have them all in these 3 tables? if i have all of them in same tables, im afraid that the amount of rows will be huge cause i tend to have a lot of countries! what is best practice for this?

  Read the article

• Compare two table and find matching columns

  - by Karthick

  Hi, I have two tables table1 and table2, i need to write a select query which will list me the columns that exist in both the tables.(mysql) I need to do for different tables (2 at a time) Is this possible? I tried using INFORMATION_SCHEMA.COLUMNS but am not able to get it right.

  Read the article

• SQL Syntax for multiple conditions in the same field

  - by Jonathan

  I can't seem to find this in the mysql manual: How do you enter multiple conditions for the same field in a select statement? e.g.: SELECT * FROM table WHERE ID = '1, 2, 3, 4' Is there a way to do this without using this: SELECT * FROM table WHERE ID = '1' OR ID = '2' OR ID = '3' OR ID = '4'

  Read the article

• best way to display image in php

  - by pradeep

  Hi, I am storing images in mysql Db directly. what is the best way to display the image in good quality (thumbnail and original size images) using php.

  Read the article

• Best Way To Store Users Passwords Using PHP?

  - by PeAk

  What is the best way to store users passwords in a MySQL database using PHP. For example, md5 or is there something better? examples would be much appreciated.

  Read the article

• How do I get records from the database for a particular interval?

  - by Vishal

  My table has records for every minute (for instance the column name is date), now I want to fetch records with an interval of 5 minutes! Can it be done at database level? I am using Django with MySQL

  Read the article

• Organize address cache

  - by Orsol

  Hi, I need to organize cache in mySql database for address - coordinates. What is the best practice to store address? Do i need to compress address string or use it as is? edit: Ok, let's I reassert my question. How to store long (up to 512) string in database if I need to search by exactly this string in future.

  Read the article

• User monthly payment system

  - by SomCollection

  I want to create a monthly payment system for community members, at this point I have figured out that I need the following tables in my mysql database. Edited Users table user_id, first_name, last_name Payment table payment_id,user_id,amount,due_date,payment_date,total What I need to display list of users who did not pay 6th of every month. How do I do this? And once the last day of the month is reached, how do I move to the next month?

  Read the article

• analyze table, optimize table, how often?

  - by every_answer_gets_a_point

  in mysql i have 3 tables. one is 500,000, another 300,000, and finally around 5,000 they each get maybe 50-500 additional rows daily should i run analyze and optimize table on them? if so then how often?

  Read the article

• how i can make a sort system depend on Character

  - by moustafa

  i mean i have songs table ok?? i want to make some things like that a | b | c | d click on a select from the database the songs that start by a Character how i can do that by the mysql???

  Read the article

• Inserting Cells Into A Table ?

  - by lentlesoup

  How do i go about inserting a cell into a table? For example, i retrieve data from a database using MySql and PHP, how do i then go about inserting a cell into an already scripted table? In my case, how would i insert a cell into a row 150 pixels from the start of the row? example: ___________________________________________ | <--150px--> |cell| |

  Read the article

• How can I limit the number of registrants to an event?

  - by user356900

  I've set up a basic html/php submission form where people can register for our event, but need a way to replace the submission form webpage with one that reads something like "We have reached our registration limit" when we reach a certain number of submitted forms. Our database is MySQL (if that makes a difference) I've looked around on the web but people either say to count the entries by hand, or the ones that do have an automated system use CMS like drupal or joomla. Is it possible to setup an automated script that will do this?

  Read the article

• Get user IP via comment Form

  - by jasmine

  I have inserted a hidden input in my comment form: $ip = $_SERVER['REMOTE_ADDR']; <input type="hidden" name="c-ip" value="<?php echo $ip; ?>"> With this input, ip column is empty in mysql. What is wrong in input. Thanks in advance

  Read the article

< Previous Page | 424 425 426 427 428 429 430 431 432 433 434 435  | Next Page >