Last PHP Question - I promise

noswad · 05-27-2006, 03:34 PM

Hi.

I have one last final problem with PHP sessions.

Please take a look at the attached small screen shot. Each session is called [game1] all the way down to game20]

If the database is full for all sessions except [game8] users will see a blank line where [game8] should be.

Is there anyway to move [game9] up one line to prevent the blank space?

Also, as a rule of thumb, I would need such a script to ignore any blank sessions and move all the full lines towards the top.

Thanks VERY much for reading. I promise this is my last question

????: NamePros.com http://www.namepros.com/programming/201760-last-php-question-i-promise.html

David.

Kadenz · 05-27-2006, 03:56 PM

You Should probalbly use this instead:

Code:

$detect = mysql_query("select `field` from `table` LIMIT 0, 20");
while ($row = mysql_fetch_array($detect, MYSQL_BOTH)) {
   printf("%s", $row[0]); 
}

or at least this is what I think you're trying to do.

noswad · 05-27-2006, 04:29 PM

Hi

You have confused me there lol.

Im just looking for a simple script that will ignore blank fields and move the next field containing data upwards to prevent users seeing blank lines on pages.

Thanks for trying though.

Dan · 05-27-2006, 04:38 PM

PHP Code:

  for ($i = 1; $i <= 20; $i++) {

????: NamePros.com http://www.namepros.com/showthread.php?t=201760
  if ($_SESSION['game'.$i]) {

    echo $_SESSION['game'.$i];

}

Displays the game if it is not blank.

noswad · 05-27-2006, 04:48 PM

Hi Dan

The page is displaying...

"Parse error: parse error, unexpected $ in /homepages/33/d149588437/htdocs/test.php on line 16"

Thanks for trying

xemiterx · 05-27-2006, 06:16 PM

with one more } at the end of the code from Dan it should work.

05-27-2006, 03:56 PM	#2 (permalink)
Kadenz Resistance is Futile Join Date: Apr 2006 Location: Montreal, Canada Posts: 1,094 Follow @MitchellBundy	You Should probalbly use this instead: Code: $detect = mysql_query("select `field` from `table` LIMIT 0, 20"); while ($row = mysql_fetch_array($detect, MYSQL_BOTH)) { printf("%s", $row[0]); } or at least this is what I think you're trying to do. __________________ Freelance Web Developer PHP, MySQL, XHTML, CSS, Javascript, jQuery, Wordpress Portfolio: www.bundy.ca

05-27-2006, 04:29 PM	THREAD STARTER #3 (permalink)
noswad NamePros Regular Join Date: Aug 2005 Location: Leeds, UK Posts: 263	Hi You have confused me there lol. Im just looking for a simple script that will ignore blank fields and move the next field containing data upwards to prevent users seeing blank lines on pages. Thanks for trying though. __________________ Michael McIntyre - Fan site for the super funny UK comedian Michael McIntyre

05-27-2006, 04:38 PM	#4 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,792	PHP Code: `for ($i = 1; $i <= 20; $i++) { ????: NamePros.com http://www.namepros.com/showthread.php?t=201760 if ($_SESSION['game'.$i]) { echo $_SESSION['game'.$i]; }` Displays the game if it is not blank.

05-27-2006, 04:48 PM	THREAD STARTER #5 (permalink)
noswad NamePros Regular Join Date: Aug 2005 Location: Leeds, UK Posts: 263	Hi Dan The page is displaying... "Parse error: parse error, unexpected $ in /homepages/33/d149588437/htdocs/test.php on line 16" Thanks for trying __________________ Michael McIntyre - Fan site for the super funny UK comedian Michael McIntyre

05-27-2006, 06:16 PM	#6 (permalink)
xemiterx NamePros Member Join Date: Dec 2003 Location: Oregon Posts: 110	with one more } at the end of the code from Dan it should work. __________________ Play Pac Man Boxhead Rooms Boxhead 2 Futoshiki Thing Thing 3

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)