Hey guys..

I have a question.. I am not entirely sure how to do this, but I want to work on my dj pages and make a form where the dj can insert an artical in there page.. then have it return so much results then have it go page=blah. I want it to show the artical name and when it was submitted then the text that they desire.. RIght now I have a standard form for the content section, but I am not sure how to do it this way, but I have always been wanting it to be like that.. then let them have the option to delete an artical.

Thanks..

Mike

"I have a question"

Generally means that something you say will have a question mark following it.

After reading your statement, it was clear, that there was not a question asked, (because of the lack of question marks).

But there were several statements where you requested information, reffering to your above statement, when you asked for "a" question, implying there was only a single question asked.

Those aside however.

I think you need to decide what you want, and break up the questions into smaller sections. "then have it return so much results then have it go page=blah" for example. What is returning results? what's going page=blah?!

"I want it to show the artical name and when it was submitted then the text that they desire",

Thats pretty simple, make the article page have some unique ID associated with it, such as ArticleID=12, then use the $_GET value and select the relivant table from the database.

Employ an individual with common sense and knowledge of PHP to code it for you.

Not everyone is made to be a programmer, and it does not seem to be working for you.  We've tried to teach you the fundamentals, without these fundamentals everything is obscure.  On the old site we had a couple categories  you would fit into: "newbie," "lamer."

I have worked out the design part and added the SQL..

Here is my error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mfoland/public_html/pages/jockpage.php5 on line 1017

Code:

<? $sql = "SELECT * FROM `mfoland_djpage`.`JockSite` WHERE `dj` = '$dj' AND `page` = '$page' ORDER BY time ASC LIMIT 6"; >> Line Error: $sql_result = mysql_query($sql,$connection);while ($row = mysql_fetch_array($sql_result)) {$page = $_GET["page"];$title = $row["title"];$body = $row["body"];$time = $row["time"];?>

I think the problem I am having then is echoing the links and auto including page numbers.. Lets say if I go to page 2.. I then have 2 links previous 6 entries, newest 6 entires.. so lets say newest page entries start on page 1.. and so forth.. I have an IF statement now for page 1 only showing a link to page 2 to show the oldest entries. times Ascend to put the newest first.. I already have all that. I only get the line error when I do the page = in the SQL. Not sure why.. and what function can I use to do the page numbers in a link to auto foward, etc?

Otherwise, what I have coded is going well. Thanks

Actually the blah by the page is actually the page number.. See previous post.

And Specific, I have actually built alot of stuff by myself.. It is just when I get these line errors, I can't seem to figure out what is wrong.

This is a perfect example of ridiculous.

The warning is part of the comprehensive error handling of PHP.  Any half-wit can diagnose and understand what the warning is all about by just reading it.

How do you fix the problem?

Here is your answer:

"supplied argument is not a valid MySQL result resource in /home/mfoland/public_html/pages/jockpage.php5 on line 1017"

With all the fixes we have provided you, not once have you asked how it works.  This isn't the right mentality to learn, and just gives off the vibe of "I don't care how it works as long as it works!"  If thats the case get the fuck out of here, quit wasting my time and space.  Work this problem out yourself and maybe you'll get somewhere in life besides a blacklist full of lamers.

You know what. You should be willing to help. I looked at the code, I want my account removed.

Are their any PHP groups on the web that has a nicer group of members? Obviously I made the mistake of joining.

I won't waist your time and space anymore. Hopefully I will find a nicer group. Sorry for joining.. Hopefully people will rate your site better than I will!

the line I showed you was the error.. It is the mysql.. The only time it fucks up is when I do the and page = .

And you will not say things as you said about me. That kind of crap won't fly.

Good riddance

bye

You obviously didn't check the existance of $dj or $page.

Either way, the select is messed up.

If you just echo your $sql variable before you query it, you can see exactly what fudged up.

if they're fine, its probably the time ordering, or limiting of 6.