User Profile

Collapse

Profile Sidebar

Collapse
Teckie
Teckie
Last Activity: Mar 20 '07, 09:27 PM
Joined: Mar 12 '07
Location: BC, Canada
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Teckie
    replied to PHP/MySQL Row ID's & Num_Rows
    in PHP
    Of course, I was thinking too much on the PHP side, I forgot all about the SQL order by.

    Thanks again. :)
    See more | Go to post

    Leave a comment:


  • Teckie
    replied to PHP/MySQL Row ID's & Num_Rows
    in PHP
    Ahh, thanks!

    Thank you both for your help. The function does work and I've implemented it in all of the areas I needed to, and they all function excellent. This couldn't have been anymore quicker, I'm quite impressed.

    Is there a way to reverse this function? Such as "id" 10-1, instead of 1-10?...
    See more | Go to post

    Leave a comment:


  • Teckie
    replied to PHP/MySQL Row ID's & Num_Rows
    in PHP
    I noticed that in your script you used "while( $row = mysql_fetch_ass oc($result))". What exactly does this do? I found this in a few tutorials but none of them seemed to have explained what it serves in the script.

    Thanks for your help though, I'll try it out. :)...
    See more | Go to post

    Leave a comment:


  • Teckie
    started a topic PHP/MySQL Row ID's & Num_Rows
    in PHP

    PHP/MySQL Row ID's & Num_Rows

    Basically, I need a way of getting around a problem I recently found out...

    When I don't have a sequential row ID pattern (1,2,3,4), which comes up like (2,5,6), the script will return absolutely nothing.

    This is my current PHP code:
    [PHP]<?php
    $sql_queries[1] = "SELECT id FROM `news`";
    $sql_query = mysql_query( $sql_queries[1] ) or die();
    $sql_num_rows = mysql_num_rows( $sql_query...
    See more | Go to post
No activity results to display
Show More
Working...