10,940 Topics
 | |
 | Hello, What I am making is a block of code where it "balances" the load for support tickets on a website. I know that my setup may (most likely will) not be the best. I'm looking for working, not a lecture on how to do everything and have it all … |
 | I have resolved a couple issues on my site thanks to you all, and hoping that you can come to my rescue one last time, because I am at wit's end trying to figure this one out. I have a shopping list on each page. Normal grocery store items; users … |
| | Hi I coded a calendar pop up with events and I wanted to be able to join the event table with a timecard table but im not sure if im doing this correctly. What it is suppose to do is when they add stuff to the calendar the person can … |
| | I need help using a mysql user defined function in php. What i want to do is use the mysql function to perform a query to get the count from the inventory table whose movie_id's are equal to the movie_id entered by the user. And then I would like to … |
| | hi all, l created php submission script and l wanted to how l can create another script which allows me to view all the submissions made in an orderly manner? |
| | Hi all, was wondering if I could get some help with my code. I want to be able to insert a person and details into a database, however i keep getting a syntax error, and not very experienced so was hoping some one here could help. thanks dbConfig.php [code=php]<?php // … |
| | |
| | I need help using a mysql user defined function in php. What i want to do is use the mysql function to perform a query to get the count from the inventory table whose movie_id's are equal to the movie_id entered by the user. And then I would like to … |
| | Can anyone help me figure out why the table movie_actor cannot be created and how to fix it? I know it's the only table without a primary key, but I don't see a need for one. [CODE=MySQL] create table actor ( actor_id int not null auto_increment, first_name varchar(20), last_name varchar(20), …  |
| | |
| | I am making a mysql fulltext search. my database table article1 has ~18000 articles, article2 has ~7000 articles, article3 has ~13000 articles. FIELD cat is a INDEX field Now I want to make a union search. there are 5 groups words put into 3 table, match out the results. But … |
| | I keep getting this error when I try to run and print out the results of my database query. I know that this error usually mean that my query failed but i can't figure out what is wrong with it. [CODE=PHP] $genre=readline("Enter Genre: "); $query = "SELECT movie_title FROM movie …  |
 | Hi guys! i wonder how can i save image path in a string to MySQL, i mean...what instruction i have to use...i want to save it to MySQL and then show it into a picture box. Thank you very much for your help.  |
 | hi, although, database is connected and admin table of my database consist of 2 rows of data, I still get 0 value for $numRow=mysql_num_rows($result); And mysql_fetch_array doesnt fetch values properly plz can any body help me thx in advance [code]<?php //include_once 'config.php'; /* 1. Got the username and password from … |
| | I'm trying to load a CSV file into a database table, but having some issues. [CODE] LOAD DATA LOCAL INFILE 'Report_1.csv' INTO TABLE report_1 Fields terminated by ',' ENCLOSED BY '\"' LINES terminated by '\n\r'( company,key_code,dlr_code,rep_code,dlr_name,first_name,last_name) [/CODE] This gives me the following error: [ICODE] File 'Report_1.csv' not found (Errcode: 2) … |
| | In mysql, the table consist of informationtype, status and informationno , [CODE] $information = mysql_query("SELECT * FROM table WHERE informationtype='message' AND status='waiting'"); $row = mysql_fetch_assoc($information); $result=($row['informationno']); [/CODE] The query result are 4 rows. The informationno are 11001; 11002; 11007; 11009; If I intend to express the results in term of … |
| | i've been attempting to execute this code , all i got was an error. [CODE]<?php $connect = mysql_connect("localhost","root","") or die ("connection failed!"); mysql_select_db("users") or die (mysql_error()); echo "connected!" $extract = mysql_query("select * from member order by id ASC") or die mysql_error(); ?>[/CODE] and this error appeared : [ICODE]Parse error: syntax … |
| | Hi, I have gone over and over the subject and still confused. I currently develop in PHP 5.2.x along with MySQL. (awaiting host to upgrade to 5.3.x, hopefully not to long although on local i develop using php 5.3.5) Currently i use the standard MySQL functions in PHP like: [B]mysql_connect()[/B],[B] … |
| | Hello, I've got a problem with simultaneous placement of an order in a webshop. I will start off with a general description of the problem, and provide details after that. **The problem** Orders are stored in the table 'orders'. Each order has a BillNumber, which is obtained via a mysql … |
| | On executing the DELETE statement I keep getting the error about foreign key constraint failing. What do I do?  |
| | I'm creating a html form that allows the user to search for people in a database. I want the form to work with drop down selects and radio buttons. Currently I'm using an if { } elseif {} else if{} format to my script. However this causes a problem because …  |
| | I have a html form where a user can narrow down his or her's search. For example they want to find a person based off of a number of characteristics, say hair color, eye color, body type. These are selected by a drop down menu and there are additional radio … |
| | hi guys as the title which is the best in security mysql_connect() or mysqli_connect() and which one you prefer thank you for help or suggestion . |
 | we have a mysql server running from mac os x. i dont like mac but the server has been here forever. a client machine received the 'too m any connections to server' error. my colleague restarted the mysql server - and now the mysql server service will not start. does … |
| | I checked my php.ini file and there is no ; in front of extension=php_mysql.dll or extension=php_mysqli.dll. I think the I am getting this error because my figuration File (php.ini) Path is C:\Windows. How would I change it to C:\Apache2.2\php\php.ini? Also, once I have done this do I need to recompile … |
| | I am trying to get information from my database that contains a foreign key that relate to another table, I am trying to enter details of an order and then have the customer ID of that order enter automatically from the customer table. [CODE] [B]Customer Table [/B] CREATE TABLE IF … |
| | Hi, I have a fully pledged membership system and want to integrate my own user referral system but want some tips, advice really on the logic of it. Basically already registered users on my site will have the option to refer people, only registered users. I will try to explain …  |
 | Hey Guys, I need some help with Deleting data from a MySQL . Currently I have, Two PHP files. the First is the main page. [CODE]<?php $host=""; $username=""; $password=""; $db_name=""; $tbl_name=""; mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); ?> <p>This Page Refreshes Every … |
 | Hello I have been using SQL for a number of years, but I am struggling with an intermediate query. I want a record to be displayed as below [ICODE] 1 Ademola Adebayo 4 Women @ West Street Member 2 Christine Adebayo 4 Women @ West Street Leader [/ICODE] when I …  |
| | I want to make a query that would return data about students who failed in a specific course, the report is looking like this- studId, studName, last grade, year last course was taken, num of fails in this course. so I'm having problems writing the correct SQL query to get … |
The End.