Can anyone help me please? :]

Marty Rogers · 12-18-2006, 01:50 PM

Hi,

I was wondering if somebody would be able to help me. I want to have a page on my website where i can see all layouts that have been submitted to my database that have a status set as inactive. I know how to output those but i just need a tick box or button/link to delete a layout row from the database (if i dont want to add it to my website) and a tick box or button/link to change the status from inactive to active (if i want to add it to my website).

Thanks in advance!

UPDATE!!!!

Okay, i've done the delete row and edit status links but i've realised it's crap LOL. Each time i add a row to my database it automatically adds an id, which is a number going up in order. Im upto 330 layouts now, i just added a test layout with an id of 331 and deleted with the function i just created (that i asked for help with above) so it deletes the row but then when i add another row it adds an id of 332, but i'd like it to use 331 again (if the row doesn't exist for the id) - anyone know what i could do here?

TwistMyArm · 12-18-2006, 02:45 PM

It's not a great idea to start reusing IDs... it kind of defeats to purpose and I don't know of any easy way to do it other than to grab all of the IDs and iterate through them until you possibly find an unused one.

But again: don't do it

Cybo · 12-18-2006, 03:58 PM

Quote:

Originally Posted by Fun4Free.co.uk

Hi,

I was wondering if somebody would be able to help me. I want to have a page on my website where i can see all layouts that have been submitted to my database that have a status set as inactive. I know how to output those but i just need a tick box or button/link to delete a layout row from the database (if i dont want to add it to my website) and a tick box or button/link to change the status from inactive to active (if i want to add it to my website).

Thanks in advance!

UPDATE!!!!

Okay, i've done the delete row and edit status links but i've realised it's crap LOL. Each time i add a row to my database it automatically adds an id, which is a number going up in order. Im upto 330 layouts now, i just added a test layout with an id of 331 and deleted with the function i just created (that i asked for help with above) so it deletes the row but then when i add another row it adds an id of 332, but i'd like it to use 331 again (if the row doesn't exist for the id) - anyone know what i could do here?

The only way to do something like that is to use manual submition on the id's, not automatic. Which means defining an ID each time you insert a row.

EDIT:

On a better note; i'll explain it a bit more, my post above sounds a little odd :P

You would need to do the following steps:

1) Turn off "auto_increment" for "id"
2) Rebuild the database

Then when you isert a row, you would need to do the following:

PHP Code:

  $result = mysql_query ("SELECT * FROM table");

$total_rows = mysql_num_rows($result);

$counter1 = 0;

$freespaces = 0;

$last_id = 0;

$free = array();

while ($row = mysql_fetch_assoc($results))

{

      $counter1 += 1;

      if ($last_id != $counter1 - 1)

      {

            // We have found a free space

            $free[$freespaces] = $row['id'] - 1;

            $freespaces += 1;

      }

      $last_id = $row['id'];

}

// $free[0] is the id of the first free space

if ($freespaces == 0)

{

      // No free spaces? Move to the next in the list.

      $nextspace = $total_rows + 1;

}

else

{

      // A Free Space was found

      $nextspace = $free[0];

}

 
// Make the new ID = $nextspace

Hope this helps

- Richard Anderson

beaver6813 · 12-19-2006, 12:02 AM

Although considering all the code needed to do that, you might be better off just letting it auto-increment. And then sort out the numbers in your site's interface... Why do you need to get the id's in order so much?

Marty Rogers · 12-19-2006, 01:45 AM

Thanks alot cybo

Im just fussy, i guess i don't really need it lol. Hmm i think i will leave it then instead of making more work for myself when it's not needed =P.

I have another question if any of you are up for helping me? this question is about my new website BangVideoBang and i want to add tags for videos i put up on the site now, view this video for example:

http://www.bangvideobang.com/videos/...e-session.html

I have added some tags for it, is there anyway that i could make each tag goto something like this:

http://www.bangvideobang.com/videos/tags.php?tag=bmx
http://www.bangvideobang.com/videos/...tag=dave+mirra
http://www.bangvideobang.com/videos/...?tag=back+flip
http://www.bangvideobang.com/videos/...?tag=warehouse

(i haven't added tags.php yet so the links above won't work)

Those are the tags i have added for that video, i want it so a visitor can click any of the tags and then it will go off and get all the videos with that tag in it.

Anyone know how i could do this? Im new with php and mysql so i don't know much.

Thanks alot.

Cybo · 12-19-2006, 01:53 AM

Fun4Free,

Are these tags stored in your database? If they are would be be able to share the layout of the database and I will knock you up a script, the PHP anyway :P, your need to do the HTML.

Marty Rogers · 12-19-2006, 02:04 AM

Yeh they are. what do you mean the layout of the database? (sorry lol) Is it the structure?

Click Here: http://img246.imageshack.us/img246/884/structurepe0.png

I bet it's all wrong heh lol. I use name for the tags. Gotta sort those field names out at some point.

Cybo · 12-19-2006, 02:06 AM

Yeah, thats what I need. Which one are the tags stored in? And how are the tags stored? (EG; Are the separated with a space, ect?)

Marty Rogers · 12-19-2006, 02:09 AM

I put the tags in the 'name' row. I have them with a comma and then a space. should i just do a comma and no space or is that okay?

Like this: live bands, hanging, cute, music, warped tour

Cybo · 12-19-2006, 02:12 AM

Quote:

Originally Posted by Fun4Free.co.uk

I put the tags in the 'name' row. I have them with a comma and then a space. should i just do a comma and no space or is that okay?

Like this: live bands, hanging, cute, music, warped tour

Nah, that's all fine. Let me knock something up for you and I will post again in this thread so you know i've posted it

I wont do the html, but I will put where you need to put it :P Give me a little while

Marty Rogers · 12-19-2006, 02:15 AM

Thanks alot mate, im well happy lol

Cybo · 12-19-2006, 02:35 AM

tags.php

PHP Code:

  <?php

// Connect to the database here.

 
 
if (!isset($_GET['tags']))

{

      // No tags sent... Change the below:

      header("Location: http://yoursite.com/index.php");

}

// Get the tags

$rawtagdata = $_GET['tags'];

 
// Explode the raw data

$tags = explode("+", $rawtagdata);

 
$sql = "SELECT * FROM thetable WHERE name LIKE '%" . $tags[0] . "%'";

$counter1 = 1;

$loop1done = false;

 
while ($loop1done = false)

{

      if (!isset($tags[$counter1]))

      {

            $loop1done = true;

      }

      else

      {

            $sql .= " OR name LIKE '%" . $tags[$counter1] . "%'";

            $counter1 += 1;

      }

}

$results = mysql_query($sql);

Again, hope it helps :P

Marty Rogers · 12-19-2006, 02:47 AM

Thanks for your help cybo but i didn't explain what i needed properly =P

I know how to do the tags.php page to output the video listings for the selected tags. I just don't know how to change the actual tags on the video pages into links, so that a visitor can click on the tag which goes to tags.php?tag=blah. I add the tags to the database as 'tag, tag tag, taggy, tagoo' etc lol. I could add them as links directly into the database but i was just wondering if there is a small php code that would make all the tags that are outputted display as links instead of just text as you see on:

http://www.bangvideobang.com/videos/...out-the-e.html

under video information.

Thanks alot though mate, reallly appreciate it

UPDATE!!!

I've added the tag links now, have a look:

http://www.bangvideobang.com/videos/...out-the-e.html

