Full Stops In Mysql Queries
I am using Mysql to search for domains in a database. For example: PHP Code:
SELECT COUNT(*) FROM domains WHERE domain = 'phpbuilder.com'
The problem is that the query will always return 0 whatever domain I input (that is present in the database). Unfortunately I built some more complicated parts of this script before testing the query itself so it took me a little while to figure out the problem was because of the full stop. If I remove the full stop in the database and use domaincom in the SQL query then the query works fine.
View Complete Forum Thread with Replies
Related Forum Messages:
Do Queries On XML Similar To The Way That You Do Queries On MYSQL And Then Use The Results.
I am fairly familiar with PHP and MYSQL and I know a little about XML. I would like to know if it is possible to do queries on XML similar to the way that you do queries on MYSQL and then use the results. An example of a simple PHP/MYSQL setup. <?php $user="username"; $host="sqlserver"; $password="password"; $database="database"; $connection = mysql_connect($host,$user,$password) or die ("Couldn't connect to the server"); $db = mysql_select_db($database,$connection) or die ("Couldn't connect to the server"); $query = "SELECT * FROM database WHERE(Criteria)"; $result = mysql_query($query) or die ("Couldn't execute query."); while ($row = mysql_fetch_array($result)) { extract($row); echo"Set of instructions to carry out for each row in the result"; } ?> The question is, is it possible to do similar things with PHP/XML? Lets say that I have an XML file located at a certain URL and I want to run a query on it and use the results. 1. Is it possible? 2. What is the easiest way to do it? 3. How would I translate the above code to work with XML? 4. Is ther resource on the web on how to structure the queries?
View Replies !
MySQL Error Stops Page Rendering
Can anyone clue me on on how to have my html page continue rendering past a MySQL error? If you visit www.Base2WebDesign.com, click login, type in anything for a username and password, then view the page source. You will see that the page displays the error then just stops rendering the html. (I know what the error is, I deleted that table on purpose for a simple way to show you what I would like fixed.) This doesn't cause any problems on this particular page (other than it fails vailidation) but I some of my website I have other information below those errors and even the remainder of the page. If it hits an error I would like the remainder of the page to still be displayed, just display the error and keep moving. Is there anyway to do this?
View Replies !
Displaying Full URL Address From Mysql DB
Hi all I am having a problem, displaying a field form my mysql db. the field is a text varchar(80) containing url's (web addresses more importantly). the issue is, when a user enters into the db an address without the 'http' suffix on the start of the url, I try to display it.. but obviously the browser then renders it as a file to the root directory when actually its an entire new url. Did I explain that good enough?
View Replies !
Full Text Search ( Mysql )
I was searching the sql man , for some good ways to search a mysql db. so i found that Full text search the best way is to go becease LIKE just gives to mutch output.PHP Code:
View Replies !
Full-text Search Mysql
I building a little site using PHP and mysql. Now I want to make full text searches on some columns in one table. The problem is that I have 25 colums in the table that I want to put at full-text index on. I belive there is a limitation of 14(?) colums. What is the proper way to handle this? Reading about full-text indexes, do I have to make a "repair table..." after each time I insert data in the table the will be included in the indexed columns? If this is the case I must repair the table every time I insert anything?! I am using "DBDesigner 4". How can I see in my table that it is a full-text index. Seems like it appears as a normal index in my data definition as well as in the reversed engineered graphical interface.
View Replies !
MySQL Full-Text Searching
I am reading this article that says by default, the ft_min_word_len is 4 characters and the ft_max_word_len is 84 characters. I don't have access to the MySQL configuration file, is there a way to change the full-text word length settings like using .htaccess? I access my MySQL using phpMyAdmin, which is shared with a bunch of other users. So I have no rights to make modification whatsoever. Is there a way to modify just my table in there?
View Replies !
Showing Full 2d Array On Screen From MySQL
I have successfully created a MySQL database, and inserted a table "65chain" into it. The table has 10 columns, including the primary key column Drop_1, and 6 rows. The Drop_1 column is indexed at 600, 800, 1000, 1200, 1400, and 1600. The table is representative of a series which will have varying numbers of rows and columns. In phpMyAdmin, I see the 2d array I would like to see eventually on my web page, when I select the SQL tab and enter SELECT * FROM `65chain` WHERE Drop_1 is not null Great. I am now creating my script. So far I have:
View Replies !
Full HTML Pages In MySQL Page?
I'm working on a small script to put full html pages in a database and then retreive the data to show on the page. The problem is that VARCHAR can only go up to 255 characters I believe. I also tried TEXT, but then I get a few columns like 'Field','Type','Function','Null' and 'Value'. I don't know what to do with the other columns. I also can't seem to be able to put data in the table with a script. Can anyone tell me what the best way is to do this and how to insert data into it with PHP? And are there any problems when I try to display it on the page (I read somewhere that special characters are being left out sometimes).
View Replies !
MySQL 5.0, FULL-TEXT Indexing And Search Arabic Data, Unicode
MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode [This version has a couple subtle edits from the orginial I posted on mailing.database.myodbc - I'm cross posting here on this topic/subject related newsgroup] I was wondering if anybody has experienced the same issues challenges I'm experiencing I'll describe shortly. Once resolved some fascinating and powerful multi-lingual apps incorporating non-English/latin character sets can be realized by many developers. I have a Unicode utf8 English - Arabic - Hebrew - Greek (and several other languages) database in Microsoft Excel. I KNOW that it is Unicode utf8 data because MySQL tells me it recognizes the encoding as such but not in the context I want. Allow me to explain ... I can search the Unicode utf8 encoding with no problem in Excel. While in Excel I highlight a complete word or a partial string of an Arabic word copy it to the clipboard (i.e. memory). I then do a find and the process is the same successful result as if it was an English string. MySQL 5.0 is supposed to handle Unicode utf8 I created a MySQL database I named: languages CREATE DATABASE languages ; and I implemented the following command on a MySQL command prompt: ALTER DATABASE languages DEFAULT CHARACTER SET utf8; No problem (so far) MySQL seemingly recognized utf8 and accepted it. My understanding is with the ALTER command the tables I create against languages will be utf8. I now created a table I named mainlang which denotes it will be the main table for my languages. mysql>CREATE TABLE mainlang ->( ->langNumID varchar(30), ->colB varchar(30), ->colC varchar(30), ->primary key (langNumID, colB) ->); Again so far no problem: Table successfully created. My third column 'colC' is where the Unicode data will be stored. I now attempt to import the database from my Excel file into my MySQL database as follows: mysql>load data infile 'c:arabicdictionary.csv' ->into table mainlang ->fields terminated by ',' ->lines terminated by ' ' ->(langNumID, colB, colC); ERROR 1406 (22001): Data too long for 'colC' at row 1 So what to do? I did a search and found other people seemingly had the same problem and someone suggested: ALTER DATABASE languages DEFAULT CHARACTER SET cp1250; I dropped mainlang, recreated it, redid the load and Lo and behold ... it seemed to work. No Data too long error occurred and when I did the following query: mysql>select langNumID, colB, colC ->from mainlang ->where colB = ��' I see colA have a correct numeric value, colB a correct numeric value (4994) and for colC a string of unintelligible characters with diacritical marks, oomlats etc. which I know is the cp1250 encoding interpretation of the Unicode utf8 data which is similarly unintelligible in its own regard. Now what I try is: do a copy of the obscure colC cp1250 character string into the clipboard/memory and then do the following tweak on the original select statement to see if I can search on the (now) cp1250 character string: mysql>select langNumID, colB, colC ->from mainlang ->where colc = 'paste of the cp1250 character string' The computer would not allow a paste unless I pressed the escape key. On initiating this select command I got an empty set (no match) My questions are: Has anyone been successful creating a Unicode utf8 MySQL database that accepts Arabic? If yes, how did you get around or not encounter the Data too long issue? Have you tried the cp1250 (or cp1251 - same mechanics same results) work around as I have? Are you able to search the cp1250 character string (my colC)? If yes, how did you successfully manage to do it? Lastly, if I take the cp1250 encoded string and paste it into Excel ... I can string search the cp1250 encoding with no problem. Also, here's how I know my Unicode utf-8 data is correct apart from my own manual cross-referencing and being recognized by MySQL in some respect: When I copy the Unicode utf8 encoding and try to paste it into the select command to see what would happen I get the following error: ERROR 1257 (HY000): Illegal mix of collations (cp1250_general_ci, IMPLICIT) and (utf8_general_ci, COERCIBLE) for operation '=' So what I have here is a situation where MySQL is recognizing Unicode utf8 encoding but not from the respect of packing a table! Go Figure ...
View Replies !
Using MySQL Sub Queries In PHP CLI
I am using a sub query like the following in a cron file and its throwing a query error. ...eexpiry = (CURDATE() + INTERVAL (SELECT alert2 FROM settings) DAY)... Does that mean I cant use sub queries in PHP CLI?
View Replies !
Php/mysql Queries
I finally got my totals to work for this survey, but now the queries are killing the database. With only 14 submissions to the database it takes 10 sec to query the whole thing. 100 survey submissions didn't even load after 5 min. How can I economize my queries? PHP Code:
View Replies !
Mysql Queries
I hope this is not to much to ask for in a post, but any help would be apperciated. my site script uses a template .tpl system similar to smarty... to for each $en[] query i'll be able to post the results below in the html by using <% %> I attempted to start writing the queries but i think i need to use something like mysql_result(mysql_query("SELECT... for each. Code:
View Replies !
Scheduled Mysql Queries?
How do you schedule a mysql query? Like (half pseudo-code): mysql_schedule("every five minutes"); $query = mysql_query("SELECT some integer"); $int = mysql_fetch_array($query,MYSQL_NUM); $int[0] += 10; mysql_query("INSERT $int") or something along those lines...I want my users to accumulate "taxes" every turn..even when their not playing..turns will last 5 minutes.
View Replies !
Put MySQL Queries Into Variables
The following query returns 7 codes, how do I put each of them into a separate variable? $result = mysql_query("SELECT day_plan FROM calorie_plan WHERE calories = '$calories'"); if (!$result) { die('Invalid query: ' . mysql_error()); } while ($row = mysql_fetch_array ($result)) { $day_plan = $row['day_plan']; } I'm sure I've done this before but I can't remeber how or where.
View Replies !
Dates In MySQL Queries
I am trying to do select all of the records in a table where they data has not expired. The table contains two fields Subject (varchar(100)) and ExpiryDate (Date). I am getting all of the records returned when I execute: $sql = "select * from tbl where ExpiryDate > " . date("Y-m-d"); mysql_query($sql); The expiry date in the record I am looking at is 2004-03-25 and the query that is being executed is: select * from tbl where ExpiryDate > 2004-03-28 What am I missing? Can anyone recommend a good site to look at that discusses dates in MySQL queries?
View Replies !
MySQL Queries On Email?
Is it possible for an SQL query to be activated when an email arrives? Its for a mailing list, so that if someone emails a special address for unsubscribing, it automatically pulls their address' off the mailing list DB?
View Replies !
How Can I Get Rownum Using MySQL Queries ,
How can I get rownum using MySQL queries , In Oracle one can you in this way SELECT rownum as srno, fname FROM tablename suppose If there are 45 records and if i use while for the srno should display 1, 2, 3, ... 45 query like SELECT rownum as srno, fname FROM tablename I dont want to use php counter, i want it from query
View Replies !
Relatively Complex Php/mysql Queries
I need to write to 5 related mySQL tables from one form, using php. First, I need to write some of the data to one of the tables so that I can extract (SELECT) the auto_incrementing primary key to use as a foreign key in the next two INSERTS. Then I have to extract (SELECT) the auto_incrementing primary key from one of those tables to use as a foreign key in the last tables. But if I get a failure part way through this operation, I could have a partial write and my data integrity is not just compromised... it's just plain bunged up! What are some strategies that can be used to prevevnt this from happening?
View Replies !
Mysql Queries Overload?
I need load some fields from a Mysql database, including some text fields, into variables or an array, but I will use them on different pages, for example: "$result[Name]" loads in every page, but "$result[Adress]" will load only in adress.php , questions: 1)is there a way to load the line returned by the query in a array and store it in a page which every one of the others can access? 2)if make a new query every page loaded, will this overload my server since lots of clients can login at the same time? 3) Is there a way to pass the array? 4) Is any of these the best way of doing it? Or anyone have a better idea? PS: If im gonna pass the variables, I need to pass it in a text link.
View Replies !
Big Amount Of Mysql Queries...
I have good script which works fast, but if i try to push to mysql many queries, i loose about 1000% of speed... my system have about 300-800 select queries and they can't be optimized... can it be here some hidden things too process many queries (select) faster? (no merge or different sql based optimizations... only php)
View Replies !
Secure MySQL Queries
I would like to know if there is any functions I should use on every data entered by a user before making my SQL query to make it secure so the user cannot try to mess with the database? I usually do addslashes sometimes but is there a function that I could use on every variable that I will use in my SQL query that would make it secure in everyway?
View Replies !
Multiple Queries To MySQL
I am querying each column twice; once to see how many people said 'Yes' to that question, and again to see how many people said 'no' to that question. This means a total of 38 queries. Is this the right way to do it or is there a better way? Like just one BIG query? Code:
View Replies !
MySQL Queries And Relevance
I'd like to be able to search for multiple words, and have it return any results in which a certain field contains all or any of those words in any order. So, if I search for "example one" it would return things that contained "one example" and "one other example as well as the exact phrase, or ones that only contain some of the words in the query ("example two"). Ideally, it should also give each result a rank based on how closely they match the query, and list them in order of relevance. Anyone have any idea how this could be done?
View Replies !
Multiple MySQL Queries
I am trying to select data from two separate MySQL tables, where I cannot use join, but when I put the two select queries into a single query, I get an error telling me to check my syntax. Both of the queries work fine when I use them to query the MySQL server directly. My guess is that the MySQL extension only expects a single resource back from the database, but get's several, or that it just checks the statement first, and decides it's not valid. However, my guesses and/or assumptions don't really make much of a difference as to the workings of the PHP MySQL extension. Would anyone know if there is something I can do to get around this problem?
View Replies !
Speed Up Mysql Queries?
I have a database with well over 350,000 records and was wondering if there was anything i can do to speed up how it reads from the database. i cannot remove any of these tables. here is how i read from the database now. Code:
View Replies !
Optimizing Mysql Queries
have a feeling that this isn't very optimal. Is there a way where you can put all these mysql queries into one or more fewer than this? This way works great, though a bit too much queries. $querytotal = mysql_query("SELECT id FROM $db WHERE date_pub='$week' AND visible=Ɔ'"); .......
View Replies !
MySql Caching Queries
I would like such that once any unique query has been executed, it should be cached and should display quickly next time the same query is called unless the mysql table which is being accessed is updated or its timestamp changes. Is this possible or there are better caching/speed improvements available?
View Replies !
Safe MySQL Queries
After realising how easy it is for a malicious user to inject an sql query into a paramenter for a query, e.g: $query = "SELECT name FROM employees WHERE ID = ".$HTTP_GET_VARS['id'] And the user enters for the query string: mypage.php?id=1 UNION DISTINCT.... I'm trying to work out what level of protection is needed. As far as I can see, for integer values I should just validate that a numeral has been entered, and for text the addslashes() or mysql_escape_string() functions are enough. Am I right in saying this?
View Replies !
An (OR) Operator For MySQL Queries
I've used one before but can't remember what it was, say for example I need to SELECT 2 different specific values from the same field. something like: $query = "SELECT * FROM table1 WHERE field1 = 'dog' OR field1 = 'cat' LIMIT 0,100"; of course the above statement will return an error but you get the idea of what I am trying to do. I haven't been able to figure it out yet.
View Replies !
MySql Last Month Queries
I have to manually change the dati in the php file every month, for it to work. My current syntax: $sql_3="SELECT COUNT(distinct person_id) from request_rights where register_date < 񟭇-08-01 00:00:00'"; $select_3 = mysql_query($sql_3) or die("Nevar pieslçgties DB!"); $select_3_rez = mysql_fetch_array($select_3);
View Replies !
Standard Mysql Queries
I'm familiar with standard mysql queries. but his one is a little advanced for me. can so one decipher it. "SELECT o.*, u.username FROM myauction o, myauction_users u WHERE blah blah blah blah blah...
View Replies !
Using Mysql Queries With Functions
I am using a a class with the following function to gain the only sql result i need to use with 4 other functions. I am trying to avoid writing the same query over and over. function SQL($result){ $sql = "SELECT gametype, name, choice, comments FROM sportd ORDER BY id_num DESC"; $result = mysql_query($sql); return $result; } I am able to echo the number of rows in the result to other functions but not any of the result variables. My question is, How can i take the function above, and use the $result var in other functions?
View Replies !
Skipping Mysql Queries
I have a mysql query that tracks traffic to my site and if the query takes too long then the page simply fails to load. If I put this on the bottom of the page the page loads but I get the headers already sent error message. Is there a way I can skip a query if it takes over, say 2 seconds to finish?
View Replies !
Mysql Queries And Activity
I am going through and optimizing my code. I would like to get a nice "before and after" picture of how many fewer queries and general activity I have after I am done optimizing. I'm sure it could be done on the server end but is there any way for me to tell on the user end when I only have access to cpanel X?
View Replies !
Construct MySQL Queries
I am having trouble with MySQL and PHP. I want to do neat stuff in PHP but I have trouble generating commands and stuff. I was wondering if there is any visual tool that can help me contruct PHP and MySQL codes.
View Replies !
1000s Of MySQL Queries
I am trying to execute arounf 1500 MySQL queries using the same script: [php] <?php // Line 1 mysql_connect(..., ..., ...); mysql_select_db(...); mysql_query("INSERT INTO.........."); mysql_query("INSERT INTO.........."); //Line 6 etc ?> I am getting this error: Parse error: syntax error, unexpected T_STRING in /home/isaac/public_html/thepeccavi/bsc/pupils/sql.php on line 6Isaac
View Replies !
PHP/MySQL - Effiecient Way (low CPU, Fewest Queries)
Suppose you have a database with a Date column (format: YYYY-MM-DD)that has an entry for many days, spanning several years. Maybe sometimes entire weeks or even entire months are skipped, but there are lots of entries. ********************* * myDate * myEntry * ********************* 2001-02-22 asdasdas 2001-02-28 ssdsdwww 2001-03-10 dfgdfgdf ... 2005-06-03 sdfsdfdg What is the most effiecient way (low CPU, fewest queries) to extract each month and year that contains at least one entry? Sort of like the archive list in blogspot.
View Replies !
Dynamically Generate MySQL Queries
what I expect will be a reasonably simple question. I have an html form (which is generated in php) which contains a number of rows (one row per product in the 'products' table). It is generated with the following php <code> // create a table for the results echo('<table border=1 cellpadding=2>'); echo('<tr> <th>Product Description</th><th>Sales $</th><th>Sales Units</th><th>Credits $</th><th>Credits Units</th> </tr>'); // add the results to the table while ( $row = mysql_fetch_array($result) ) { // get columns from the output on the current row $ProdDesc = $row['ProductDescription']; $ProdID = $row['ID']; // write content collected above into table cells echo('<tr><td>'); echo($ProdDesc); echo('</td><td>'); echo('<form action="update-db.php" method="post"><input type="text" name="sd'); echo($ProdID); echo('">'); echo('</td><td>'); echo('<form action="update-db.php" method="post"><input type="text" name="su'); echo($ProdID); echo('">'); echo('</td><td>'); echo('<form action="update-db.php" method="post"><input type="text" name="cd'); echo($ProdID); echo('">'); echo('</td><td>'); echo('<form action="update-db.php" method="post"><input type="text" name="cu'); echo($ProdID); echo('">'); echo('</td></tr>'); } echo('</table>'); //the table is complete </code> The values sd1, su1, cd1, cu1,...... cuXX are all available to the update-db.php page which is called when this form is submitted so I am fairly sure this is working correctly. So far, so good, but when it comes to inserting the data into the database I have not been able to create the SQL dynamically (in testing I know the number of products and have manually written lots of SQL INSERTs but this will not work in the real world) The SQL needs to look like roughly like this: mysql_query ("INSERT INTO sales_dollars (SaleID, ProductID, WeekCommencing, Sales, Credits) VALUES ('', '$prodID','$WeekCommencing','$sd1', '$cd1')"); My logic was to say something like this (which needless to say doesn't work !) <?php for ($prodID = 1; $prodID <= $prodCount; $prodID++) { $currentSD = "sd" . $prodID $currentSU = "su" . $prodID $currentCD = "cd" . $prodID $currentCU = "cu" . $prodID mysql_query ("INSERT INTO sales_dollars (SaleID, ProductID, WeekCommencing, Sales, Credits) VALUES ('', '$prodID','$WeekCommencing','$currentSD', '$currentCD')"); } I may have messed up the for loop here but the real problem was that query would insert '$sd1', '$sd2' etc as text strings into the database rather than evaluating $sd1 to it's value (passed from the original table which would be a number) I have tried using eval() with no success (though that may well be due to my complete newbieness with php). I have also tried passing the values from the original html as arrays and trying to use simillar logic as above to read from $array[$currentArrayElement] also with no success. Again, if I manually echo the results of $array[0] I am returned the value entered in the first html field but I can not dynamically select the next array element. I hope I have made sense of the problem without writing unnecessary garbage.
View Replies !
Executing Multiple SQL Queries (MySQL)
I am writing an install script, which needs to build the tables and insert specific records for the application. There are about 50 or so queries. (format exported via phpMyAdmin) I've got all these queries in a file - how do I go about running them all individually? Clause - I can't simply use file() and do each like that. The SQL statement for the tables is in a multiline format, like this: Quote: CREATE TABLE `categories` ( `ID` int(11) NOT NULL auto_increment, `parentID` int(11) NOT NULL default Ɔ', `name` text NOT NULL, `description` text NOT NULL, `filename` text NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `ID` (`ID`) ) TYPE=MyISAM;
View Replies !
Optimise Two Mysql Queries To One Query
$a = mysql_query("Select a,b FROM t WHERE category=1") while($a) { $x = $a[a]; //some echo //another query $b = mysql_query("Select * FROM t WHERE subcategory=$x") while ($b) { //some echo } } Point is that I have menus, parents with childes (childes are not parents) and I want to display them using only one query. - Parent 1 -- Child 1 -- Child 2 - Patent 2 -- Child 3
View Replies !
Select & Delete Mysql Queries
i've try to insert and delete record at the same page, but it only can insert and can't delete the record. when i click submit button from the previous form, the record is insert into table B and delete from the table A. is the code correct? Code:
View Replies !
Simplify/Reduce Mysql Queries
Anyway to simplify/reduce the amount of queries I use here (they will get loaded on every page by hundreds of users simultaneously)? It's an IP system Im building to record the IP's of my users. If working correctly, it should add a new entry each time their IP changes, and keep up to 10 records of IP changes. Code:
View Replies !
1000-10000 Mysql Queries
there is one PHP file (cronjob.php), which will update mysql database every 24 hours. Script will always do 6 required sql queries and 3 additional queries for every user in the database. But what if my site has 1000 or even 10000 users? Will server break?Queries data contains only number, no long text or etc. So, if 3-30k mysql queries for server at one time is too much, what to do then?
View Replies !
UNIQUE Or DISTINCT MySQL/PHP Queries
I have a product database (provided by a partner site) which has 10,000+ items. These items are identified by a unique ID number, which in this case is the manufacturers' product items. To do away with EXTENSIVE "massaging" of the data, I am "dumping" the raw text-delimited data into our MySQL database, in its own unique table. I query the database to display different types of items, and want to do it MORE EFFICIENTLY than the structure of the data allows. Code:
View Replies !
Listbox And Multiple Php/mysql Queries
i've run into a bit of a problem which i can't seem to solve. Basically i'm making a forum and i'm working on a section that enables you to view information about the other users signed up the forum in one big table. I have 6 columns and a listbox that enables you to sort the data regarding the selected item chosen (ie. if postcount is chosen the table will be sorted by post count) Anyway, here's my code for the listbox: Code:
View Replies !
Using Session Variables In Mysql Queries
My php code consists of getting a person's session_id() and placing that in a session variable for use in other pages. The thing is, though, that when i place a session variable in a mysql query, i get the following error: Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/content/e/r/i/ericjacobson01/html/index.php on line 11 This is the part that php complains about: $_SESSION['buyer_id'] = session_id(); $istableset = mysql_query("SELECT * FROM ' .$_SESSION['buyer_id'] '");
View Replies !
Mysql Sort Multiple Queries
I have a table called registration and a table called apppost. When I run the following code below, both queries print and match fine on the same page (like I want it to). However, when I do a sort (i.e. - http://www.example.com/folder/phpfile.php?sort=status) I get a warning that the mysql_fetch_array($result2) supplied argument is not a valid MySQL result resource. The data from the first query ($result) still displays correctly, but the data from the second query ($result2) doesn't display at all. Code:
View Replies !
|
TRACKER
