04192005 1358 GMT-6
Pete, this is a very basic (read nothing into it, and expect nothing of
me) question.
If I do not use the id of the application to know what is Next or
Previous, what would I use? Date?
Wade
Pete wrote:
>In message <[EMAIL PROTECTED]>, Wade <[EMAIL PROTECTED]>
>writes
>
>
>>04192005 1013 GMT-6
>>
>>Ok. Im working on this site and there is this very long application.
>>Once you submit that, I have created a 'viewer' for the owner of the
>>site to review those apps. Apps can be held for a long time. Some are
>>rejected. When filled, they are removed - just like the rejected ones.
>>
>>The owner wants to see all apps, starting with the first one. Now, I
>>thought about sorting by date, but, because the apps can be updated, the
>>date changes with every update. So, I went with the appid. Its
>>sequential - just like the owner wants it to be.
>>
>>
>
>So how does the user see the information when the program starts? All
>the apps in a table? (what is an app? application to join?). It
>sounds as though he just gets one on screen, deals with it, then presses
>the [next page] button.
>
>
>
>>I would start at the first one and go on to next and so on.
>>
>>Now, you have to know that I do not have access to make changes to the
>>db. I have suggested it time and again but the owner wants it a certain
>>way.
>>
>>If you have a better suggestion - PLEASE tell me.
>>
>>Here is a piece of code from another list. It worked for one guy but Im
>>having difficulty with it.
>>
>>
>
>This is the bit you keep coming back to, and I can't see why. Here, you
>say, show me the one before I just viewed,
>
>
>>$q1 = "SELECT Max(clrId ) As prev from tblcolorpattern Where clrId <
>>$id";
>>$res = mysql_query($q1);
>>if($res)
>>{
>> $num = mysql_num_rows($res);
>> if($num)
>> {
>> $prev = mysql_result($res,0,0);
>> }
>>}
>>
>>this code give me id before the current id in DB
>>
>>/************************************************/
>>
>>$q2 = "SELECT Min(clrId ) As next from tblcolorpattern Where clrId >
>>$id";
>>$res = mysql_query($q2);
>>if($res)
>>{
>> $num = mysql_num_rows($res);
>> if($num)
>> {
>> $next = mysql_result($res,0,0);
>> }
>>}
>>this code give me id after the current id in DB
>>
>>I rewrote it so I could better understand it:
>>
>>$sql = "SELECT MAX(appid) AS prev from application WHERE appid < =
>>'".$appid."'";
>>
>>$result = mysql_query($sql);
>>
>>if ($result) {
>> $num = mysql_num_rows($result);
>> if ($num) {
>> $prev = mysql_result($result, 0, 0);
>> }
>>}
>>
>>I must have misunderstood how to use it.
>>
>>
>
>What do you get? Error message? Blank screen? Wrong record?
>
>
>
>>Wade
>>
>>
>
>
>
[Non-text portions of this message have been removed]
The PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
