PHP - Trying To Limit Data That Comes Back From Mysql Query Into Array

Hi. I'm trying to make a sort of a forum, and this is the part of the code that needs to be changed, only I don't know how.
Code: [Select]
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name ORDER BY id DESC";
// OREDER BY id DESC is order result by descending
$result=mysql_query($sql);
?>
<table width='50%' border="0" align="center" cellpadding="3" cellspacing="1">
<?php
$limit=10;
$page=0;
$numrows = mysql_num_rows($result);
$pages = intval($numrows/$limit);
if ($numrows % $limit) {
$pages++;}
$current = ($page/$limit) + 1;
if (($pages < 1) || ($pages == 0)) {
$total = 1;}
else {
$total = $pages;}
$result = mysql_query("SELECT * FROM $tbl_name ORDER BY id DESC LIMIT $page,$limit");
while($rows=mysql_fetch_array($result)){?>
<tr><td><font size="+2"><a href="view_topic.php?id=<? echo $rows['id']; ?>"><? echo $rows['topic']; ?></a><BR></font></td>
<td width='0*'><? echo $rows['datetime']; ?></td></tr>
<tr><td><? echo substr($rows['detail'], 0, 250)."..."; ?>&nbsp;&nbsp;<a href="view_topic.php?id=<? echo $rows['id']; ?>"><? echo "Citeste mai mult";} ?></a>
</td></tr>
<tr><tr><td>
<?
if ($page != 0) { // Don't show back link if current page is first page.
$back_page = $page - $limit;
echo("<a href=\"$PHP_SELF?query=$query&page=$back_page&limit=$limit\">back</a>    \n");}
for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it.
{
 $ppage = $limit*($i - 1);
 if ($ppage == $page){
 echo("<b>$i</b>\n");} // If current page don't give link, just text.
 else{
 echo("<a href=\"$PHP_SELF?query=$query&page=$ppage&limit=$limit\">$i</a> \n");}
}
if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) { // If last page don't give next link.
$next_page = $page + $limit;
echo("    <a href=\"$PHP_SELF?query=$query&page=$next_page&limit=$limit\">next</a>");}
?>
</td></tr></tr><?php
mysql_close();
?>
</table>

I made a database with 4 fields and 11 entries. The script shows the last 10 entries just as it should, but when I click on the 'next' button, nothing happens (it should show the first entry, but it just refreshes the page, and still the last 10 entries/1st page are shown). I think it has something to do with the link, but I can't figure out what exactly.
Can someone help, or at least give me a hint? Thanks in advance. Bye.

Lets start out by saying I'm a nube to sql/php things so I am learning as I go. I try to read all that I can before I post, and only post when I cant figure it out on my own.

That being said. What I want to do in simplest terms is be able to assign a variable to each item in an sql table. So say I have an mysql table that has ID, username, fontcolor. I want to be able to pull those out so say....


while($row = mysql_fetch_array($users)) {

$username[$i] = $row[username];
$fontcolor[$i] = $row[fontcolor];
}


Then on the page I can just call to $username[1] type thing. I have tried mixing this several different ways with for and while and I keep getting errors on the page. I realize the code isn't showing everything but its just there to show you the idea of what I'm trying to do. I just want it to generate a list(array) that will make it easier for me to call back just the items I need on parts of the page with out having to have extra coding everywhere.

Thanks in advance.

Jim

So I'm querying my database to add the results (mapID's) into a PHP array.
The MySQL query I used in the below code would usually return 10 values (only 10 mapID's in the database)

Code: [Select]
while($data = mysql_fetch_array(mysql_query("SELECT mapID FROM maps"))){
$sqlsearchdata[] = $data['mapID'];
}
Instead the page takes ages to load then gives this error:
Quote

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 16 bytes)

It says the error begins on the first line of the above code. I'm assuming this is not the right way to add the value from the MySQL array into a normal PHP array.

Can anyone help me?

Hi,

I want to develop array like following

Code: [Select]
$BCD=array('type' =>'TYPE1',
    array(
        0=>array('column1'=>'value1','column2'=>'value1','column3'=>'value1','column4'=>'value1','column5'=>'value1','column6'=>'value1','column7'=>0),
1=>array('column1'=>'value1','column2'=>'value1','column3'=>'value1','column4'=>'value1','column5'=>'value1','column6'=>'value1','column7'=>0),
2=>array('column1'=>'value1','column2'=>'value1','column3'=>'value1','column4'=>'value1','column5'=>'value1','column6'=>'value1','column7'=>0),
3=>array('column1'=>'value1','column2'=>'value1','column3'=>'value1','column4'=>'value1','column5'=>'value1','column6'=>'value1','column7'=>0),
        )
    ));   
   I have written following code to achieve the same but not getting result.
   
  Code: [Select]
  $sql = "select * from tablename ";
    $result = mysql_query($sql);
    $k=0;
    while ($row = $db->mysql_fetch_array($result)) {
           // array_push($BCD['type'],$row['type']);
           
            $BCD1=array('type' =>$row['type'],
            array(
                $k=>array('column1'=>$row['column1'],'column2'=>$row['column2'],'column3'=>$row['column3'],'column4'=>$row['column4'],
'column5'=>$row['column5'],'column6'=>$row['column6'],'column7'=>$row['column7'])
            ));
            $k++;
    }

Hi and thanks for taking the time to read this and to help if you can

I have a flex app that is sending data to a php script that will then perform tasks based on the data found inthe array, my problem is that there are over 270 items in the array and I need to alter many of them BEFORE the script performs its task, what I need is a way to alter the data in the array without having to do it one at a time which I will have to do, below is some exxamples of what I am looking to do

for example the array will have data on aprox 35 colors and I need to check and these values and change them if needed, my current system is as follows

$color1 = $skin['color1'];

if (preg_match("/0x/i", $color1)) {

$color1 = str_replace("0x", "", $color1);

} else {

$color1 = str_pad(dechex($color1), 6, '0', STR_PAD_LEFT);

}

if($color1=="" || $color1=="000000"){$color1="100000";}

now currently I would have to do this individualy for $skin['color1'], $skin['color2'], $skin['color3']  etc etc so is there a way I can do it without such bloated code, for example a while or a foreach statement etc? im not great at php so I am not sure how I would go about this if its possible

another thing is that the rest of the values in the array are for image values and I need to fillter through them to find out which are the default images and which are not (no tasks are performed on default images) the following are example values from the array for the arrar item $clockface = $skin['clockface']

/home/thesite/public_html/flex_app/assets/default/clockface.png

/home/thesite/public_html/flex_app/gallery/clock/clockface_3.png

/home/thesite/public_html/flex_app/uploads/uploaded_file.jpg

now depending on the value of the array I would wat the following for the 3 values above

$clockface = ""; // if its the first value

$clockface = "/home/thesite/public_html/flex_app/gallery/clock/pack3/clockface.svg" // if its the second value

$clockface = "/home/thesite/public_html/flex_app/uploads/uploaded_file.jpg" // if its the third value

now the above is easy to do on an individual basis but I want to streamline my code and not have an if statement with str_replace etc for each and every value which means I would have to do the code over 200 times for the images

now as you can see from the first set of values there are certain things that give clues as to what and where the image is ("assests/default", "gallery/clock/clockface_3.png" and "uploads/uploaded_file.jpg") and I would use these to produce the final values above but again I would have to do it on an individual basis for each array value

so is there any way I can streamline the process with again a while or a foreach statement or another way of doing this?

your help is very much appriciated

regards

wayne