10,940 Topics
 | |
 | Hey there, I have these three tables: A, B, and C. A has a one-to-many relation with both B and C. Right now, what I am doing is: I run a select query on A. I put the results on an array, lets say aArray. For each row in the …  |
| | |
| | I have two tables, author and quote: author: AID, Name, YOB, YOD. quote: ID, AuthID, Content. I currently get all the authors with one query and as I loop through them, I run a second query to get the count of quotes that have the current AID: $sql = "SELECT … |
| | I have two tables that I need to get the following information but I can't seem to figure out how to structure the query: Table 1 type show max min Table 2 model height width depth In Table 1 I have the following for the first row (as an example): … |
| | Hi I am attempting to build my own cms (although very basic) using php and mysql. Instead of having a static homepage, I want the content displayed to be dynamic. In other words, I want the homepage to be flexible/changeable based on whatever the latest 'content' entry into the database … |
| | Hi, i am inserting data from CSV file in mysql. I am trying to skip ist row of CSV file as it contains headings. need suggestions??  |
| | SELECT t.* FROM (SELECT * FROM jobs WHERE `status` IN (0,1,2,3) ORDER BY `status` DESC, job_datetime LIMIT 11, 20) AS t That's a cut down sample of my sql. It was more complicated, but I've pared it down to this just to see why I was getting some strange numbers … |
| | i need a querry to add -- in the end of a table. for example if i have a table like tb name ze ad|ID| aa | -------------- 01|02|aa01 | 02|03|aa02 | how do i add -- to the end of all fields of aa column to be like aa01--\aa02--? |
 | Stuck again... :) I am returning close to 60 records from a search in mysql. I want to add these records to a select box. When I am looping through the records, it adds a select box for each record. Not sure where I am going wrong. It does load … |
 | Hey guys, I don't see anything wrong in the function but mysql_result is complaining about the parameter value passed to it. function question_exists($question_id){ $question_id = (int)$question_id; return ( mysql_result(mysql_query("SELECT COUNT('id') from `posts` WHERE `id`=$question_id"),0) == 0) ? false : true; // if the question doesn't exist (equal to ZERO) then … |
| | I am trying to configure a menu for my CMS I want to be able to use Nested Sortables just like you have in WordPress. The problem Im having is getting my head around how I am going to start I already have a column in my database table called … |
| | I am totally stuck here and found tens of samples on posting to get and set values. What I am trying to do is - 1) Let a user enter a vehicles year model into a textbox in my form (set to post) 2) I then need to get this … |
| | I'm trying to use a drop down form box & select statements to gather certain pieces of information from my database however i'm recieving the error **Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /study/comp/c3329871/webpages/mysql/queryContinent.php on line 26** This is the code from my php file … |
| | Hello, I am getting the following error message: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mochas/domains/zoink.sx33.net/public_html/includes/blogpost.php on line 54 My code (Line 54): while($row = mysql_fetch_assoc($query)) |
| | Hello guys, i need a help slightly with this project of my university. my equipment are working with some components, 1. Radius Server - MySQL - OS Linux Ubunto 12.04 or OS Microsoft WindowsServer2008 - SQLServer. 2. Router Linksys Wrt-54g 3. Other Server with certification unit, which we need manage, …  |
| | Hi I am having some issues with getting data to update for a logged in users account, I have got it to display the data in the database which i want to edit but for some reason it just wont go through it says it has updated but when I … |
| | Does anyone know a better way of getting this code to execute the mysql queries. I am trying to Insert table records to a new table then update it. so I need to call the table cms_homecontent first then insert those values to the new table cms_homecontent_versions and also ignore … |
 | I am baffled, I have the following query which should return 4 records but for some reason it is counting 8 records and returning each row twice. I know I could use distinct, but as I also know that there are no duplicate records in this table I don't want … |
| | hi frnds..can you give some idea about php training.how to start in online or any institute |
 | Hi, I am trying to create a script which searches through a MySQL column which contains URLs and check the URLs to see if they are up OR down. At the moment I am getting no results added into the database e.g. 1 = UP, 0 = DOWN. Can someone … |
| | Hi, I wanted to know that can we use a php function on a column in mysql query. I want to make something like this SELECT html_entity_decode('field') from table. Thanks in advance. |
| | Hi, I'm wondering what type of mysqlfield would be advantageous for outputting the containing text as a bullit list in php and if the text should be formatted a certain way. I would be supergrateful for an example! :p Take care Adam |
| | Hello, I have problem with entering default values in MYSQL database. When i insert new record using phpmyadmin it works fine (empty fields get default value), but when i use the same query in my application (written in PHP), empty fields in html form don't get default value in MYSQL … |
| | Hello DaniWeb, I've finally gotten around to swapping from MySQL to MySQL(i), mainly due to it's security advantages with Prepared Statements. In the past I've been adding `include ('/Some/Directory/File.php);` to the top of each page, so that I can store my functions in a secure directory and so that I … |
| | I have a small problem. I wrote this script to update the status of my list using a checkbox for each line I want updated. But I (beeing new to this whole thing) can't seem to get my button to do what I want it to do. <?php //ansluter till … |
| | I have a table which shows our top sellers and Weeks of Stock left. Its generated by joining an order db with a stock db. I'm struggling with try to capture the really fast movers. Here is the script SELECT a.EAN, a.SKU, a.Name, Sum(a.OrderedQuantity) Round(Avg(a.Price),2) as AvgPrice b.Quantity, round((b.Quantity/Sum(a.OrderedQuantity)),0) as … |
| | I am trying to create a form that updates mySQL-database. I've created three php-pages. **updatepizza.php** <?php $host="localhost"; // Host name $username="root"; // Mysql username $password="billie"; // Mysql password $db_name="cygna_fyraarstider"; // Database name $tbl_name="pizza_menu"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot … |
| | Good Afternoon all, I'm working on a project for school, and we have a part where we want a combobox filled with data from a mysql database, tabel = sport. We can work out how to fill a normal combobox just with strings, but we can't find out how to …  |
| | how can i show the week number and corresponding dates using the tax year i tried Week(date, 0) but that shows 1-1-2012 as week 0 Eg; qc_data.date holds the date a qc inspection took place. if i want to show that the first full week in April this year (2 … |
| | **I'm beginner of Php .. I Develop my first dynamic website -> http://wwww.afrogfx.com if you look at my sidebar you will see categories list my problem located here if i create sub sub categories like that** CAT A - SUB CAT A-1 - SUB CAT A-2 -- SUB CAT A-3 … |
The End.