I would use ajax for that. You can even ajax two different files, one with a setTimeout() that will time the query and the other with be the actual query. When the ajax responds you just use the same div field with innerHTML so that you can display the option of using a different search method before the query is finished and when the query finishes, you just override the innerHTML with the query results.
Otherwise this is going...
w0rKInPHP
Last Activity: Mar 28 '08, 06:26 PM
Joined: Oct 26 '07
Location: Phoenix
-
So something is going on between the php source and the database. My first suggestion would be to output the query without posting to the database, copy it from the page and then paste it into the database. My guess is that maybe something like single quotes are not being escaped correctly or maybe some are missing. But you want to output the sql exactly as it is being passed to the database like
...Code:$sql='INSERT INTO problems (Issue_key,
Leave a comment:
-
I don't use access too often but the last half of your query (SELECT "Issue ID 1" AS Issue_Key, "steve" AS user, "7777" AS phone, "test information" AS issue, "10/30/2007" AS Issue_Date) looks incomplete. Select from what table?Leave a comment:
-
actually, the size of one table should not bog down the whole database. The only time that it will bog down is when you are doing some type of search function which includes that table. If the size of one table does bog down the entire database you have a couple of options. one, use two different databases, one for log data, if you have that much to log that it would be worth it. or two (which is what I would do) is get a different type of database...Leave a comment:
-
[CODE=php]//sql?
<?php
$query = "select pk from tablename where email = 'emailaddress'" ;
$result = pg_query($query ); //mysql_query() for mysql
$total = pg_num_rows($re sult); //mysql_num_rows( ) for mysql
if($total == 0)
{
//code goes here.
}
?>
//array?
foreach($emaila rray as $email)
{
if(strcasecmp($ email, $otheremail)...Leave a comment:
-
do it this way and it will work
and fix your $values variable, which if you do it this way, you won't need to trim it because the explode is taking consideration of the white space.Code:list($field, $value) = explode(" = ", str_replace(";", "", $line));Leave a comment:
No activity results to display
Leave a comment: