this is my code: now this code works fine, but it echo my results on the same line since its a loop. i want my output to be 3 photos per line for example: image1 image2 image3 (jumps to line) image4 image5 image6 and not: image1 image2 image3 image4 image5 image6. To be more precise i want to add a
Tag: while-loop
Display contact database by all categories it is marked, then alphabetical order
I’m trying to build a Vendor Contact Database with categories. Various vendors are marked under more than one category. I have structured my table as the following: My Current Code This is just a basic idea. My contact database has more fields including phone number, email, etc. Seeing how our category …
How to select only the first elements satisfying a condition?
I have the following table (simplification of the real problem): Now a simple SELECT id FROM Table WHERE value=’T’; would get me all the IDs where value is T, but I just need, in the example above, the first 2 (1 and 2). What is the best way to do this? I’d prefer not to use a while loop. I
How to use WHILE LOOP to add value to list with condition, SQL Server 2008
I have a loop query with scenario below: orderqty = increase value 1 each loop runningstock = decrease value 1 each loop allocateqty = case when orderqty > 0 and runningstock > 0 then 1 else 0 loop till runningstock=0 or total allocation=stockqty Query: Result: the correct one should be like this: Answe…
sql while loop with date counter
I need to do something like this in sql: How can I do the above correctly in SQL? Basically, my startdate and enddate are strings and not datetimes because my business logic is referencing string column in another table with a date as the name of the column-But I need to loop through a bunch of columns, each …
How to implement a do-while loop in tsql
I’m trying to figure how to implement this in TSQL The only iterative control flow sentence provided by Transact-SQL is while (condition) sentences that first evaluates the condition and if that condition is true then execute the sentence. I’m thinking in a scenario like execute a UPDATE statement…