Enter Keywords:
1 - 10 of 166(0.024 seconds)
Sort By:
 
This simple php code to delete a record from MySQL is not working.  Updates and inserts are working fine from php.  Just the deletes are not working.    Here is my code: <?php require ("connectDB...
Zones: PHP and DatabasesDate Answered: 02/04/2007 Rating: 9.4 Views: 0
I've created a few data pages using PHP that includes SQL.  I have multiple pages that use different SQL statements to produce the data.  Occasionally, when I go from one PHP page to another, I get...
Zones: PHP, MySQL Server, PHP and...Date Answered: 01/25/2008 Rating: 8.2 Views: 0
I am having problems with my search query. This is for a music site. The query works , but it is returning duplicate results - which I assume is because a song can have multiple GENRES , so I u...
Zones: SQL Syntax, Databases, MySQL ...Date Answered: 02/28/2008 Rating: 6.6 Views: 0
Hi folks, I have a live LAMP system that's getting about 55K/day hits (spread predominantly over the day).  Mainly a hit about every 1-2s. The database is MySQL 5.0.38, Apache 2.2.3, PHP 5.2....
Zones: MySQL Server, Apac...Date Answered: 02/22/2008 Rating: 6.2 Views: 9
I have 2 tables in the database - categories and subcategories In the categories table, I have an ID column (primary key) and another column for the category name. In the subcategories table...
Zones: MySQL Server, Databases, PHPDate Answered: 05/09/2008 Rating: 9.2 Views: 0
Hi I was hoping someone could offer some advice I am trying to build a basic search function on a site, it will take keywords from a text field and check them against the 3 feilds in the tab...
Zones: SQL Syntax, MySQL Server, ...Date Answered: 05/25/2008 Rating: 8.2 Views: 17
HI I have been having real trouble getting my head around displaying relevant results, i have asked various questions with regads the mysql SELECT statement but have real issues working out the...
Zones: PHP and Databases, SQ...Date Answered: 07/02/2008 Rating: 7.8 Views: 25
Hi I am getting the mysql error #1210 - Incorrect arguments to MATCH I am trying to using a fulltext search on 3 fields across two tables, i have set up the fulltext index the fields in eac...
Zones: MySQL Server, SQL Syntax, ...Date Answered: 05/27/2008 Rating: 9.9 Views: 25
Hi I use the following code to fulltext search 3 columns across two tables, but i am not getting the results returned in a relevant order. Can anyone see any obvious things that i am doing w...
Zones: MySQL Server, PHP ...Date Answered: 06/02/2008 Rating: 9.8 Views: 0
Hi Can anyone recommend some really good image upload code for use with php. Which can resise thumbs/main images! Many thanks --s--
Zones: PHP, PHP and DatabasesDate Answered: 07/02/2008 Rating: 9.6 Views: 0