18,960 Topics
Hey i'm writing my own first full website with PHP and MySQL and i've come to a problem. I know i need to optimalize it with some fewer echo's and more elses, but this is what i have now and apart from the problem, it works. On the site at …
Hi I have a table which have 4 fields. How i can give rights via DB for update, Select, Delete and insert. For example User A only Update Field 1 User B only Update field 2 and select all fields. User C can delete field 3 records User D can …
I currently have the following code on my view information page which allows the user to go to a different page to update and delete the information, which can be seen below: - Update: - [CODE]<a href=\"update_line.php?barcode=".$user["barcode"]."\">Edit Line</a>[/CODE] Delete: - [CODE]<a href=\"delete_line.php?barcode=".$user["barcode"]."\">Delete Line</a>[/CODE] I also attached the other related pages …
I'm writing a simple forum system to go along with one of my projects - nothing fancy, just categories, forums, threads, and posts. Some threads, however, are marked as 'stick', which means that they're stickies. No matter how many threads there are or where they're posted on, they always must …
hello everyone, i want to generate report by php for login at specific time. and i m usin database with my sql. so plz give me favour for code to make it successful. manish
I spent a long time figuring this out on the internet so I will post this now to hopefully help others with the same problem. this is to display the currently logged in user using mysql. this is so they log in with a username, and it displays actual name. …
HI Dears all I have 2 tables in DB. [LIST=1] [*]Lease_north [*]Lims_payment [/LIST] My first query is [ICODE]Select * from lease_north WHERE LaStartDate like '%-04-%'[/ICODE] its shows 100 result means 100 payments are due and must be paid in April. My second query is[ICODE]Select * from lims_payment WHERE pdate like …
Hi to all, i am trying to set the logon data for crystal reports that i have created. in crystal report builder i manage to connect to mysql by the jdbc driver downloaded from the official site of mysql. [link=http://www.eakes.org/80/connecting-to-mysql-with-crystal-reports-xi/][/link] but i want to change the ip of the mysql …
I have one join query with 3 tables, which takes lot's of time to execute. I need to reduce execution time i.e., optimize it [code] QUERY: SELECT SQL_CALC_FOUND_ROWS p.*, FLOOR(p.prodratingtotal/p.prodnumratings) AS prodavgrating, 0 AS prodgroupdiscount, pi.* , (IF(p.prodname='gold', 10000, 0) + IF(p.prodcode='gold', 10000, 0) + ((MATCH (ps.prodname) AGAINST ('gold')) * …
Hi I have a table with info that I want to read and display. I can read it and display but I cant seem to format it can anyone tell me whats wrong. [code] <html> <head> <title>comment</title> </head> <body> <form action="postcomment.php" method="post"> name: <input type="text" name="name" ><br> comment: <textarea name= …
Hi All, I am developing a mysql monitering tool , So I don't want to give password inside the script, the script should able to access the database from OS user authnetication. Can you please help me here , how to access mysql database without prompting / or giving password …
Hi, I am in the middle of developing a web application (customer DB) and currently attempting to create a module to update the number of member registered under 1 agent. I have 2 table, 1 is 'users' and another 1 is 'dealers'. The 'users' table contains some normal user credential …
Hey Guys n Gals, I want to make login page in which I m taking email ID n password. If user enters email ID & password. Welcome.php should be open. else fail.php opens.Plz, read my attachments, But I received following warnings. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL …
how to get popup window if new row inserted into mysql database for a particular table... That to be display inserted values in popup window... Advance thanx...
Hi, wonder if anyone can help. I want to insert a jpeg as blob data into a table column holding blob values. So far I just can't seem to come up with the right script to run in mysql workbench. The jpeg is stored on the same machine where mysql …
i have to creat a form to generate a report that give details about the usage of stock of my system. there are 4 conditions to generate the report, and user are given a choice to select all 4 condition, or any of the four and also user can choose …
Hi, I can't solve this problem: I have a query which fetches the contents of the page meta tags from a database. It works fine when I have the query on page but when I turn it into a function (which is placed in my functions file) and call it …
Hi there, I'm trying to compare 2 arrays at the moment. There are 2 tables, the first (Category) holds a list of categories, e.g. Electricians, Plumbers, Builders and each has an ID number. The second table (Company) is a list of companies e.g. JonTheElectrician, GaryThePlumber and of course BobTheBuilder. Each …
Hi everyone, I’m having some difficulties with a query which purpose is to give users with more than one thread (called CS) in current year a 5% point “raise”. My relational schema looks like this: Thread = ([B]threadid[/B], threadname, threadLocation) threadoffering = (threadid, season, year, user) user = ([B]name[/B], points) …
Hi I'm currently creating a basic math tutor for kindergartners and i'm using dreamweaver 8 as my text editor with PHP and MySql. One of my modules involves lessons in which i would want to put addition and subtraction and i have created a flash documents to demonstrate(addition and subtraction) …
Hi all, I've looked through this forum for some hours and am absolutely unable to fix my problem; no matter what I do. I'm trying to pass a PHP variable as part of a MYSQL query like so: [CODE] $id = $_GET["bodyid"]; $blog = getEntries("SELECT `Articlebody` FROM `Blog` WHERE id …
Hi, I am writing a program that has a listbox which is bound to a dataset. When I click a button (e.g. delete) the item is deleted from the database ok using an SQL query but is still shown in the listbox. How do I get the listbox to refresh/update …
Hi all, I have a database with contact info, and I need to display the info in groups. Currently in my database table called contacts I have a field called 'groups'. The values are 'favorites', 'home', 'work', and 'friends'. I tried creating a page called group.php and used a dropdown …
Hello all. First post from a PHP newbie. I'm trying to teach myself how to retrieve data from my MySQL databse and have so far managed to get the text retrieval to work. What I'd now like to do, is to get my PHP page to retrieve an image, specifically …
I am using vs.net 2008 vb and mysql I am using datasets alot in this application, however I am having a few small snags I am running into. I created a login system that works quite well, but I need using the db or settings or a variable keep the …
Hi Everybody, Im having a bit of a problem with an assignment..Im trying to write a JDBC servlet which checks the value of a name in the database against the value inputed in a form..USER and PASS are the values inputted to the by user into the form.. The code …
Hi guys, I'm trying to UPDATE the image that has been already in the database with another image using a form in PHP. I got the uploading working all fine already. Just the edit part. With this code, I get no error, but the MySQL table is not written with …
Hi All Can anyone help me with this problem please. I am writing a program in C# and have an access db07. The user should be able to enter a date into a text box then that date is addedd to my sql query and then return all record with …
Hey guys, I've just started coding php, for a school project. I'm creating a member login system with functions to add/edit contacts. Currently I'm stuck at updating the contacts. I'm able to pull up data into a form in a page called 'edit.php', but after updating and clicking submit, it …
Hi guys. I'm having a bit of a 'mare trying to return some ResultSet results. Basically, my method gets the results from a database and builds a String of the information and returns it. However, I can only get the method to return the LAST constructed String, as the "result" …
I've been scratching my head for a bit now and I can't think of a way to make a mysql_query pull a set of data that matches a number in an array. It's easier to explain what I want to do with code.. so here goes.. Then I need my …
hi, i am using the following code to retrieve information for todays date: [CODE]<?php $query = "select * from CUSTOMER where DATE (date) = DATE(NOW())"; $result = @mysql_query($query, $connection) or die ("Unable to perform query.<br />$query<br/>"); $num_rows = mysql_num_rows($result); echo "$num_rows"; ?>[/CODE] i cant seem to find any code to …
i have this weird problem and i dont know how to make it work. the problem appears after i consider the OR statement.without or statement the first part is working . So idont how to use this statement in mysql. i hope someone can help me. Down is my script. …
hi, I have written the perogram in perl and i want take previous date in "April 3 2010" in this formate . plz tell me how can i get this. [code=perl]#!use/bin/perl use Date::Format; my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(); my @weekday = qw(Sunday Monday Tuesday Wednesday Thursday Friday Saturday); my @month = …
hi, could anyone recommend a free mysql query builder? i have been working on a database and had some help with some small queries, however i need to create a large recordset through dreamweaver and wondered what tool i could use to generate my query visually? many thanks
Hi everybody. right now i'm doing a hotel reservation system using php and phpmyadmin. The process involved 1) user inputs check-in and check-out dates (to check what rooms are available during the dates input) 2) database is queried for all room categories AVAILABLE within the dates indicated step 1 and …
Hi, I have a search form that picks users of class name of course name. Now I have a problem viewing data in categorization from mysql database with php. For Example I need the following: Course Name: Name Class Name: Name 1. Name Surname(User) 2. Name Surname(User) 3. Name Surname(User) …
Hello and Thanks, I am trying to create a teacher grade book for my school, I have a mysql database 'gradebook' and two tables 'students' and 'data' (mysql code below) to start, I am also using PHP. I have googled this to death and can't seem to come up with …
Hello I need to do search through a mysql db on a column and search how many values are equal to a number and than post the number of the values that are equal to this. I would like the number of the values to be saved into a php …
Dear Friends, I use the following: MySQL Server 5.1 MySQL Workbench 5.2 OSS I have a strange problem. I have a backup of my MySQL database with MySQL Workbench 5.2 I use MySQL Workbench 5.2 for importing MySQL database. That's works fine, see Annex. Then i go to SQL Development, …
I have a field Status in my table message Its value when any message is entered in table is 1 but I want to alter it to 0 after 1 day of message posting how can I do so Plz help me
Hi, I have a counter and it works fine in firefox, but when I try to bring up the page to be counted in internet explorer in does not work. The page wont even be brought up in the browser. If I disconnect the include file to the counter it …
Hello everyone, I'm not sure the title fits my question, but I didn't know how to word it correctly. Here is my question. I'm working on a forum that pulls data from a SQL database via PHP. It's data on employee data (name, job title, what programs they have access …
I have a small desktop application created, i wan to create a login function for this. i have a database using MySQL which stores user name and password. i wan to know how to compare the user name and password entered in the text field with the data in the …
HI im trying to added extra fields to my register.php , but i keep getting a error message saying 'Error:user not added to database' I've simply tried to edit the original code using the same methods used for the previous fields yet it still doesn't work. im sure my mysql …
am developing software using sql database. i want an sql statement that can enable me retrieve data which for example has same surname,save them in an array or dataset and navigate through them.
Hey Guys, I am developing one tool on perl to moniter mysql database in many systems(in all types of OS). I want to track some info like this getting databases parameters , getting database schemas, get logspace .... etc , what could be the good approach in perl.. If you …
hi, I have date in this format December 2 2009 December 2 2009 December 2 2009 and i want to insert it in my table in mysql .I m inserting this with the help of perl means i m doing my program in perl .ook at my program [code=perl]#!/usr/bin/perl use …
hi i want to know that how can i search the entire database at once.... i have code with which i can only search from a single table but i want that search should be performed on entire database.... i m using php+mysql....... help me out...
The End.