10,946 Topics
 | |
| | Hi all, I am trying a scenario for calling a shell script when ever a trigger is called. Can some one guide me how to achive this scenario. Also it should passes the value from the table to the shell script. Can some one explain me along with the example. …  |
| | hi , i ma using the reporting service in MS SQL express 2008. but in the company i don't have the admin previlages to upload and create reports to the server. if i was to ask from the administrator to grant me the previlages what previlages does he have to … |
| | [CODE]<?php if (isset($_POST['submit'])) { if ($_POST['lang']=="") { echo "Dictionary name can't be emptry!"; } else { $name=mysql_real_escape_string($_POST['lang']); include('db.php'); [B]$check=mysql_query("SELECT * FROM information_schema.tables WHERE table_name = '$name'"); echo $count=mysql_num_rows($check);[/B] if ($count>0) { echo "That dictionary name already exists!"; } else { $go=mysql_query("CREATE TABLE IF NOT EXISTS $name ( `id` int(11) NOT … |
| | hi, i have in a table"visitdate1, visitdate2, visitdate3 and visitdate4" i also have in this table address fields of "housenumber, street, city, zip" i want to run a query which shows me the amount of visits to a house. should these be stored in different tables? thanks |
| | Hey guys.. could someone please help me with.. What wrong with this: [CODE] echo "<td width='25%'><img src='images/Lock.png' title='" . $row['username'] . "' - '" . $row['password'] . "'></td>";[/CODE] i Get only the username.. Cheers, Sagive |
 | I have developed a program where I do some database connections and send some queries with JDBC to MySQL database called ANU. I have used NetBeans 6.9 under Ubuntu 11.04 as platform. When I run the app from NetBeans, it works perfectly but when I try to run it from …  |
| | Hi everyone! So I'm finishing a shopping cart, and there is just one thing that annoys me - the currency is on the left side. Its like this: $10, but I want it to be like this: 10$. Is there any way that I can do this? Thanks! |
| | Dear All, I have a big table of poi's based on latitude and longitude. So then based on a given latitude and longitude I would like to find the nearest point in my poi table. Can I use some mysql functionality to do to be best optimize way. The problem … |
| | Hi All! I have a zip code table that has the zip code, city, state and various other info in each row. The problem is that if I pull up all the cities in a zip code (say 33308) I get the same city spelled twice like this: [CODE]Fort Lauderdale … |
 | Hello everyone! I've created a mailing list where users can subscribe with a form, and the results are added to a MySQL database. They can also unsubscribe. The subscribe/unsubscribe pages work GREAT, but the page where I send out the email is giving me some trouble. It says that the …  |
 | Good morning everyone, I could be crazy but I am starting to work more on both my php skills and my mySQL skills, forgive me if I am asking the wrong question in the right forum or vice versa. [B]My objective[/B] I am building a script so when I log … |
| | Hi, I am new to PHP Development. I am retrieving data from my database table clf_email. I am having a mysql_num_rows error in results. I cannot understand where i am going wrong and what error i am doing in the code. Please help in removing this error. [CODE] <?php require_once("../db.php"); … |
| | Hi, I am a beginner in php and mysql. Someone pls be kind to help me the following if possible. 1. I know the host name, database name, table name 2. The table has 3 fields-State, Name, Specialty. 3. I want to have a drop down list name ‘State’. In … |
| | How does one create a dynamic table (meaning that it expands as information is automatically put in) with data coming from a MySQL database? I'm pulling information from a private school's "stock" database and need to fill in a table with information such as the date of the stock, the … |
| | So i've got a little problem. I'm just running a website for fun, got it from a friend because he didn't need it anymore. Site is called: fapperd.nl Now i'm really happy with me installing a phpbb forum on my server and made a button for the forum as you … |
 | This question seems to always have 2 sides to it. If I make a [COLOR="Red"]register.php[/COLOR] with the registration form, should I have it submit to [COLOR="green"]processreg.php[/COLOR] or should it just process all on the same page? Same thing for login. I have read that it may e more secure to … |
| | Hello, I am trying this code out but has error. Please help, This is my code. <?php include 'dbFunctions.php'; $result = mysql_query('select * from criteria_m'); if (!$result){ die('Query failed: ' . mysql_error()); } $i = 0; while ($i < mysql_num_fields($result)){ echo"information for column $i:<br />\n"; $meta = mysql_fetch_field($result, $i); if(!$meta){ … |
 | POSTBACK.php [CODE=PHP] <?php $q=$_GET['q']; $words=explode(' ',$q); //$words2 = "'%".implode("%','%",$words)."%'"; //echo $words2; $con = mysql_connect('localhost', 'root', '')or die('Could not connect: ' . mysql_error()); mysql_select_db("ajax_demo", $con)or die('cannot connect'); //$sql = 'SELECT * FROM `ajax_demo_table` WHERE `FirstName` LIKE CONVERT(_utf8 '%'.$q.'%' USING latin1) COLLATE latin1_swedish_ci OR `LastName` LIKE CONVERT(_utf8 '%'.$q.'%' USING latin1) COLLATE latin1_swedish_ci'; … |
| | Its kind of complicated.well iam trying to create a search form,where the output will be like : Found (a number) results: Name: Surname: [View Button1] Name: Surname: [View Button2] and so on,depented on the results of query. i am calling a fun on pageload.in that i create the buttons,and i … |
 | I recently moved a script I created for Google Maps over from my development site and I changed the information in the mysqli line and now I'm recieving an error mesage -- any idea what's going on here? Here's the error message: [CODE]Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user … |
| | I'm looking to select almost duplicate rows in a table. I initially just sorted all the rows by name and picked out the duplicates manually (took a while), but I'm wondering if there's a "real" way to go about doing this. Problem is that the duplicate names can slightly differ. … |
| | Hi all, Can anybody help me out how to export multiple excel sheets in a single xls file using php and taking datas from mysql table. thank you |
| | how to find the last dml action held on which row in a table using mysql plz do me a favour , tanks in advance.. |
| | Hi, i have a login page which i designed in dreamweaver. When i connect my php to the dreamweaver everything is ok. Here i need help when i press on my login button, currently when i click it, it takes me to another blank page and says login successful. But … |
| | Alright, so I am embarking on a fairly large project that is complete with user profiles. My question is, what's the fastest, most efficient way to store user meta like books, movies, etc. I was planning: metaid | userid | firstname | lastname | movies | books | biography | … |
| | Hi, I seem to have an issue with this code...its giving me an error at this line: lblDB.Text = currentRecord.ToString(); The error is [B]System.NullReferenceException was unhandled by user code[/B] I have debugged and connection to DB is working and the dataReader does have the record in it but I am … |
 | this has got me stumped, i have a simple few text boxes that users type in the hotel name. Some names have special char in them like: L 'Ermitage I have two tables, the Top3 table has data that i display to users The details are where the main data … |
| | Hi there, I am currently facing some problems with return carriages. I have an address already in a table in the database which has return carriages. Now when you echo the address out it will loose the return carriages and instead will put it all on one line. I have … |
| | Hi, I am using the twitter api to retrieve some data. I'd like store my followers latest status tweet containing that hashtag #RT and the mention of my name. The staus ID can be retrieved via $xml->status->id. In the code below I'd like to php to search for certain words … |
| | Hi, im currently designing a form on dreamweaver and it allows a client to enter their Name, Email and Comments. At the same time i want this data to store in my mysql database which i created. The php code that i used is shown below, but the problem is … |
| | Hello guys, i am a very beginner php developer (i know only the basics) and i am trying to create a website about betting which will retrieve info from mySql databases. the problem is that i have stored some variables (which are written in greek) in databases and then when … |
| | I've been trying to solve SQL exercises from [url]http://www.sql-ex.ru/[/url] for some time. You can find database description below: Short database description "Computer firm": The database scheme consists of four tables: Product(maker, model, type) PC(code, model, speed, ram, hd, cd, price) Laptop(code, model, speed, ram, hd, screen, price) Printer(code, model, color, … |
| | i got something really stange going on with mysql.look [CODE] <?php $numid=$_POST['numid']; $query1="select * FROM datatable LEFT JOIN datatable2 ON datatable.numid=datatable2.numid WHERE "; $connect=mysql_connect("xxx","xxx","xxx") or die ("Check your server connection"); $db_found = mysql_select_db("mydb",$connect); if ($db_found) { echo "Database FOUND <br>"; if (strlen($numid)>0){ $query1.="numid='$numid' AND "; } $query1=substr($query1,0,(strlen($query1)-4)); $result = mysql_query($query1); … |
 | EDIT* Sorry I didn't mean to add that error message in the topic title. Hey guys, I'm new to PHP and MYSQL and I have been searching for hours for a way to copy the data from a row in one table (all columns) and insert it into another table … |
| | Im thinking about taking on a chat room php based project. I want to make sure my logic is right though. This is very raw so please feel free to contribute if you see any problems that might occur. [B][U]MYSQL[/U][/B] [U]TABLES[/U] Username chatroom1 chatroom2 etc.. [B][U]PHP[/U][/B] [U]Sign up.php[/U] Insert username … |
| | Hi, When I run query below I get duplicated records. Instead of 2, I get 4 records. I guess there is a problem with JOIN because when I remove [B]image JOIN[/B], it works fine but without [B]image JOIN[/B], the query is helpless for me. Please help, thanks in advance [B]QUERY[/B] … |
| | So I have this code for my webpage but whenever I put in the "include" php code [CODE]<?php include('include/mysqli.inc'); ?>[/CODE] everything below that disappears. Basically I'm trying to enter in the appropriate variable data from the quotes database that I'm using into the correct table fields. But I can't do … |
| | Hello all In my table mytable I have Date column. how is the query to find the nearest date in mytable to current date ? thank you denny |
| | [code=text]mysql_query() [[url]http://www.mysql.com/doc]:[/url] 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 'into kiwanis_info ( 'identity', 'firstnam', 'lastnam', 'phonenum', 'emailaddr', ' at line 1[/code] Above is waht I get when inserting into a file from … |
| | Hi there. I'm having a problem getting values from a drop down to insert into a table. What I want to do is get the key for the value and then insert that. For example: I have a table called format which holds an auto incremented ID key and a … |
| | Can you show me the way about storing the special characters into mysql database using php. Actually,I'm working on such a website where user can upload text and programming codes into mysql. Thank you in advance.  |
| | Hi All , I tried to update the field RANGE_ALLOC_BLOCK_SIZE in table GLOBAL_VARIABLES of information_schema database.But i face the error Access denied for the root user.Can anyone help me to update the field. Thanks, Arun T |
 | Hey Guys, I have a quick question for you. I display a new event every day that allows users to attend that event. The event id and user id are added to an event participants table. I have 3 tables in my DB: "userinfo" which holds stuff like id, Name, … |
| | Hi everyone, Can anyone tell my why this does not work? I created a stored procedure that uses a variable / input value as table name, but it does not do what it's supposed to do. Here is the code: [CODE] delimiter // DROP PROCEDURE IF EXISTS userpages.respondtoconnectionrequest// CREATE DEFINER … |
| | Hi guys i have an assignment and it's asking me to let the user enter data into one of three text boxes to search for something in a database it also has to show the results in a table and be hyperlinked to the next page being bookingdetail.php and the … |
| | I'm having trouble getting my queries to insert properly. this is my table structure books(ISBN(pk), authorID(fk), formatID(fk), publisherID(fk), titleID(fk), yearPublished) the ISBN and year are past directly via a form but the foreign keys are all auto incremented in their own tables. I was trying this: [code] mysql_query("insert into authors(authorName, … |
| | Hello people, When I call my function ReadMyTable::readAdmin(); i get an error where it says I have not the right to use self::admin within that function, please, help me to fix this problem ! here is my code : [CODE]<?php class ReadMyTable{ public static $admin="admin"; public static $presentation="presentation"; public static … |
| | I have database entrys that have a date column ( mySQL date type ) in this format(2011-5-30). I want to compare that date with the current server date and with 3 days before that day, to automatically send an email to a specified address. |
| | I want to synchronize the data in the record store in mobile phone with mysql database. I connected them through a web service. How can i sync them. What is the way?? i looked in at syncML. Didn't found how to use it properly. Is there any other ways?? please … |
| | hi, i have a table setup where the user selects multiple check boxes from a form and it inserts into the table. this works fine and when i do a report i can do something like this: [CODE]SELECT COUNT(*) as MembersCount, MemberCounty FROM membersDetails WHERE MemOpportWith LIKE '%msg%' GROUP BY … |
The End.