[Form Loads the Script Itself]

I don't understand your question

[paging in a comment system]

http://www.phpfreaks.com/tutorial/basic-pagination

[Mysql only getting the first record?]

I got it, thanks!

 

while($row = $db->sql_fetchrow($result))

{

var_dump($row);

 

};

[Mysql only getting the first record?]

No. You're selecting one field from each record. Each iteration of a loop over mysql_fetch_* will hold one record, with that record's selected field(s) in an array.

 

So I should loop this?

$result = $db->sql_query($sql);

[Mysql only getting the first record?]

Where's the while() loop you're using to fetch the records from the result resource?

Shouldn't both values be inside of $row though? When I use a var_dump I'm only getting one value? I tried using a foreach, and every result came out with 59.

[display random entry from database]

$sql = "SELECT * FROM table";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$rand_keys = array_rand($row, 6);

 

then loop it.

[Mysql only getting the first record?]

$sql = "SELECT poster_id from phpbb_posts WHERE topic_id = ".$topic_id." ";
$result = $db->sql_query($sql); //same as mysql_query
$row = $db->sql_fetchrow($result); // same as mysql_fetch array.
var_dump($row);

 

With this code (i commented the query function for you) im getting

array
  'poster_id' => string '59' (length=2)

 

When I run this into SQL in phpmyadmin I'm getting

59 56 //this is what I want

 

I need to get all of the records, not just the first one. I have even tried using replacing the function with mysql_query and mysql_fetch_array

any ideas? It's a bit late, so I may just be making a simple mistake.  Thanks!

[Beyond pissed]

I fixed this a few weeks ago, sorry for not letting you all know!

[include()'ed html file not displaying img's]

is somefile.html in a separate folder than index.php?

[require()]

Set a root path var. For example:

$root_path = http://www.google.com/

require($root_path  . 'anyfolder/any.php') 

[I need an alternative way to do this query]

There sure is! Here it is:

 

function totallyAwesomeFunctionForTonyhhInsertQueries($tableName, $values, $keys = array()) {
   $insert = "INSERT INTO `{$tableName}`";

   if (count($keys) > 0) {
      $insert .= "`". implode("`,`", $keys) ."`";
   }

   $insert .= " VALUES";

   foreach ($values as $key => $value) {
      $insert. = "'". implode("', '", $value) ."'";
   }

   return $insert;
}

 

And if you want to insert the same value again and again, there is another function for that!

 

function totallyAwesomeFunctionForTonyhhInsertQueryRepeat($query, $times) {
   for ($i = 0; $i < $times; $i++) {
      mysql_query($query);
   }
}

 

I tickle myself sometimes... Anyways, point is, you can make functions...

 

Well yeah, I just didn't know how to approach it, but thanks!

 

(Keeping the function name)

[I need an alternative way to do this query]

Is there a function which will allow me to throw the values into an array and post them into the DB as separate records? If so a little help would be appreciated!

if(empty($row))
	{
		//Need a better way.
		$sql = "INSERT INTO phpbb_user_items
		VALUES
		(13, '$user_id', '0'),
		(12, '$user_id', '0'),
		(11, '$user_id', '0'),
		(9, '$user_id', '0'),
		(27, '$user_id', '0'),
		(15, '$user_id', '0'),
		(16, '$user_id', '0'),
		(22, '$user_id', '0'),
		(21, '$user_id', '0'),
		(23, '$user_id', '0'),
		(24, '$user_id', '0'),
		(26, '$user_id', '0'),
		(29, '$user_id', '0'),
		(30, '$user_id', '0'),
		(31, '$user_id', '0'),
		(32, '$user_id', '0'),
		(33, '$user_id', '0')
		";
		$result = $db->sql_query($sql);
	}

[Popup box for mysql query]

It would be an ajax call. You'd have javascript talk to a php file which would check that specific table to see if it's been updated. Afterwards, you'd display a message saying that it has been updated, or display the information that was inserted/updated with ajax.

 

http://api.jquery.com/jQuery.ajax/

