PHP - Double Metaphone Character Limit?

im using the floowing code to pull all alerts from the database. as you can see i have 3 types of alertsd. Profile alerts, forum alerts and topic alerts. They are sorted and placed on the screen under their respective header. However i want to limit it so it only displays 4 of each type of alert. I cant use LIMIT in the query because that would limit all alerts meaning only 4 alerts in total would show up and i just need to limit each alert type. any ideas?


$alert_query = $link->query("SELECT 
                            a.a_aid, a.a_alert_type, a.a_time_alerted, 
                            a.a_fid, a.a_poster, a_alert_read,
                            a.a_tid, c.f_name as cat_name,
                            f.f_fid, f.f_name,
                            t.t_name,
                            u.u_avatar, u.u_avatar_cropped
                            FROM ".TBL_PREFIX."alerts as a
                            LEFT JOIN ".TBL_PREFIX."forums as f
                            ON (f.f_fid = a.a_fid)
                            LEFT JOIN ".TBL_PREFIX."topics as t
                            ON (t.t_tid = a.a_tid)
                            LEFT JOIN ".TBL_PREFIX."forums as c
                            ON (c.f_fid = f.p_id) 
                            LEFT JOIN ".TBL_PREFIX."users as u
                            ON (u.u_username = a.a_poster)
                            WHERE a.a_user_name = '$user_name'
                            ORDER BY a_time_alerted
                            ") or die(print_link_error());
        $alert_info = $alert_query->fetchAll();
        
        $pm_alert_list = '';
        $num_pm_alerts = 0;
        $num_forum_alerts = 0;
        $num_topic_alerts = 0;
        
        foreach($alert_info as $key => $val)
        {
            $alert_info[$key]['a_alert_read'] == 0 ? $color = '#f5dfaf' : $color = '#f4f4f4';
            
            // if alert is a profile message alert
            if($alert_info[$key]['a_alert_type'] == 1)
            {    
                $pm_alert_list .= '<dd style="background:'.$color.';" class="alert" id="alert-'.$alert_info[$key]['a_aid'].'"><p class="alert_intro">';
                $pm_alert_list .= '<input type="checkbox" class="pm_checkbox" id="pm_checkbox-'.$alert_info[$key]['a_aid'].'" />'.profile_link($alert_info[$key]['a_poster']).' posted on your wall</p>';
                $pm_alert_list .= '<p class="alert_time"> on '.asf_date($alert_info[$key]['a_time_alerted'],'full').'</p>';
                $pm_alert_list .= '</dd>';
                $num_pm_alerts++;
            }
            
            if($alert_info[$key]['a_alert_type'] == 2)
            {    
                $forum_alert_list .= '<dd style="background:'.$color.';" class="alert" id="alert-'.$alert_info[$key]['a_aid'].'"><p class="alert_intro">';
                $forum_alert_list .= '<input type="checkbox" class="pm_checkbox" id="pm_checkbox-'.$alert_info[$key]['a_aid'].'" /><strong><a href="'.$config['asf_root'].'category/'.create_url($alert_info[$key]['cat_name']).'/forum/'.create_url($alert_info[$key]['f_name']).'">'.$alert_info[$key]['f_name'].'</a></strong> has a new topic</p>';
                $forum_alert_list .= '<p class="alert_time"> '.asf_date($alert_info[$key]['a_time_alerted'],'full').'</p>';
                $forum_alert_list .= '</dd>';
                $num_forum_alerts++;
            }
            
            if($alert_info[$key]['a_alert_type'] == 3)
            {    
                $topic_alert_list .= '<dd style="background:'.$color.';" class="alert" id="alert-'.$alert_info[$key]['a_aid'].'"><p class="alert_intro">';
                $topic_alert_list .= '<input type="checkbox" class="pm_checkbox" id="pm_checkbox-'.$alert_info[$key]['a_aid'].'" /><strong><a href="'.$config['asf_root'].'category/'.create_url($alert_info[$key]['cat_name']).'/forum/'.create_url($alert_info[$key]['f_name']).'/topic/'.create_url($alert_info[$key]['t_name']).'">'.$alert_info[$key]['t_name'].'</a></strong> has a new post</p>';
                $topic_alert_list .= '<p class="alert_time"> '.asf_date($alert_info[$key]['a_time_alerted'],'full').'</p>';
                $topic_alert_list .= '</dd>';
                $num_topic_alerts++;
            }
        }

Hello friends,

if i've database table (mytable) has the following ids
1
2
3
4
5
6

and i want to get it with limit the first (1 to 3 ) only

Code: [Select]
$sql ="select *  from  mytable LIMIT 3"; this will show the first 3 (1,2,3)

how then i write code that shows which is after 3
so it shows me
4
5
6

and if there any way i can say
Code: [Select]
$sql ="select *  from  mytable LIMIT (first half of ids)"; and (shows 1,2,3..ect till half)
Code: [Select]
$sql ="select *  from  mytable LIMIT (second half of ids)";
will (shows 4,5,6...ect till end)

 
thank you

please help me with this.since i started posting this form to its self it has been inserting values twice into the database when the user clicks submit button and i also noticed that i have to refresh the page before inserted comments can be showed.this is my code: Code: [Select]
<?php
                                 include"header.php";
                                  $sql="SELECT post_content,post_by FROM post WHERE topicsID='$tpid'";
                            $result=mysql_query($sql)or die(mysql_error());
                                while($row=mysql_fetch_array($result))
                             {

                               echo"<strong>{$row['post_by']}</strong>:  {$row['post_content']}"."</br>";
                             }
                                         ?></td>

</tr>
</table>
<?php
include"header.php";
if(isset($_POST['submit']))
{
$comment=mysql_real_escape_string(trim($_POST['comment']));
$name=mysql_real_escape_string(trim($_POST['name']));
$hidden=$_POST['id'];
if($comment!=='' && $name!=='')
{
$topicid=$_GET['id'];
$ins="INSERT INTO post(post_content,post_by,post_id)VALUES('$comment','$name','$topicid')";
mysql_query($ins) or die(mysql_error());
}
else
{
echo"you cannot post an empty field";
}
}


?>
<h3>Post your comments here</h3>
<form action=''method='post'>
<textarea name="comment" id="content" style="width:400px;height:50px;background-color:#D0F18F;color:#000000;font:15px/20px cursive;scrollbar-base-color:#638E0D;"></textarea>
<br />
Name:<input type="text"name="name"/>
<input class="button" type="submit"name="submit"value="submit" />

</p>
</form>

Why is double spacing the results I know it's stupid simple but I can't see it. I removed $host ip so if you test put one in there.

<!doctype html>

<html lang="en">
<html>
<body>
<?php
ini_set('max_execution_time', 0);
ini_set('memory_limit', -1);
$host = "insert IP";
$ports = array(21 ,22 ,23 ,25, 80, 81, 110, 143, 443, 587, 2525, 3306);
foreach ($ports as $port)
{
    $connection = @fsockopen($host, $port, $errno, $errstr, 2);
    if (is_resource($connection))
    {
        echo '<p>' . $host . ':' . $port . ' ' . '(' . getservbyport($port, 'tcp') . ') is open.</p>';
        fclose($connection);
    }
    else
    {
        echo '<p>' . $host . ':' . $port . ' is not Open.</p>';
    }
}

?>

    </body>
</html>

 

sorry, I posted twice.

This is strange.. I have the following code that checks if there is currently a cap set on requests.

Code: [Select]
$result = mysql_query("SELECT cap FROM requests");
while($data = mysql_fetch_array($result))
{
if ($data['cap'] == '1') {
echo"<h1>Requests are currently disabled at this time.</h1>";
}else{
echo'<h1><a href="requestlivery.php">Request Livery</a> | <a href="requestlogo.php">Request Logo</a></h1>';
}
}
For some reason, this: <h1><a href="requestlivery.php">Request Livery</a> | <a href="requestlogo.php">Request Logo</a></h1> is printed out twice on the webpage. Like:

Request Livery | Request LogoRequest Livery | Request Logo

I even put that code on a brand new blank page, and it does the same thing. Any ideas as to why would it do that?

Unk

Can someone please tell me what i have got wrong here?

I am trying to return value C if conditions a AND B are met or return value D.  Not sure if its parenthesis or something else?

<?php if (($row_Recordset4['multidirection']=="yes") &&
($_POST["widthcheck"] < $row_Recordset4['drop'])) echo $row_Recordset4['width'];else echo $row_Recordset4['drop'] ?>

Thanks

Hey guys i need to generate a table for a multilevel marketing simulation of 10.000 members. It's a bi-level.

All i need is a table with id, parrent

I am lost with the double loop ...

if u use this for one condition

if ($nr > 5)

how would u check if the nr is between 5 and 50

thanks !

I know via firebug that the correct parameters were passed to my process page and the parameter being passed that in caused issues on the process page is $characterIDList. What's causing the issue is that its not inserting the value into the insert query. The rest of the insert query works fine.

process page


$characterIDs = explode(',', $_POST['characterIDList']); 
    foreach($characterIDs as $itm){
         $id = (int)$itm;
     }
    $defaultcharid = (int)$characterIDs[0];

$query = "INSERT INTO `handlers` (username, password, firstname, lastname, email, status_id, isadmin, default_character_id, creator_id, datecreated) VALUES ('$username','$password','$firstname','$lastname','$email','$status','$admin', '$defaultcharid', 1, NOW())";

Is there a limit to how many items can be stored in an array?

My code looks in a directory of photos and writes the file names into the one-dimensional array.

I just switched from my test folder to my actual photo folder - about 600 photos - and when I ran my script with var_dump enabled, my array only goes up to 128 items (0-127).

I sure hope arrays aren't that wimpy?!

Each photo is about 1-2MB in size, but since I am only storing the file name, I would expect that I could easily store thousands of elements in this array.

What is going on?

 

hello, is there a wat to limit the following to only the first 25 characters?

$customername=$row1["customer"];

thanks

Alright so I have some code for pagination... the problem is on the middle pages it will display double the number of results... (IE if its supposed to display 5, it displays 10)

Code: [Select]
// Number of messages per page:
$user_message_number = 5;

$page = $_GET['page'];
if($page <= 1){
$low = 0;
$high = $user_message_number;
} else {
$low = ($page - 1) * $user_message_number;
$high = $page * $user_message_number;
}

$messages = mysql_query("SELECT * FROM messages WHERE recipient='$user_id' ORDER BY id DESC LIMIT $low, $high") or die(mysql_error());
while($pull_messages = mysql_fetch_array($messages)) {
// Displays content
}

That's all of the code that would directly effect the outcome... Any thoughts/comments/suggestions are greatly appreciated.

Hi,

I have a timestamp mysql field that I'm trying to see if something happened within a time limit. The field is updated with the time when the action is complete so I just need to figure out how to see if it's within a time. I currently have a defined variable set titled "MAX_RESPONSE_TIME" and that's in seconds. By default "MAX_RESPONSE_TIME" is equal to 300 seconds. How can I see if a mysql timestamp field is within 300 seconds?

Im wondering if someone can shed some light on possibly the best way to do this.
I currently have a website which recieves 26000-37000 visits a month. The host got on my case about to many MySql connections and with help from someone here decided a cache system was best. the cache system is now in place and only updates if the cached file is older than 5 days. I am still recieving high connections to my database and wonder if it is spam as i have a search box. the search box once filled in redirects to a page which queries the database for the keyword and displays results and because it was just selecting and not inserting into database i didnt go for the captcha. this is why i suspect spam, I have thought about limiting the amount of search queries per time limit by ip but I am unsure of how to tackle this and if it will help against spam bots?

a google search has only found an answer which stores every visitors ip in a database and keeps count there which I cant see the benefit as it is creating more work for the DB. I have thought maybe creating a session variable that increments with every search and when searching checks this value but I am not to sure if this would help as it would be down to cookie settings.

can anyone shed some light on a possible solution to this.

I am not expecting you to write this for me but for now just to help with the best way to tackle the problem.

Thank you for your time.