How Do I Return Result Of Mysql Row Deletion
The data entered by a user on form 1 on page1.php is posted to
delete.php to remove that row from a table. After the SQL operation
the user is returned to page1.php.
How can I determine the success or failure of the SQL operation so I
can display an appropriate response message to the user?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Same Mysql Query Doesn't Always Return A Result
We have no access to a mysql NG on my provider's server, so we ask here: We have a long query (long in text) with a UNION between 2 select. We have been informed that some times the query doesn't return any result. We have tried on our server and we always get a result. BUT, trying on the hosting server, many times the query doesn't return any result and doesn't get any error. Any idea ? does Union have any problem ? how to check if the query failed ? My hoster said that sometimes the table can be locked (if the server is overloaded) and then mysql doesn't return any result, but this seems to me an aberration. the query takes about 0.0050 sec to execute when it doesn't return any result, and 0.030 when I get results
Mysql_free_result Return Error Saying Not Valid Mysql Result Resource
im trying to do a query which takes rows of large amounts of text data and displays them one after another. the size of the fields is causing the page to be massive in size. so to try and reduce this im trying to use mysql_free_result to clear the contents from memory. however its returning an error saying not valid mysql data when im certain that it is. is this because im using a while loop like this...? ($row = mysql_fetch_result($result)) { mysql_free_result($result); }
IE6 & Cookie Deletion
I have always previously always used cookies for authentication and on both sides (Netscape & IE) it has always operated flawlessly. Now that I have finally decided to try out IE6 i'm finding some problems with deleting cookies. Are there any bugs out there that I should know of?
Selecting Db Results For Deletion.
I am having a problem trying to select a number of unique db results from a db driven printed table (using a loop to print). I want the results selected (via a checkbox button) to be identified using their unique ID number, then passed to a php deletion script and deleted from the DB (the ID nums are passed) In other words I am trying to delete threads from a forum DB.
Timed Deletion In Database
Does anybody have any pointers for code that will delete a record by setting an expiration date for it. I want to have news stories delete say 2 weeks after they have been posted automatically, I am using php and mysql?
Deletion And Editing Of Modules
i'm creating a miniature CMS. At the moment i'm working on the creation/deletion and editing of modules. I've got the creation working. But i'm struggling on the deletion and editing. This is what i was thinking: [Deletion] 1. (ID) Module 1 [Delete] (Link: modules.php?do=delete?name=Module%201&id=1) [Editing] 1. (ID) Module 1 [Edit] (Link: modules.php?do=edit?name=Module%201&id=1) How would i make it so the URL was that?
Mass Deletion/Paging
I am a first timer here and I hope to enjoy the forum in the long run. I have a question regarding mass deletion and pagination or paging. I have the following code/method which displays the search result and I want, within the search result, to allow staff or members with appropriate access to be able to delete (multiple records via checklist) records from the database. The methods are under index.php and here is the code below: Code:
How To Ensure Deletion Of Session Files
I am looking for the setting in php.ini what can be configured to make sessions expire and session files removed. Can it be the following entry or is it something else? ; After this number of seconds, stored data will be seen as 'garbage' and ; cleaned up by the garbage collection process. session.gc_maxlifetime = 1440
Getting Result From Mysql
I am using this code to get some data from a mySQL database. Which seems pefectly valid to me. Here it is: Code:
Return The Key From Last Mysql Insert
How do I return the auto incremented value of the primary key from a tuple that I have just inserted into a MySql database. If that is not quite clear enough then this long winded explanation should explain what I mean: Say I have a MySql table called "n" with two columns: 1: id = Autonumber - Primary Key 2: name = Text If I insert a tuple with the following mysql command using a PHP interface: Quote: INSERT INTO `n` ( `name`) VALUES ('Paul Smith') Then a tuple with with values say (34,Paul Smith) will exist in the MySql table. 34 is the value of the auto generated primary key. The question is how can I find this value 34, which is the primary key, without running a statement like : Quote: SELECT * FROM `n` WHERE `name` = 'Paul Smith'
MySQL Results To Return Only One Value
For example, I have a column that has three different values, 1, 2, & 3. In the database, there may be over 500+ entries with one of these values assigned to it. How can I get MySQL to return just 1, 2, & 3 only once rather than several hundred times.
No Return Using PEAR And MySQL
Below is the php code (Very simple): <?php include_once('C:AppServphpPEARDB.php'); $db = DB::connect("mysql://alucard@localhost:3306/soccer"); $db->setErrorHandling(PEAR_ERROR_DIE); if (DB::isError($db)) { print $db->getMessage(); exit; } else { $result = $db->query("SELECT * FROM league;"); print 'Query returned ' . $result->numRows() . ' rows' print 'Query returned ' . $result->numCols() . ' cols' print 'Query affected ' . $db->affectedRows() . ' rows' $db->query("INSERT INTO people VALUES ('Thomas', 0);"); print 'Query returned ' . $result->numRows() . ' rows' print 'Query returned ' . $result->numCols() . ' cols' print 'Query affected ' . $db->affectedRows() . ' rows' $result->free(); } $db->disconnect(); ?> Now the problem is, when I ran this code, there is nothing return in browser.(ALL BLANK, see nothing, no error, no result, absolutely white) There was also no changes on DB.
MySQL Result Resource
I want to build a function that, depending on the input, will either return the results from a MySQL query or do something else and return one of several messages. My problem is checking the return value to see which is returned. Is there a php function that checks a variable to see if it is a valid MySQL result resource? I looked through the manual and couldn't find anything.
MySql Result In Textarea
I have a script to display mysql query results in a table. I'd like to display the results in a scrollable textarea. Is there a way to do this?
Returning 1 Result From MySQL
I know the usual way of receiving results from MySQL, useing a while loop e.g. $sql = "SELECT * FROM users WHERE email='joe@hotmail.com'"; $result = mysql_query($sql,$connection); while ($row = mysql_fetch_array($result)){ echo $row["firstname"]; echo $row["lastname"]; echo $row["email"];} BUT, if I know they only 1 result is going to be returned, is there a way to do this without using a while loop? So if I only wanted to get only the firstname of the person with email joe@hotmail.com. can I do this without a while loop or do I have to use one?
Total Result Php Mysql
PHP Mysql limit the result to 5 I can display the 5 results using a do & while which it ok. I want to list the total or all the results without using a do or while this is so I can combine the results and remove duplicate words from the total results I.E. Do & While row result 1 this is the top 2 this is the bottom 3 this is the middle 4 this is the end 5 this is the finish This is what I want to do: result this is the top this is the bottom this is the middle this is the end this is the finish modified result:: this is the top bottom middle end finish
Invalid MySQL Result
I keep getting the following two errors: Warning: Supplied argument is not a valid MySQL result resource in /home/xxx/public_html/articlepro/newarticle.php on line 75 Warning: Supplied argument is not a valid MySQL result resource in /home/xxx/public_html/articlepro/newarticle.php on line 84 Here's the code which I think is causing the problem. PHP Code:
MySQL (DB) Result Sorting
I'm doing is taking results (fetching rows) from my mySQL database. But what I want to do is sort the results according to last name. So basically the table structure looks something like this: id (primary key) fullname A example rows could be: 1 John Smith 2 Mary Jane Now what I want to do is sort the results in PHP based on last name. I'm using the Pear DB for connecting to my mySQL database. Based on the example rows I gave, Mary Jane would go first, and then John Smith. How would I go about doing this? I was beginning to split the result based on spaces, and the last word to explode, but how would I truly do this?
Modifying MySQL Result - But Not The DB
How can I modify a MySQL data set returned by mysql_query? I am basically doing a while loop over the rows, changing one field, and then doing a mysql_data_seek back to the beginning of the set before returning it. However, later calls to mysql_fetch_assoc still return the orginal data, meaning that (I assume) I am changing a copy of the data rather than the result set itself. Taking the reference (i.e. $record =& mysql_fetch_assoc($result);) did not help. I have read a large quantity of the posts in the php.net site, googled, and read my PHP books - but have come up short on this one. Yes, I know it's better to simply modify the DB. However, I'm working with an existing code base which is very complicated, and want to cherry pick one very well tested feature by making a change in the result set only under special circumstances.
Substr() With A MySQL Result?
I am trying to limit the amount of text exhoed from a MySQL database column. From reading around it appears the substr() should be able to do this Code:
Mysql Result Into Array?
I have a shopping cart script sending info to a processor. I need to send the qty's and item name's in some sort of string via a single variable to the process form. i.e. (3) Hipster Turnips, (6) Butter Milk Baby Brains, (2) Super Freaks Code:
Result From Mysql Into Foreach?
when using mysql_fetch_array($result) I usually toss that into a while loop like so while($row = mysql_fetch_array($result)){ ... } however I was wondering if there was a way to put it in a foreach statement like so foreach(mysql_fetch_array($result) as $row){ ... } Is that legit? Will this work?
Linking To A MySQL Result
I had it the other day but now altered the code for my real database and it stopped working. Here is the first page which lists the 10 most recent news stories: <?php require ('get_connected.php'); $sql = mysql_query ("SELECT title, story_id FROM news ORDER BY story_id DESC LIMIT 0, 10"); while ($row = mysql_fetch_assoc($sql)){ echo "<a href='view.php?id={$row['story_id']}'>" . ucwords(strtolower($row['title'])) . "</a><br>"; } ?> And here is the page that should be displaying the news story based on story_id selected by the user.....
Linking Back Into MySQL From A Return
I have a simple contact table with a catagory, name, address columns and I'm sorting it by catagory then name. My question is after I get this return how I can make each catagory listing link back into the database to return all its members in a seperate part of the page. I can make a simple echo html table loop to return the catagory data, but how do I also include an <a> link to each catagory listing so that it will then access the database and dump it into another part of the page.
Affected Row Return Values From MySQL
When I remove 10 rows from a table in a mySQL database, I am not getting 10 as the affected rows return value. I am also getting positive return values if I try to delete a non-existent entry. here is a small test script that I am working on where I am getting errors. Code :
Return MySQL Table Name As PHP Variable
I've got a MySQL query something like the following: $fields = mysql_query('SELECT ItemID FROM Table1 UNION SELECT ItemID FROM Table2 ORDER BY RAND() LIMIT 1'); There's more criteria than that, but this illustrates the basics of the situation. Essentially I want to randomly select one row from either of the two tables. I've got that part down; the query is returning the results I need. However, the problem I'm having is finding out which table the query pulled the result from. I'm querying two tables and will return one result - but I need to know which table the result came from. Is there any way to assign it to a variable? If so, how can it be done?
MySQL Query Return Category Name Instead Of #
I Have 2 MySQL tables of interest here. Table 1: categories ID name Table 2: items ID category (this relates to the category ID in Table 1) title I want my table on my webpage to show the category name from Table 1 instead of the category number in table 2. Code:
Using MYSQL Result To Send Mail
I have wrote a program to load a number of email address from the MYSQL database. And I have use "$mail = mysql_query("select email from user;",$link_ID); Now, I want to use mail() to send email to those e-mail account I got. What should I do for this?
Date Formatting From Mysql Result
always in the past I have done my date formatting from the query like so: DATE_FORMAT(dateField, '%W, %b %e, %Y') AS realDate I have tried formatting the straight date result with PHP like so: having fetched results with mysql_fetch_array, $newDate=$result["dateField"]; $formattedDate=date($newDate, 'm/d/y'); This doesn't work and simply returns the unformatted date as it is stored in the database.
Invalid MySql Result Resource
I have written a php script to search a MYSQL database and with the line: $result = mysql_query ("SELECT * FROM table1 WHERE first_name LIKE '$first_name%' AND last_name LIKE '$last_name%' " ); The next line, if ($row = mysql_fetch_array($result)) { , gives me the error message "supplied argument is not a valid MySql result resource"
Display Of Mysql Table Result...
I have a mysql table of articles with fields: - recordID - department - articleTitle - articleText Using PHP, I'm attempting to get the results of the table to display as follows: Department 1 - articleTitle 1 - articleTitle 2 - etc.... Department 2 - articleTitle 1 - articleTitle 2 - etc.. I figure I should use a while loop but can't figure out how to exit/reset the loop when a new 'department' is encountered in the $result.
Replacing Array With Mysql Result
I wanted to repalce the following line of code $data = array(40,21,17,14,23); with for($i=0;$i<$numrows;$i++) { //print(mysql_result($result,$i,2));print("<br>"); array_push($data,mysql_result($result,$i,2));} where mysql_result($result,$i,2) is the value and when i print it displays the values. But $data array is the Y axis value for drawing a chart. Here I wanted to replace the hard coded value with values from mysql but the second code does not function. Does anybody have idea how can I replace the $data array or what may be the problem with my coding The first one works but the second one does not work but in both cases it does not display any error.
Mysql Search Close Result
I've to find in a table the "closer" result given some text. Here is a little example: given the text "Batman socks" I've to find the best matching result in choices like: -"mickey socks" -"robin socks" -"batman black socks" ->this should be found -"batman wallet" -"batman" or given the text "leather shoes" I've to find the best matching result in choices like: -"socks" -"shoes" ->this should be found -"pants" -"shirts" -"leather wallet"
Mysql Problem Understanding Result And Id?
I can't understand why the output from this is not ƍ'? $query = "SELECT * FROM contacts"; $result = mysql_query($query); echo mysql_result ($result, 7, "id"); I also tried adding "ORDER by id" but I still can't get it to echo 7.
MySQL Result Printing In For-loop
I have a script that count and print every week in a selected year. Now i want to connect this to the returned result from a MySQL query. Code to explain what I am trying to accomplish: Code:
Different Result For MySQL And PHP String Comparison
I have issued an SQL statement "SELECT email FROM mailing_list ORDER BY email ASC"; By right the order of the email should be sorted from smallest to largest. However I got different results when I used record that was ranked higher to compare against record that was ranked lower. I got opposite results. Code:
Mail A Set Of Addresses From A MYSQL Result
I'm populating a field in MYSQL that collects email addresses for a certain topic and saves them like this: mail1@mail.com|emailaddress2@mail.com|email3@email.com - Basically what I'd like to do is explode the data, and set up a mailer from PHP that informs each of the addresses individually that there has been an update to the topic. I *don't* want each of the mail addresses to be visible to all the recipients on the list, so simply inserting the data into the TO: field won't do, because then all the addresses are visible, causing security concerns. Code:
Allow The User To Sort A Mysql Result
So what i got going on is a database that has, things about a video game, including the image location. what i want to do is have a nav bar up top, so the user can select a differnt way of sorting the mysql result, from like ASC to DESC, or sort by genre.
Mysql Doesnt Return All Results Of A Query
I have an sql query like this: SELECT column FROM table WHERE column1="3" AND column2="1" This query works perfectly if i run it in the command line, to be exactly it return two results. But if i run it from php i just get the first of the two results. Any ideas? Mysql 4.1.8 php 5.0.3 I have a second problem. But its more of a question. if i run the foreach loop on an array like this array("id" => "78"), then it splits 78 up in 7 and 8. Now you say its stupid to use a foreach for this array. But in the function there i use it the array could also be two dimensional. Is this behavior normal? I looked in the php manual but found nothing.
Return Record Ranking Of A Mysql Table
I have a table consisting of names, and registration dates. I query the db "select * from users order by regdate" I want do another query for a particular user, I am looking for the script to say: user is row 15 of 30.
Trying To Return Mysql Array Items From Function
I am writing a calendar script which returns events, holidays etc.. from MySQL for days with events. This was easy BUT then I tried to return multiple events on some days and thats where I am stuck. I found some examples of returning arrays from functions from functions but they all use some form of array(Ƈ',ƈ',Ɖ') and then use a for loop... I am using mysql_fetch_array so this does not seem to work... First, here is some of the code from the function where I am returning the value: PHP Code:
Query Mysql, Return Highest Value Then Create Value +1
I have a product input form I created (with php freaks help) for my website which I input general information and specs on our products. What I'd like to do now is when that form loads, it searches a seperate table and looks for the highest "ID" number. It returns the number, adds 1 to it and displays the number somewhere on the input form for reference + error checking. When the form is submitted it takes that form and creates a record pushing that number in the correct field.
MySQL Result Can't Be Returned From Class Method.. ?
I've been messing around with objects and classes lately and can't figure out why this wont work. I have index.php which uses the pbMySQL class (pbMySQL.class.php) and methods: Code: include("lib/pbMySQL.class.php"); $db = new pbMySQL; $db->pbMySQL_open("localhost","user","pass"); $db->pbMySQL_useDB("database"); // $q=$db->pbMySQL_query("SELECT * FROM pbn_news ORDER BY id DESC"); $q=mysql_query("SELECT * FROM pbn_news ORDER BY id DESC"); if(isset($q)) { while($row=mysql_fetch_array($q)) { print $row['name']."<br> "; } } else { print "query returned FALSE"; } $db->pbMySQL_close(); My problem is that when I use the first query method (which is commented; uses the pbMySQL_query() method) I do not get the mysql result returned, but if I use the same query without the method, I get the result. Here is the method from my class: Code: function pbMySQL_query($query) { if(!isset($this->conn) || !isset($query)) { print "Error : argument(s) missing.<br> "; } else { $this->query = mysql_query($query,$this->conn) or die("Error : query failed.<br> mysql said: <i>".mysql_error()."</i><br> "); if(isset($this->query)) { return $this->query; } else { return FALSE; } } } The method returns FALSE and I don't understand why. Is it something in particular I have to do different when using a class?
Error Message - 0 Is Not A MySQL Result Index
Could anyone explain what this might mean? Warning: 0 is not a MySQL result index I have a simple form set up where a user types in a keyword and then a page is displayed based on the keyword. See below: HTML page: <html> <head> <title></title> </head> <body> <form action="submitform.php3" method="GET"> <p><strong><font face="verdana, arial, ms sans serif" size="1">id#</font>:</strong> <input type="text" name="keyword" size="15" maxlength="25"> <input type="submit" value="Go!"> </p> </form> </body> </html> submitform.php3 page: <?php mysql_connect ("localhost", "username", "password"); mysql_select_db (dbname); $result=mysql_query("SELECT $url FROM table WHERE keyword LIKE '%$keyword%'"); list($url)=mysql_fetch_row($result); ?> The concept is really simple. A user types in an keyword and that page is displayed. There is a database set up with a table that has two columns. One is "keyword" and the other is "url" For example row 1 the keyword is abc, and the url is http://www.abc.com.
How To Get Mysql Query Result Into Temp. Txt File
I did a lite search in the archive but didn't find anything specific to my problem. Here is what I am trying to do: I've got a table with about 25k entries of company addresses. I need to be able to pull specific data out of the table and put it in a temporary text file and then display the result in the browser for the user to save locally. The query part and the format of the data is all simple enough but I am having trouble figuring out how to get the data from the query into a temporary text file and then displaying that file. here is what I whipped up but it obviously doesn't work: Code: <? $tmpfname = tempnam("/path/to/file/", "FOO"); $list = mysql_query("select * from FH_LIST where State='AK'"); while ($list_results = mysql_fetch_array($list)) { $data = blah blah blah; fwrite($tmpfname, ".$data "); } fopen($tmpfname, "r"); fpassthru($tmpfname); ?> I get an error message saying: Warning: Supplied argument is not a valid File-Handle resource (referring to $data).
|
TRACKER
