Databases
in [PHP]
|
Navigation Help Hi, Could any one please help me with Page Navigation. I have done Next and Previous page Navigation but confused on printing page numbers (1,2,3,4) and hyperlink them. Below is the code which i'm halfway on but it only prints "1" with no hyperlink where as I have 11 pages, if i print $noPages. Could you please correct... 4 Jun 2008 21:49
Can't get PHP PGSQL module to load Hello all, I am trying to use PostGreSQL with PHP (using Apache on Windows), but can't get the php_pgsql.dll module to load. phpinfo() reports that the loaded configuration file is C:\Program Files\PHP\php.ini. (It also reports that the "Configuration File (php.ini) Path" is "C:\WINDOWS" - I... 3 Jun 2008 20:14
question, about mysql query This isn't a PHP question at all. It's a MySQL question. However, answers are below, with forwards to the appropriate lists for archiving purposes. On Mon, Jun 2, 2008 at 9:19 PM, LKSunny <ad(a)pc86.com> wrote: two table, tablea and tableb tablea uid, col1, col2, col3 1, xx, xx, xx 2, xx, x... 3 Jun 2008 20:14
SELECT FOR UPDATE Hi all. Which is more efficient in order to use SELECT FOR UPDATE? %> SELECT * FROM `table` WHERE (`table_id` = 32) LIMIT 1 FOR UPDATE; %> UPDATE `table` SET `field_name` = 'Pizza' WHERE (`table_id` = 32) LIMIT 1; OR %> SELECT `field_name` FROM `table` WHERE (`table_id` = 32) LIMIT 1 FOR UPDATE; %> ... 2 Jun 2008 11:53
mssql_connect() hi, I have a problem to connect MsSQL server 2005 with mssql_connect() function. the error: fatal error undefined function mssql_connect(). I correct php.ini(unquoting php_mssql.dll) i put it in c:/windows/system32 but still i cany see mssql library in phpinfo() page. Please Help Me. ... 3 Jun 2008 20:14
Help needed PHP with Excel database Hi I am a PHP beginner and using "Namo Webeditor" trial version in order to access an Excel file via ODBC...and I get no result Namo generates the following code: ================================= <? $a_startrow = $startrow; $a_maxrows = $maxrows; require('wed_php_odbc.inc'); ?><html> <head> ... 31 May 2008 13:17
authentication verification So the user comes to the site and they're presented with a log in page. They enter they're username and password and php checks a mysql database for a matching username and password. If there is a match, it responds with 1 line found. If no match, it responds with 0 lines found. In the case of a match, php then se... 4 Jun 2008 03:22
Wrong results with ORDER BY DESC Hey all. I installed Apache and PHP onto my computer to use for testing about six days ago, and have had MySQL installed for a few weeks before. It all works fine, except for certain queries PHP gets very odd and inconsistent results back. Here's an example. This query, in both PHP and through the MySQL Query ... 4 Jun 2008 02:35
Searching shopping cart I am getting the following error when running the query through php my admin: MySQL said: Documentation #1191 - Can't find FULLTEXT index matching the column list I am new to this; Thank you for the help. Ron On Wed, 2008-05-28 at 22:01 -0400, Ron Piggott wrote: Someone referred me to: http:... 28 May 2008 22:53
Searching shopping cart Someone referred me to: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html Does this look like I am on the right track? Ron SELECT MATCH(shopping_cart_product.product_description, shopping_cart_product.product_name) AGAINST ('$keyword') as Relevance FROM ( shopping_cart_category INNER JOIN shopp... 1 Jun 2008 20:47 |