[function in a mysql array. doh!]

Where's your mysql connection?

[Attach Jquery slider to refresh script]

Just throw a variable into the slider and in the interval?

 

 

var refreshId = setInterval(function() {

      $("#container").load('stats.php');

  },time);

 

(I didnt download the slider or anything, so bare with me..)

time = 800;

[No matter what I do image stays black (GD) help!]

The image is showing up fine, but when i does, its black. It's suppose to just be a transparent square.

[No matter what I do image stays black (GD) help!]

function buildAvatar(array $imgArray = array())

{

$img1 = imagecreatefrompng($phpbb_root_path.'images/spacer.png');

foreach($imgArray as $img)

{

$img2 = imagecreatefrompng($phpbb_root_path.'avatars/equip_img/'.$img);

$this->imagecopymerge_alpha($img1, $img2, 0, 0, 0, 0, 210, 300, 100);

}

imagealphablending($img1, false);

imagesavealpha($img1, true);

return $img1;

}

 

The background of my PNG was transparent, I don't know what I did, but it's now black! I'm thinking it's the image! Not the code, this same code worked before, and I've tried tons of different ways of fixing it. How should I save the image to work correctly?

[Beyond pissed]

My site has had all of it's tables dropped TWICE I CAN'T FIND THE INJECTION, can anyone help?

 

http://www.threechan.org/e/

 

http://www.threechan.org/e/phpfreaks.txt

 

please, someone help

[Any help with this preg_replace?]

I'm trying to alow users to reference links, but I'm stumped.

 

$com = preg_replace("/(^|<<)(<<[^<]*[0-9])/", "\\1<a href = #".$com.">#$com</a>\\2</div>", $com);

 

If I typed <<#123 I would get:

#<<123<<123

 

and it would link to <<123

 

The output I'm looking for is

 

<<#123

 

and have it link to

#123

[first site]

Thanks guys.

[What is this called? Or how is it done?]

Script for web page:

 

		<script type="text/javascript">

		function Ajax()
		{
			var
				$http,
				$self = arguments.callee;

			if (window.XMLHttpRequest) {
				$http = new XMLHttpRequest();
			} else if (window.ActiveXObject) {
				try {
					$http = new ActiveXObject('Msxml2.XMLHTTP');
				} catch(e) {
					$http = new ActiveXObject('Microsoft.XMLHTTP');
				}
			}

			if ($http) {
				$http.onreadystatechange = function()
				{
					if (/4|^complete$/.test($http.readyState)) {
						document.getElementById('ReloadThis').innerHTML = $http.responseText;
					        setTimeout(function(){$self();}, 6000)	
					}
				};
				$http.open('GET', 'random.php' + '?' + new Date().getTime(), true);
				$http.send(null);
			}

		}

	</script>

 

Also include this in the 'body' which is the additional loader before the above takes effect.

 

		<script type="text/javascript"> //ADDITIONAL LOADER BEFORE ABOVE LOADER CURRENTLY AT 6000.
		setTimeout(function() {Ajax();}, 1000);
	</script>

 

then add random.php and add the code you want it to load.

 

Thanks! Really appreciate it.

[What is this called? Or how is it done?]

Use Ajax. Keep the header on your web page, then insert the ajax DIV below, and in the loader file, place a header redirect.

 

If you want code let me know.

 

Hey sounds good! And yeah, an example would be fabulous!!

[first site]

My first time writing HTML and CSS from scratch i usually use a free template but i got bored a decided to try it myself, what do you guys think? most link will be broken.

 

concido.tk

[What is this called? Or how is it done?]

Sorry meant to edit not quote..

[What is this called? Or how is it done?]

It's a little difficult for me to explain but, when a website loads another site (For example with Curl or something) How is the site able to keep a header or some part of original site 'attached' to the site they loaded..for example, say you're redirected, the site you redirected to loads, but you still see the site you redirected from header on at the top of the page. How is this done? What is it called? Do you need me to clear it up a bit better? I can try to find an example.