Welcome to Geeklog, Anonymous Thursday, April 25 2024 @ 05:07 pm EDT

Geeklog Forums

upage v 2.0 released!

Post New Reply

Author:

Mood:

Code

Font Color Font Size Close Tags

Forum BBCode Help

BBCode	Effect
[b]bolded text[/b]	bolded text
[i]italicized text[/i]	italicized text
[u]underlined text[/u]	underlined text
[s]strikethrough text[/s]	strikethrough text
[img]http://www.site.com/forum/images/forum.png[/img] OR [img h=65 w=50]http://www.site.com/forum/images/forum.png[/img]
[url=https://www.geeklog.net]Geeklog[/url]	Geeklog
[quote]quoted text[/quote]	To quote: quoted text
[size=15]Your Text[/size] "12" is usually standard on message boards. Usually measured in pixels (px).	Your Text
[color=red]Red Text[/color] OR [color=#FF0000]Red Text[/color] Can use many different color names or hex codes.	Red Text
[list] []List item 1 []List item 2 [/list] OR [list=1] []List item 1 []List item 2 [/list]	List item 1 List item 2 List item 1 List item 2
[code]monospaced text[/code]	monospaced text
[code=XYX]formatted code[/code] Where XYZ can be any of the following: c css html4strict java javascript jquery perl php plain python SQL and many more...	formatted code
To enter a backslash (\) in your post, use \\\\	\

Subject

[QUOTE][u]Quote by: amckay[/u][p]OK, it must mean the previous query failed and stupid me I don't do error checks.  Just prior to the code mentioned above is :

[code]
        // now we have to re-lookup the one we just inserted

$sql    = "SELECT * FROM {$_TABLES['upic']} "
                . " WHERE upic_uid = {$P['upic_uid']} "
                . " AND upic_file = "{$P['fclient']}" "
                . "";
        $result = DB_query( $sql );
        $UP     = DB_fetchArray( $result );

[/code]

Add a check on the DB_query so it looks like this :

[code]
        // now we have to re-lookup the one we just inserted

$sql    = "SELECT * FROM {$_TABLES['upic']} "
                . " WHERE upic_uid = {$P['upic_uid']} "
                . " AND upic_file = "{$P['fclient']}" "
                . "";

if ( ! $result = DB_query( $sql ) ) {
                $retr   .= " ... " . $LANG_UPAGE['upic_db_fail']
                        . " [" . $sql . "]";
                return $retr;
        }

$UP     = DB_fetchArray( $result );

[/code][/p][/QUOTE]

Options:

HTML Mode

Geeklog Forums

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks