php code to select last inserted row

Question

Sir, I upload a youtube video src from my cms and need to display video on webpage. every thing is working fine.

Ehen I upload a data from cms ,every time new row is created in database.but i can not upload youtube video source with every record.

But I need to fetch last uploaded video source from database.

for ex-

In my database there are 5 rows.
Now i need to select last inserted souce from database.
for ex- I need to select row 3 source from database

id name source
1 raj //www.youtube.com/embed/zmotgOJDKXk

2 ravi

3 roy //www.youtube.com/embed/zmotgOJDKXk

4 martin

5 king

Below is my code to echo and select data

<?php
$sql="SELECT id ,source from content order by id desc";
$sub_top=mysql_query($sql);
?>

<?php while ($video= mysql_fetch_array($sub_top)) { ?>

      <div class="video"> <iframe width="292" height="315" src="<?php echo $video['source']; ?>" frameborder="0" allowfullscreen></iframe></div>
      <?php } ?>
        </div>

Are you saying you need to display last record in descending order only if source present? — v2solutions.com
– v2solutions.com, Commented Jan 13, 2015 at 12:57
yes. need to display last record in descending order only if source present — rahul ingle
– rahul ingle, Commented Jan 13, 2015 at 13:00

David Ansermot · Accepted Answer · 2015-01-13 12:56:46Z

1

Add the clause "LIMIT 0,1" :

$sql = "SELECT id,source FROM content ORDER BY id DESC LIMIT 0,1 WHERE source <> ''";

answered Jan 13, 2015 at 12:56

David Ansermot

6,1148 gold badges51 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rahul ingle Over a year ago

only need to display last record in descending order only if source present

Stender · Accepted Answer · 2015-01-13 13:01:36Z

1

don't know what you're asking, but this should find the newest row with a source.

$sql="SELECT id ,source from content WHERE source IS NOT NULL order by id desc LIMIT 0,1";

answered Jan 13, 2015 at 13:01

Stender

2,5121 gold badge18 silver badges26 bronze badges

Comments

score 0 · Accepted Answer · 2015-01-13 13:03:32Z

0

This should do

SELECT *
FROM content
WHERE source IS NOT NULL
ORDER BY id DESC
LIMIT 1;

edited Jan 13, 2015 at 13:03

answered Jan 13, 2015 at 12:57

user4446130

1 Comment

rahul ingle Over a year ago

need to display last record in descending order only if source present

kayo · Accepted Answer · 2015-01-13 13:03:47Z

0

I think that you need to fetch only last record containing youtube URL.

select id, source from content where source ilike '%youtube%' order by id desc limit 1

this will select one record from db and it has to contain word "youtube". I don't use mysql so I didn't test it.

answered Jan 13, 2015 at 13:03

kayo

6421 gold badge6 silver badges10 bronze badges

Comments

Adib · Accepted Answer · 2015-01-13 13:04:11Z

0

You can use REGEXP by MySQL in order to conduct this operation. The regular expression should be something like www.youtube.com/(.+)

SELECT id,source FROM content ORDER BY id WHERE source REGEXP 'www.youtube.com/(.+)'

This will definitely limit it to only show any record with youtube links

answered Jan 13, 2015 at 13:04

Adib

1,3443 gold badges16 silver badges32 bronze badges

Comments

v2solutions.com · Accepted Answer · 2015-01-13 13:05:06Z

0

To Display last record with source not null:

$sql="SELECT id ,source FROM content WHERE source IS NOT NULL ORDER By id desc Limit 0,1";

answered Jan 13, 2015 at 13:05

v2solutions.com

1,4399 silver badges8 bronze badges

Comments

Jigar Patel · Accepted Answer · 2015-01-13 13:05:37Z

0

In Frame add Frame unique ids on page and add allowfullscreen=""

Code is below

<div class="video">
  <iframe width="292" id="vid_1" height="315" src="<?php echo $video['source']; ?>" frameborder="0" allowfullscreen=""></iframe>
</div>

answered Jan 13, 2015 at 13:05

Jigar Patel

2071 silver badge6 bronze badges

Collectives™ on Stack Overflow

php code to select last inserted row

7 Answers 7

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related