12-18-2006, 01:50 PM	#1 (permalink)
Marty Rogers Account Closed Join Date: Apr 2006 Location: England, UK Posts: 494 2.00 NP$ (Donate)	Can anyone help me please? :] Hi, I was wondering if somebody would be able to help me. I want to have a page on my website where i can see all layouts that have been submitted to my database that have a status set as inactive. I know how to output those but i just need a tick box or button/link to delete a layout row from the database (if i dont want to add it to my website) and a tick box or button/link to change the status from inactive to active (if i want to add it to my website). Thanks in advance! UPDATE!!!! Okay, i've done the delete row and edit status links but i've realised it's crap LOL. Each time i add a row to my database it automatically adds an id, which is a number going up in order. Im upto 330 layouts now, i just added a test layout with an id of 331 and deleted with the function i just created (that i asked for help with above) so it deletes the row but then when i add another row it adds an id of 332, but i'd like it to use 331 again (if the row doesn't exist for the id) - anyone know what i could do here? Last edited by Fun4Free.co.uk; 12-18-2006 at 02:22 PM.

12-18-2006, 02:45 PM	#2 (permalink)
TwistMyArm NamePros Member Join Date: May 2006 Posts: 160 81.00 NP$ (Donate)	It's not a great idea to start reusing IDs... it kind of defeats to purpose and I don't know of any easy way to do it other than to grab all of the IDs and iterate through them until you possibly find an unused one. But again: don't do it __________________ Free Fuel Efficiency Calculator \| CMS Book Store

12-19-2006, 12:02 AM	#4 (permalink)
beaver6813 NamePros Regular Join Date: May 2005 Location: England Posts: 349 65.50 NP$ (Donate)	Although considering all the code needed to do that, you might be better off just letting it auto-increment. And then sort out the numbers in your site's interface... Why do you need to get the id's in order so much? __________________ -Beaver6813.com V5 Soon!

12-19-2006, 02:35 AM	#12 (permalink)
Cybo NamePros Member Join Date: Nov 2006 Posts: 57 388.25 NP$ (Donate)	tags.php PHP Code: <?php // Connect to the database here. if (!isset($_GET['tags'])) { // No tags sent... Change the below: header("Location: http://yoursite.com/index.php"); } // Get the tags $rawtagdata = $_GET['tags']; // Explode the raw data $tags = explode("+", $rawtagdata); $sql = "SELECT * FROM thetable WHERE name LIKE '%" . $tags[0] . "%'"; $counter1 = 1; $loop1done = false; while ($loop1done = false) { if (!isset($tags[$counter1])) { $loop1done = true; } else { $sql .= " OR name LIKE '%" . $tags[$counter1] . "%'"; $counter1 += 1; } } $results = mysql_query($sql); Again, hope it helps :P

12-19-2006, 01:45 AM	#5 (permalink)
Marty Rogers Account Closed Join Date: Apr 2006 Location: England, UK Posts: 494 2.00 NP$ (Donate)	Thanks alot cybo Im just fussy, i guess i don't really need it lol. Hmm i think i will leave it then instead of making more work for myself when it's not needed =P. I have another question if any of you are up for helping me? this question is about my new website BangVideoBang and i want to add tags for videos i put up on the site now, view this video for example: http://www.bangvideobang.com/videos/...e-session.html I have added some tags for it, is there anyway that i could make each tag goto something like this: http://www.bangvideobang.com/videos/tags.php?tag=bmx http://www.bangvideobang.com/videos/...tag=dave+mirra http://www.bangvideobang.com/videos/...?tag=back+flip http://www.bangvideobang.com/videos/...?tag=warehouse (i haven't added tags.php yet so the links above won't work) Those are the tags i have added for that video, i want it so a visitor can click any of the tags and then it will go off and get all the videos with that tag in it. Anyone know how i could do this? Im new with php and mysql so i don't know much. Thanks alot.

12-19-2006, 01:53 AM	#6 (permalink)
Cybo NamePros Member Join Date: Nov 2006 Posts: 57 388.25 NP$ (Donate)	Fun4Free, Are these tags stored in your database? If they are would be be able to share the layout of the database and I will knock you up a script, the PHP anyway :P, your need to do the HTML.

12-19-2006, 02:04 AM	#7 (permalink)
Marty Rogers Account Closed Join Date: Apr 2006 Location: England, UK Posts: 494 2.00 NP$ (Donate)	Yeh they are. what do you mean the layout of the database? (sorry lol) Is it the structure? Click Here: http://img246.imageshack.us/img246/884/structurepe0.png I bet it's all wrong heh lol. I use name for the tags. Gotta sort those field names out at some point.

12-19-2006, 02:06 AM	#8 (permalink)
Cybo NamePros Member Join Date: Nov 2006 Posts: 57 388.25 NP$ (Donate)	Yeah, thats what I need. Which one are the tags stored in? And how are the tags stored? (EG; Are the separated with a space, ect?)

12-19-2006, 02:09 AM	#9 (permalink)
Marty Rogers Account Closed Join Date: Apr 2006 Location: England, UK Posts: 494 2.00 NP$ (Donate)	I put the tags in the 'name' row. I have them with a comma and then a space. should i just do a comma and no space or is that okay? Like this: live bands, hanging, cute, music, warped tour

12-19-2006, 02:15 AM	#11 (permalink)
Marty Rogers Account Closed Join Date: Apr 2006 Location: England, UK Posts: 494 2.00 NP$ (Donate)	Thanks alot mate, im well happy lol

12-19-2006, 02:47 AM	#13 (permalink)
Marty Rogers Account Closed Join Date: Apr 2006 Location: England, UK Posts: 494 2.00 NP$ (Donate)	Thanks for your help cybo but i didn't explain what i needed properly =P I know how to do the tags.php page to output the video listings for the selected tags. I just don't know how to change the actual tags on the video pages into links, so that a visitor can click on the tag which goes to tags.php?tag=blah. I add the tags to the database as 'tag, tag tag, taggy, tagoo' etc lol. I could add them as links directly into the database but i was just wondering if there is a small php code that would make all the tags that are outputted display as links instead of just text as you see on: http://www.bangvideobang.com/videos/...out-the-e.html under video information. Thanks alot though mate, reallly appreciate it UPDATE!!! I've added the tag links now, have a look: http://www.bangvideobang.com/videos/...out-the-e.html

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