[PHP-DB] php-db-unsubscr...@lists.php.net

php-db-unsubscr...@lists.php.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Slooooow query in MySQL.

Seeing the query would help. Are you using sub-queries? I believe that those can make the time go up exponentially. -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada College www.wnc.edu 775-445-3326 P.S. Please note that my e-mail and website address have changed

[PHP-DB] First and Last ID of a table

mytable ORDER BY id DESC LIMIT 1; $last_result = mysql_query($last_query,$con); $last_id = mysql_result($last_result,0,'id'); I'm just wondering if there was any way to do this more efficiently, like with one query instead of two. Or is this about as simple as I can do it? Thanks. -- Kevin

Re: [PHP-DB] error logging MySQL syntax errors?

put: echo mysql_error(); right after the sql query. -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326 On Apr 27, 2007, at 10:15 AM, Tim McGeary wrote: I am getting semi-ambiguous messages in the browser like: You

Re: [PHP-DB] Order By [blank]

Unfortunately, I'm on 4.0.x so sub-queries are out. And yeah, I should get my host to upgrade but we both work for the government so that isn't happening. ;-) Any other thoughts. -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu

Re: [PHP-DB] Order By [blank]

for your help. -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326 On Dec 21, 2006, at 10:12 AM, [EMAIL PROTECTED] tg- [EMAIL PROTECTED] wrote: You shouldn't have to do that. the IFNULL() handles all that. If the item is null

Re: [PHP-DB] Special Character

,$replacements,$data); $data = trim($data); $data = preg_replace(/ +/, , $data); $data = addslashes($data); return $data; } -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326 On Nov 16, 2006, at 7

[PHP-DB] Distinct Partial Matches: RegExp

'anynumberofletters dash anynumberofletters dash ' Of course, I could be barking up the wrong tree with the REGEXP thing. Anyone care to point me in the right direction? -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326 -- Kevin

Re: [PHP-DB] Distinct Partial Matches: RegExp

Well, its not really a search that would be way easier. :-) What I'm looking for is a query that will give me the complete list of items that are distinct, minus the last number after the last hyphen. animal-dog animal-cat animal-bird -- Kevin Murphy Webmaster: Information and Marketing

[PHP-DB] In_Array in Query

was hoping not to do something like the following: $query = select id from table where row = $user_area[0] OR row = $user_area[1] OR row = $user_area[2] -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326

Re: [PHP-DB] Count Many Records

(data1,Form Name,link.php); -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326 On Jun 28, 2006, at 5:39 PM, Chris wrote: Kevin Murphy wrote: Actually the design is in the code below I need to display the counts from

[PHP-DB] Count Many Records

($data2h_results); echo tr; echo td align=\center\ valign=\top\$data2_count/td; echo td align=\center\ valign=\top\$data2h_count/td; echo td align=\center\ valign=\top\$data2p_count/td; echo /tr; -- Kevin Murphy Webmaster: Information and Marketing

Re: [PHP-DB] Count Many Records

in data1, You have $data1p_count PROCESSED records in data1, etc. -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326 On Jun 28, 2006, at 1:56 PM, [EMAIL PROTECTED] wrote: Kevin Murphy asks: The following code works